January Blog Post Wrap-up
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
Securing SQL Server: Transparent Data Encryption
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
Complete Access to all our Online SQL Server Courses
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 on SQL Server
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
SQL Server Wait Type: PREEMPTIVE_OS_QUERYREGISTRY
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
Fill Factors on Indexes – What does that mean?
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?
3am SQL Emergency? We have a Service for that!
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!
Using Synonyms on SQL Server
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
Query to find the most used data files 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
Is Your SQL Server Secure?
SQL Server is a popular database management system that is widely used to store and manage data in a variety of applications. As with any… Read More »Is Your SQL Server Secure?