There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

The SQL Server team is unleashing the first widespread test builds of the next version of Microsoft's database, a k a SQL Server 2008 R2 (codenamed "Kilimanjaro").

Here's one big advantage to moving to Microsoft Azure SQL Database-you never have to patch. That's all well and good, but most of the SQL Server installed license base is still on-premise. If you're ...

Microsoft publishes SQL Server 2025 Release candidate with TLS 1.3, Ubuntu 24.04 support and many AI improvements. Reading processes are up to 50 times faster, but an important restriction remains ...

We are using MS SQL Server 2005. Now, I'm no database architecting genius, but I'll present the approach that I would take: ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...

Microsoft's relational database engine has had the same licensing model since 2012. The new version released this week brings significant changes that brings SQL Server closer to Azure SQL's ...