CosmosDB APIs Inside SQL Server 2024

New enhancements in SQL Server 2024 will allow MongoDB and Cassandra clients to store their data in a SQL Server database, in native NoSQL format.

Custom Statistics Distributions in SQL Server 2022

You can create custom statistics distributions, sampling, and histograms in SQL Server 2022 with a new trace flag

The PASS Data Community Summit 2024 Call for Speakers

The PASS Data Community Summit call for speakers and volunteers is open. You have until April 10 to submit something, and you can do that here: Data Community Summit...

Wargames

Database Mirroring is Back in Azure SQL Database

Database Mirroring comes back to SQL, at least to Azure SQL Database with Fabric as the destination. Read a few of Steve's thoughts on this feature.

A New Word: 1202

1202– n. the tipping point when your brain becomes so overwhelmed with tasks you need to do, you feel too guilty to put anything off until later, prioritizing every...

The Cloned Database Size

The Journey to Change

Many of us have a journey, either to SQL Server, or in today's world of many databases, perhaps away from SQL Server. Steve looks at his, and another's, journies.

Server Dashboards in Azure Data Studio

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can customize them. Another article will cover the Database dashboards. […]

A First Look at SSMS 20

Recently Microsoft released SQL Server Management Studio (SSMS) v20.0, which is a major release of the primary tool that many of us use to work with SQL Server. Over the last few years, the tools team at Microsoft has worked to separate the tools from the various editions, giving us separate SSMS downloads. There have […]