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
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
Use extended events; they work - and make you appear magical. -- "Write a SQL blog post in 11 words or less" via Thomas Larock (Blog | @SQLRockStar)
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
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
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
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
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s the eighth post in the plan cache series. I hadn’t expect to take as many days off from this due to the 31 Days of SSIS, but that one had a stricter time table that I … Continue reading Can You Dig It? – Find Estimated Cost
Last month, I published the 31 Days of SSIS blog series. As a conclusion to that series, I wanted to post a wrap-up post, but quite honestly I was a little out of steam on February 1. I wanted to thank those that have read or will read the posts in this series. It was … Continue reading 31 Days of SSIS Conclusion
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with an introductory post. This series has been a collection of the things that I’ve picked up over the years in my work with SSIS. I figured I’d end this series with a best practice that I’ve not often … Continue reading 31 Days of SSIS – SSIS Naming Conventions (31/31)
Strate SQL 