Find blocking by T-SQL Queries

Blocking is an unavoidable and by-design characteristic of any relational database management system (RDBMS) with lock-based concurrency. As mentioned previously, in SQL Server, blocking occurs when one session holds a…

Read Full
62 views 08:16 2 Comments

Find Server Information by TSQL script

Display all Server Information by using TSQL script The below listed all SQL Server Information can be retrieved by a TSQL script. But before that, we need to Enable xp_cmdshell…

Read Full
31 views 17:48 0 Comments

Backup & Restore Multiple Databases

Backup and restore all databases from an old SQL server and restore it on new SQL server. The number of databases are approx 99+. Let's try to make backup and…

Read Full
46 views 09:40 0 Comments

Fixing Orphaned Users in SQL Server

Introduction In easier terms, a 'Login' is like an entry pass to get into a SQL Server, and a 'User' is like an entry pass to access a specific database…

Read Full
54 views 04:07 0 Comments