I’m Presenting at PASS Summit 2019!

I’m Presenting at PASS Summit 2019!

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 incredibly fun - and exhausting - week ahead! Be sure to follow me on Twitter as I will have plenty of updates throughout the week. Here's what I'll be up to: Session My session this year is on…
Read More
Microsoft Focus Groups at PASS Summit 2019!

Microsoft Focus Groups at PASS Summit 2019!

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, Thursday, and Friday. Rie Irish (@IrishSQL) has posted a full schedule on her blog, with registration links for each. (Separate registration via EventBrite is required.) I'm really looking forward to this unique opportunity to provide feedback to product teams. I hope to see you there as well!
Read More
Finding Your Isolation Level

Finding Your Isolation Level

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 checked. Isolation Level Hierarchy Isolation level settings can be configured in three different places: Database (this is only a default, with limited choices)Connection (affects all queries using this connection)Statement (affects only a specific query) Database Isolation Levels Isolation level settings for the entire database exist…
Read More
I’m Presenting at GroupBy!

I’m Presenting at GroupBy!

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 that the stars have aligned and I am able to participate. Even more exciting is that GroupBy is offering two streams this time around. European sessions will take place on Wednesday 9 October starting at 10:00am UTC, and North American ones will…
Read More
Upload Directly to Azure Blob Storage Archive Tier with PowerShell

Upload Directly to Azure Blob Storage Archive Tier with PowerShell

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 announced some enhancements to Azure Archive storage, one of which is the ability to upload directly to the access tier of your choice. Previously, you could only upload objects to your account's default tier (hot or cool), and then had to change each object to…
Read More