Stairway to Advanced T-SQL Level 10: Using Scalar Functions
Learn about scalar user defined functions in this next level in the Stairway.
The New Data Warehouse Choice
Steve Jones looks a little more closely at the Azure SQL Data Warehouse, perhaps a viable choice for many of us.
The 4 Presentations I’m Proudest Of, and What Inspired Them
Take a look at some of Brent Ozars favourite public presentations, and hear the stories of how they came to be.
Clownpocalypse and DR
Today we have a guest editorial as Steve is out of town at the PASS Summit. Grant looks at disasters and being prepared.
SQL Server Synonyms
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.
Bringing Data Catalog into your CI/CD pipeline
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
Orchestrating Azure Databricks Notebooks with Azure Data Factory
Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.
Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
Career Goals and Inspiration
Steve asks what you might want to achieve or accomplish in your career.
Count the Number of Weekend Days between Two Dates
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
Blogs
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers