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.
This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.
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 […]
We look at problems in different ways and Steve notes this can help or hinder us in software development.
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.
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, […]
What is a distributed monolith vs. a microservice architecture? Steve has a few thoughts today.
Learn how to use Fivetran HVR software to ETL data into your One Lake Storage from a PostgreSQL database.
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
Hi, Need your help. I've a SP that is using Update statement on a...
I have query which is filling TEMPDB I need suggestion how to modify this...
I have query which is filling TEMPDB I need suggestion how to modify this...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers