Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

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 ...

Preparing for the SQL Server 2025 era – Ascent’s guidanceIssued by Ascent TechnologyJohannesburg, 01 Apr 2026 Preparing for the SQL Server 2025 era – Ascent’s guidance. Prepare for the SQL Server 2025 ...

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 ...

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 ...