SQLOPS IS THE ONLY AUDIT YOU’LL NEED FOR PRODUCTION DATABASES
Cannot generate SSPI Context in SQL Server
Cannot Generate SSPI Context is a generic connectivity error you may encounter while working with SQL Server. One of our customer had a new installation of SQL Server and ran in to this error. After hours of head scratching, the customer emailed us with the error...
SQL Server Developer Edition Free Download
Get a copy of SQL Server 2017 Developer Edition SQL Server developer edition is now free! Finally, Microsoft has made it easy for companies to develop and test SQL Server 2017 by making the developer edition of SQL Server completely free. This is certainly helpful for...
SP_What is smarter than SP_Who2
SP_What is smarter than SP_Who2! We’ve seen many DBAs scratch their head to find out who is running what in SQL Server. When a user complains about the database performance issue, the first thing DBAs do is run SP_Who or SP_Who2 to see what may be happening in SQL...
SQL Agent Job Failure Permanent Fix
Many production DBA’s have asked if there’s a way to find out how many times a job has failed in the last few months. This information can easily be obtained and can be extremely helpful to identify and permanently fix SQL Agent job failures.
Optimize for Ad Hoc Workload in SQL Server
By default, when a query is executed in SQL Server, it compiles and generates an execution plan and stores it in the plan cache. If this is a one-off or ad-hoc query that will never be run again, then the newly generated plan is wasted and its space that is being used in the plan cache is also wasted. This means the buffer pool now contains compiled plan of queries that will never be executed.
How to rebuild indexes in SQL Server
Rebuilding indexes in SQL Server is an essential maintenance task that helps optimize database performance and improve query execution times. Indexes play a crucial role in speeding up data retrieval by providing quick access paths to rows in a table. However, over...
Data and Log File Performance Using Instant File Initialization
Ever wondered why SQL Server takes long time to: Create a database Expand data files for additional growth Automatic data file growth due to auto-grow settings Restoring a database, etc. Today we will be looking into a powerful and yet not very popular feature that...
