Using Azure Synapse Link for Azure Cosmos DB (2020-12-17)

 SQLServerCentral Newsletter for December 17, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Using Azure Synapse Link for Azure Cosmos DB]( - [Developing a backup plan]( - [Join the Redgate Tool Tips Swap]( - [From the SQL Server Central Blogs - T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?]( - [From the SQL Server Central Blogs - Using Aws Sdk With Go for Ec2 Ami Metrics]( Question of the Day - [Database Firewall Rules]( The Voice of the DBA  Daily Coping Tip Be generous and feed someone with food, love, or kindness 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. Join the New Stars of Data Standing in front of a group, large or small, was one of the most intimidating things to me as a young man. I hated making presentations in school and university to others. As I moved through my career, however, I realized that this was an important skill for my career. Often in many positions, I had the chance (or need) to debate, argue, or just present a viewpoint to others on my team or inside my organization. I had to train others, teaching them about our systems. I had to explain my decisions to management and defend actions. All of these moments required speaking and communication skills. You can take a chance and share something with others [by submitting to The New Stars of Data](. Their next event is in March, which gives you lots of time to prepare, practice, and get feedback before delivering a session. If that's too soon, I'm we'll see another [GroupBy conference](, [SQL Saturday](, or other virtual event that will consider you. I'd ask that all of these events reserve 10% of their slots for new speakers to their event. After all, it can be less intimidating to speak virtually, and there are lots of opportunities right now. Many of you might not think you're smart enough, or an expert in some area. I'll share a little secret with you: I'm not either. I often see questions at [SQLServerCentral]( or in the Microsoft MVP email list that amaze and surprise me. I truly feel like an [impostor]( at these moments, when I realize I don't know or understand something. At some point in life I started to take chances and deliver small talks at work or user groups. I realized that I didn't need to be an expert to teach something to others. I realized I could [have some success](, even without being the smartest person in the room. There are always people that know more, but there are always others that want to learn something simple. Level 101 talks are always popular and in demand. Take a chance today, and submit to the [New Stars of Data](. I'm happy to help you with an abstract, or give you feedback on a practice talk. William, Ben, and many others will help as well. [Submit a talk](, ask for help, and continue to grow your career. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Using Azure Synapse Link for Azure Cosmos DB]( Sucharita Das from SQLServerCentral Learn how you can query CosmosDB data from Azure Synapse in this walkthrough. [Developing a backup plan]( Additional Articles from SimpleTalk Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan. [Join the Redgate Tool Tips Swap]( Additional Articles from Redgate Learn and share tool tips with your peers. Redgate has launched their Tool Tips Swap to help everyone make the most of their Redgate products. To get involved, simply share your top Redgate tool tip for boosting productivity. All tips will be collated into a blog post and shared with the community. Plus, you’ll get the chance to win a 3-month subscription to Pluralsight. From the SQL Server Central Blogs - [T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?]( Tracy Boggiano from Database Superhero’s Blog T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have... From the SQL Server Central Blogs - [Using Aws Sdk With Go for Ec2 Ami Metrics]( Sheldon Hull from Sheldon Hull Source The source code for this repo is located here: What This Is This is a quick overview of some AWS SDK Go work, but not a detailed tutorial. I’d love feedback from...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Database Firewall Rules I am working in Azure SQL Database and I want to set a database level firewall rule. How can I do this? 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) The Classifier What does the classifier() function do in R? Answer: This function will allow you to train a model in machine learning with one of a few different types of algorithms Explanation: The classifier() function is a machine learning tool that can use one of a few types of ML algorithms to build a model. Ref: classifier() - [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -