Articles

SQLServerCentral Article

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. […]

5 (1)

You rated this post out of 5. Change rating

2024-03-28 (first published: )

2,679 reads

SQLServerCentral Article

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 […]

5 (3)

You rated this post out of 5. Change rating

2024-03-27

2,558 reads

SQLServerCentral Article

Quick and Effective Migration Between CosmosDB Collections Using ADF

This document aims to explain the process of using ADF (Azure data Factory) to make a copy of a Cosmos DB (Instance A)  collection into a new collection in another Cosmos DB Instance effectively and cost effectively. For example, here is our  Instance A in the Data Explorer: Here is Instance B: We are looking […]

You rated this post out of 5. Change rating

2024-03-25

302 reads

Blogs

Finding the Latest Backup Timestamps for Your Databases

By

Finding the Latest Backup Timestamps for Your Databases I wanted to find out the most...

Using SQL Elastic Pools

By

We use SQL elastic pools at work. I needed to learn more about their...

Webcast: How to Secure SQL Server – End to End Security

By

On April 16, 2024, I will be giving another webcast; this one will be...

Read the latest Blogs

Forums

SQL agent help

By rocky_498

Hi Guys, I have an SQL Agent job. It is called an SSIS Package...

Database Mirroring is Back in Azure SQL Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Mirroring is Back in...

Tracking Database Growth - Script Automation & Reporting

By EM2

Hello,   I found this script that helps me in populate a table with...

Visit the forum

Question of the Day

The Cloned Database Size

I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:database file propertiesI now run this command:

DBCC CLONEDATABASE(sandbox, sandbox_clone);
GO
When I examine the database file properties, what do they show?

See possible answers