Steve Stedman

Join us at Stedman’s SQL School, where we offer a comprehensive range of classes designed to enhance your SQL Server expertise. Whether you are a DBA, developer, or just starting out with SQL Server, our courses provide valuable insights and practical skills to tackle real-world challenges. Here’s a glimpse of what we offer: Class details are available here: https://Stedman.us/School Course …

Stedman SQL School: Elevate Your SQL Server Skills Read more »

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: PAGELATCH_UP Read more »

When it comes to managing SQL Server, monitoring and optimizing performance is a critical part of ensuring that your database environment is running smoothly. The Database Health Monitor for SQL Server is an invaluable tool for monitoring performance and identifying potential issues before they become significant problems. One of the most critical aspects of SQL Server Performance monitoring is understanding …

Managing SQL Server with Database Health Monitor Read more »

Exploring Sample SQL Databases in SQL Server SQL Server is a robust relational database management system that offers a variety of features for data management, analysis, and reporting. One of the great resources for learning and testing SQL Server capabilities is the set of sample databases provided by Microsoft. These databases are rich with sample data and scenarios, making them …

Exploring Sample SQL Databases in SQL Server Read more »

Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS MEMORY_ALLOCATION_EXT SP_SERVER_DIAGNOSTICS_SLEEP CXPACKET ASYNC_NETWORK_IO LCK_M_SCH_S LCK_M_S LCK_M_IX LCK_M_IS LCK_M_U Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

Learn how a worktable table applies in the realm of SQL Server, efficient query processing and resource management are crucial for maintaining performance and reliability. One of the often-overlooked components that play a vital role in query execution is the worktable. In this blog post, we’ll delve into what worktables are, how they function, and why they are important for …

What is a Worktable in SQL Server Read more »

Converting data types is a common task in SQL Server, especially when dealing with data imports or migrations where data might not be in the desired format. One frequent requirement is converting text data to integer data types. In this blog post, we’ll explore various methods for converting text to integers in SQL Server, discuss potential pitfalls, and provide best …

Converting Text to Integer in SQL Server Read more »

One of the fundamental aspects of working with SQL Server is understanding how to get the number of rows affected by a query. Whether you’re working with SELECT, INSERT, UPDATE, or DELETE statements, knowing the row count can provide critical insights into your database operations. In this blog post, we’ll explore different methods to retrieve the row count in SQL …

Understanding SQL Query Row Count in SQL Server Read more »

Have you seen our Managed Services offering? Managed Services for SQL Servers has become one of the largest parts of our business, and we have even expanded the managed services team now to 4 people supporting clients SQL Servers. A short video where I describe the managed services offering that we have at Stedman Solutions to support SQL Servers. We …

Have you seen our Managed Services offering? Read more »