Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
Calculate the Statistical Mode in SQL Server using T-SQL
Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Server, but how can we determine the mode using T-SQL?
SQL Saturday #387 - Madison, WI
SQL Saturday is coming to Madison, Wisconsin on April 11th 2015. Join us for a free day of SQL Server training and networking and hear expert speakers like David Klee, Wendy Pastrick, and Jes Borland. Register while space is available.
Setting Different Colors for Connections in SSMS
Learn how to set colors for different connections in SSMS.
Defusing Database Time Bombs: Avoiding the Need to Refactor Databases
Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs.
Data Mining Part 26: Data Mining and Microsoft Azure
This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.
Azure Blob Storage Part 7: Snapshots
Robin Shahan introduces the concepts of snapshots in relation to Azure blob storage. She explains what they're for and how to take them, promote them, and delete them.
Database Continuous Integration workshop, Los Angeles
Redgate are hosting a 1-day public workshop on April 10th 2015 in Los Angeles, California. This workshop will teach you how to link your source control system to a build system, trigger database builds automatically, and lay the foundations for package-based deployments.
Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)
This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers