Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them. In a previous Practical .NET column I showed ...

In this review of Stellar Repair for MS SQL, we take a closer look at Stellar’s corporate-grade SQL repair solution, ...

Microsoft announced the general availability of SQL Server 2019 and SQL Server Big Data Clusters at its Ignite conference on Monday. SQL Server 2019 builds on intelligent query processing features ...

Every release of SQL Server promises increased performance, better security and improved business intelligence. You get all of that with SQL Server 2016, plus other strategic options such as cloud ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...

From AI-driven attacks to cutting-edge vector search capabilities, 2026 is redefining how we secure, optimize, and manage SQL databases. New SQL Server features, evolving threat landscapes, and modern ...

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...