Month: November 2019
Send Disk space report daily by a Job
How to send Disk space report daily by a Job Send Disk…
Send Database Backup Report Daily by a Job
How to Send Database Backup Report Daily by a Job Send Database…
Find Server Information by TSQL script
Display all Server Information by using TSQL script The below listed all…
Backup & Restore Multiple Databases
Backup & Restore Script for Multiple Databases Backup and restore all databases…
Fixing Orphaned Users in SQL Server
Fixing Orphaned Users in SQL Server A ‘Login’ allows us to connect…
How To Download Youtube Private Video
How To Download Youtube Private Video A few months before one of…
Find cached execution plan
Find cached execution plan An execution plan, simply put, is the result of…
Configuring Database Mail in SQL Server
Configuring Database Mail in SQL Server Prerequisites to Enable Database Mail Before…
SQL Network Interfaces, error: 26
SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified Users often…
Find the SQL Server Cluster details
Scenario A cluster includes two or more physical servers, called nodes; identical configuration is…
Create login by CMD in SQL Server
Scenario You have got the SQL database engine installed but no SSMS…
Best Practices for SQL Database setting
1. Database Owner: ‘sa’ As per my understanding, the Database Owner always…
How to delete Naukri account
Scenario If anyone wants or needs to delete naukri.com profile/account from its…
Find all the users for a particular database
Scenario How to find all the users present in a database. Solution…