Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. Ones that I thought were pretty decent that have been lost to the time. Some of them have pretty decent content, in my opinion, and don’t deserve to live solely in the moment that they … Continue reading Re-Blogging Posts
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
I’m going to SQL Rally! Are you going to SQL Rally? Have you heard of SQL Rally? What’s SQL Rally? I’m glad you asked. SQL Rally is a new two day PASS conference. It’s a great cross between the PASS Summit and a SQL Saturday. For a couple days, you can come together with a … Continue reading I Got Registered!
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)
Yesterday, I went in for my re-take of the MCM written exam. If you recall, I failed the exam last time. I did a great job of failing, in fact, and only received a 522 on the exam. I didn’t share my score previously because it was a bit embarrassing. And honestly, I wasn’t sure … Continue reading MCM Exam – Take 2
We’ve seen a few summaries come through by now, so I’m going to throw mine into the mix. To recap those that I’ve already read, there are: Grant Fritchey (Blog | @GFritchey) – Summary Jes Schultz Borland (Blog|@grrl_geek) – Summary Kelly Martinez (Blog | @greeleygeek) – Summary Bringing Friends One thing different about this SQL … Continue reading #SQLSat67… it's mystery is only exceeded by it's power.
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
Last week I spoke at the TechFuse event in Minnesota – out at Mystic Lake Casino. As I mentioned in the session, I wanted to post the content from my session – [download id="5"]. Along with including a few links that people might find useful. First, we skipped talking about XQuery – if you want … Continue reading TechFuse Follow-Up
A couple weeks ago, I got some pretty great new. The book proposal that I had submitted to Apress was accepted. Over the next few months, I’ll be working on a book with a focus on indexing. As part of this, I want to find out your indexing strategies? It’s not that I don’t have … Continue reading What Are Your Indexing Strategies?
Twin Cities Code Camp will be hitting the University of Minnesota Campus again next month. This is a biannual event in the Twin Cities where developers can get together and show their code. An opportunity to see what other people are doing and to exchange ideas. The event is on Saturday and Sunday on the … Continue reading Twin City Code Camp 10 Is Coming
Strate SQL 