Friday Flyway Tips–Dark Mode

I saw a post that Flyway Desktop has a dark mode and I had to try it out. I’ve been working with Flyway Desktop for work more and more...

Moving SQL Prompt History to Another Machine

A customer was asking about SQL Prompt recently and how their history is stored and if it can be moved to another machine. This post shows how this works,...

Search for queries with Query Store GUI

Hey folks, long time no write!
Today I want to bring a tip that I use every week but I found that most SSMS users are unaware it exists.
I can...

My data architecture book is published!

I’m thrilled to share that after 15 months of dedicated effort, my book, “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh,”...

How to Call REST API using VS Code

Sometimes you need a fast way to test your API call and responses, and for that VS code is the perfect tool to do that. For today’s demo, we...

Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them

Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...

David Kahn, legendary author, has passed away

I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...

Digging up undiscovered savings

You might be able to shave off thousands – or more – in your monthly cloud bills for your critical SQL Servers, all while maintaining or even improving performance....

Moving towards the DataFrame API using the Spark Connect gRPC API in .NET

All Spark Connect Posts
Code
Goal of this post So there are two goals of this post, the first is to take a look at Apache Arrow and how we can...

SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes

SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes

As we know, the SQL Server buffer cache is an area or region inside the server's memory where SQL Server...