There are several methods you can use to detect corruption in your Microsoft SQL Server database: * Use the DBCC CHECKDB command: The DBCC CHECKDB… Read More »SQL Server Corruption: How To Detect Corruption
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there… Read More »Common Waits Reported by Daily Monitoring This Month
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: Securing CLR
Today Microsoft released a new update for SQL Server. SQL Server 2008 –
In the last day or two Microsoft has released several updates with security patches. If you have SQL Server running anywhere, please make sure it’s… Read More »SQL Server – Security Patches
Steve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and… Read More »Exclusive SQL Performance Tuning Training
Why is SQL Server performance important? SQL performance is important because it directly affects the speed and efficiency of a database system. Poor performance can… Read More »SQL Performance Training Opportunity
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: SLEEP_MEMORYPOOL_ALLOCATEPAGES
SQL Server instance level settings allow you to control various aspects of the behavior of your SQL Server instance. One such setting is the ability… Read More »Securing SQL Server: Force Encryption Setting
A SQL Server database is considered “corrupt” when it has become damaged and cannot be used properly. This can occur due to a variety of… Read More »SQL Server Corruption: What Is Corruption