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 like privnote.com. This service allows you to create a secure, encrypted note that you can share with others. The recipient …
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 a database is corrupted, the data it contains may be lost or inaccessible, which can be a major problem for …
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. PREEMPTIVE_OS_PIPEOPS CXPACKET ASYNC_NETWORK_IO OLEDB SP_SERVER_DIAGNOSTICS_SLEEP XE_LIVE_TARGET_TVF LCK_M_SCH_S CXCONSUMER MEMORY_ALLOCATION_EXT LCK_M_S Our daily monitoring product scans your SQL Server hourly and …
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. In simple terms, it’s a copy of your database that you can use to restore your data in case of …
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 …
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 …