I’m excited to announce that I will be speaking at the July meeting of the virtual Boston Business Intelligence User Group. I’ll be presenting an introductory session on Microsoft Fabric. The session is hosted online so everyone is welcome to join for an evening of learning and networking. The event is free, but please register at the link below to help the organizers with logistics...
June 8, 2023
Upcoming Presentation – Boston Business Intelligence User Group
08June
June 7, 2023
Upcoming Presentation – Toronto Data Professionals Community
07June
I’m excited to announce that I will be speaking at the June meeting of the virtual Toronto Data Professionals Community. I’ll be presenting an introductory session on Microsoft Fabric. The session is hosted online so everyone is welcome to join for an evening of learning and networking. The event is free, but please register at the link below to help the organizers with logistics and...
June 7, 2023
Upcoming Presentation – Jacksonville SQL Server User Group
I’m excited to announce that I will be speaking at the July meeting of the Jacksonville SQL Server User Group (JSSUG). It’s always fun to spend some time with local SQL community. I’ll be presenting an introductory session on Microsoft Fabric. If you’re local, come on out and join us for an evening of learning, networking, and of course food. The event is free, but please...
February 14, 2023
What is a DWU?
14February
You’re new to Azure Synapse Analytics but you know you want to build a data warehouse. What do you do? After a quick search of the internet, you discover you need a Synapse dedicated SQL pool. Log into Azure, click a few buttons, deploy a Synapse workspace, and it’s time to get started with the dedicated SQL pool but there is one problem…you have no idea what a DWU is. The...
November 15, 2022
PASS Data Community Summit 2022
15November
We are back in business! It’s been a few years since there was an in-person PASS Summit. Some major changes and a couple of years later we are excited to be back in person for what is now the “PASS Data Community Summit”. If SQL Saturday and Data Saturday event sizes are any indication, this conference will be significantly smaller than past years when it was the PASS Summit but...
August 2, 2022
Create Comma Delimited List in SQL
02August
Previously, I wrote a blog about how to create a comma separated list in T-SQL. 12 years later…one moment I have to go check and see if I’m really so old that I can say I wrote a blog post 12 years ago… Ok, I’m back. It is confirmed. I am in fact officially old. I really did write that blog 12 years ago on June 23, 2010. Wow. Anyway… 12 years later that post has...
May 24, 2022
Azure Synapse Analytics Release Notes
24May
Each month the Azure Synapse Analytics team works hard to get new features, updates, and improvements out the door. Here you will find a running list of updates released each month and links to the corresponding blog posts from the product team. You can always find the full updates from the product team and other great Synapse content over on the Azure Synapse Blog. May 2022 Read about the May...
November 1, 2021
Log Analytics with Azure Synapse Analytics
01November
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to monitor them. How do you do that? By looking at the logs that are produced. How do you capture and make sense of thousands of log entries from hundreds of services for this really awesome solution you’ve been working on? Azure Monitor. This post isn’t...
November 1, 2021
Log Analytics with Dedicated SQL Pools (Formerly SQL DW)
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to monitor them. How do you do that? By looking at the logs that are produced. How do you capture and make sense of thousands of log entries from hundreds of services for this really awesome solution you’ve been working on? Azure Monitor. This post isn’t...
January 28, 2020
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
28January
I’ve come across another error message in my seemingly never-ending battle with Azure Key Vault. A while back I couldn’t delete a resource group because of Key Vault soft-delete. Then I couldn’t recreate a Key Vault with the same name again because of soft-delete. Which brings us to today’s post where I had to go to PowerShell and purge a key that but ran into an issue...
