Power BI Anomaly Detection
One of the problems with data analysis is the potential for anomalies that can skew results. In this article we look at a Power BI feature to detect anomalies and outliers in the data.
Redgate Tool Tips
Redgate recently invited customers to share their tops tips for improving productivity using Redgate tools. This blog outlines their hints and includes relevant training resources to further your learning.
Restoring Master on a Windows 2019 / SQL Server 2019 Cluster
Howto restore master database on a Clustered SQL Server 2019 Instance
Five facts about the SQL Server Model Database
In this article we cover interesting facts about the SQL Server model database and how new databases inherit properties from the model database.
Moving from application automation to true DevOps by including the database
This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code.
Growing Outside of the English World
The world is bigger than one country, and Steve is trying to remember that.
Stairway to SQL Server Virtualization Level 2 - The Ideal SQL Server Virtual Machine Architecture
In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.
PowerShell editors and environments part 2
In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.
Reading Stored Procedure Output Parameters in Azure Data Factory
This article will help you to work with Store Procedure with output parameters in Azure data factory.
Blogs
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
Forums
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers