2 min read
0
Make Named instance look like a Default instance
Convert or make SQL Server Named instance look like a Default instance Hi tech giants, today I have learn how…
Category: MSSQL
3 min read
2
Find database growth size in SQL Server
All of a sudden I received an email from the database owner – “pls share file growth if u have…
3 min read
0
How to Configure MSSQL Backup Compression as the Default Option
Introduction In Microsoft SQL Server, backup compression is a powerful feature that can significantly reduce the size of database backups,…
3 min read
2
Find blocking by T-SQL Queries
Blocking is an unavoidable and by-design characteristic of any relational database management system (RDBMS) with lock-based concurrency. As mentioned previously,…
2 min read
2
Find who dropped Database at what time
Find who dropped Database at what time As a DBA often we face a scenario that someone has dropped the…
1 min read
2
Provide a SQL Login ALTER TRACE permission
Provide a SQL Login ALTER TRACE permission One SQL login holder asked DBA team “Please provide me profiler access urgently“.…
4 min read
1
Extended Security Updates for SQL 2008
How to get SQL Extended Security Updates for SQL 2008/2008 R2 database instance. The End of Support date for SQL…
3 min read
0
Change ‘TempDB’ file location in SQL Server
Introduction The TempDB database is essential to SQL Server’s management of temporary data and execution of different tasks. The TempDB…
3 min read
1
Determine or Estimated time (ETA) of Backup & Restoration
As a DBA you may face a few common questions whenever someone accidentally deleted some database objects or the whole…
4 min read
2
Send Disk space report daily by a Job
How to send Disk space report daily by a Job Send Disk space report daily by a Job. Here we…