..And The New Adventure Has Begun

I am so happy to announce that I have joined the team at Fortified Data. I have just completed my first week (well, four days) and I feel like...

SQLSat Baton Rouge 2023!

Looking forward to #jambalaya at #SQLSatBR on July 29! Register today: sqlsatbr.comI hope to see as many people as possible that weekend, I'll be there at the Friday night...

A New Word: Ozurie

Ozurie – feeling torn between the life you want and the life you have. I think many people feel ozurie often. I certainly had a lot of this in...

Notes from SQLSaturday South Florida 2023

Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.

Statistics and the Ascending Key Problem

I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...

Volunteering at Work: Teaching Others

I give a few talks on career topics, and one of these is Branding Yourself for a Dream Job. In the talk, I sometimes tell a story in the...

db_ddladmin Jr.

A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema ... Continue reading

Tracking the Inaccurate Cardinality Estimates

Tracking the Inaccurate Cardinality Estimates

When it comes to query performance, lately the Cardinality Estimates seems to have been a hot topic with each new release  of SQL...

Microsoft Fabric Overview

First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...

Reading and searching events inside the SQL Server default trace

Note: SQL Trace and SQL Server Profiler are deprecated and will be removed in a future version of Microsoft SQL Server. The replacement technology for them is Extended Events. To Learn More: https://learn.microsoft.com/en-us/sql/relational-databases/sql-trace/sql-trace?view=sql-server-ver16SQL Server...