Viewing Deployed XEvent Metadata

When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events....

Viewing Deployed XEvent Metadata

Today will be the first of a few introductory level posts about Extended Events.
When dealing with Extended Events, there are...

Pro SQL Server Wait Statistics available now!

Remember that blog post from April this year that I announced working on my first ever SQL Server related book...

Monitoring of free space in database files

Monitoring of the size of database files is one of the important DBA tasks and this process should be automated....

10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)

If you’ve read my blog for a while you may have seen the following posts:
Ten MDX Calculations For Your Cube...

Better Test Data Domains with SQL Data Generator

I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with...

CISL – Columnstore Indexes Scripts Library, Release 1 (“Ortus”)

I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”.

Go on...

Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT

I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my...

Shredding Extended Event Actions

Are you rolling the dice with your love/hate relationship with XML? Tune in to see how you can ease your XML frustration along with increasing your free time to...

Shredding Extended Event Actions

The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that...