Month: November 2019

Posted in MS SQL

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
Posted in MS SQL

Send Database Backup Report Daily by a Job

How to Send Database Backup Report Daily by a Job Send Database…

Display all Server Information by using TSQL script
Posted in MS SQL

Find Server Information by TSQL script

Display all Server Information by using TSQL script The below listed all…

Posted in MS SQL

Backup & Restore Multiple Databases

Backup & Restore Script for Multiple Databases Backup and restore all databases…

Posted in MS SQL

Fixing Orphaned Users in SQL Server

Fixing Orphaned Users in SQL Server A ‘Login’ allows us to connect…

Posted in Others

How To Download Youtube Private Video

How To Download Youtube Private Video A few months before one of…

Posted in MS SQL

Find cached execution plan

Find cached execution plan An execution plan, simply put, is the result of…

Posted in MS SQL

Configuring Database Mail in SQL Server

Configuring Database Mail in SQL Server Prerequisites to Enable Database Mail Before…

Posted in MS SQL

SQL Network Interfaces, error: 26

SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified Users often…

Posted in MS SQL

Find the SQL Server Cluster details

Scenario A cluster includes two or more physical servers, called nodes; identical configuration is…

Posted in MS SQL

Create login by CMD in SQL Server

Scenario You have got the SQL database engine installed but no SSMS…

Posted in MS SQL

Best Practices for SQL Database setting

1. Database Owner: ‘sa’ As per my understanding, the Database Owner always…

Posted in Others

How to delete Naukri account

Scenario If anyone wants or needs to delete naukri.com profile/account from its…

Posted in MS SQL

Find all the users for a particular database

Scenario How to find all the users present in a database. Solution…