5 Ways to Examine Cardinality Metrics
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
357 reads
SQLEspresso
Live, Learn, and Grow
Ever look back at old work and wonder what was I thinking when I did that? Or even better you...
2018-04-25
325 reads
Free Training 24HOP
In my sessions, I always talk about how to build your skill set when you don’t have a budget for...
2018-04-18
530 reads
Template Explorer Gold Mine
Sometimes as a newbie to SQL Server using SQL Server Management Studio (SSMS) you don’t know about the little gold...
2018-03-27
488 reads
SQL Server Updates Tricked Me for Years
When applying a new SQL Server cumulative update, hot fix, or upgrade SQL Server doesn’t always apply all the fixes...
2018-02-21
1,137 reads
Bloggers Should Have Reach
One of my goals for 2018 is to expand the reach of my blog.
As a blogger starting out I had...
2018-02-14
314 reads
Expanding My Reach
I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted. Simple- Talk is technical journal and...
2018-02-07
308 reads
Can You Hear It Now?
Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...
2018-01-31
376 reads
Maintaining Balance
Last week, I got the chance to give my I’m It Survival Tips for the Lone DBA in a webcast for the first...
2018-02-09 (first published: 2018-01-24)
1,642 reads
How to get started with Always Encrypted for Beginners Part 3: One Two Punch
A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always...
2018-01-17
770 reads
Blogs
Monday Monitor Tips: Searching Permission Changes
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
Generative AI vs Predictive AI | Real-World Examples & Tools You Should Know
By Rohit Garg
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming...
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Forums
Best Compliance Training for Professionals to Stay Ahead of Regulations
Finding the best compliance training is essential for professionals who need to stay current...
SQL Server 2008 to SQL Server 2022
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers