-
Find database size when it is offline
1 July 2021Hi, Tech Giants! What new to me today? Yeah, We did a SQL Server migration activity or we can say a side-by-side up-gradation activity. From our DBA side, it’s almost…
-
Auto-open new query window in SSMS
30 June 2021How to Change Product Key for SQL Server The Microsoft Evaluation Center brings you full-featured Microsoft product evaluation software available for downloads. We have downloaded from official website and install…
-
Make Named instance look like a Default instance
29 June 2021Convert or make SQL Server Named instance look like a Default instance Hi tech giants, today I have learn how to make a SQL server named instance look like a…
-
Find database growth size in SQL Server
28 June 2021All of a sudden I received an email from the database owner – “pls share file growth if u have so that the sizing can be done better” We don’t…
-
How to Configure MSSQL Backup Compression as the Default Option
28 February 2021Introduction In Microsoft SQL Server, backup compression is a powerful feature that can significantly reduce the size of database backups, thereby saving storage space and improving backup and restore performance….
-
Find blocking by T-SQL Queries
27 August 2020Blocking is an unavoidable and by-design characteristic of any relational database management system (RDBMS) with lock-based concurrency. As mentioned previously, in SQL Server, blocking occurs when one session holds a…
-
Find who dropped Database at what time
12 January 2020Find who dropped Database at what time As a DBA often we face a scenario that someone has dropped the database and we need to find out who dropped it….
-
Provide a SQL Login ALTER TRACE permission
5 January 2020Provide a SQL Login ALTER TRACE permission One SQL login holder asked DBA team “Please provide me profiler access urgently“. Mentioned user using a SQL login and he wants to…
-
Extended Security Updates for SQL 2008
22 December 2019How to get SQL Extended Security Updates for SQL 2008/2008 R2 database instance. The End of Support date for SQL Server 2008 and 2008 R2 is July 9, 2019 Extended…
-
Change ‘TempDB’ file location in SQL Server
18 December 2019Introduction The TempDB database is essential to SQL Server’s management of temporary data and execution of different tasks. The TempDB files are often kept on the same disc as the…