Year: 2019

How to get SQL Extended Security Updates for SQL 2008/2008 R2 database…

How to change ‘TempDB’ file location in SQL Server The location of…

SQL Server Installation Best Practices SQL Server Installation Best Practices. Windows Requirements…

Estimated time to complete Backup and Restoration database in SQL Server As…

How to send Disk space report daily by a Job Send Disk…

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

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

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

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

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

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

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

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

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

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

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

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

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

Introduction How to run a SQL query using command prompt without SQL…

Find IP and Port using SQL SSMS Find IP and Port of…

How to find out user activity on database without any particular Auditing…

Apply latest service pack to standalone SQL Server We have given a…

Scenario Sometimes you need to gather the SQL instance details in a…

Scenario You often get complained that user is not able to connect…