Author: OTI

Things You Must Do After Installing SQL Server Rolling out SQL Servers is a key task for DBAs. While for some DBAs this can be a frequent exercise, others will have to face it one time or other throughout their…

Hi, 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 done 90%, 10% percent is pending. We have some offline…

How 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 the product. Check all available SQL server version here: https://sqlserverbuilds.blogspot.com…

Convert 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 default instance. Recently I was trying to connect an application…

All 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 have any mechanism or 3rd party tool that monitored such…

Blocking 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 lock on a specific resource and a second SPID attempts…

Find 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. We can easily find the information from Schema Changes History…

Provide 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 run profiler on a particular database of a production server.…

How 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 Security Updates include provision of Security Updates and Bulletins rated…