Author: Steve Stedman

Protecting SQL Server from Ransomware: The Power of Immutable Backups In today’s digital landscape, data is a cornerstone of organizational success. For those of us who’ve managed SQL Server environments over the years, the journey of safeguarding data has been both dynamic and challenging. With ransomware attacks looming as a persistent threat—capable of encrypting vital data and disrupting operations—immutable backups stand out as a vital defense for SQL Server databases. Let’s explore why these backups are indispensable and how to …

Immutable Backups for Your SQL Databases Read more »

SQL Server Replication Course from Stedman Solutions Are you looking to master SQL Server replication but don’t know where to start? Or maybe you’ve been tasked with setting up replication in your SQL Server environment, and it feels like a daunting task. The SQL Server Replication Course from Stedman Solutions is here to help you bridge that gap. Designed by true SQL Server specialists, this course provides hands-on learning to give you the confidence and expertise you need to handle …

SQL Server Replication Course by Steve Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Risks: User Tables in the Master Database and Disaster Recovery When it comes to managing SQL Server, the master database stands out as one of the most critical system databases. It holds essential system-level data, including server-wide configurations and the existence of other databases. Given its importance, it’s understandable why any conversation about disaster recovery will inevitably …

User Tables in the Master Database and Disaster Recovery Read more »

Identifying TempDB Bottlenecks with Database Health Monitor Reports SQL Server’s TempDB is a crucial system database that supports temporary storage needs for the SQL Server instance, including temporary tables, table variables, and work files necessary for sorting and query processing. However, TempDB can become a performance bottleneck if not properly managed, especially in high transaction environments. Fortunately, tools like the Database Health Monitor offer insightful reports, such as TempDB IO by Hour, TempDB Usage by Hour, and TempDB High Usage, …

Identifying TempDB Bottlenecks Read more »

Enhancing SQL Server Health with Database Health Monitor Alerting Overview Monitoring your SQL Server environment is essential for ensuring its optimal health and performance. The SQL Server Email Alerting feature in Database Health Monitor is a robust solution designed to keep you informed. By incorporating email notifications into your monitoring setup, this tool empowers you to address issues such as performance slowdowns, security threats, or other critical incidents proactively, before they escalate. With prompt alerts delivered directly to your inbox, …

Enhancing SQL Server Alerting Read more »

Some people say I am obsessed with Join Types, they may be right, you can decide. Todays featured join product is the Joins Shower Curtain. Joins Shower Curtain Start you day out right with a shower and learn some SQL Join Types while you are there. Shower Curtain Impress your friends, and improve your knowledge about joins with this shower curtain. Other Join Products Don’t miss out, get yours today! Coffee Mug Notebook Shower Curtain T-Shirts Drawstring Bag Hats Join …

Learn SQL Joins In The Shower Read more »

Stay Ahead: The Imperative of Keeping SQL Server Updated In the rapidly evolving world of technology, maintaining the currency of your software is not merely a matter of accessing the newest bells and whistles—it’s a foundational element of safeguarding your organization’s data integrity, security, and operational efficiency. This principle is nowhere more critical than in the realm of SQL Server management, a pivotal aspect of the data management strategy for countless enterprises. Through years of hands-on experience and numerous client …

Stay Ahead: Keeping SQL Server Updated Read more »