SQL Performance Tuning Training
In this free training I have poured my 30+ years of SQL Server experience and personally curate my favorite performance tuning tips, tricks and tactics.… Read More »SQL Performance Tuning Training
Monthly Database Health Monitor Training with Q+A
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
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