Year: 2024

By Posted on Posted in Uncategorized No Comments

User-defined assemblies (UDAs) in SQL Server provide a powerful way to extend the capabilities of your database. However, they also introduce potential issues and security risks that must be carefully managed. This help page aims to elucidate why UDAs can cause problems and pose security risks. What are User-Defined Assemblies? User-defined assemblies are custom code written in .NET languages like C# or VB.NET, which are then compiled into assemblies and loaded into SQL Server. These assemblies can perform tasks that …

Understanding the Risks of User-Defined Assemblies in SQL Server Read more »

By Posted on Posted in Uncategorized No Comments

Welcome to our Backup and Recovery Course! Watch this video by Steve Stedman to find out more. In today’s digital age, data is the lifeline of any business. Ensuring its safety and availability is paramount. Our comprehensive Backup and Recovery Course is designed to equip you with the essential skills and knowledge to safeguard your data effectively. For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed …

Backup and Recovery Course Read more »

By Posted on Posted in Uncategorized No Comments

Welcome to Stedman’s SQL School! In this video, we provide an in-depth overview of all the classes we offer to help you master SQL Server. Whether you are a beginner or an experienced professional, our courses cover a wide range of topics tailored to enhance your SQL skills and knowledge. Watch Steve Stedman’s video to learn more about this exciting topic. You’ll gain valuable insights and detailed information directly from an expert in the field. For additional informative videos, visit …

Overview of Classes at Stedman SQL School Read more »

By Posted on Posted in Uncategorized No Comments

Hello everyone, I’m Steve Stedman, and today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Understanding and addressing performance bottlenecks in SQL Server is not always an easy task, and one of the biggest contributors to these bottlenecks is often blocking queries. That’s why I’ve built the Blocking Query Monitor. The Blocking Query Monitor is a powerful tool specifically designed to monitor, report, and help resolve blocking …

Blocking Query Monitor – Part of Database Health Read more »

By Posted on Posted in Uncategorized No Comments

Mastering SQL Server Replication: A Comprehensive Class by Stedman Solutions Are you ready to take your SQL Server skills to the next level? Join us in this detailed video where we dive into our comprehensive SQL Server Replication class. Whether you’re a database administrator, data architect, or IT professional, this class is designed to provide an in-depth understanding of SQL Server Replication techniques to ensure data consistency and availability across different servers or locations. Watch Steve Stedman’s video to learn …

Mastering SQL Server Replication Read more »

By Posted on Posted in Uncategorized No Comments

Boost Your SQL Server Performance with Expert Guidance! In this video, Steve Stedman from Stedman Solutions introduces his comprehensive SQL Server Performance Tuning course. Learn essential techniques to optimize your SQL Server, enhance query performance, and ensure efficient database management. Perfect for DBAs and IT professionals, this course covers everything from indexing strategies to performance monitoring. Enroll today and transform your SQL Server skills: https://stedman.us/performance-class. Watch this video by Steve Stedman to find out more. For additional informative videos, visit …

SQL Server Performance Tuning Course Read more »

By Posted on Posted in Uncategorized No Comments

UPDLOCK Hint in SQL Queries: Reasons to Avoid and Best Practices The UPDLOCK hint in SQL Server is used to indicate that the lock obtained on the selected rows is to be held until the end of the transaction. This lock ensures that no other transaction can obtain an exclusive lock on the rows while the transaction is in progress. Essentially, it upgrades a shared lock to an update lock, which is a precursor to an exclusive lock. Why UPDLOCK …

Understanding UPDLOCK Read more »

By Posted on Posted in Uncategorized No Comments

As we cross the midpoint of July, it’s time to shift our focus onto the life force of our digital existence – our databases! Being the founder of Database Health and Stedman Solutions, it brings me immense joy to pronounce July as Database Health Monitor Month! This is our yearly chance to acknowledge our largely invisible data protectors, and to plunge into the heart of our systems, rich with intricate data structures and complex relations. The moment has arrived for …

Just past the midpoint of Database Health Monitor Month Read more »

By Posted on Posted in Uncategorized No Comments

Discover Stedman Solutions: Your Go-To for SQL Server Management In today’s data-driven world, managing your SQL Server environment efficiently and securely is crucial for any business. If you’ve never heard of Stedman Solutions, LLC before, this blog post will introduce you to what we do and explain why we are the best choice for your SQL Server needs. Customer Challenges and Why Stedman Solutions Managing SQL Servers comes with several challenges, including: Staffing Challenges: IT managers often lack DBA knowledge, …

Discover Stedman Solutions Read more »

By Posted on Posted in Uncategorized No Comments

SQL Server Corruption Class – Learn How to Prepare and React Course Link In this video, we introduce our comprehensive SQL Server Corruption class designed to help you prepare your SQL Server environment to reduce the impact of corruption and react effectively if corruption strikes. What is Database Corruption? Corruption in a SQL database occurs when the database becomes damaged or corrupted, making it inaccessible. Causes can range from hardware failures and software bugs to human error. This can lead …

SQL Server Corruption Class – Learn How to Prepare and React Read more »