• Understanding SQL Server Replication: Types, Prerequisites, and Key Components

    Replication doesn’t send the entire database to another location, unlike log shipping or always-on solutions. Instead, it has a unique advantage – you can choose to replicate specific parts of the database, like views, tables, or any other objects you want. In essence, replication gives you the flexibility to pick and choose exactly what…

  • dbatools

    dbatools

    DBATools is a collection PowerShell command over 700 command that can help DBA to achieve common task in a more automated manner in this section will demonstrate how to install dbatools , and how to use it deferent type of task that include 1- taking backup2- taking script of the job3-migirationand so on install…

  • Sql server database backup in details

    Sql server database backup in details

    What Is a Transaction Log? Transaction log is a list of records for all Microsoft SQL database changes. It is an essential component of the SQL Server database. If there is a system failure, you will be able to use the T-log to bring your database back to a consistent state before the point…

  • Sql Server how to Manage transaction logs

    Sql Server how to Manage transaction logs

    Managing transaction logs Transaction managing in simple mode : here we will test log managing in both simple mode and full mode . i have created two database one full one simple mode added table on it then i will run trsnaction but i will not commit the transaction you can see the qurey…