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 Server Mentoring is a training / consulting option for those who just need a little help or direction. This is a cost-effective approach for those who need just a little help. Some call it coaching, …
SQL Server Mentoring – Do you need some occasional help? Read more »
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! Our Managed Services are so comprehensive you would think we’re on your payroll. So you can focus on what the business really needs. Below is what our Managed Services can provide you! Our monthly managed services is …
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 or more columns. There are two main types of indexes in SQL Server: clustered and nonclustered indexes. A clustered index A nonclustered index The main difference between a clustered and a nonclustered index is how …
SQL Server and Clustered vs. NonClustered Indexes Read more »
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 and creating missing indexes can improve query performance and help ensure that the database is running efficiently. To find missing indexes in SQL Server, the administrator can use the sys.dm_db_missing_index_details dynamic management view. This view …
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 information about the version of SQL Server, the operating system, and other details. To use this function, you can run the following query: This query returns the version column, which contains the information returned by …
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 and popular DBA interview questions include: These questions are designed to assess a candidate’s knowledge of the core concepts and skills required for a DBA role. By asking these questions, employers can get a better …
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 may not be sleeping as well as you should. Or maybe you’re in constant worry. With our Managed Services you’re covered! And this Month it’s even easier to say “yes”. Receive your first 12 months …
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 write data to the disk due to a hardware or software failure. Error 823 “I/O error (torn page) detected during read at offset,” indicates that SQL Server has detected a torn page on the disk. …
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 in the database. SQL Server supports four different isolation levels, which are: The isolation level can be set at the session level or the transaction level, and it can be changed using the SET TRANSACTION …
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 data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …
Daily Server Monitoring – SQL Versions for January Read more »