The case for SQL Server Agent 2.0 (2020-12-21)

 SQLServerCentral Newsletter for December 21, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [The case for SQL Server Agent 2.0]( - [Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates]( - [Are your Oracle archived log files much too small?]( - [From the SQL Server Central Blogs - Introduction to SQL Server Query Store]( - [From the SQL Server Central Blogs - Toolbox - When Intellisense Doesn't See Your New Object]( Question of the Day - [HA in Business Critical Managed Instance]( The Voice of the DBA  Daily Coping Tip See how many different people you can smile at today 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. Giving of Yourself [Kathi Kellenberger]( is my colleague at Redgate, and fellow editor at [Simple Talk](. She is quite active in the WIT movement as well as other charitable endeavors such as [LaunchCode](. A longtime speaker and author in the community, Kathi has a history of giving back to help others. I enjoyed reading [her editorial]( recently about some of the giving back that our team has worked on this year. It's a good summary of the different ways that the Advocates have tried to do something for different parts of our community. Some of this was a normal "work" we might do, and some was separate, but these efforts are a part of the reason that we have this job. One thing I've been impressed with this year is how often I've seen members of the SQL Community reach out to help others. From support to listening to offers of help, I'm glad that we have found ways to give of ourselves. I've seen similar things in my community, and it gives me hope for humanity. I believe strongly that all of our should find ways to volunteer and help others in our lives. It might be when you are young, when you retire, maybe a few times a year, maybe every week, but we all benefit when we realize there is something bigger than us, and something more important than our own needs, wants, and desires. As we close out this difficult year, remember that whatever happened to you, likely there are people who struggled more. Look for opportunities to help others, in big or small ways, whenever you can. It could be with an organization. It could be a helping hand in your community or a moment that you seize and opportunity on the street. Look for [a chance to play Santa](, with a gift, a donation, or an act of service. It will do you a world of good. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [The case for SQL Server Agent 2.0]( Steve Rezhener from SQLServerCentral SQL Server Agent is heavily used by many organizations, but it hasn't changed much in years. This article speculates on some new features that might improve the scheduler. [Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates]( Additional Articles from Redgate As more organizations are managing at least some part of their data in the cloud, estate monitoring can become more complex with a mix of on-prem and cloud-based instances. Grant Fritchey discusses why businesses might move to the cloud, why they might stay on-prem, and when a hybrid approach might be best. [Are your Oracle archived log files much too small?]( Additional Articles from SimpleTalk Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs. In this article, Jonathan Lewis explains how Oracle uses online redo logs and why there might be a discrepancy in the archived log size. From the SQL Server Central Blogs - [Introduction to SQL Server Query Store]( matthew.mcgiffen 73574 from Matthew McGiffen DBA Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,... From the SQL Server Central Blogs - [Toolbox - When Intellisense Doesn't See Your New Object]( @DBA_ANDY from Nebraska SQL from @DBA_ANDY I was just working on a new SQL job, and part of creating the job was adding a few new tables to our DBA maintenance database to hold data...   Question of the Day Today's question (by Steve Jones - SSC Editor):  HA in Business Critical Managed Instance How is high availability handled in the Business Critical tier of Azure SQL Managed Instance in Nov 2020? 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) Removing Git colors I want to ensure that no colors are used in the git command line at all and just the plain colors I have configured for my terminal are there. What settings do I change? Answer: git config --global color.ui false Explanation: The --global flag is needed for all repos. The color.ui is the value to change. Ref: Customizing Git - [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 [Always on AG group]( - One of our DR server went down over the weekend with blue screen and cause the synchronization to fail. The DB monitoring system crashed cause no notification sent. I found the DR server issue after 2 days. I agree lot of things need to be straightened out, why windows team did not notify us and […] SQL Server 2017 - Development [Alter authorization on view]( - Hi I have created a view in viewschema against table1 in tableschema I would like to change the owner of the view to to the tableschema. ALTER AUTHORIZATION ON viewschema.viewName TO tableschema When I run the above, I get Cannot find the principal tableschema, because it does not exist or you do not have permission. […] SQL Server 2016 - Development and T-SQL [How to Find Duplciate Data stored in multiple tables]( - There is probably a name/term for this problem and I'm just unaware of what it is. I know how to find duplicate data in a singular table but not when the data your comparing is stored in multiple tables, 2 tables with a parent child relationship. I Restored a copy of the AdventureWorks DB but […] [Trouble dynamically rolling up some accounts]( - Hello, Hopefully someone can help we with the following issue that i have. I have provided some test data in the format of two basic tables that closely replicates the issue. Sample data: CREATE TABLE xdbExample ( [Period] INT ,[Site] VARCHAR(6) ,[Account] VARCHAR(4) ,[Value] INT ) INSERT INTO xdbExample ([Period], [Site], [Account], [Value]) VALUES ('1901','SITE01','ACC1','1') […] [Combine Date & Time parts for Two Dates, then subtract]( - Hi,  I'm trying to combine a Date and a Time field into a DateTime, and then again for two more Date and Time fields, and then subtract the two combined DateTime fields within one select field of the SELECT statement... I can combine through CAST a Date field with a Time field, and I can […] [SSIS Config Files vs Config Tables]( - I have recently run into multiple solutions where they are using Configuration Tables to store Config parameters instead of Configuration Files. I'm a little leery to continue using the table approach. We don't have SSISDB, so that's not an option. What are your thoughts on using the table vs file approach? I've always used the […] SQL Server 2019 - Administration [Connection to SSIS after upgrade]( - I've just upgraded from SQL server 2014 to 2019 and also installed the latest version of SSMS. My server has always been on a local machine (i.e. server name was (local) as far as I can remember, or if not it was just the name of the machine in Windows). I don't have external users, […] [Secure Sockets Layer (SSL) encryption. Error: \"SQL Server did not return a respo]( - Bonjour , J'ai un problème de connexion sur le serveur SQL Joindre le message d'erreur Le pilote n'a pas pu établir une connexion sécurisée à SQL Server à l'aide du chiffrement SSL (Secure Sockets Layer). Erreur: «SQL Server n'a pas renvoyé de réponse. La connexion a été fermée.». La connexion SSMS fonctionne correctement si ce […] SQL Server 2019 - Development [SSIS Script Task for PowerShell]( - HI everyone! How do i update the script task to run on a specific server. This would change for each run. Or is there another way to run the powershell? SSIS runs the below: ssis exists on server 1 Copies powershell to server 2 Run powershell on server 2. (Assistance needed) [Access to SQL expression]( - Hi folks, I'm trying and failing miserably to convert an Access Expression to SQL query The MS Access Expression strips the following field data formats to extract the middle text between the 2 hyphens 2C00P02-CRIW-93201 (Extracted value: CRIW) Any help appreciated Left(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),InStr(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),"-")-1) [TSQL Script: Min, Max function]( - Hello All, I hope you are doing well. I have difficulties to write a sql script. May be you could help me. I have a table like this. And I want to have a result like this:   I used the min and max function but it doesn't work. Do you have any idea […] Reporting Services [SSRS and subscriptions with office365]( - Hi.I have a detail with the subscriptions in Reporting Services (SQL Server 2014).I have configured DBmail using Office365. When I run the report to send it by mail it sends: Failure sending mail: Error in processing. The server response was: 5.7.3 STARTTLS is required to send mail [BN6PR03CA0006.namprd03.prod.outlook.com]Mail will not be resent. I opened the […] Integration Services [PowerShell Process Task fails in locked down Windows 10]( - Hi Guys A weird one here. I run a process task to run powershell.exe with the argument -File C:\Ace\ResetSpreadsheet.ps1 This script runs a macro in a spreadsheet in the same folder to clear existing data and then saves and exits. Because the IT people lock our boxes down to the nth degree I had issues […] MySQL [TERADATA - Execute procedure permissions]( - im finding it hard to get a reply on other forums because of low activity in general, so apologies if this is in the wrong place Im a working in Teradata and i create a procedure and all is well then he following day, having logged off and back on, i dont have execute permissions […] Job Postings [Looking for article writers]( - Hi there, I'm looking for a few freelance writers who would be willing to help with some quick turn around posts about PostgreSQL and MySQL. We're also looking for people who may have already written pieces they'd like re-syndicated. Both opportunities are paid. Right now, we're offering $50-150 a piece, with some bandwidth to increase […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -