Steve Stedman

I’m Steve Stedman, a firm believer in the value and power of effective data management. Having interacted with SQL Server extensively, I’ve recognized that data aggregation is a vital tool for anyone seeking to extract the most valuable insights from their data. To share this knowledge and help others master this powerful technique, I’ve launched a new course on Teachable …

SQL School: Elevate Your SQL Skills with Data Aggregation Read more »

Monitoring long-running queries is an essential part of database performance monitoring, as it can help identify queries that are causing performance issues and take corrective action to optimize them. The Database Health Monitor for SQL Server provides insights into long-running queries, enabling you to identify performance bottlenecks and optimize query execution. One way the Database Health Monitor tracks long-running queries …

Database Health: Monitoring Long-running Queries Read more »

The SA (System Administrator) account is a predefined account in SQL Server that has full control over the database server. By default, the SA account is disabled and is not associated with a login. However, if the SA account is enabled and given a password, it can be used to connect to the database server and perform any task. There …

Securing SQL Server: Renaming and Disabling the SA Account Read more »

Download the Join Types poster today for FREE!Available for both SQL Server (TSQL) and MySQL. The poster includes detailed graphical representations of several join types: inner join, left outer join, right outer join, cross join, multiple joins, as well as more advanced join types such as cross apply and outer apply. To facilitate easy recognition, each join type is illustrated …

Get you Join Types Poster Read more »

SQL Servers DBCC commands are a set of T-SQL commands that are used for various maintenance and diagnostic tasks. Some of these commands are documented and can be accessed through the SQL Server documentation, while others are considered “undocumented” and are not officially supported by Microsoft. Undocumented DBCC commands are usually not documented in the official SQL Server documentation and …

SQL Server DBCC Commands: Overview of Undocumented Commands Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU24 for 2019 (15.0.4345.5 – December 2023) CU22 + GDR (15.0.4326.1 – October 2023) 2023-12-14 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU10 …

New SQL Update from Microsoft Read more »

In today’s data-driven world, the health and efficiency of your SQL Server can be the backbone of your business operations. Regular SQL Server assessments are not just a good practice; they are a necessity for maintaining optimal performance and avoiding catastrophic failures. This blog post will explore the importance of SQL Server assessments and how they keep your server in …

The Crucial Role of SQL Server Assessments in Preventing Catastrophic Failures Read more »

Maximize Your Database Scalability with Stedman Solutions, LLC’s SQL Server Health Assessment As your business evolves, so does the demand on your databases. At Stedman Solutions, LLC, we recognize that scalability is key to your business’s success. Our SQL Server Health Assessment is not just about maintaining performance; it’s about ensuring your database can grow with your business. Discover the …

SQL Server Scalability and Health Assessment – Stedman Solutions, LLC Read more »

At Stedman Solutions when we talk about corruption in a database, that is something very different from ransomware. Don’t confuse a damaged database with a database that has been fully encrypted by ransomware. These stories come from a recording of a presentation by Steve Stedman and Derrick Bovenkamp. Steve: Now imagine with this picture, your fiber optic cable running through …

SQL Server Corruption: Stories About Causes of Corruption Read more »

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. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: COMMIT_TABLE Read more »