744viewsSQL Server Data Migration Assistant (DMA) is a free tool developed by Microsoft to help you migrate your databases to a newer version of SQL Server or even migrate them to the cloud, specifically...
967viewsHere are some of the key new features introduced in SQL Server 2022: Cloud-connected features: Performance and scalability: Security: Machine learning: Other notable features: Azure-connected features: Reference: Manzoor Siddiqui [www.SQLServerLog.com] You may also like SQL...
Database Administration / SQL Server
by Manzoor Siddiqui · Published March 27, 2016 · Last modified June 25, 2021
538viewsAll the jobs information are stored in system tables of MSDB system database. Here we are going to use sysjobs and sysjobhistory tables to monitor information for each scheduled jobs execution. Below query will help...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published January 30, 2016 · Last modified May 24, 2016
354viewsSQL Server provides very useful T-SQL to find out details about property information of SQL Server instance by querying SERVERPROPERTY. With this T-SQL you can find out information like Product Version, Server Name, Edition,...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / SQL Troubleshooting
by Manzoor Siddiqui · Published October 10, 2015 · Last modified December 4, 2015
SQL Server provides DMVs and system tables to find out when SQL Server was last restarted. We may need this information many times to troubleshoot or trace issues which occurs on database servers. So,...
Database Administration / Performance Tuning / SQL Server
by Manzoor Siddiqui · Published October 9, 2015 · Last modified February 12, 2021
344views If you want to identify when last time statistics were updated on objects in database then you can use either DBCC SHOW_STATISTICS header information or sys.stats catalog view. Below example displays all statistics information for the...
