Blog

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

Speaking at 24 Hours of PASS: Summit Preview 2019!

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 DBA experience, but aren't really familiar with what a data lake is or how you would use it, this is the session for you! Abstract As a data professional, you know what data is, and hopefully know what a lake is…
Read More
AI-Powered Alt Text in PowerPoint

AI-Powered Alt Text in PowerPoint

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 description of the photo and placed it in the alt text field. It also superimposed it on top of the image, which is how I discovered this was occurring to begin with. Well that's really neat. I don't know when this…
Read More