Prevent Accidental Resource Deletion Using Locks in Azure Data Factory (2022-03-16)

SQLServerCentral Newsletter for March 16, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Prevent Accidental Resource Deletion Using Locks in Azure Data Factory]( - [The basic T-SQL SELECT statement]( - [Summit 2022 Call for Speakers Now Open]( - [From the SQL Server Central Blogs - Recipe 4: Sending Alerts via Email]( - [From the SQL Server Central Blogs - s5cmd Authentication Using Enviroment Variables]( Question of the Day - [Serverless RAM]( The Voice of the DBA  Daily Coping Tip Have a no plans day and notice how that feels 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. The Chief Data Officer I don't know if I'd be a chief, but I am glad that more companies are recognizing that data is one of the most valuable assets in most companies and starting to hire [Chief Data Officers]( (CDO) to manage governance and security projects, as well as oversee data quality and management. With Chief Information Officers (CIO) and Chief Technology Officers (CTO), it appears that technology is becoming a force in the executive ranks. Most of the companies I've worked for only had one chief-anything to do with technology. It seemed that anything to do with computing fell under that individual. Adding a CIO and, now, a CDO shows that there there is a complexity in working with computer systems. The infrastructure and architectures of systems are important, but how we capitalize on information is crucial. I see a CIO as more of a business role than a technology one. The [CDO seems to be a specialist]( that owns the data and ensures that it is well cared for, protected, and more importantly, managed appropriately. That would include knowing what data we have, how it is classified, how data should be protected, when to dispose of it, and how to assess the risk of keeping data around. It seems like a mix of strategic and tactical areas that a CTO or CIO might be tempted to consider low priority issues. I think data is one of the most important assets in many companies. We are always searching for ways to better understand our environment and make decisions that improve the way our organization works. We depend on data, and these days data is often something we lean on heavily. We need to protect it, especially as more regulations appear all the time that require us to change how we use and handle data. I don't know how many of you have a CDO in your organization, or how quickly this will become common. I do know that the growing importance of the functions of this role are impacting more and more people who deal with data. While they might feel like a pain to adjust to, the more that we pay attention to how data is handled, the better off we all will be. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Prevent Accidental Resource Deletion Using Locks in Azure Data Factory]( arindamxs from SQLServerCentral Learn how to protect production resources from accidental changes in Azure Data Factory. [External Article]( [The basic T-SQL SELECT statement]( Additional Articles from SimpleTalk The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for SQL Server. [External Article]( [Summit 2022 Call for Speakers Now Open]( Additional Articles from Redgate Share your knowledge and insights at the world's largest gathering of data platform professionals! The PASS Data Community Summit conference is going hybrid this year, and whether you're planning to attend in-person in Seattle or online, this is your chance to reach a global audience and advance your career as a speaker. If you're an expert in a data-related topic, we want to hear from you. Speakers of all experience levels are welcome to submit a proposal and the Call for Speakers is open until March 31. Registration also opens on March 24, so don't miss your chance to register for Summit's homecoming in Seattle at early bird pricing. [Blog Post]( From the SQL Server Central Blogs - [Recipe 4: Sending Alerts via Email]( spaghettidba from SpaghettiDBA Welcome to the latest recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the... [Blog Post]( From the SQL Server Central Blogs - [s5cmd Authentication Using Enviroment Variables]( aen from Anthony Nocentino Blog At work, I get to work with some fantastic tech that pushes the boundaries of performance. I needed to do some performance testing from a Windows server into a...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Serverless RAM If I provision an Azure SQL Database with the Serverless option and choose 32 vCores as my Max with 16 vCores as the min, what is the maximum amount of RAM that can be allocated to this database? 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) Five Nines How much downtime is allowed each year if I am trying to ensure 5 9s of availability for my database (roughly)? Answer: 5.2 minutes Explanation: Five nines allows 5.26 minutes of downtime a year. Not much time for taking a database offline for any patching or admin purposes. Ref: High Availability - [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 [Which version to upgrade sql server 2017 or 2019]( - Hey Everyone, My project wants to upgrade their sql server 2014 SP3 to newest one. I am not sure if I should pick sql server 2017 or just go with the latest 2019 version. The databases we use is not very bulky and we have 12 databases in the production environment. Shall I just upgrade […] SQL Server 2016 - Administration [Sql Server 2016 change provider of local host]( - I am updating all Linked servers in use provider MSOLEDBSQL. i don't know how to change the local host? Any suggestions appreiacte server_id name product provider data_source 0 LOCALHOST SQL Server SQLNCLI LOCALHOST server_id name product provider data_source 2 REMOTEDB EMOEDB MSOLEDBSQL REMOTEDB     Development - SQL Server 2014 [Get the Suggested employee to assign ticket]( - Dears, I have 2 tables called Employees and Tickets Employee Data Tickets Data When the user load the tickets I have to give a suggested employee who could be assigned this ticket based on some conditions Conditions: Nearest Location(The Employee who is near to the ticket location using Latitude and Longitude) TypeId AreaId TodaysTickets (Get […] SQL Server 2019 - Administration [→ $850-800-9826 → Emirates Airlines Ticket Reservations Number](e2%86%92-850-800-9826-%e2%86%92-emirates-airlines-ticket-reservations-number) - Been thinking about booking that flight to your next dream destination? As they say, carpe diem! Check out the impressive range of routes operated by Emirates and score a reasonably priced ticket through Travelocity today. Emirates has an impressive fleet of aircraft that zips across the country connecting family, friends and loved ones every day […] [→ $850-800-9826 → JetBlue Airlines Ticket Reservations Number](e2%86%92-850-800-9826-%e2%86%92-jetblue-airlines-ticket-reservations-number) - Been thinking about booking that flight to your next dream destination? As they say, carpe diem! Check out the impressive range of routes operated by JetBlue and score a reasonably priced ticket through Travelocity today. JetBlue has an impressive fleet of aircraft that zips across the country connecting family, friends and loved ones every day […] [→ $850-800-9826 → Swiss Airlines Ticket Reservations Number](e2%86%92-850-800-9826-%e2%86%92-swiss-airlines-ticket-reservations-number) - Been thinking about booking that flight to your next dream destination? As they say, carpe diem! Check out the impressive range of routes operated by Swiss and score a reasonably priced ticket through Travelocity today. Swiss has an impressive fleet of aircraft that zips across the country connecting family, friends and loved ones every day […] ["SQL Server could not write to security log" alert for only a few events]( - Hello, Following the implementation of alerts in the SQL agent to detect errors with severities ranging from 16 to 25, I just realized that I have problems with the SQL audit that are written in the security logs of Windows because I receive alerts 17 with the description "SQL Server Audit could not write to […] [Is there any free SQL Server on Cloud for student, that has no limit (days, only]( - Hello, I'm a lecturer that intend to bring back SQL Server into our curriculum on our Uni, just wanna ask, is there any free cloud SQL Server for student that has no limit for hobbyist/student to use their service, as we know ASP.NET Core in Azure is free til 10 website, just the problem is […] [How to prevent -5 Blocking Session]( - Hello, There is an article below that discusses what causes it.   Running SQL Managed Instance environment. Is the issue too much I/O pressure?  Suggestions for monitoring/preventing.  Thanks,  Daniel  SQL Server 2019 - Development [Interrogate XML columns in table, however element names contain _x0020_ (space)]( - Good day In my current contract, I have been tasked with writing queries to extract data from an audit trail table in a SQL server DB, with two XML columns. Upon creating a script to view the data, reflecting exactly what has been changed between Old & New, i have encountered an issue - the […] [JSON structure positioning]( - I have the following  declare @X nvarchar(max) set @X='[ { "a": "", "b": "", "c": "", "e": "", "f": "", "g": "" } ]' declare @y nvarchar(max) set @y='{"bac": ""}'  what I need is  '"pro": [ { "a": "", "b": "", "c": "", "address": { "bac": "" }, "e": "", "f": "", […] [PowerShell from SSIS]( - I am attempting to run a simple Powershell command through SSIS. The caveat is that I am using Posh-SSH as an add-on module. The Powershell script connects to a server via SSH, runs a command and captures the results. It works fine when I run it manually in Powershell or from the command prompt. When […] Reporting Services [Printing group totals in a different page]( - Hi all, I have a requirement like printing the group totals in a new page with SSRS. for example: Page 1: Country State Sales_Amount USA    NJ     100 USA    NY     200 USA    OH     300  Page 2: TOTAL:  […] SSDT [SSDT development shop that sets ALL db objects to BuildAction=No]( - I work in a db development shop where it is common practice to disable the building of SQL code in SSDT projects. In other words, I have a stored procedure called sp1.sql, and I set the BuildAction to None. Object is never seen by the IDE, never gets compiled, and its only put into a […] Design Ideas and Questions [Design for multi-store online products. EAV?]( - so i have relentlessly researched the pros and cons of how to design product attributes using the EAV  model vs separate entity model and I still can’t decide what is best for my simple project. The app is basically a map of a city where users click on a particular store which brings them to […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -