Managing SQL Agent in Azure Data Studio (2024-05-17)

SQLServerCentral Newsletter for May 17, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Managing SQL Agent in Azure Data Studio]( - [SQL Replication Error - the row was not found at the Subscriber when applying the replicated UPDATE command]( - [From the SQL Server Central Blogs - Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger]( - [From the SQL Server Central Blogs - Develop and Test Your Rollback Plan]( - [Learn T-SQL Querying]( Question of the Day - [Creating Statistics on XML]( The Voice of the DBA  The Evolving DBA This editorial was originally published on Dec 16, 2019. It is being republished as Steve is on vacation. The world is changing. Plenty of people have written about the changes in the job of the DBA ([DBAKevlar]( [Brent Ozar]( including [myself](. While lots of vendors might postulate their database removes the need for a DBA, and [some might believe that]( I think that's disingenuous. Microsoft doesn't hire DBAs, but they hide that job under other titles. We still need DBAs, though the job changes a little in the future. Recently I saw a post from new PASS Board director, [Melody Zacharias]( where she notes that [DBAs are more important than ever](. She gives us five reasons, and I tend to agree with most of them. There is a need to somehow keep track of and manage data, much of which will continue to live in relational stores. As much as there is grown for key-value, graph, streaming, document, and other styles of data stores, we still use relational databases for many tasks. I don't see that going away anytime soon, especially for legacy software that will continue to live for some time. There is also the aspect of a DBA that involves the cleaning, checking, and verifying that data is in the form and format we expect, not to mention the need to ensure the data is intact and protected, and not changed inappropriately (or corrupt). Every system needs people that can dig through data and help decode its meaning as well as ensuring that business users can get it in to a report of some sort. Those tasks don't go away. While end users might have more self-service query tools, that doesn't ensure that they will actually know where the data is or how to reformat it. No end user tool is going to fix mm/dd/yyyy for a user expecting dd/mm/yyyy. There is also the need to just manage large amounts of data. I know data scientists have struggled to work with large scales of data in the past, and not just because of hardware limitations. They spend an inordinate amount of time gathering and organizing data that is used for analysis or AI/ML operations. Future organizations won't want to waste their time on those tasks and turn to some sort of DBA to help manage the large data needs of those people performing high level analysis. The DBA isn't going away, though the job is changing. Checking logs and backups is likely something you'll do less of in the future if you work in Operations. Instead, you'll manage more data, and you'll certainly need some coding skills to ensure you can perform in [GitOps environments]( where we don't click on things, but rather use code to define our systems and the configuration that we expect. The evolution can be daunting, but it can also be exciting. You have time to learn and change and build new skills. Embrace the opportunity to grow and change in your career as a DBA. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Managing SQL Agent in Azure Data Studio]( Steve Jones - SSC Editor from SQLServerCentral This article continues my series on ADS and examines the SQL Agent extension. [External Article]( [SQL Replication Error - the row was not found at the Subscriber when applying the replicated UPDATE command]( Additional Articles from MSSQLTips.com Learn how to fix replication error the row was not found at the Subscriber when applying the replicated UPDATE command for Table with Primary Key(s). [Blog Post]( From the SQL Server Central Blogs - [Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA I wrote a post recently about pruning branches in git. That’s part of the job, but the other part is removing local branches. This post looks at one way... [Blog Post]( From the SQL Server Central Blogs - [Develop and Test Your Rollback Plan]( K. Brian Kelley from Databases – Infrastructure – Security he rollback plan... what to do when things go wrong to get back to where you were before the deployment or implementation. I've seen too many cases where a... [Learn T-SQL Querying]( [Learn T-SQL Querying]( Additional Articles from SQLServerCentral Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers   Question of the Day Today's question (by Steve Jones - SSC Editor):  Creating Statistics on XML I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do? 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) Full Text Editions In which editions can I use Full-Text and semantic search? Answer: In Enterprise, Standard, Web, and Express with Advanced Services only Explanation: You can use full-text and semantic search in all editions except basic Express. Ref: Features and Editions - Programmability - [ [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 2019 - Administration [The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr]( - I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory oltp enabled. I have a full and a diff backup I'm trying to restore under a new database name, followed by some log files. The full restores fine but then the diff throws this error and I can't find anything about […] [SSRS Web Service URL - getting rid of HTTP]( - Not sure if this is the place to ask, but will give it a shot. We have an instance of SSRS 2019 running, and we connect to it via our Dynamics CRM (online version) - in this case via an IFRAME within a form. The report works, the issue is that some of the images […] [SQL Server software and windows version compatibility level]( - Is there a specific platform or website where I can verify the compatibility between different versions of SQL Server software and Windows? For instance, I would like to check the compatibility of Microsoft Command Line Utilities for SQL Server, MS Report Builder, and MS SQL Server Management Studio. [can I monitor auto stats updates through extended events?]( - We have pretty big tables very sensitive to stats with many updates. Our systems are complex with many places requiring explicit statistics updates and we want to monitor this to investigate potential SAMPLE updates overwriting FULLSCAN updates. We managed to catch all such updates through extended events by filtering on sp_statement_starting and sql_statement_starting but we […] [Access Issues]( - We have a windows account that currently has access to half of the sql server machines.(Both RDP and SQLAccess) The rest of the servers we do not have both RDP and SQLAccess. Does this mean when our accounts were created in AD we were not assigned to all relevant security groups which allows us to […] SQL Server 2019 - Development [timeout in vs for ssas tabular deploy is 0 but i still timeout deploying]( - hi we run 2019 std but i'm testing this on 2016.  following some old notes and starting from the debug tab in vs, i picked options, went to bi developer and set the properties you see below. but i still get a timeout on each line of the process when deploying as shown in the […] [Table variable declared within cursor persists across loop iterations]( - If you run this code it creates a 2 row cursor loop. Within the cursor the temp table @spec is declared and inserted into (as the output of a select). What was unexpected for me is in the second iteration of the loop the temp table contains 2 rows. The "solution" to this issue I'm […] [Blocking question]( - Hi all, We have a SSIS package that does 2 things in parallel: moves data from one partition to another within the same table. First, it truncates destination partition, then selects from source partition and inserts to destination one. But my select process is blocking truncate process, and truncate in turn is blocking insert to […] SQL Azure - Development [Performance]( - Experts, I am learning some skills so I can troubleshoot some performance-related issues. I have gotten good with some basics but when it comes to query which gets the data from tens of tables, I get lost, especially when I look at the execution plan. I am hoping if someone would give me some tips […] SQL Azure - Administration [Looking for a Recommended Azure SQL Managed Instance Book]( - Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about "care and feeding," best practices, etc. Powershell [Use of variable issue]( - All, I'm trying to set up some code in a SQL agent job. The following code works as expected: $sqlConn = New-Object System.Data.SqlClient.SqlConnection $sqlConn.ConnectionString = "" $sqlcommand = $sqlConn.CreateCommand() $sqlcommand.CommandText="Select filename from dbo.ssisfiles" $DataAdapter = new-object System.Data.SqlClient.SqlDataAdapter $SqlCommand $dataset = new-object System.Data.Dataset $DataAdapter.Fill($dataset) foreach ($Row in $dataset.Tables[0].Rows) { if (Test-Path -Path "c:\as_demo.txt") { Throw "File […] MySQL [How to install mysql-connector-python-8.4.0.zip it does not have setup.py]( - How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz SQL Server 2022 - Administration [when primary is down and not accessible failover not occured then how to recover]( - HI All, can any one reply on this when primary is down and not accessible also failover not occurred to secondary and size of the database is huge client dont want to loos the data and how to recover always on in secondary server online with out data loss SQL Server 2022 - Development [Multiple processes accessing the same table. some to write others to read / Lock]( - Dears, Hope this message finds you well We have a log table which is used at same time by some processed to read and others to write. This is causing deadlock What can we do to secure that we end up with deadlocks? Shall we shift the isolation level on the read queries or something […] [SSIS upgrade]( - I have about 40 packages that are dtsx files that were created with SQL 2016. It appears that I need to either install SNAC (which is decprecated / not recommended) or change them all to sql ole db. Is there an easy way to change to sql ole db?     [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -