Blog Posts

Raiders of the Lost ADX – dataminds connect 2023

• by Koen Verbeeck

• Koen Verbeeck

I’m very excited for this year’s edition of dataminds connect. It’s the first time I’m going to co-present a live session. My fellow explorer is the amazing bearded Johan...

2023-09-08

Speaking at the Future Data Driven Summit 2023

• by Koen Verbeeck

• Koen Verbeeck

I’m going to give a lightning talk at the online (free) Future Data Driven Summit. The subject is How I saved 80% on my Azure Data Factory Costs. The...

2023-09-08 (first published: 2023-09-07)

Decimal Display in Power Query

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

Introduction
Power Query is a versatile tool found in both Power BI and Excel, facilitating data transformation and manipulation. Despite its efficiency in numerous data tasks, managing decimal values can...

2023-09-07

Future Data Driven is Coming Sept 27 for FREE

• by Steve Jones

• The Voice of the DBA

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...

2023-09-07

Power BI VertiPaq Engine: Optimizing Column Encoding

• by DataOnWheels

• DataOnWheels

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,...

2023-09-07 (first published: 2023-09-06)

1 reads

Smooth Transition from Azure Synapse to Microsoft Fabric

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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...

2023-09-07

How to curb aggressive parallelism in Microsoft SQL Server

• by Josef Richberg

• SQLRunner

Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is map-reduce before map-reduce was a popular...

2023-09-06

IRL #8: SQL Server Down

• by Kevin3NF

• Dallas DBAs

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...

2023-09-06

Manually updating Statistics in SQL Server

• by Matthew McGiffen

• Matthew McGiffen DBA

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...

2023-09-06

Running Flyway from PowerShell–A Gotcha

• by Steve Jones

• The Voice of the DBA

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...

2023-09-06

2 reads