Earlier this year I had a PM at Microsoft reach out and ask me what I thought about the Data API Builder. I hadn't looked at it, so I made a note to check it out. I hadn't done that by the time SQL Saturday Denver 2024 occurred, where I saw Jerry Nixon from Microsoft […]
2024-12-13
7,121 reads
In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who speaks multiple languages
2024-12-13
Announced during Redgate's Keynote at PASS Summit in Seattle, PASS Summit On Tour will see smaller scale events hosted in New York, Dallas and the Netherlands in 2025. To be the first to know when tickets and dates are released, sign up to our mailing list.
2024-12-13
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.
2024-12-11
2,660 reads
This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.
2024-12-11
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 […]
2024-12-09
5,106 reads
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.
2024-12-09
2024-12-06
1,516 reads
Learn how to use Fivetran HVR software to ETL data into your One Lake Storage from a PostgreSQL database.
2024-12-06 (first published: 2024-11-27)
1,653 reads
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
2024-12-06
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers