As SQL Server 2016 approaches end of support in July 2026, a look back at its groundbreaking innovations reveals how it reshaped Microsoft's data platform and why it's time to move forward. As I've ...

Security by default – protecting the enterprise in SQL Server 2025. Explore how SQL Server 2025 strengthens enterprise security through enforced secure defaults, identity integration, encryption and ...

EFCore.Encryption provides a helpful base for building your own encrypted column implementations of any type. It also supports querying for equality by storing a hashed copy of the data alongside the ...

NoSQL databases arose in response to the limitations of using SQL (Structured Query Language) for database queries. NoSQL databases store and manage data in ways that enable high operational speed and ...

Starting from SQL Server 2016, the conversion / comparison process of datetime to datetime2 (and vice versa) has been modfied. Unfortunately, this is a breaking change for many of our existing ...

With the first public preview of SQL Server 2019, we announced support for the widely used UTF-8 character encoding as an import or export encoding, and as database-level or column-level collation for ...

Data has become the lifeblood of the enterprise. It’s the foundation for keen insight and effective decisions that lead to business growth. One of our primary design goals for SQL Server 2016 was to ...