Author: Steve Stedman

By Posted on Posted in Uncategorized

In SQL Server, the DBCC CHECKDB command is a critical tool for ensuring the integrity of your databases. It performs checks on the logical and physical integrity of all the objects in the specified database. Using DBCC CHECKDB with different options can tailor the scope and performance impact of these integrity checks. DBCC CHECKDB with No Options Running DBCC CHECKDB without any options performs a comprehensive check, including: Integrity of database pages and structures. Consistency of disk space allocation. Integrity …

DBCC CHECKDB Options Read more »

By Posted on Posted in Uncategorized

Master SQL Server Replication with Our Comprehensive Course At Stedman’s SQL School, we are proud to offer a thorough and detailed course dedicated to SQL Server Replication. This course is designed for database professionals who wish to deepen their understanding of replication to enhance their skills in data synchronization and integration across multiple databases. Whether you’re a seasoned DBA or a budding IT professional, our course on Snapshot, Merge, and Transactional Replication is tailored to equip you with the skills …

Master SQL Server Replication Read more »

By Posted on Posted in Uncategorized

Assessing SQL Server Backup and Recovery Readiness: A Must-Do for IT Managers and DBAs In today’s digital-first environment, ensuring the resilience and reliability of your SQL Server databases is not just recommended; it’s imperative. At Stedman Solutions, we understand the critical role that backups, recovery, and business continuity play in maintaining your organization’s health. That’s why we’ve developed a comprehensive self-assessment for IT managers and DBAs aimed at enhancing your preparedness for unexpected events that could impact your data infrastructure. …

SQL Server Business Continuity Self-Assessment Read more »

By Posted on Posted in SQL Joins Cheat Sheet

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 and versatility of JOINs. From eye-catching JOIN posters to cozy JOIN socks, and from comprehensive JOIN classes to much more, …

Join Types Shirt Read more »

By Posted on Posted in Uncategorized

Here is a short video that I created explaining the difference between Push and Pull replication. Watch it on YouTube. https://youtu.be/ykHsAHH-ggs?si=Msr4jRgeygOs3_Gq Replication Course Enrollment Information Want to learn more about replication? If you’re ready to take your SQL Server skills to the next level, visit Stedman’s SQL School SQL Server Replication Course to learn more and enroll today. We look forward to helping you succeed and are excited to see how you leverage these skills to optimize and innovate within …

Push vs Pull Replication Video Read more »

By Posted on Posted in Uncategorized

Securing SQL Server Against Ransomware: The Role of Immutable Backups Securing SQL Server Against Ransomware: The Role of Immutable Backups In the digital age, data is arguably an organization’s most valuable asset. For those of us who have been in the trenches with SQL Server since the early ’90s, the evolution of data management and security has been both fascinating and daunting. Today, the specter of ransomware attacks casts a long shadow over businesses, threatening to encrypt critical data and …

The Role of Immutable Backups Read more »

By Posted on Posted in SQL Server Classes

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 and versatility of JOINs. From eye-catching JOIN posters to cozy JOIN socks, and from comprehensive JOIN classes to much more, …

SQL Server Join Types Class Read more »

By Posted on Posted in SQL Joins Cheat Sheet

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 and versatility of JOINs. From eye-catching JOIN posters to cozy JOIN socks, and from comprehensive JOIN classes to much more, …

Join Types Shower Curtain Read more »

By Posted on Posted in SQL Server Corruption Tagged with ,

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 we’re going to talk about here was one of the first really big corruption repairs that I did after Derek …

Steve and Derrick – Stories of Corruption Read more »

By Posted on Posted in Uncategorized

Ensuring Your SQL Server’s Resilience: Free Backup, Recovery, and Business Continuity Self-Assessment In the realm of database management, the terms “backup,” “recovery,” and “business continuity” are more than just buzzwords; they are critical components of a robust SQL Server strategy that safeguards against data loss and downtime. At Stedman Solutions, LLC, we understand the complexities and challenges involved in ensuring the resilience of your SQL Server environments. That’s why we’ve developed a comprehensive and completely free Self-Assessment for SQL Server …

Backup and Recovery Self-Assessment Read more »