Author: OTi
Linux Commands frequently used
Linux Commands frequently used Linux is a powerful and versatile operating system,…
Database stuck in Mirroring, Disconnected / In Recovery
Mirror database stuck in the state of ‘Mirroring, Disconnected / In Recovery’…
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…
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…
How To Download Youtube Private Video
How To Download Youtube Private Video A few months before one 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…
How to delete Naukri account
Scenario If anyone wants or needs to delete naukri.com profile/account from its…
Latest service pack to SQL Server
Apply latest service pack to standalone SQL Server We have given a…