New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2008 –
Month: February 2023
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 patched. SQL Server 2022 GDR SQL Server 2019 CU19 SQL Server 2017 CU31 then GDR SQL Server …
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 tricks to get more performance out of your SQL Server. Become part of this exclusive …
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 lead to slow query times, resulting in a poor user experience and decreased productivity. Additionally, …
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. When a client application requests data from the database, the request is placed in a …
SQL Server Wait Type: SLEEP_MEMORYPOOL_ALLOCATEPAGES Read more »
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 to force encryption for all connections to the instance. This is a security feature that …
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 reasons, such as hardware failure, system crashes, software bugs, or human error. When a database …
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. When a client application requests data from the database, the request is placed in a …
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 database, the level of activity, and the importance of the data. For most production databases, …
SQL Server Corruption: How Often Should I Run CheckDB Read more »
Comments in TSQL
Commenting for SQL Server in TSQL is a powerful and useful feature that allows developers to annotate and document their code in a clear and concise manner. By including comments in their TSQL code, developers can provide context, explain complex …