Monitoring Azure Blob Storage (2022-07-08)

SQLServerCentral Newsletter for July 8, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Monitoring Azure Blob Storage]( - [Four ways to elevate team efficiency and code quality]( - [Different ways to Convert a SQL INT Value into a String Value]( - [From the SQL Server Central Blogs - The Effectiveness of Solar Estimation]( - [From the SQL Server Central Blogs - When is a mouse not a mouse?]( Question of the Day - [Pizza Math]( The Voice of the DBA  Daily Coping Tip Be willing to ask for help when you need it. I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Flexibility in DR Disaster recovery is a topic that many people who work with databases find important. DBAs work to ensure their systems are highly available while practicing the skills needed to recover them in the event of a disaster. While we often practice the failure of a complete server or database, we sometimes forget there can be other issues for which we need to plan. I ran across [a story about a data center outage in London](, which was similar to an incident I experienced. In this case, a piece of power equipment failed and systems lost network access. While many of us aren't responsible for the network, we certainly would still receive complaints if the database wasn't available. In my situation, I was in a data center watching some workman service UPS systems. At the time I was a manager of database systems and thought they had things under control. I left the data center and went downstairs, only to audibly notice when the power dropped that all servers seemed to stop running. Similar to the London outage, a switch that was supposed to change power from one set of UPSes to the other failed. Our entire global infrastructure for 10,000+ people and who knows how many customers went down. This was in the pre-cloud era where we acted as our own cloud. And not very well. There are systems outside of our databases that we depend on. We might not be responsible for them, but we ought to ensure they are a part of our disaster recovery plans and account for various things going wrong. At the very least, we ought to question whether power, network, storage, and more are adequately prepared for major issues. We also need to think about minor issues. Atlassian had a major outage, at least for some customers, and [they realized that they hadn't planned to recover parts of their databases](. A similar issue might occur for any of us, where we might have to restore parts of a database, whether that's a table, partition, or a series of rows. Corruption or human error might result in a set of data that's unreadable or even gone. I know I've accidentally caused data issues, and I'm careful. I learned to recover from my own mistakes and anticipate those of others. I practice not only full restores but how to copy over part of table from another location. A disaster is a major problem, but it might only affect a minor part of our systems. We need to ensure we are ready for any size or scale of problem and be ready to adapt our thinking and process to meet the disaster with the appropriate actions. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Monitoring Azure Blob Storage]( arindamxs from SQLServerCentral Learn about how you can monitor your Azure Storage account and set alerts to let you know when to take action. [External Article]( [Four ways to elevate team efficiency and code quality]( Additional Articles from Redgate IDC have reported that ‘the shortage of full-time developers will increase from 1.4 million in 2021 to 4.0 million in 2025’. So how do teams keep pace with business demands, without relying on recruiting extra staff? Discover 4 ways that teams can elevate efficiency and code quality to speed up delivery of accurate database changes. [External Article]( [Different ways to Convert a SQL INT Value into a String Value]( Additional Articles from MSSQLTips.com In this article we cover different ways to convert a SQL Server numeric value into a string value. [Blog Post]( From the SQL Server Central Blogs - [The Effectiveness of Solar Estimation]( Steve Jones - SSC Editor from The Voice of the DBA We added a solar system to the ranch as a way to hedge against future costs as well as require less energy from the utility. I don’t plan to,... [Blog Post]( From the SQL Server Central Blogs - [When is a mouse not a mouse?]( DataOnWheels from DataOnWheels This is the first in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Pizza Math (from a post on Twitter). I went to get a round 9 inch pizza the other day, but they had run out of those pans. They brought me two circular 5 inch pizzas. What does this mean for my hunger? 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) Azure Data Lake Storage Gen 2 Azure Data Lake Storage Gen 2 is built on ...? Answer: Azure BLOB Storage Explanation: Azure Data Lake Storage Gen2 is built on Azure Blob storage, adding a file system semantics, security and scale. Ref: Introduction to Azure Data Lake Storage Gen2 - [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 2016 - Administration [First responders kit - BlitzIndex question]( - Hello, hope someone can help, maybe a simple question so i am using the Blitzindex from Brent Ozar, and its great, but one question, with some of the findings being "Missing Index" or "Index phobia", it does say estimated impact or missing index request... I am looking for a way to find out "This would […] SQL Server 2016 - Development and T-SQL [Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)]( - (1) Sort rows with year column and month column == Jan, Feb, Mar, etc. == correctly, without using CASE or other conditional expressions. (2) Table "emp_training" has (emp_id, training_id, status) where status = F(fail)/P(pass). Each employee (emp_id) may pass a class only once but may fail it (multiple times even). Write all necessary DDL to […] [Designing a table]( - Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2 |cusomter relations 3 |IT training 9 |None Thanks. I have this scenario: A worker may attend up to 4 training courses per year. I need to design a table "WorkersCourses" where I can enter multiple records per worker. This will need […] [Which table design is better ?]( - Hi, I have a scenario where a worker can do multiple training courses each year (max 4). Is it better to create a table this way:  WorkerID |Year |Courses Worker01 |2021 |CourseCode01 Worker01 |2022 |CourseCode01 Worker01 |2022 |CourseCode02 Worker01 |2022 |CourseCode03 Or this way:  WorkerID |Year|course1 |Course2 |Course3 |Course4 Worker01 |2021|CourseCode01| | | […] [CAST AS DATE Assistance]( - Can someone let me know why I'm not able to use CAST method to cast a field as date  ;WITH numbering AS ( SELECT MontaguOwner, CurrentOpportunityStatus, LastDateStatusChanged, OpportunityName, rank() OVER (PARTITION BY MontaguOwner, CurrentOpportunityStatus ORDER BY LastDateStatusChanged DESC) AS rank, row_number() OVER (PARTITION BY MontaguOwner, CurrentOpportunityStatus ORDER BY LastDateStatusChanged DESC) AS row_number FROM enrorigination.opportunities_hv […] [Put result of one query into another]( - Hi all! I have to do this 177 times more, and it must be possible to make it a bit more automatic.  I have to deliver +200 sets of queries, whish tells that two values should be updated. When finished, it will be run by my Customer. First query; SELECT per_personal_id FROM dbo.personal WHERE […] Administration - SQL Server 2014 [SQL Server 2014 Question]( - So I have inherited an older SQL 2014 Server and have been working on understanding what I need to migrate or can shutdown without affecting our current applications. There is only one DB i know for a fact that relates to a digital faxing server we use I have a collection of 6 Databases with […] SQL Server 2019 - Administration [Drop database on Secondary Node from Primary for automatic restore job]( - hi all We've ventured into the world of AAG's as we have now moved across to SQL2019. We have a Primary node and two secondary nodes. We have a training database that is autoamtically created from the main production database. This was initially added to the AAG manually and syncs fine. What we are now […] [SQL Server 2019 HA]( - Looking for a HA solution for SQL server for our branch offices. Current setup has our 3 offices running independent standalone servers with SQL server. No redundancy in place. My aim is to centralise the servers in 2 locations. Location A and B has one server each. Both running windows server vm and sql in […] SQL Server 2019 - Development [Combine tables with SQL in power bi]( - Hello everyone, i hope everyone is fantastic!! I've done some SQL queries in power bi to get my data and do some ETL. I have 6 companies, therefore, 6 queries. Now i would like to append them, combine(?) them in order to have just one sales table. What would you think it would be my […] [Removing UNION and getting the same result]( - Hi, I need to update my sql script and remove the UNION but get the same result - Current result from script using Union - DDL- For Accounts and bp_table1 /****** Object: Table [dbo].[bp_Account] Script Date: 04/07/2022 10:48:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[bp_Account]( [bp_id] […] [Employee Hierarchy Recursive CTE Different Top Level Directors Overtime]( - Hi, I have looked at some examples of Employee > Manager Hierarchy using Recursive CTE. The issue I have is the Top of Chain i.e. the Chairman there was different Chairman's over a period of time for example:  Final Results I require  If you look at EmpId 129 Rafael Nadal he left at the time Jeff […] [Add a column with default value]( - Hi guys I have a query with a SELECT statement, that joins 2 other queries, filter a column and order another one. I did it in SSMS. I would love to add a new column with a static value for all records, past and future. I believe i should add these lines, but i'm not […] SQL Azure - Administration [Deploying a standalone Azure VM running SQL Server into an availability zone]( - If i deploy a standalone Azure VM running SQL Server into an availavility zone; what will this achieve? Will i get two load balanced copies of the instance running from VM's out of two data centers in the zone with the data being synced? I think that is what the documentation is suggesting, but I […] Design Ideas and Questions [Multiple Fact Tables]( - Please assist? I would like to do a data model of the tables here: Any idea how i would go about to break this down and build a decent data model/links to tables?   [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -