Author: Steve Stedman

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 →

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 Read more →

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, …

April is Join Types Month Read more →

Uncategorized

Celebrating World Backup Day with Stedman’s SQL School: Unlock the Secrets of Efficient Backup and Recovery As we mark World Backup Day on March 31st, it’s a timely reminder of the critical importance of data backups in our increasingly digital world. In the realm of database management, particularly with SQL Server, the significance of having a reliable backup and recovery strategy cannot be overstated. Data is the lifeline of any organization, and the ability to recover it swiftly and accurately …

Celebrating World Backup Day Read more →

Uncategorized

Embrace Efficiency and Growth: The Integrated Power of Managed Services In today’s fast-evolving business landscape, organizations are constantly seeking ways to optimize their operations, scale efficiently, and ensure the robust management of their critical IT infrastructure. Stedman Solutions offers a suite of Managed Services designed to address these core needs, emphasizing the essential role of expert database administration in achieving business excellence. This consolidated blog post integrates insights from various discussions, outlining how Stedman Solutions empowers businesses through its comprehensive …

The Integrated Power of Managed Services Read more →

Uncategorized

Configuring Database Mail in SQL Server: A Dual Approach In the realm of SQL Server management, setting up Database Mail is a critical task for database administrators. It enables the sending of email notifications directly from your SQL Server, which can be invaluable for monitoring job failures, system alerts, or operational notifications. This short guide will explore two primary methods of configuring Database Mail in SQL Server: using SQL Server Management Studio (SSMS) and via T-SQL scripts. Both methods serve …

Configuring Database Mail in SQL Server: Video Read more →

Uncategorized

Finding Peace of Mind with SQL Server Managed Services As the owner or manager of a business that relies on SQL Server for critical data management and operations, the thought of your SQL Server encountering issues during the off-hours can be a significant source of stress. The fear of waking up to a server crash, data loss, or performance issues is enough to keep anyone up at night, questioning if their SQL Servers are properly taken care of. This concern …

Sleep Better With Our SQL Server Managed Services Read more →

Uncategorized

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 In The Shower Read more →

Uncategorized

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 with Database Health Monitor Read more →

Uncategorized

Cut Costs Without Compromising Quality: Outsource Server Maintenance with Managed Services and Watch Your Savings Grow Welcome back, fellow data enthusiasts! Today, we’re diving into a topic that’s not only crucial for your business but also a game-changer in the world of database management: outsourcing server maintenance with Managed Services. At Stedman Solutions, we understand the importance of efficiency, reliability, and, above all, cost-effectiveness when it comes to managing your Microsoft SQL servers. Why Outsource SQL Server Maintenance? Let’s face …

Cut Costs Without Compromising Quality Read more →