The first release candidate (RC0) of SQL Server 2025 is now available. As we move toward general availability, our focus shifts to delivering enhanced stability, performance, and product improvements ...

Database administrator with 14+ years of hands-on experience in database management and database design.

A seasoned software engineer with extensive experience in building complex distributed data-intensive backend services. The most general way to satisfy a COUNT DISTINCT or SELECT DISTINCT clause is to ...

Facebook (and, by extension, Meta) are particular in the way that they allow users to create accounts and interact with their platform. Being the opposite of the typical anonymous service, Facebook ...

Abstract: The common computational pathology tissue slides mainly include Fresh Frozen (FF) slides and Formalin-Fixed Paraffin-Embedded (FFPE) slides. The FF slide has low quality but is easy to ...

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

Part of the SQL Server 2022 blog series. Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST ...

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.