How to Suspend and Resume an Availability Database in SQL Server Always On Availability Group
Callum One of the fantastic features of Always On Availability Groups is that you can take...
Callum
Identify When your SQL Database Was Last Used – SQL Server
Database servers are used for storing vast amounts of data. It is essential to know...
Convert Unix Timestamp in SQL Server (T-SQL)
Want to know how to convert a Unix timestamp to a SQL Server timestamp or...
SQL Server Error VIEW SERVER STATE permission was denied on object ‘server’,databasE’Master’
Did you face the error – VIEW SERVER STATE permission was denied on object ‘server’,...
T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about...
SQL SERVER script to get Database Backup History
Here is a SQL Server script that will get you the database backup history for...
Type conversion in expression may affect “Cardinality Estimate” in querY plan choice
This blog post is about the conversion between implicit and explicit conversion within SQL Server....
Key (Lookup) in SQL Server Key Lookup performance
Learn about SQL Server key lookup performance and how to improve the performance of key...
Round up or Round down in SQL Server
SQL Server has a built-in function to round numbers up or down. Learn how to...
Steps to add Add Identity Column to Table in SQL Server
The identity column uniquely identifies a row in SQL Server. You can have only one...