Consolidating Cloud Backups

I am a big fan of the cloud. While I appreciate local storage and privacy/control/security, etc., that stuff can also go away locally. Plus, I like the convenience, and...

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

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

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

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

Using Spark Connect from .NET to run Spark jobs on Databricks

All Spark Connect Posts
Goal of this post This post aims to show how we can create a .NET application, deploy it to Databricks, and then run a Databricks job...

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

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

Friday Flyway Tips–Linking a GitHub Issue to a Code Commit

Recently I was doing a demo and a customer asked how I had linked my commit in Azure DevOps to the work item that existed. It’s easy, and tldr;...

I’m Speaking!

After a long hiatus of not blogging, I’m trying to get back into writing.  So, to kick it off first thing in 2024, I’m speaking! I’m honored to have been...