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 eighth PASS Summit as an attendee and my seventh 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

This year Microsoft is conducting focus groups at PASS Summit. Attendees will be able to meet with members of various product teams and either provide feedback on existing features or learn the roadmap for where different facets of a product are headed. Focus groups will be taking place throughout the day on Wednesday, …

Read More

Often when I am troubleshooting SQL Server or Azure SQL Database performance issues which I believe to be related to concurrency, I get curious about what isolation level is being used. But how does one find out the isolation level a query is executing with? There are actually several locations that may need to be …

Read More

I'm always happy when I have the opportunity to present a session for an audience, but I am especially excited about delivering a session for GroupBy next week! GroupBy is a free online training event that has been going on for about three years. I've always thought it was a great concept, but it hasn't been until now …

Read More

Last year I wrote about how to upload data to Azure Blob Storage Archive Tier, and included a PowerShell script to do so. It's something I use regularly, as I have hundreds of gigabytes of photos and videos safely (and cheaply!) stored in Azure Blob Storage using Archive Tier. Things Just Got Easier! Microsoft recently …

Read More

With PASS Summit 2019 quickly approaching, PASS is organizing a sneak peek at some of the sessions presented at Summit in a 24 Hours of PASS event coming up on September 10-11. I'm very happy to be delivering a brand new session entitled Dipping Your Toes In: Azure Data Lake for DBAs. If you've worked with data or have …

Read More

I was working on a slide deck and did something I don't normally do – I added a photo. Usually the graphical content of my presentations involves diagrams or other vector art – I don't often have the need for actual photos. But this time I did, and I was really surprised to see that PowerPoint generated a text …

Read More

After months of hard work on the part of volunteers and PASS HQ, the session schedule for PASS Summit 2019 is live! You can find it here. My hat goes off to the fine people who put this together – building conference schedules is not for the faint of heart. Now that session times and locations have been determined* …

Read More

SQL Saturday Indianapolis is coming up quickly – it's in less than two weeks! I am very happy to be returning to Indy on Saturday, August 17 to deliver my session Dipping Your Toes Into Azure Data Lake for DBAs. Abstract: As a data professional, you know what data is, and hopefully know what a lake is too. But what's a …

Read More

In the past few months I've had not one but two shining examples of how having a backup strategy meant absolutely nothing when it came time to restore from a disaster. All the backup planning in the world is completely useless if you can’t successfully restore your backups. The Ransomware I had a client that was hit by …

Read More