4 min read
2
Send 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…
Month: November 2019
4 min read
0
Send 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…
8 min read
0
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…
2 min read
0
Backup & Restore Multiple Databases
Backup and restore all databases from an old SQL server and restore it on new SQL server. The number of…
3 min read
1
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’…
2 min read
0
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…
8 min read
3
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,…
2 min read
0
SQL Network Interfaces, error: 26
SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified Users often see “SQL Network Interfaces, error: 26 – Error Locating…
2 min read
1
Find the SQL Server Cluster details
Scenario A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node,…
2 min read
4
Create login by CMD in SQL Server
Scenario You have got the SQL database engine installed but no SSMS installed on it. In this scenario how you…