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 2016 SP3 then GDR then GDR SQL Server 2014 SP3 then CU4 then GDR then GDR
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 group of subscribers learning to put the horse power back into their SQL Server. What You Get: Free weekly emails …
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, as data sets grow larger, the impact of poor performance becomes even more pronounced, resulting in increased costs for additional …
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 queue and the client application must wait for its turn to access the data. The time that the query spends …
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 ensures that all communication between the client and the server is encrypted, which helps protect against eavesdropping and man-in-the-middle attacks. …
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 is corrupt, you may encounter errors when trying to access the data or perform certain operations, and some data may …
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 queue and the client application must wait for its turn to access the data. The time that the query spends …
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, it is recommended to run DBCC CHECKDB at least once a day, or more frequently if the database is under …
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 logic, and make it easier for others to understand and maintain their code. There are two types of comments in …