Introduction to SQL Jobs in Azure Data Studio (2021-12-13)

SQLServerCentral Newsletter for December 13, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Introduction to SQL Jobs in Azure Data Studio]( - [Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow]( - [A Flyway Teams Callback Script for Auditing SQL Migrations]( - [From the SQL Server Central Blogs - Tagging in SQL Monitor]( - [From the SQL Server Central Blogs - Configure SQL Server on Linux for Active Directory Authentication]( Question of the Day - [Amazon Aurora]( The Voice of the DBA  Daily Coping Tip Do something helpful for a friend or family member 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. Acknowledging Success Today is the Redgate annual award event, and I'm honored to be hosting again. I've been asked a few times, and I used to look forward to the gathering in Cambridge followed by our annual Christmas party. Last year this was virtual, as it is this year, so I'm hosting again from my home office. Not what I had hoped would happen, but I'll have some fun. Last year I had a number of shirt changes between my parts, and I may do that again. I know there are often annual sales awards in many companies, usually with some vacation or prize being given out, but not a lot outside of that department. In most of my jobs, we've usually had some sort of holiday party, but nothing else. As we approach the end of the year, I wonder if you find your organization doing any sort of recognition for your work this year? Or maybe highlighting those that have gone above and beyond what is expected? At Redgate, we have nominations in various categories. Some are sales-oriented, but we have an open award category as well as an ingeniously simple one. We've had people or groups from different parts of the company win that one. I think that recognition of effort and work accomplished is important for the morale and motivation of employees. When management recognizes people for their hard work and lets other employees have input into the process, you build a better team of people working together. Even when we aren't the winners, we can appreciate the effort that others put into improving the organization. My view is that few too few in the management of organizations appreciate the value of employees, especially the knowledge workers. Replacing people is hard, and it is expensive. Unmotivated people do less work and do it less well. I hope that more organizations learn this and start to put effort into valuing those that contribute to everyone's success. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Introduction to SQL Jobs in Azure Data Studio]( Daniel Calbimonte from SQLServerCentral Learn how to work with SQL Agent Jobs in Azure Data Studio. [External Article]( [Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow]( Additional Articles from MSSQLTips.com In this article we look at how ingestion will read data from the landing zone and push data into the Bronze layer of the Delta Lake tables for Azure Synapse Analytics. [External Article]( [A Flyway Teams Callback Script for Auditing SQL Migrations]( Additional Articles from Redgate Demonstrates a cross-database PowerShell callback script for reporting on and auditing Flyway migrations, telling you which scripts were used to create each version, when they were run, who ran them and more. [Blog Post]( From the SQL Server Central Blogs - [Tagging in SQL Monitor]( Steve Jones - SSC Editor from The Voice of the DBA For many of us, we’ve learned over time that we need to filter out the amount of things that we deal with in an given situation. We certainly often... [Blog Post]( From the SQL Server Central Blogs - [Configure SQL Server on Linux for Active Directory Authentication]( aen from Anthony Nocentino Blog In this post, we’re going to walk through configuring Active Directory authentication for SQL Server on Linux. We will start by joining the Linux server to the domain, configuring...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Amazon Aurora What type of database is AWS' Amazon Aurora? 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) Dynamic Data Masking Permissions What permissions are needed to change the mask on a column in a table for Dynamic Data Masking? Answer: ALTER on the table and ALTER ANY MASK Explanation: You require ALTER on the table, and ALTER ANY MASK to change a mask. Ref: Dynamic Data Masking Permissions - [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 - Development [Job is empty SQL]( - Hi guys,  I really do not understand why I still receive empty emails. Please check my code:  EXEC msdb.dbo.sp_send_dbmail @profile_name = '#####' , @recipients = 'a###' , @subject = 'queryresultset' , @body= 'test tes tesl' , @execute_query_database = 'dbo.rates' The mail I get is:    SQL Server 2016 - Development and T-SQL [Creating a unique value for a certain period & staff]( - I'm trying to build some business logic for my ETL which gives a unique ID (Integer in this case) groups for a particular Date period related to a Staff and I'm stuck on how to achieve it. Only way I can think of is using case statements as I will have so many of them […] [Write 2 complex queries]( - I have a DB: CREATE TABLE cabinet ( id_cabinet INT PRIMARY KEY, area INT NOT NULL ); CREATE TABLE doctor ( id_pib INT PRIMARY KEY, speciality VARCHAR(50) NOT NULL, surname VARCHAR(100) NOT NULL, id_cabinet INT NOT NULL, FOREIGN KEY (id_cabinet) REFERENCES cabinet(id_cabinet) ); CREATE TABLE nurse ( id_pib INT PRIMARY KEY, pib VARCHAR(255) NOT NULL, […] [Foreign key in the column values of another table]( - I have trouble in writing a SQL query. I have a data table with below columns. DataTable 1 id     notes ---------------------------------------------------------------- 1      develop document disseminate to {{param = "ac-    1_prm_1"}} 2      develop document to {{param = "ac-1_prm_2"}} Data table Parameter parameterid […] [How to increase performance to load a factless date-date-interval table]( - Hi all, I am currently having performance issues by populating one of my factless fact tables (fact_Datum). My business relevant fact table is not point-in-time but time-interval-based, because I am dealing with the whole history of the customer. Because we have use cases to analyse the data point-in-time, I have modelled that in the following […] SQL 2012 - General [Azure SQL backup policy strategies and best practices?]( - What are best practices for setting up long term retention for an Azure SQL DB? Are there any common strategies to keep the costs low? How should one go about implementing it for keeping 10 year backups. When I select weekly snapshots for 10 years, the cost is going through the roof (3.5x the cost […] [Deadlock occurred while trying to perform multiple inserts into the same table]( - We wrote the script to split inserting data the same table. There is an error occurred on one of the session as "ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 185) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." So, when […] SQL Server 2012 - T-SQL [Problem understanding SUM function with GROUP BY]( - I have code I'm trying to write to sum the time in decimal for each user_name: SELECT [user_name], dbo.fnGetDecimalTime([event_sec]) as 'Decimal_Time', SUM(dbo.fnGetDecimalTime([event_sec])) as 'Decimal_Time_SUM' FROM [Charter].[dbo].[ConvoHrs] group by [user_name], [event_sec] order by [user_name], [event_sec] desc But my data comes back looking like this: user_name Decimal_Time Decimal_Time_SUM (b) Alexander Pierson   2.00 2.00 (b) Alexander Pierson […] [Problem understanding SUM function with GROUP BY]( - I have code I'm trying to write to sum the time in decimal for each user_name: SELECT [user_name], dbo.fnGetDecimalTime([event_sec]) as 'Decimal_Time', SUM(dbo.fnGetDecimalTime([event_sec])) as 'Decimal_Time_SUM' FROM [Charter].[dbo].[ConvoHrs] group by [user_name], [event_sec] order by [user_name], [event_sec] desc But my data comes back looking like this: SQL Server 2019 - Administration [Guardian Botanicals Blood Balance Reviews: Benefits & Price?]( - Data about Guardian Botanicals Blood Balance lately, glucose issues have become more pervasive. These issues are brought about by an assortment of clinical and way of life factors, and treating them requires the utilization of costly, manufactured drugs that as often as possible have secondary effects. Guardian Botanicals Blood Balance has set up a good […] [SQL Agent step won't write to SQL log directory]( - I have a SQL 2019 (RTM-CU14) installation with an Agent job which constantly fails with the error: Unable to open Step output file. The step failed. The "Output file" value attempts to write to the SQL error log directory using agent tokens - although I've tried with a fully specified filename as well. Using C:\Temp […] [High Log Reads on Readable Secondary Databases]( - I've an AoHA environment where some of the Readable Secondary databases are being quite heavily read for reporting purposes. We are seeing that on these database there are high reads against the transaction logs. This image shows the levels of IO on the 3 main databases (highlighted), and one can see the Readable Secondary node […] [Activity Monitor always paused for "sa" login]( - Hi Everyone, I'm also experiencing the issue of a constantly "paused" SSMS Activity Monitor on a recently setup server. I've followed all the steps outlined in this blog post, without success: I'm using SQL Serer 2019 v15.0.4188.2 with SSMS v18.10. I've tried remote connections, local connections, using the "sa" user as well as another […] General Cloud Computing Questions [Recommended course with lab for Kubernetes CKA cert]( - Im a DevOps and cloud engineer and want to learn kubernetes because most opportunities that I come across are requiring experience with it. I know linux and have a solid and useful understanding of containers. Moreover, I have experience with Docker, bash, Python and Powershell. That said, I'm more of a hands on learner but […] Powershell [List file shares from TAR file]( - How can I list just the directories from a TAR file, then extract just 1 file share from that TAR file. Thanks.   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -