Category: MS SQL
Change Default TCP Port in SQL Server
Change Default TCP Port in SQL Server When any version or edition…
Things You Must Do After Installing SQL Server
Things You Must Do After Installing SQL Server Rolling out SQL Servers…
Find database size when it is offline
How to find database size when it is offline in SQL server…
Auto-open new query window in SSMS
How to Change Product Key for SQL Server The Microsoft Evaluation Center…
Make Named instance look like a Default instance
Convert or make SQL Server Named instance look like a Default instance…
Find database growth size in SQL Server
How to find database growth size in SQL server All of a…
Find blocking by T-SQL Queries
Find blocking by T-SQL Queries Blocking is an unavoidable and by-design characteristic…
Find who dropped Database at what time
Find who dropped Database at what time As a DBA often we…
Provide a SQL Login ALTER TRACE permission
Provide a SQL Login ALTER TRACE permission One SQL login holder asked…
Extended Security Updates for SQL 2008
How to get SQL Extended Security Updates for SQL 2008/2008 R2 database…
Change ‘TempDB’ file location in SQL Server
How to change ‘TempDB’ file location in SQL Server The location of…
SQL Server Installation Best Practices
SQL Server Installation Best Practices SQL Server Installation Best Practices. Windows Requirements…
Estimated time of Backup & Restoration
Estimated time to complete Backup and Restoration database in SQL Server As…
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…
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…