Here is a sample query using the MIN and MAX functions in T-SQL: This query selects the minimum and maximum values for the Price column from the Products table. The results of the query will be a single row containing …
It’s never a good idea to email passwords, whether it’s your own personal password or a password that you’re sharing with someone else. Here are a few reasons why: A better option for sharing passwords is to use a service …
Corruption in a SQL database is when the database becomes damaged or corrupted, making it unable to be used or accessed. This can happen for a number of reasons, such as hardware failure, software bugs, or even human error. When …
New Course – Preparing for Corruption 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. …
Common Waits Reported by Daily Monitoring This Month Read more »
SQL Server backups are an essential part of any database administrator’s job. In this blog post, we’ll discuss what SQL Server backups are, why they’re important, and how to create them. First, let’s define what a SQL Server backup is. …
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 …
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 …
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 …
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 …
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 …
Daily Server Monitoring – SQL Versions for December Read more »