Seattle SQL Pro Workshop 2017

Free workshop on SQL Server leading up to Summit 2017 that will provide attendees an alternate means to increase affordable learning opportunities during the week.

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.

Freecon – Oct 27 in Seattle

It is well known that there is a wealth of information within Extended Events. One can tap plenty of information about performance issues, errors, or general interest type stuff by setting up an XEvent Session and trapping some (hopefully) useful information.