Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as the encryption of backups, to protect sensitive data from unauthorized access. TDE encrypts the data at the page level, meaning that the data is encrypted as it is written to the disk and decrypted when …
Securing SQL Server: Transparent Data Encryption Read more »
DBCC INPUTBUFFER is a DBCC command in Microsoft SQL Server that can be used to retrieve the last batch of Transact-SQL statements submitted through a specific connection to the database engine. It can be useful for troubleshooting problems with long-running queries, identifying the cause of deadlocks, or simply examining the T-SQL code being executed on the server. To use DBCC …
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 …
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. …
A corrupt SQL Server database can be a nightmare scenario for businesses, as it can lead to data loss, operational disruptions, and financial repercussions. Ignoring a corrupt database and neglecting the necessary repairs can exacerbate the situation, intensifying the consequences. In this blog post, we will explore the potential outcomes of not repairing a corrupt SQL Server database and highlight …
SQL Server: Consequences of Ignoring a Corrupt SQL Server Database Read more »
In addition to its customizable dashboard, intelligent alerting system, and powerful reporting capabilities, the Database Health Monitor also provides valuable insights into wait statistics and blocking queries. Wait statistics are a crucial component of database performance monitoring, as they provide information about the amount of time that queries spend waiting for various resources, such as locks, I/O operations, or CPU …
Database Health: Wait Statistics and Blocking Queries Read more »
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 …
Master SQL Server Replication with Our Comprehensive Course At Stedman’s SQL School, we are proud to offer a thorough and detailed course dedicated to SQL Server Replication. This course is designed for database professionals who wish to deepen their understanding of replication to enhance their skills in data synchronization and integration across multiple databases. Whether you’re a seasoned DBA or …
SQL School: SQL Server Replication Our Comprehensive Course Read more »
Are you ready to supercharge your SQL Server’s Performance? If so, you’re in luck! We’re thrilled to announce an exclusive limited-time offer on our comprehensive SQL Server Performance Tuning course, designed to equip database professionals with the skills and knowledge needed to optimize SQL Server Performance effectively. 11% OFF – Enroll Now at 11% off With Coupon Code PERF11 Enroll …
SQL School- Unlock Peak Performance With our Performance Tuning Course Read more »
Over the years I have documented many of the concepts around corruption repair. Want to find out more, check out the corruption category at by blog. NOLOCK is a query hint in SQL Server that allows a SELECT statement to read data from a table without acquiring a shared lock on it. This means that the query can read uncommitted …