PASS DBA Virtual Chapter Tomorrow

Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter.  If you missed the first part of this series, you can watch it before hand here. Below are the details on the event and the session description… Extended Events, Work Smarter Not Harder – Part … Continue reading PASS DBA Virtual Chapter Tomorrow

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