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 of a databases data and log files, as well as the encryption of backups, to protect sensitive data from unauthorized access. TDE encrypts the dat Read more…
Complete Access to all our Online SQL Server Courses
Sat, 28 Jan 2023
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 are consistently being added! Here is a current list of all online courses available now Read more…
Primary Keys on SQL Server
Fri, 27 Jan 2023
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 are implemented using a constraint that ensures that each row in a table has Read more…
SQL Server Wait Type: PREEMPTIVE_OS_QUERYREGISTRY
Thu, 26 Jan 2023
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 Read more…
Fill Factors on Indexes – What does that mean?
Tue, 24 Jan 2023
3am SQL Emergency? We have a Service for that!
Mon, 23 Jan 2023
Using Synonyms on SQL Server
Sun, 22 Jan 2023
Query to find the most used data files on SQL Server
Fri, 20 Jan 2023
Is Your SQL Server Secure?
Thu, 19 Jan 2023
Our Managed Services Video Explanation
Wed, 18 Jan 2023
Securing SQL Server: Renaming and Disabling the SA Account
Tue, 17 Jan 2023
Common Waits Reported by Daily Monitoring This Month
Mon, 16 Jan 2023