Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with Fabric
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
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
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?
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
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
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, […]
Distributed Monoliths
What is a distributed monolith vs. a microservice architecture? Steve has a few thoughts today.
Using Fivetran (HVR) to Replicate Data From PostgreSQL to an Azure Databricks Warehouse: Data Engineering with Azure
Learn how to use Fivetran HVR software to ETL data into your One Lake Storage from a PostgreSQL database.
Calculate a Moving Average with T-SQL Windowing Functions
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers