This month's T-SQL Tuesday is being hosted by Steve Jones, who has asked for blog posts today on experiences we have had with triggers, good or bad.

I am not a fan of triggers. While they represent a very simplistic construct of "if something happens, do something else", I've yet to encounter a situation …

Read More

I'm very happy to be presenting at next month's meeting of the Chicago SQL Server User Group! This meeting will take place on Thursday August 9 at the Microsoft Technology Center in Chicago. For a little something different, I won't be speaking about SQL Server. Instead, I will be giving an introduction to Azure …

Read More

As a former DBA, it should be no surprise that I am a big fan of keeping data safe, and not just corporate data – this extends to my personal data as well. Early on I realized that the cloud was a great way to protect all my photos, videos, and other digital keepsakes that I absolutely could not stand to lose. As cloud …
Read More

I always feel honored when chosen to present at a SQL Saturday event. Being selected is never a guarantee, especially these days when organizers seemingly have more speakers and abstracts to pick from than ever before. But I am just over-the-moon happy to share that I was picked to speak at SQL Saturday in Oslo, Norway …
Read More

If you've been a SQL Saturday organizer for a few years, you might remember that prior to March of 2014, PASS handled much of the finances. All money collected from sponsors and meal fees went into a trust account managed by PASS which was earmarked for that specific event. Organizers then requested their funds from …
Read More

I've found myself working with PowerShell more frequently as of late, in no small part due to the amazing dbatools module. This has led to me trying to figure out how else I can utilize it for some of my personal internal processes.

I like to use public datasets for experimentation and presentation demos, especially …

Read More

Next week I am happy to be presenting for the Chicago Suburban SQL Server User Group, which meets in Downers Grove, IL.

I will be delivering my session Locks, Blocks, and Snapshots: Maximizing Database Concurrency. This takes a look at SQL Server’s available isolation levels, what they are, how they differ, and why the …

Read More

I'm very pleased to be returning to Wisconsin in April to speak at SQL Saturday Madison 2018! This has always been one of my favorite events. Not only is it close to home, but it's in a wonderful location and full of great friends. Thank you so much to the organizing committee for all of the hard work you do!

This year …

Read More

I think one of the reasons I like computers is that they're so much easier to deal with than people. They're predictable, emotions never get in the way, and there's always a logical explanation for everything if you dig deep enough. All that being said, I am grateful for my hobbies that don't involve sitting in front …

Read More

If you've done any amount of work in Linux from Windows, chances are pretty good you've used PuTTY at some point. PuTTY is a free and open-source terminal emulator that supports a variety of protocols, including SSH. I've been using it since college and have always been very happy with it. It's free, it's tiny, and it …
Read More