(blobeater) I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is assuming you understand the resource utilization patterns of the databases involved.

(Greg Robidoux) One thing that is often handy is to know how much space each table is using within your database. It is helpful to know the number of rows, the data space used as well as the index space used.

(Pinal Dave) While playing with my lab server having broken replication, I encountered an error message when I was trying to remove publication.

(Melissa Coates) Recently a customer expressed concern that an owner of an Azure resource group automatically gains access to the data within the services contained in the resource group.

(johnsterrett) In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster.

(Pinal Dave) During my Comprehensive Database Performance Health Check engagement with the client, one of the most common issue found was the huge size of the transaction log file.

(Grant Fritchey) There are so many reasons to love Extended Events that it can really be overwhelming, but, one more reason that I love them are the ability to customize Live Data.

(Jack Vamvas) Having a well designed and tested disaster recovery plan is essential for managing IT systems.

(Idit Izak) SQL Managed instance is located inside a Vnet.

(K. Brian Kelley) I’m working to improve my SQL Server database development skills, specifically in the area of data modeling. I’ve seen some information on data normalization and the forms, however, I’d like to understand them better and why they are used.