NoSQL inside SQL Server
This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.
What Kind of DBA Are You?
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
Building Databases: One Man’s Best Practice?
One man’s meat is often another man’s poison. In this editorial Tony Davis looks at why a migrations-based approach to database version control might not always be best practice.
Adjusting Model
This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.
Hidden Tricks To SQL Server Table Cleanup
How to delete millions of rows with virtually no contention.
An Introduction to the OpenPOWER Foundation
In a bid to challenge Intel's dominance of high performance computing environments, IBM have introduced OpenPOWER, a flexible open-source framework based on their POWER processor architecture. Robert Sheldon looks at the potential of this new platform.
The Case for Upgrading
When is it worth upgrading your SQL Server? It's a question Steve Jones explores today.
Understand the Limitations of SQL Server Dynamic Data Masking
Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep in mind that it is not true encryption and that the data cannot be protected in all scenarios. Aaron Bertrand explains.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
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