Recent SQL Server 2025, Azure SQL, SSMS 22 and Fabric announcements highlight new event streaming and vector search capabilities, plus expanding monitoring and ontology tooling -- with tradeoffs in ...

The third and final keynote at the PASS Summit, and this morning I’ve been given a space on the official blogger table at the keynote! Actually this just means I’ve got a table to rest my laptop on ...

Microsoft Fabric, Power BI, Analysis Services, DAX, M, MDX, Power Query, Power Pivot and Excel If you’re reading this outside the US, why should you care about what PASS is doing here? I know from my ...

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

Following the rollout of SQL Server 2025 Release Candidate 0 (RC0) in August, Microsoft revealed its plans for SQL Server Management Studio (SSMS) in September too. Among these for the upcoming ...

Last month, Microsoft released a few updates for SQL Server Management Studio (SSMS) 21, while also revealing its plans for the next major release, SSMS 22. This follows the release of a SQL Server ...

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs. I ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale. One of the most exciting new ...