How to Change Always On availability group mode
Callum This topic describes how to change the availability mode of an availability replica in an...
Callum
Script SQL Database Permissions for database refresh
Do you restore SQL databases across SQL instances? The Database administrators get frequent requests to...
T-SQL script to Measure Transactions Per Seconds in SQL Server
Learn how to measure transactions per second in SQL Server with this quick and easy...
Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
SQL Server UPDATE STATISTICS WITH FULLSCAN is a process that is used to update statistics...
T-SQL script to Backup database SQL Server with TimeStamp
The T-SQL script takes a full backup of all databases(System databases and user databases) in...
Get a list of installed SQL Server Components with SQL Server Discovery Tool
Usually, DBA needs to check the SQL Server and find out the answer to the...
Install SQL Server 2022 on Windows
Microsoft announced a private preview of SQL Server 2022 last fall at ignite. SQL Server...
Explain the difference between CHECKPOINT and LAZY Writer in SQL Server
In SQL Server, the checkpoint and lazy writer mechanisms play crucial roles in data durability,...
Explore WITH(NOLOCK)and the difference between NOLOCK and WITH(NOLOCK)SQL Server Table hint
SQL Server Table hints(NOLOCK) help override the default behavior of the query optimizer during the...
PowerShell Script to restart SQL Services
This article gives PowerShell script to restart the SQL Server service, SQL Server Agent, Reporting...