SteveStedman

SQL Server Version Number List: From SQL Server 7.0 to SQL Server 2022 When working with SQL Server, understanding the version number of the instance… Read More »SQL Server Version Number List

Introduction In the digital age, effectively managing your SQL Server has never been more critical. You might think that employing a full-time Database Administrator (DBA)… Read More »Why Choosing Stedman Solutions is a Cost-Effective Alternative to Hiring a Full-Time DBA

For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. Finding and… Read More »Finding and Resolving Blocking Queries in SQL Server

Download “The Real Cost of SQL Server Management” White Paper Discover the true cost of managing SQL Server with our white paper, “The Real Cost… Read More »The Real Cost of SQL Server Management

Why My SQL Server is Slow If you’re asking yourself, “Why my SQL Server is slow?”, you’re not alone. A slow SQL Server can be… Read More »Why my SQL Server is slow?

CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR… Read More »Securing SQL Server: Disable CLR

DBCC WRITEPAGE is an undocumented and unsuported DBCC command in Microsoft SQL Server that can be used to write a page of data from a… Read More »SQL Server DBCC Commands: DBCC WRITEPAGE

Microsoft SQL Server’s database corruption can lead to severe operational complications, making crucial data inaccessible and potentially jeopardizing business continuity. Comprehending this problem requires a… Read More »SQL Server Corruption: NOLOCK and Corruption