PASS Board elections coming up

It’s four years since I ran for election to the PASS Board now, for a two year term which ended two years ago. The two other people that got elected when I did were Denise McInerney and Adam Jorgensen. Two years ago, Denise and Adam became the two Vice Presidents, and Adam is about to … Continue reading PASS Board elections coming up

Superhero powers for managing the enterprise

This month’s T-SQL Tuesday is hosted by Jen McCown of @midnightdba fame. She wants us to write about strategies for managing the enterprise, and as a database consultant, I find myself giving advice on this kind of thing to customers remarkably often. No, I’m not going to do stories about LobsterPot customers. We don’t do … Continue reading Superhero powers for managing the enterprise

SQL 2014 queries under a strobe light

I just wrote a post about Live Query Statistics. Let me show you how this technology in SQL Server 2014 can be used for some amazingly cool (nerdy cool, at least) stuff. Behind the scenes, LQS uses a DMV called sys.dm_exec_query_profiles. When you run a query with SET STATISTICS PROFILE ON, the engine puts data … Continue reading SQL 2014 queries under a strobe light