-
Sql Server – TDE encryption on always on
•
TDE.sql Step 1: Database Master Key (DMK) on the primary replica first, you can check if your instance already has a database master key if the result came empty means no master key created since the result came empty we will create master key using the below qurey now we have master key with…
-
sql server table partition
•
data partition ${toc}As a database grows in size due to frequent insertions, deletions, and updates, even straightforward SELECT queries can become slower. When a table grows to a point where it’s unwieldy, the overall size of the database increases significantly. This is where table partitioning can be incredibly beneficial. Partitioning involves dividing a large…
-
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 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
•
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
•
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…