Speaking at PASS DBA Virtual Chapter

If you are looking to become more familiar with extended events, take a gander at this month’s DBA Virtual Chapter meeting.  I’ll be presenting at both of the meetings for the month. The first meeting will cover the basics and some information on where Extended Events is going.  The second will cover some deeper content … Continue reading Speaking at PASS DBA Virtual Chapter

T-SQL Tuesday #17 – APPLY Knowledge

It’s that time of the month again… again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Matt Velic (Blog | @mvelic).  The topic that he chose for this month is the APPLY operator. This is a great topic.   I like it because, often, when I am presenting I ask the question, “who … Continue reading T-SQL Tuesday #17 – APPLY Knowledge

Index Black Ops Series

Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats.  The series investigates how the columns in the DMV are populated and demonstrates how to aggregate values in the DMV. The posts in this series are: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 … Continue reading Index Black Ops Series

Aggregating With Correlated Sub-Queries #tsql2sday

It’s that time of the month again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek).  The topic that she chose for this month is aggregates. The Dilemma A few months ago, a client I was working with had a dilemma with one of their search queries.  A query … Continue reading Aggregating With Correlated Sub-Queries #tsql2sday

FileSystemHelper Update and Release

About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients.  As a result, I had created the CodePlex project FileSystemHelper.  I blogged about it back then and had meant to get back to it with a number of updates but that never really happened.  Along the … Continue reading FileSystemHelper Update and Release

Can You Dig It? – Plan Cache Series

A few PASS Summit’s ago, I became interested in the information available in the Plan Cache.  As part of that interest, I started digging into the plan cache to  find out what is there and available to be pulled out. Some of those investigations led to a few presentations; which have in turn led to … Continue reading Can You Dig It? – Plan Cache Series