Mastering TempDB: Managing TempDB growth
Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth.
Converting Binary Numbers To Hex
A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.
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.
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