686viewsSQL 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...
952viewsHere 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
476viewsAll 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...
SQL Commands / SQL Programming / SQL Server
by Manzoor Siddiqui · Published February 27, 2016 · Last modified May 25, 2016
SQL constraints are set set of rules by which SQL engine enforces the integrity of database. Constraint maintains the standard rules to follow so that integrity in database can be maintained. If there is...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published January 30, 2016 · Last modified May 24, 2016
328viewsSQL 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,...
SQL Commands / SQL Programming / SQL Server
by Manzoor Siddiqui · Published December 27, 2015 · Last modified May 16, 2016
365viewsIn many tables we use Identity column to maintain the uniqueness and automatically increment the values when records are inserted. If you want to reset the identity column numbers in a table then we...
More
