Today Microsoft released a new update for SQL Server. SQL Server 2019 CU23 for 2019 (15.0.4335.1 – October 2023) CU22 + GDR (15.0.4326.1 – October 2023) 2023-10-12 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None SQL Server 2022 RTM Download links: NoneCU9 …
In the dynamic world of databases, ensuring optimal performance and robustness is crucial. Yet, many businesses often sideline database assessments, unaware of the untapped potential they can unlock. At Stedman Solutions, we emphasize the importance of our SQL Server Health Assessment. Why? Because the overall health of your SQL Server can drastically impact your business operations, especially when it comes …
Why Every Business Needs Stedman Solutions’ SQL Server Health Assessment Read more »
Today Microsoft released a new update for SQL Server. SQL Server 2012 CU10 for SP3 (11.0.6607.3 – August 2017) CU16 for SP2 (11.0.5678.0 – January 2017) CU16 for SP1 (11.0.3487.0 – May 2015) 2023-10-10 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None …
I have used my over 30 years of SQL Server experience to personally curate my favorite performance tuning tips and tricks into this training. I am excited to contribute and share with the SQL Server community some of my favorite solutions. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. …
The month of October is about more than just spooky decorations and pumpkin spice lattes—it’s about making sure your SQL Server environment is running at its peak! This October, Stedman Solutions is offering a deal you simply can’t afford to miss. When you purchase a SQL Server Assessment, you will also receive a full year of our SQL Server Daily …
Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …
Daily Server Monitoring – SQL Versions for October Read more »
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 …
In our data-centric world, SQL Server plays a pivotal role in driving business strategies and operations. But beyond mere performance, how confident are you in your server’s overall system configuration? More importantly, is your SQL Server environment truly disaster-proof? Let’s explore why these matters are essential and how Stedman Solutions LLC can be the partner you need for these assessments. …
Stedman Solutions LLC: Your Partner in SQL Server Resilience & Preparedness Read more »
At Stedman Solutions we have done many corruption repairs since 2015. When I talk about corruption, most of this information comes from real world scenarios that actually happened at different businesses that we were part of recovering… or not part of recovering if things were completely gone. In a Microsoft SQL Server database, several components can become corrupt, including: * …
DBCC SHRINKFILE is a database console command (DBCC) in Microsoft SQL Server that can be used to reduce the size of a data or log file in a database. Reducing the size of a file can be useful for reclaiming disk space or for reducing the size of a database to make it easier to move or backup. To use …