In the next installment of this series, learn how you can read data from the Google Cloud Platform (GCP) and virtualize it into your Azure Data Lake Storage.

Aggregate Functions in Power BI including Running Total, Running Average and Max

by Additional Articles

MSSQLTips.com

Power BI

This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.

The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner

by omu

SQLServerCentral

Performance and Tuning

Every SQL Server developer has heard it: "Don't use NOLOCK in production!" But this common rule isn't as simple as it seems. Sometimes, what seems like a bad practice can actually be the right choice. Let's explain what NOLOCK really does in simple terms. When you use NOLOCK, you're telling SQL Server "just show me […]

Why Would You Do That?

by Steve Jones

SQLServerCentral

software development

We look at problems in different ways and Steve notes this can help or hinder us in software development.

3 Legit Signs It’s Time for Enterprise Edition

by Additional Articles

Brent Ozar Blog

Uncategorized

Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re wondering what you’re missing, and whether you should be on SQL Server Enterprise Edition. Here are 3 warning signs to watch out for.

The Pervasive Nature of Open Source

by Steve Jones

SQLServerCentral

This week there was a headline that said "Open Source Software Powers 96% of Modern Applications, New Study Finds" and if you stopped reading there, you might think, hey, it's not in the apps I work on. Or you might think that because you use OSS software, most of the world also does. Microsoft, Oracle, […]