Steve Stedman

Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …

Don’t Miss Out With Join Types Month Read more »

Hey there, fellow SQL enthusiasts! I’m Steve Stedman, and I’m excited to share my SQL Server course on the TSQL Output Clause. If you’re like me and passionate about mastering SQL Server, then you’re in for a treat! This course is designed to help you unlock the power of the TSQL Output Clause to streamline your database operations. Check it …

SQL School: Master the TSQL Output Clause with My SQL Server Course Read more »

In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have been able to get everything. Some have paid the ransom, and some have not. Even some who have paid the ransom did not got their data back. …

Fighting back against Ransomware Read more »

Grab a blanket and get comfortable. It’s story time with Steve Stedman and Derrick Bovenkamp! In this 10 min video they will share with you database corruption stories. From these stories hopefully you’ll learn what not to do. Things to watch out for to avoid server corruption. Transcription: Steve Stedman 0:04Let’s roll onto the corruption stories. So the first one …

Stories of Corruption Read more »

Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …

Demystifying SQL Server Join Types: A Guide to Mastery Read more »

Understanding Merge Replication in SQL Server In the world of data management, ensuring that information is up-to-date and accessible across different locations is crucial for businesses to function efficiently. This is where the concept of merge replication comes into play, especially within SQL Server environments. Merge replication is a sophisticated data synchronization strategy that enables multiple databases to remain synchronized, …

Understanding Merge Replication in SQL Server 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. Will a corrupt SQL Server database ever just get better? No, a corrupt …

SQL Server Corruption: Will It Get Better Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU26 for 2019 (15.0.4365.2 – April 2024) CU25 + GDR (15.0.4360.2 – April 2024) 2024-04-11 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: NoneCU12 …

New SQL Update from Microsoft Read more »