Speaking at SQL Saturday #500 in Boston!

I have been selected to speak at SQL Saturday #500 in Boston on March 19th - I will be speaking (at...

SQL Server Statistics - Histograms

Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics...

Things I learned in 2015

Happy 2016!
I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what...

CISL 1.1.0: cstore_doMaintenance (Columnstore Maintenace Solution Explained)

After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...

Notes from SQLSaturday #480 in Nashville

Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...

Notes from the January 2016 MagicPASS Meeting

I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with...

Overview of Published Articles – 2015Q4

Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...

Power BI Export Data

If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...

The SQL Server Security Model, Part 1: Logins [Foundations Friday]

How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...

T-SQL Code Coverage in SSDT using the SSDT Dev Pack

Code Coverage

What is code coverage?
When you write some code and then test it, how sure are you that you have...