-Dec 10, 20211 minGet a list of supported Time Zones in SQL Server and Azure SQL DatabaseDo you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article. The...
-Dec 10, 20211 minIdentifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...
-Dec 9, 20212 minSQL Script to fix Orphan users in SQL Server databaseThis blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...
-Dec 6, 20211 minFix error "Agent XPs disabled" in SQL ServerThis article explains the steps to fix the SQL Server agent error "Agent XPs disabled" using T-SQL scripts. Error details You might see...