Anatomy of Select

TSQL is one of the most valuable tools any SQL Server professional can add to their toolset. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.

Profiler vs. Xe Smackdown

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events.

SQL Server 2016 Just made SQL Server BEEFY-er!

SQL Server 2016 has just been released and your manager is pressing hard to hear from you what this could potentially mean for the business. Is there anything useful in this new release?