Data Collection: Making Wait Statistics Useful

2015-05-29 0 Comments

I've become quite a fan of the SQL Server Data Collector over the last year. In particular, the Server Activity collection set is what really impressed me. But there is one part I found lacking:

0 comments:

Who Backed Up Your Database?

2015-05-17 0 Comments

As cool as server-scoped DDL triggers are, it's discouraging that you can't create one to fire on a database backup event or transaction log backup event.

0 comments:

Dear Developers, It's No Longer OK To Not Know The SQL Server Security Model

2015-05-14 0 Comments

I've got a bone to pick with you developers: stop asking for SQL logins with

0 comments: