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
#SQLSat67… it's mystery is only exceeded by it's power.
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.
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
TechFuse Follow-Up
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
What Are Your Indexing Strategies?
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 City Code Camp 10 Is Coming
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
There's A New North Central Regional Mentor
What has two thumbs and just signed on to be a PASS Regional Mentor? This guy! Over the past couple weeks, I’ve been going back and forth with some e-mails with PASS. The result of which places me in the open Regional Mentor position for the North Central region. For a little history, this process … Continue reading There's A New North Central Regional Mentor
Happy Pi Day
Here’s wishing you a Happy Pi Day… If my picture isn’t good enough, here’s a better representation of pi. Hope you didn’t forget about Daylight Savings if you are one of the those afflicted by this change in the time zone.
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
SSWUG DBTechCon Coming Up
Over the last few years, I’ve blogged about and spoke at the SSWUG Virtual Conferences. It’s that time of the year again, and the next virtual conference is coming up in a few short weeks. The event will be on April 20-22 and you can attend from the comforts of your home or office. If … Continue reading SSWUG DBTechCon Coming Up
Strate SQL 