Check Azure SQL DB Space Used (2024-03-29)

SQLServerCentral Newsletter for March 29, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Check Azure SQL DB Space Used]( - [What Happens When Multiple Queries Compile at Once?]( - [From the SQL Server Central Blogs - Dear Women in Tech, You Can Present at EightKB, Too]( - [From the SQL Server Central Blogs - Speaking at dataMinds Saturday & Techorama 2024]( - [The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform]( Question of the Day - [The Cloned Database Size]( The Voice of the DBA  The Journey to Change I assume most of you reading this work with SQL Server, at least for some of your workday. I know there are plenty of you who also support Oracle, MySQL, PostgreSQL, or some other database platform. The results in our (Redgate's) [State of Database Landscape report]( showed that many organizations, indeed most, have more than one database platform in production. This was also a theme in our Data Community Summit and Redgate Summit keynotes, where Ryan and Grant discussed their journey to learn a new platform. One, a requirement ([Ryan]( for a new job, and another, an opportunity ([Grant]( as the company focus shifted. I assume some of you out there have had similar experiences either moving towards, or away from, SQL Server. I ran across a [Breaking up with SQL Server post]( from David Alcock, noting that his job had evolved from SQL Server to AWS, GCP, PostgreSQL, Python, and more. The author got tired of database work, had an opportunity to learn about new areas, and got excited while doing so. That's similar to my career, where I did a lot of networking and administration work early in my career but saw an opportunity in databases (and financial rewards), so I worked to change. I enjoyed the new tech and built a great career. I wish David good luck on his journey. For many of us, there is regular tension between gaining deeper knowledge and more expertise or broadening the variety of skills we have. We have to decide where we spend our time as time is a limited resource. Hopefully, we realize that improving our skills in some way is a good use of our time and are doing something. At the same time, we need to find some balance and realize there are other demands on our time outside of work. Family, friends, hobbies, faith, all of these need some time for a healthy, balanced life. We might need to lean on our current skills and expertise at times, not investing in ourselves, but it shouldn't be our long-term strategy. As I've said in a few presentations, evaluate your growth every quarter. You might take a few quarters off from learning but don't take off a year. Or not multiple years. There are often rewards for improving our skills. These might be a raise, better choice of projects, better employment, or maybe even the spark to build your own business. It takes work, but I've not often found the time I spent was wasted. Even if I learn skills I don't use or enjoy, I learn something about myself that helps me better direct my future direction. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Check Azure SQL DB Space Used]( Cláudio Silva from SQLServerCentral Learn how you can check the space used for your Azure SQL databases. [External Article]( [What Happens When Multiple Queries Compile at Once?]( Additional Articles from Brent Ozar Blog An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution plan (then executes <500ms) if multiple SPIDS all submit that query (different param values) when there’s no plan at start, does each SPID calc the execution plan, one after the other after waiting for the prior SPID to finish? [Blog Post]( From the SQL Server Central Blogs - [Dear Women in Tech, You Can Present at EightKB, Too]( hellosqlkitty from SQLKitty Last year, I submitted and was accepted to present at the EightKB conference. At first, I thought my current presentation wasn’t advanced enough, but Tracy Boggiano convinced me otherwise.... [Blog Post]( From the SQL Server Central Blogs - [Speaking at dataMinds Saturday & Techorama 2024]( Koen Verbeeck from Koen Verbeeck I have the pleasure to announce I’ll be presenting at two conferences this spring. The first one is at dataMinds Saturday 2024 (back in-person!): Yes, it’s a long abstract... [The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform]( [The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform]( Site Owners from SQLServerCentral Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.   Question of the Day Today's question (by Steve Jones - SSC Editor):  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 properties] I now run this command: DBCC CLONEDATABASE(sandbox, sandbox_clone); GO When I examine the database file properties, what do they show? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Backing up the Resource Database How does the Resource database in SQL Server 2022 get backed up? Answer: You can perform a file-based or disk-based backup manually of this database Explanation: SQL Server cannot perform a backup of the Resource database itself, but you can make a file- or disk-based backup. Ref: Backing up and Restoring the Resource Database - [ [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [need help in optimizing long running UPDATE statements]( - Hi All, Need help in tuning below UPDATE statements. Have this long running 3 UPDATE statements doing lot of reads. we r trying to refresh prod to one of sub-prod env. Will share the plans in some time. Is there a good way to optimize below queries? Few i can think of is, please provide […] SQL Server 2012 - T-SQL [Pivot 1 row to multiple columns using T SQL]( - Hello. I have data in a table that I want to pivot from 1 row to multiple columns. I only want the colums with dx to pivot if there is a value in them. Thanks. This is a sample of what I have: MemberNbr     dx       […] SQL Server 2019 - Administration [Permission related question]( - I have a view in a database A which is created from a table in database B. This view has PII data and I want to restrict users from running select against it. But those users are part of AD group (We don't create individual accts) and they must have data reader permission on database […] [SSRS Report Job failing in first attempt]( - Today I can see my job running SSRS Report using stored procedure inside and failing in first attempt with below error , but in 2nd attempt the job runs fine. Please help me to solve this issue and what could be the reason behis this failure. Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> […] [Best way to compare tables from SSMS and Oracle]( - Hi, I need to compare tables from SSMS against Oracle. what is the best way to compare tables from different databases and different servers. Any automation tool or any approach to ease the work? SQL Server 2019 - Development [is there an ssrs feature that plays nice with tablix's and just one footer?]( - Hi i inherited some multi document (eg print all invoices in the invoice number from and to parameter range i am providing) crystal reports for conversion to ssrs 2019 A theme i see is repeating tablix lines till they fill up pages and only printing footer like info at the BOTTOM of the last page […] [Help with date range subquery]( - I have two large tables. One table(Table A) contains trouble tickets that are created when applications fail. The other table(Table B) contains warning notifications that are emailed whenever there may be an issue with an application. I need to write an efficient query that will select fields from Table A where a NotificationDate (Table B) […] [can i query roles and users from my various tabular databases]( - hi we've begun recording apps x roles at my company. Currently the apps are erp's but i think roles attached to tabular models would blend nicely, especially if i can find a way to also expand the groups assigned to certain roles. i'd feed the data daily. from what i've seen AD has some kind […] [create XML]( - Hello.. I want to create an XML file with the below structure. I have all the elements in respective tables. And I am using FOR XML AUTO , ELEMENTS to generate the file. My only issue is that I am not able to generate the incremental recordIdentifier tag that increases in value under each node […] Powershell [unix timestamp to datetime]( - I have a sql table where the app is writing. A unix timestamp value to the field. I would like to iterate thru the table and pull from a specific datetime but not sure how to code that in PS that also would export to csv file. I just pulled the latest record from table […] Anything that is NOT about SQL! [how can i find just my posts in sql server central?]( - Hi as in other forums but possibly worse, there doesnt seem to be an easy way to show just my posts in this forum. If i search on my first name i see only a random post from a week or two ago but there are quite a few posts since then and of course […] SQL Server 2022 - Administration [OLDEDB drivers]( - How sql server OLDEBB or ODBC etc drivers intalled? Are they installed from SSMS installation on the client? Recently I have a new computer I installed SSMS 19.X version, and VS 2022, in visual studio 2022 SSIS project, when I create a connection manager the SQL native client driver is no longer available, I understand […] [SQL Agent Failing Backup using Domain Account]( - Good Day, I am hoping you can help with a frustrating issue i have encountered. We have recently setup a domain joined SQL 2022 Cluster using HYPER-V failover. All is working well with the databases and the failover. The issue We have encountered is with our SQL Agent jobs. We have a few setup and […] [Always on availability group vs Always on Failover cluster instance question]( - Hello, we are currently running a WSFC cluster two node setup (nodes are on two different locations) and we have a few instances (roles) on this cluster. We are using SAN as a storage solution. Because we are getting new hardware we explored a few options for HA and DR. We need to provide 0 […] SQL Server 2022 - Development [[CA IDMS ODBC Driver]Restricted data type attribute violation]( - I moving data from mainframe to SQL server. Error: Unable to copy contents of source table to destination (Insert/SelectFull) Unable to get record from table (table_3). STAT:2 ERR:-2147467259 SQLSTATE:S1000 Microsoft OLE DB provider for ODBC Drivers : [CA IDMS ODBC Driver]Restricted data type attribute violation using CA IDMS ODBC driver to read on mainframe […]   [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -