Implementing SQL Server Integration Services with Azure Data Factory
Read on to step through the process of implementing Azure Data Factories.
Using All Your Tools
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
Performance Tuning Using Extended Events: Part 1
In this article, learn how to identify performance tuning opportunities using Extended Events.
What's a forgivable mistake?
Today Steve wonders if your company is understanding of your human frailty.
From Source Control to Database using SQL Compare Command Line
Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.
Understanding Azure Storage Options
The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution.
Expect the Unexpected with DiRT
Disaster recovery is no joke at Google, where they really test their systems, people, and processes.
UNION vs. UNION ALL in SQL Server
Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?
Proactive Performance Tuning
Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.
Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework
This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.
Blogs
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...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers