Securing SQL Server: Securing CLR
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
New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2008 –
SQL Server – Security Patches
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
Exclusive SQL Performance Tuning Training
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
SQL Performance Training Opportunity
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
SQL Server Wait Type: SLEEP_MEMORYPOOL_ALLOCATEPAGES
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
Securing SQL Server: Force Encryption Setting
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
SQL Server Corruption: What Is Corruption
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
SQL Server Wait Type: TRACEWRITE
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: TRACEWRITE
SQL Server Corruption: How Often Should I Run CheckDB
The frequency with which you should run the DBCC CHECKDB command on your SQL Server database depends on several factors, including the size of your… Read More »SQL Server Corruption: How Often Should I Run CheckDB