By Posted on Posted in Performance No Comments

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

Common Waits Reported by Daily Monitoring This Month Read more »

By Posted on Posted in Classes No Comments Tagged with , ,

Today I am pleased to announce that we have a new course available at Stedman SQL School. This is our second class in the SQL Short series, which is a set of short but focused courses to help improve your SQL query skill in specific areas. The Aggregating Data in Your SQL Server course is a detailed course on how …

SQL Short – Aggregation Class Read more »

By Posted on Posted in Performance, Server Health, SQL Daily Checkup, SQL Monitoring No Comments Tagged with , , , , ,

Some businesses overlook the database assessment. Here are a few reasons why you shouldn’t. Faster server faster queries – I probably don’t need to explain “faster” to you but when we perform a performance assessment we find the underlying cause of the poor performance. No more performance patch up work. Once fixed, it will free up time for your team …

Faster, Better, Safer with a SQL Assessment Read more »

By Posted on Posted in Performance No Comments

I have used my over 30 years of SQL Server experience to personally curate my favorite performance tuning tips and tricks into this training. I am excited to contribute and share with the SQL Server community some of my favorite solutions. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. …

Exclusive SQL Performance Tuning Training Read more »

By Posted on Posted in Classes 2 Comments Tagged with ,

I have just completed a course in our SQL Queries series called TSQL Output Clause.   This is a short course, priced at a value for just $5.00. Course Title Using the TSQL Output Clause   Course Details The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and it cause be …

TSQL Output Clause course – just released Read more »

By Posted on Posted in Performance Tuning, Server Health, SQL Daily Checkup, SQL Monitoring No Comments Tagged with , , , ,

For the month of October we are offering a free add-on for anyone who purchases a Server Assessment from Stedman Solutions. From October 1st to October 31, with the purchase of server assessment, you will also receive for no additional charge 1 full year of our SQL Daily Monitoring product. If your assessment is for one SQL Server you will …

Receive a full year of Daily SQL Monitoring FREE Read more »

By Posted on Posted in Performance No Comments

Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …

Daily Server Monitoring – SQL Versions for October Read more »

By Posted on Posted in Backup, Recovery No Comments Tagged with , , ,

Current SQL Server course coupon codes and on going deals you can only get from Stedman Solutions! See All Our Online Courses! On Going Deals you can only get from Stedman Solutions FREE JOIN types reference sheet Free Ransomware / Cyber Attack Awareness Course Free Database Comparison Tool Free SQL Server CTE Book

By Posted on Posted in Backup, Recovery No Comments Tagged with , ,

“Oh yes of course I have SQL Server backups” Take another look. Do they fit your needs? About 40% of new customers we meet do not have adequate backups for their business! That’s 1 in 3 companies! This course helps you determine or learn: What your needs are What type of backup fit your company How often to run backups. …

A Sneak Peek at the Backup and Recovery Course Read more »