Monitoring Azure SQL Databases (2022-03-18)

SQLServerCentral Newsletter for March 18, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Monitoring Azure SQL Databases]( - [Bulk Formatting of the SQL Server SQL Files]( - [The effects of NULL with NOT IN on Oracle transformations]( - [From the SQL Server Central Blogs - T-SQL Tuesday 148: Finding and keeping a consistent audience, and what works]( - [From the SQL Server Central Blogs - Reading more efficiently]( Question of the Day - [Saving Synapse Money]( The Voice of the DBA  Daily Coping Tip Get outside and notice how the weather 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. Becoming a Better Colleague Have you ever said something you regret? Made a comment you wish you could take back? Perhaps you tried to make a joke and offended someone. In any case, how do you react? I saw [this thread on Twitter](, which started off with this comment: "Please know, if you’re someone who brings a book to the bar… nobody likes you". I don't know this person, and I know this isn't remotely true. I take books to bars and restaurants all the time. I travel alone and use a lot of spare time to read, usually over 100 books a year. I often dine alone and will have a drink or a meal at a bar while I read. I'm getting off track here. The sentiment isn't really important, and I wasn't offended. What I liked in this thread was the reaction of the author. He reflected and then wrote that it's not his thing, he had a poor perception of this action based on a friend, and he hadn't considered other points of view. What interested me was the reaction to learn, to change your mind, and to apologize. I see the same thing in software development and operations teams. Sometimes we have very strong opinions or ideas on things. We might imply, or even say, that someone isn't smart when they made a mistake. We might call them a name, or we might denigrate them for making a suggestion. I think strong opinions are good. They help us move forward, decisively, in a timely manner. They give us the confidence to do our jobs. However, that doesn't mean we are always right, or that we shouldn't present ourselves differently to a group. My view is that we ought to have strong opinions, loosely held. If there is evidence that we are wrong, or we need to adapt, we should change something. If we offend someone or weaken the team, we ought to apologize. It's often easier to apologize than change our habits, though both skills are valuable in our careers. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Monitoring Azure SQL Databases]( Johan Åhlén from SQLServerCentral There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This article will describe two options that are available: Azure SQL Analytics and Azure SQL Insights. Both […] [External Article]( [Bulk Formatting of the SQL Server SQL Files]( Additional Articles from Redgate In this article, Phil Factor explains how to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch. [External Article]( [The effects of NULL with NOT IN on Oracle transformations]( Additional Articles from SimpleTalk IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN and NOT IN. [Blog Post]( From the SQL Server Central Blogs - [T-SQL Tuesday 148: Finding and keeping a consistent audience, and what works]( Diligentdba 46159 from Mala's Data Blog This months’ T-SQL Tuesday blog party is hosted by Rie Merrit (t|b) as part of Azure Community Group lead. Her call is to pick one or two things that... [Blog Post]( From the SQL Server Central Blogs - [Reading more efficiently]( K. Brian Kelley from Databases – Infrastructure – Security In IT, we have to read a lot. For instance, understanding how to set something in Azure or Okta or vSphere may mean we are consuming 5 or more...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Saving Synapse Money You have a dedicated SQL Pool in your Azure Synapse Analytics Workspace. This pool is used heavily during the day, but from 8pm local time until 6am, it isn't accessed. What is the easiest way to save money in this situation? 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) 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? Answer: 96GB Explanation: The rule (as of Feb 2022 ) is that the vCore count times three (x3) is the maximum RAM. Ref: Serverless Resource Limits - [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 2012 - T-SQL [Problem with Latitude and Longitude Distance calc]( - I have an ad hoc block of code that is performing well, but when I place the logic into an insert into a temp table I get NULLS in my Distance field: This works well: Declare @source geography = geography::Point(35.93099821, -79.95852298, 4326); Declare @destination geography = geography::Point(36.08000000, -79.44000000, 4326); Select @source.STDistance(@destination) / 1609.344 as Miles; […] [Can't run package via SQL Agent]( - Hi all, I didn't manage to run the SSIS Package via SQL Agent. I can do it manually but when I execute the job via SQL Server - package is down with an error "oXC0208449 the specified DSN contains an architecture mismatch" . I have 64 windows. ODBC Driver was set up for 32. Also, […] SQL Server 2019 - Administration [1+(844)-460-3598Expedia Customer Service number]( - Expedia Customer Service number . Expedia , Inc., also known as Expedia, is the main in the United States and a legacy carrier. Its headquarters are located in Georgia, Atlanta. Together with its subsidiaries and local affiliates, the Air, which includes Expedia Connection, conducts around 5,400 s per day to 325 attractions across 52 states […] ["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:  […] Integration Services [Very wierd casting exception after deployment]( - Hey everyone,  The issue I'm having is the strangest thing so I figured I post it here to get more eyes on it and to see if there is anything I'm missing. So, I have a SSIS package (SSIS 2019) where I have a script task that is getting some data from a web […] 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -