Finding Free Space Per Drive & Mount Point in PowerShell

Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter) about checking Disk Space & Mount Points...

Finding Free Space Per Drive & Mount Point in PowerShell

Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter) about checking Disk Space & Mount Points...

Not SQL: Taking a stand against scammers

If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...

Power BI Premium, Report Server, Apps and API

Announced today are some really cool new Power BI features:
Power BI Premium
Previously available were two tiers, Power BI Free and...

SQL PowerShell 2017 IS HERE!

Cue Princess Jasmine.
What do I mean “Cue Princess Jasmine”?

Well because starting today, it’s a “Whole New World for You & Me”
What...

SQL Server 2017 Announced

By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...

The Birthday Problem – with T-SQL and R

When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people,...

Understanding Database Backup Encryption in SQL Server

Terabytes of data, millions of rows; the entire business depends on this — a database administrator’s responsibility is as massive as...

Why CROSS APPLY is AWESOME

CROSS APPLY was introducted as part of TSQL in SQL Server 2005. Origionally it was created as a way to...

Adaptive Query Processing – Interleaved Execution

A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...