Database corruption in Microsoft SQL Server can present serious challenges, causing data loss, disruption of services, and potential impact on business operations. Understanding the causes,… Read More »SQL Server Corruption: NOLOCK and Corruption

Keeping your SQL Server up-to-date with the latest patches and updates is an important part of maintaining the security and stability of your system. Here… Read More »Securing SQL Server: Patching your SQL Server

DBCC TRACESTATUS is a database console command (DBCC) in Microsoft SQL Server that can be used to display the status of a trace flag, which… Read More »SQL Server DBCC Commands: DBCC TRACESTATUS

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: PAGELATCH_UP

Database Health: Finding and Resolving Blocking Queries Tue, 30 May 2023 Finding and resolving blocking queries is an essential part of database administration, as blocked… Read More »May Blog Post Wrap-up

Finding and resolving blocking queries is an essential part of database administration, as blocked queries can cause significant performance issues and slow down query execution.… Read More »Database Health: Finding and Resolving Blocking Queries

In observance of the US federal holiday Memorial day, and in memory of all who have died in service, Stedman Solutions, LLC will be closed… Read More »Honoring those who have died while serving

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: Harness the Power of Data Aggregation

There are several common causes of database corruption in SQL Server, including: * Hardware failures: Hard drives, memory chips, or other hardware components can fail,… Read More »SQL Server Corruption: What Causes Corruption

DBCC CHECKIDENT is a command in SQL Server that is used to check the current identity value of a table, and also to reset the… Read More »SQL Server DBCC Commands: DBCC CHECKIDENT