Atlanta BI Edition SQL Saturday Precon

The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...

Changing Course On Learning

With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...

Covering Indexes

Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a...

Puzzled by T-SQL

Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.
Adam...

Question of the Day: Check, Please

This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....

Row-Level Security part 2 – Controlling Write Access

My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible...

Run T-SQL in Parallel

Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations...

Run T-SQL in Parallel

Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times...

Speaking at SQLSaturday Nashville in January 2016

I’m starting the new year with a trip to Nashville for SQLSaturday #480 to do presentation on automating restores. New topic,...

What Do You Mean There is No Current Database Backup?!?

Yet another late night/early morning tale...

The LOG backups for multiple databases on a server failed overnight (not all databases, but...