I’m Speaking at Pass Summit 2019
I am very excited to be heading to PASS Summit 2019 in Seattle next week. It’s one of my favorite weeks of the year. Getting to hang out with...
2019-11-01
21 reads
SQLEspresso
Invest in Yourself Stop Making Excuses
Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me and elicited a strong reaction from myself. It got me thinking I need to write...
2019-11-08 (first published: 2019-10-22)
1,559 reads
The FAST number_rows Query Hint
Query hints are always about tradeoffs—typically you are giving up something, such as flexibility, to achieve more consistency, or very specific performance characteristic. One example of this migt when...
2019-10-29 (first published: 2019-10-16)
1,028 reads
New Event Calendar
Speaking Engagements Check out my new Event Calendar, to see my upcoming and past speaking engagements. You can catch me at various events throughout the year. If you are...
2019-10-15
14 reads
SQL Server Statistics Health Reminder
I’ve written about statistics in SQL Server a few times now. Through conversations I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics...
2019-09-26 (first published: 2019-09-18)
503 reads
Quick SSMS Tip
It is widely known that I am a horrible speller and hate to type code. I tend to use a lot of code snippets and reuse code to avoid...
2019-09-20 (first published: 2019-09-11)
1,262 reads
What SQL Server Performance & Management Tools Do I Use?
Several times I’ve been asked what tools are in my performance tuning and SQL Server management arsenal, so I decided to just create this blog to list them out...
2019-09-04
438 reads
Are My SQL Server Indexes Being Used?
Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as...
2019-09-11 (first published: 2019-08-28)
2,797 reads
Keep It Simple Stupid
Some of us take days and weeks to write a blog, while others can take two minutes and write a great blog *cough* *cough* Denny (B|T). Why is that?...
2019-07-24
38 reads
Understanding Columnstore Indexes in SQL Server Part 3
My last two blogs were on understanding columnstore and creating columnstore indexes. In this post, I will touch on one last topic, when to use columnstore indexes. As noted...
2019-08-05 (first published: 2019-07-17)
650 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers