Changing SQL Server Database Logical Names
SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.
Presenting Data
One important skill is for the DBA or developer of the future is being sure they can present data to clients in a way they can use it.
Parallelize Data Flows with SSIS Balanced Data Distributor Transformation
In this article, Daniel Farina shows how to speed up SSIS package execution by using the Balanced Data Distributor Transformation.
Would You Pay To Wear Jeans?
For this Friday, Andy Warren asks if you would pay to change your wardrobe for work.
Azure SQL Database Security Features
The Microsoft Azure platform is evolving fast. Azure SQL Database is riding high on the cloud wave with new features enabled at a fast pace. In this article, Kun Cheng shares a few Azure SQL Database security features that could help developers and DBAs develop and manage a secure SQL Database solution.
Survey: What are your plans to upgrade SQL Server?
The Microsoft SQL Server product group are evaluating how to better assist with your SQL Server upgrades. With the upcoming SQL Server 2005 extended support deadline fast approaching, they want to understand how to help you migrate to a modern, supported version of SQL Server, and how to provide support and upgrades in future.
10 SQL Snippets For Faster, More Effective Code
How many hours per week do you spend writing the same SQL again and again?
Continuous Delivery In Real Life
Everyone wants to know who is actually using Continuous Deliver for their software. Today Steve Jones has a prominent example.
Resolution for SSIS Package Catastrophic Failure
Solution to overcome SSIS Package Catastrophic Failure Error
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