Steve Stedman

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 ASYNC_NETWORK_IO CXPACKET CXCONSUMER LCK_M_IS MEMORY_ALLOCATION_EXT OLEDB XE_LIVE_TARGET_TVF PREEMPTIVE_OS_GETPROCADDRESS TRACEWRITE Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

August Promotion SQL Daily Checkup 6 months free with any new or renewing mentoring client. Sign up for a 4 or 8 hour mentoring package in August and receive 6 months of our daily checkup service for free. If you already are using our SQL Daily Checkup, we will extend your subscription by 6 months. Offer expires August 31. Greetings, …

Special Offer: Get a Complimentary SQL Daily Checkup with Stedman Solutions’ Mentoring Service in August! Read more »

August Promotion SQL Daily Checkup 6 months free with any new or renewing mentoring client. Sign up for a 4 or 8 hour mentoring package in August and receive 6 months of our daily checkup service for free. If you already are using our SQL Daily Checkup, we will extend your subscription by 6 months. Offer expires August 31. Hey …

Exciting Offer: Get a FREE SQL Daily Checkup with Stedman Solutions’ Mentoring Service in August! Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2017 CU31 for 2017 (14.0.3456.2 – September 2022) CU31 + GDR (14.0.3460.9 – February 2023) 2023-08-15 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU7 …

New SQL Update from Microsoft Read more »

Finding and removing duplicate indexes is an essential part of database performance optimization, as duplicate indexes can cause unnecessary overhead and negatively impact query performance. The Database Health Monitor for SQL Server provides insights into duplicate indexes, enabling you to identify and remove them to improve database performance. Duplicate indexes occur when two or more indexes cover the same column …

Database Health: Finding Duplicate Indexes Read more »

A short video where I describe the managed services offering that we have at Stedman Solutions to support SQL Servers. We can help with 1 SQL Server, 50 SQL servers, or more with our managed services offering. In an age where data is the new gold, managing this treasure trove efficiently is paramount to a business’s success. A robust data …

Understanding the Critical Role of a Database Administrator Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU7 for 2022 (16.0.4065.3 – August 2023) 2023-08-10 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU7 for 2022 (16.0.4065.3 – August 2023)   …

New SQL Update from Microsoft Read more »

Sometimes we all need a little help without a long term commitment. That why we created our SQL Server Mentoring service at Stedman Solutions. SQL Server Mentoring is a training / consulting option for those who just need a little help or direction. This is a cost-effective approach for those who need just a little help. Some call it coaching, …

SQL Server Mentoring – Do you need a hand? Read more »

DBCC PINTABLE is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL Server. SQL Servers DBCC PINTABLE command is an undocumented database console command that is used to pin a table in the cache of a SQL Server instance. Pinning a table in the cache allows it …

SQL Server DBCC Commands: DBCC PINTABLE Read more »