Accessing results in a random order: Towards the automated Thank-you letter
Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....
Avoid Transact-SQL's Column Alias Limitations
A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.
Handling Service Broker Errors
The previous installment of the 'SQL Server 2005 Express Edition' series discussed using transactions to protect the integrity and consistency of Service Broker-based communication. Depending on the type of issue encountered by our code, the outcome might be different from expected. This article demonstrates a more robust approach to error handling and applies it to our target.
How to create indexes on computed columns in SQL Server
There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
SSIS Custom Error Handling
This article from Zach Mattson shows how you can set up custom error handling in your SSIS packages. Learn how to direct those error rows to another component for separate processing.
Using Intersect - SQL School Video
This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.
Adding a UI to the Standalone SQL Agent
In a recent blog post, SQL Server expert Denny Cherry discusses adding a user interface to his Standalone SQL Agent, a replacement for the SQL Server Agent service.
Blogs
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
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...
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