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 …
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 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 …
Need some help? Introducing SQL Server Mentoring: Your Shortcut to Expert Guidance 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-04 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: NoneCU6 …
Greetings, fellow SQL enthusiasts! Steve Stedman here, thrilled to introduce you to an invaluable resource that will revolutionize your SQL Server experience. At Stedman Solutions, we understand that sometimes a little guidance can go a long way, without the need for a long-term commitment. That’s why we’ve developed our SQL Server Mentoring service—a game-changing option designed to provide you with …
Unlock Your SQL Server Potential with Stedman Solutions’ Mentoring Service Read more »
Last chance saving on Database Health Monitor Sun, 30 Jul 2023 You only have until the end of the day to get this Database Health Monitor discount of 25% off. This month marks the anniversary of Database Health Monitor. To celebrate I am offering 25% off the licensing fee for th Read more… Database Health Monitor with Coaching Fri, 28 …
You only have until the end of the day to get this Database Health Monitor discount of 25% off. This month marks the anniversary of Database Health Monitor. To celebrate I am offering 25% off the licensing fee for the annual subscription for Database Health Monitor but this deal is only good when you purchase before the end of July. …
With years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. With this month being Database Health Montior month we have a special combo offering. I created the Database Health Monitor course to help people get the most value out of using the product, and with …
As a business owner or IT professional, you know that your data is one of your most valuable assets. That’s why it’s critical to protect it against data loss, hardware failures, cyberattacks, and other threats. One of the best ways to do this is to run regular database backups on your SQL Server. In this blog post, we’ll discuss why …
The Importance of Running Backups on SQL Server and Why You Need to Test Them 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 …