Future Data Driven is Coming Sept 27 for FREE

The Future Data Driven 2023 virtual conference is coming on September 27. Register today and save a note in your calendar. I have been honored to speak at this...

Power BI VertiPaq Engine: Optimizing Column Encoding

Power BI encoding is a powerful optimizing option that is often overlooked because it’s not visible in neither the Power BI Desktop tool nor in Power BI Service. Natively,...

Smooth Transition from Azure Synapse to Microsoft Fabric

The buzz around Microsoft Fabric has been growing steadily since its announcement. This game-changing platform unifies several critical Azure services, including Data Factory, Synapse, and Power BI, all under...

How to check if powershell is running as administrator with elevated privileges

How to check if powershell is running as administrator with elevated privileges

In case it's not clear from the title, I am referring to...

IRL #8: SQL Server Down

Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...

Manually updating Statistics in SQL Server

Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you...

Quick Tip About Fonts in Deneb Visuals in Power BI

This week, I was working with a client who requested I use the Segoe UI font in their Power BI report. The report contained a mix of core visuals...

Running Flyway from PowerShell–A Gotcha

I ran across an interesting gotcha while trying to run a Flyway command from PowerShell. Specifically, the snapshot command and providing a parameter that is the snapshot.filename parameter. Someone...

Connecting to SQL Server Database Engine, simplified

One of the advantages of being on the Database Docs team at Microsoft is that I get to work with amazing people, which means we can respond quickly to...

SQL Server is not a Car

Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...