Bob Pusateri, Author at Bob Pusateri

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…

28 Oct 2019

By Bob Pusateri

Microsoft Focus Groups at PASS Summit 2019!

PASS Summit

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!

17 Oct 2019

By Bob Pusateri

Finding Your Isolation Level

SQL Server

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…