SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited...

What’s the Size of that Index?

When you need to figure out how indexes are contributing to the overall size of a table within a database, this script will help you!
Related Posts:

Ghosts in your Database...

What’s the Size of that Index?

I have previously written about finding what the big space consumers are within the database. I even shared scripts in...

Culture Differences: US v UK

This is a bit of an off topic post from the technical stuff, but there’s a bit of a tie-in,...

SQLSaturday #423 Baton Rouge

This is I believe the 7th SQLSaturday in Baton Rouge. Please come out this Saturday at the LSU Business Center...

Sneak Preview – Episode 014 - WaterOx Consulting

Let’s Play A Game! So, just to tickle your fancy, here is...
The post Sneak Preview – Episode 014 appeared first on...

Baltimore Crime Report Using Power BI

As part of my quest for using data to find answers to everyday questions using Power BI – after analyzing baby names...

Permissions Posters

I’ve been doing a lot of research recently for my permissions session and for a project at work. During said...

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:
He had a table of a few dozen million rows. The table had...

Single value filters and custom error messages in Power BI

"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief...