Month: September 2024

Master SQL Server Performance with Our Comprehensive Tuning Course Is your SQL Server not performing at its best? Are you looking to maximize efficiency, reduce costs, and enhance system stability? Look no further. Stedman Solutions is excited to offer a SQL Server Performance Tuning course designed to equip database professionals with the skills and insights they need to transform their …

Comprehensive SQL Server Performance Tuning Course Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2 (13.0.5888.11 – March 2021) CU15 + GDR for SP1 (13.0.4604.0 – July 2019) CU15 for SP1 (13.0.4574.0 – May 2019) CU9 for RTM (13.0.2216.0 – November 2017) 2024-09-10 Here are the latest updates for each …

New SQL Update from Microsoft Read more »

Mastering SQL Joins with Our Free T-SQL Join Types Poster Have you ever found yourself scratching your head, trying to remember the difference between a LEFT OUTER JOIN and a RIGHT OUTER JOIN? Or maybe you’re unsure when to use a CROSS APPLY versus an INNER JOIN? If so, you’re not alone—SQL joins can be tricky, especially when you’re deep …

Our Free T-SQL Join Types Posters 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 September Read more »

In our data-driven world, having a reliable backup for your SQL Server data is just half the battle; knowing how to effectively recover that data is equally vital. Stedman’s SQL Server Backup and Recovery Course is designed to equip you with not just the skills to back up your data, but more importantly, to recover it in various challenging scenarios. …

Are you ready to restore those backups? Read more »

In the fast-paced digital world we live in, data is everything. Whether you’re a seasoned DBA or a junior developer, understanding how to properly backup and restore SQL Server databases is essential for protecting this invaluable asset. To those searching for the most comprehensive and easy-to-understand training, look no further. Stedman’s SQL School has created an outstanding course on SQL …

Why SQL Server Backup and Recovery Skills are a Must-Have and How to Master Them Read more »

Watch this sneak peek we put together for you! In today’s digital age, robust data backup and recovery systems are more crucial than ever. One minor glitch, hardware failure, or cyber-attack could spell disaster, especially for businesses that rely heavily on data. If you’re looking to secure your SQL Server data, Stedman’s SQL Server Backup and Recovery Course is an …

Backup and Restore Course Overview Read more »

Monitoring disk I/O is an essential part of database performance monitoring, as disk I/O can significantly impact query performance and slow down database response times. The Database Health Monitor for SQL Server provides insights into disk I/O, enabling you to identify potential issues and optimize database performance. Disk I/O refers to the input and output operations performed on your server’s …

Database Health: Monitoring Disk I/O Read more »