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?

Extended Events – Better than Profiler

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.

Bare Naked Skinny on SQL Server

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Monitoring SQL Server with Extended Events

Every good enterprising DBA has the prime directive of monitoring the SQL Servers under his/her jurisdiction. The last thing a DBA wants to hear is that there is a problem with a database under his/her purview from an end-user.

A Masters Passport to Extended Events

As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.

SQL Server Compression and what it can do for You

ABSTRACT SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. […]

Extended Events in SQL Server

Abstract: 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. We will […]