How to Find Missing Indexes
In SQL Server, missing indexes are indexes that the query optimizer has determined would improve query performance, but do not exist in the database. Identifying… Read More »How to Find Missing Indexes
Finding the version of SQL Server being used
To find the version of SQL Server that is being used, you can use the @@VERSION system function. This function returns a string that contains… Read More »Finding the version of SQL Server being used
Common DBA Interview Questions
There are many different DBA (database administrator) interview questions that employers may ask to assess a candidate’s knowledge and skills. Some of the most common… Read More »Common DBA Interview Questions
Sleep Better Knowing We’ve Got You Covered
If you have a SQL Server with backups and vulnerability issues or running on an older version of SQL, I can guess to say you… Read More »Sleep Better Knowing We’ve Got You Covered
SQL Server Errors 823, 824, or 825
Errors 823, 834, and 825 are all related to I/O errors in SQL Server. These errors occur when SQL Server is unable to read or… Read More »SQL Server Errors 823, 824, or 825
SQL Server Isolation Levels and What They Mean
In SQL Server, the isolation level is a property that determines how transactions are isolated from each other, and how they access and modify data… Read More »SQL Server Isolation Levels and What They Mean
Daily Server Monitoring – SQL Versions for January
Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the… Read More »Daily Server Monitoring – SQL Versions for January
12 Months for the Price of 10 – Managed Services
Limited time offer, first 12 months for the price of 10 months when you sign up for a managed services package in January. Between now… Read More »12 Months for the Price of 10 – Managed Services
SQL Server Wait Type: BACKUP_OPERATOR
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: BACKUP_OPERATOR
Error 701 There is insufficient system memory to run this query
Error 701, “There is insufficient system memory to run this query,” is a common error message in SQL Server. This error indicates that the system… Read More »Error 701 There is insufficient system memory to run this query