Sometimes we all need a little help without a long term commitment. That why we created our SQL Server Mentoring service at Stedman Solutions. SQL… Read More »SQL Server Mentoring – Do you need some occasional help?
If you’re growing your business, you don’t have time to manage your databases. Let us manage your SQL Server so you can seize the day!… Read More »Focus on what’s best – leave us the rest
In SQL Server, an index is a data structure that allows you to quickly retrieve data from a table based on the values of one… Read More »SQL Server and Clustered vs. NonClustered 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
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
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
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
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
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
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