All the news from the Keynote on day 1 of PASS Summit 2018!

Read More

All the news from the Keynote on day 1 of PASS Summit 2018!

Read More

I don't know where the last year went, but it's once again time for PASS Summit. It really doesn't feel like a year has passed! This will be my seventh PASS Summit as an attendee and my sixth as a speaker. I know I'm extremely fortunate to have been able to attend and present so many times, and am looking to the …

Read More

PASS Summit is now approaching really quickly, so this will be my final tip for the year. I've mentioned in previous posts about the tremendous networking opportunities you will find at Summit, and I'm going to bring that up again, because I really feel it's that important. There is a ton that goes on during the day at …

Read More

I'm very proud to once again be speaking at SQL Saturday in Portland, Oregon, coming up on November 3! Portland is one of my favorite cities and has long been one of my favorite SQL Saturday events. It also a wonderful way to ease in to a great week at PASS Summit, and the start point of the SQLTrain, both of which I …

Read More

Well, maybe the title is a little bit harsh. You absolutely can drop a SQL Server database that's offline, but remember that its files won't be deleted if you do. Safely Dropping Databases At a previous employer, we had a well-defined process when dropping databases for a client. It went something like this: Confirm in …

Read More

This week's PASS Summit Tip is all about food. And with all the learning and networking opportunities you'll find there, you're going to need a lot of it! Have you ever been to a wedding where the food is just "meh"? It's edible, but nothing great. You can't blame the happy couple for it, because they're …

Read More

This Month's T-SQL Tuesday is hosted by Jeff Mlakar, and he has asked for us to tell the tale of a project that went horribly wrong. This will be short, but it's one of my favorite stories of a project that wasn't totally thought through. I (thankfully) wasn't part of the team for this, but the way word spreads in IT, …

Read More

This PASS Summit tip is all about power. Electricity. Inconveniencing electrons for your own personal benefit. If you're attending a tech conference, chances are really good you'll have multiple computing devices with you, and each of those devices will need power. And if you're like me, you'll be doing plenty of …

Read More

I've been honored to present a session at PASS Summit for the past few years, but this year I am especially humbled as I had not one but two abstracts accepted! The first is an introduction to Azure Cosmos DB. The other is covering some of my favorite SSMS and T-SQL tips and tricks that can help you save time! Select …

Read More