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… Read More »SQL School: Elevate Your SQL Skills with Data Aggregation
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… Read More »Database Health: Monitoring Long-running Queries
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… Read More »Securing SQL Server: Renaming and Disabling the SA Account
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:… Read More »Get you Join Types Poster
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… Read More »SQL Server DBCC Commands: Overview of Undocumented Commands
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… Read More »New SQL Update from Microsoft
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… Read More »The Crucial Role of SQL Server Assessments in Preventing Catastrophic Failures
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… Read More »SQL Server Scalability and Health Assessment – Stedman Solutions, LLC
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… Read More »SQL Server Corruption: Stories About Causes of Corruption
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: COMMIT_TABLE