A Working Break on President's Day
Today is a day off from Redgate for Steve, but he's working elsewhere on this holiday.
An Introduction to Flowlets in Azure Data Factory
Learn how you can re-use parts of your pipeline in Azure Data Factory. Save off some tasks as a flowlet for use in multiple pipelines.
Tutorial: Using the hierarchyid Data Type
This tutorial is intended for users who are experienced with Transact-SQL, but are new to the hierarchyid data type.
Learning Never Gets Old
It’s been a goal for several years to write (or help write) a book on a topic I love. While I can’t share details yet, there’s some movement on this dream and I’m excited about it. And I’m even more excited that I get to do it alongside someone that I’ve respected for a long […]
JQ - Tool for Querying JSON documents using the CLI
Learn how you can query JSON data from a CLI to check it before importing the data into a database.
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows the top-ranking users in their most popular location. It’s even got an index to support it
Attention SQLBits 2024 Attendees!
Microsoft will be featured at SQL Bits with a keynote speaker, a full day of training and a few other sessions. Register today for the conference in March and we hope to see you there.
Stairway to Biml Level 6 - Programming with Metadata
In this next level of the Stairway to Biml, learn how metadata makes your Biml code more efficient and helpful in generating packages.
This is Why You Use Git for Scripts
Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers