Download the Join Types poster today for FREE!Available for both SQL Server (TSQL) and MySQL. The poster includes detailed graphical representations of several join types: inner join, left outer join, right outer join, cross join, multiple joins, as well as more advanced join types such as cross apply and outer apply. To facilitate easy recognition, each join type is illustrated …
SQL Servers DBCC commands are a set of T-SQL commands that are used for various maintenance and diagnostic tasks. Some of these commands are documented and can be accessed through the SQL Server documentation, while others are considered “undocumented” and are not officially supported by Microsoft. Undocumented DBCC commands are usually not documented in the official SQL Server documentation and …
SQL Server DBCC Commands: Overview of Undocumented Commands Read more »
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU24 for 2019 (15.0.4345.5 – December 2023) CU22 + GDR (15.0.4326.1 – October 2023) 2023-12-14 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: NoneCU10 …
In today’s data-driven world, the health and efficiency of your SQL Server can be the backbone of your business operations. Regular SQL Server assessments are not just a good practice; they are a necessity for maintaining optimal performance and avoiding catastrophic failures. This blog post will explore the importance of SQL Server assessments and how they keep your server in …
The Crucial Role of SQL Server Assessments in Preventing Catastrophic Failures Read more »
Maximize Your Database Scalability with Stedman Solutions, LLC’s SQL Server Health Assessment As your business evolves, so does the demand on your databases. At Stedman Solutions, LLC, we recognize that scalability is key to your business’s success. Our SQL Server Health Assessment is not just about maintaining performance; it’s about ensuring your database can grow with your business. Discover the …
SQL Server Scalability and Health Assessment – Stedman Solutions, LLC Read more »
At Stedman Solutions when we talk about corruption in a database, that is something very different from ransomware. Don’t confuse a damaged database with a database that has been fully encrypted by ransomware. These stories come from a recording of a presentation by Steve Stedman and Derrick Bovenkamp. Steve: Now imagine with this picture, your fiber optic cable running through …
SQL Server Corruption: Stories About Causes of Corruption 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 …
Are you ready to supercharge your SQL Server’s performance? If so, you’re in luck! We’re thrilled to announce an exclusive limited-time offer on our comprehensive SQL Server Performance Tuning course, designed to equip database professionals with the skills and knowledge needed to optimize SQL Server performance effectively. 11% OFF – Enroll Now at 11% off With Coupon Code PERF11 Enroll …
SQL School: Unlock Peak Performance With our Performance Tuning Course Read more »
Monitoring CPU load is an essential part of database performance monitoring, as high CPU usage can cause performance issues and slow down query execution. The Database Health Monitor for SQL Server provides insights into CPU usage, enabling you to identify potential issues and optimize database performance. High CPU usage can occur for a variety of reasons, such as inefficient query …
Database Health: Monitoring CPU Load with Database Health Monitor Read more »
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 December Read more »