Improve you knowledge and skill set with this FREE Database Health Monitor training and Q&A. This training will be held every month on different days… Read More »Monthly Database Health Monitor Training with Q+A
Securing SQL Server: Transparent Data Encryption Mon, 30 Jan 2023 Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption… Read More »January Blog Post Wrap-up
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… Read More »Securing SQL Server: Transparent Data Encryption
If you are one of our Managed Service clients, you have 100% free access to all current and future online courses. And yes, new classes… Read More »Complete Access to all our Online SQL Server Courses
Primary keys are an essential element of database design and are used to uniquely identify each record in a table. In SQL Server, primary keys… Read More »Primary Keys on SQL Server
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.… Read More »SQL Server Wait Type: PREEMPTIVE_OS_QUERYREGISTRY
In SQL Server, the fill factor is a configuration option that determines how much space is left on each page of an index when it… Read More »Fill Factors on Indexes – What does that mean?
You call us in the middle of the night, and within 2 hours we’re on the issue with our Highly Available Support Managed Service! Just… Read More »3am SQL Emergency? We have a Service for that!
Synonyms in SQL Server are a useful feature that allow developers to create an alias or alternate name for an object in the database. This… Read More »Using Synonyms on SQL Server
To find the most used data files on SQL Server, you can use the sys.dm_io_virtual_file_stats dynamic management view. This view contains statistics about the I/O… Read More »Query to find the most used data files on SQL Server