Change ‘TempDB’ file location in SQL Server
Introduction The TempDB database is essential to SQL Server's management of temporary data and execution of different tasks. The TempDB files are often kept on the same disc as the…
Read Full
Determine or Estimated time (ETA) of Backup & Restoration
As a DBA you may face a few common questions whenever someone accidentally deleted some database objects or the whole database. “How long-time SQL Server will take to complete the…
Read FullSend Disk space report daily by a Job
How to send Disk space report daily by a Job Send Disk space report daily by a Job. Here we will use a TSQL script for the activity. The script…
Read FullSend Database Backup Report Daily by a Job
How to Send Database Backup Report Daily by a Job Send Database backup report daily by a Job. Here we will use a TSQL script for the activity. The script…
Read FullFind 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
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
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
Find cached execution plan
An execution plan, simply put, is the result of the query optimizer's attempt to calculate the most efficient way to implement the request represented by the T-SQL query you submitted. Execution plans can tell you how a query will…
Read Full
Configuring Database Mail in SQL Server
SQL Server Database Mail facilitates email communication directly from the database engine. This capability is critical for transmitting query results, error alarms, and reports, as well as keeping you informed…
Read FullSQL Network Interfaces, error: 26
SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified Users often see “SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified” error message while connecting to SQL Server. Steps to…
Read Full