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 …
In SQL Server, locking and blocking are mechanisms that are used to protect data integrity and consistency by controlling access to data by concurrent transactions. Locking is the process of identifying and reserving data resources for use by a specific task, while blocking is the process of preventing other tasks from accessing data that is currently being used by another …
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 …
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 December Read more »
50% off TSQL JOIN Types class Wed, 30 Nov 2022 As the last day of November, today is the last day that I will be promoting specials for our SQL Server training courses. Today’s promotion is 50% off the SQL Server JOIN Types class. The JOIN Types class is ou Read more… Free Ransomware Course – Everyday Value Tue, 29 …
As the last day of November, today is the last day that I will be promoting specials for our SQL Server training courses. Today’s promotion is 50% off the SQL Server JOIN Types class. The JOIN Types class is our best selling class and will teach you all the ways to connect tables using different types of JOINs. In this …
Around a year ago I put together this free Ransomware Awareness course. It is one of those things that I felt so strong about because I had seen so many small (and large) business being impacted by ransomware. If I can give this course away and prevent just one ransomware course, it has bene worth it. In the last couple …
Today’s amazing deal is the backup and recovery course. Being Cyber Monday, we have to get a bit crazy, and for crazy deals today we have first 90% off the backup and recovery class until 8:00am pacific time. If you are late and miss that deal you can still get the course with an 80% discount until 11:00am pacific time, …
For those who purchased the backup and recovery course during the first 28 days of November I have a deal for you. Absolutely free, not strings attached is the aggregation course to say thank you for your purchase. If you registered for the backup and recovery course in November, you just need to watch your email and in the next …
Free Aggregating Course for anyone who purchased the backup and recovery course Read more »
The reason that I have chosen this deal for Small Business Saturday is that this blocking query script has made such a big difference for so many of our small business customers. This is more than just a course, enrollment in the course also gets you access to our track blocking queries script, and training on how to use it. …
Small Business Saturday Deal 50% off Track Blocking Queries with Email Alerts Read more »