Query History and Server Reports in Azure Data Studio (2022-03-14)

SQLServerCentral Newsletter for March 14, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Query History and Server Reports in Azure Data Studio]( - [DBAs and DevOps: A match made in heaven?]( - [What’s new in SQL Monitor? Tagging and Current Activity Page (minor release v12.1)]( - [From the SQL Server Central Blogs - I’m writing a SQL Server security presentation and I need your help.]( - [From the SQL Server Central Blogs - Unable to Validate Source Query in Tabular Editor]( Question of the Day - [Five Nines]( The Voice of the DBA  Daily Coping Tip Take three calming breaths at regular intervals during the day 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. The Challenges of Changing Software Tools Years ago I set up an email account for my son using Gmail, periodically forwarding things I thought he might find interesting. One day I was with him at his PC and asked if he'd seen something from me. He said he hadn't and opened his mail. He had dozens of emails, many of them marketing. I asked him why he didn't delete some of the obvious marketing ones that he didn't care about. He pointed to the sidebar, where the usage of his account was listed. It showed a few percent of the 10GB he was assigned in use. He said if the usage got too high, he would. For now, he would rely on search to find things. That was fascinating to me. I'd grown up with limited space, used folders for organization, and pruned out anything old or useless. It was an eye-opening conversation to me on the difference in how generations looked at computing. That same thing is happening on a larger scale. As [this piece shows](, newer generations are approaching the way they use computers in a completely new way. They don't even necessarily know how to find items on their computer by browsing, which is strange for older users. It's a trend that vendors embrace. In Windows, Microsoft surfaces "Documents", "Pictures", "Music", etc., and I find many people have no idea where those folders actually are in the file system. I used to worry that we were losing skills that were needed. However, now I'm not so sure. The scale of items we might save has grown. In many ways, why would we care where they are on a system. Really, we need a way to access them, and linkages, search, and other techniques might be better than relying on our memories of how we've filed things. As I think about it, many of the problems of deploying software over the years have been because of incorrect paths. Why should developers manage that? Why don't projects and compilers just sort this out for us? How many times have I had to add an entry to my PATH variable? Shouldn't executable software solve that for me? Certainly someone needs to care about locations and security and various other details, but for most people using a system, these are unnecessary details. I don't know "where" stored procedures or functions reside. SQL Server ensures they exist somewhere and the various Object Explorers in tools put them in a place I can find. I embrace these types of changes and encourage our industry to make installing and using software, as well as the management of files and other items easier and more autonomous. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Query History and Server Reports in Azure Data Studio]( Daniel Calbimonte from SQLServerCentral Introduction to Query history and server reports i... [External Article]( [DBAs and DevOps: A match made in heaven?]( Additional Articles from SimpleTalk DevOps is a buzzword thrown around a lot. But what does it mean for you as a DBA? And how can the whole team work together to achieve peak performance across multiple projects? Join Kathi for the discussion. [External Article]( [What’s new in SQL Monitor? Tagging and Current Activity Page (minor release v12.1)]( Additional Articles from Redgate We've released a minor version of SQL Monitor, v12.1, that includes two exciting new features: ‘Tagging’ and a ‘Current Activity’ page. In a nutshell: tags allow you to record aspects of a server so that you have information at your fingertips, and the Current Activity page directly queries the monitored server when you open it to get the most up-to-date information possible. It’s all part of our commitment to making SQL Monitor the best monitoring tool out there! [Blog Post]( From the SQL Server Central Blogs - [I’m writing a SQL Server security presentation and I need your help.]( Kenneth.Fisher from SQLStudies I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going ... Continue reading [Blog Post]( From the SQL Server Central Blogs - [Unable to Validate Source Query in Tabular Editor]( Angela Henry from SQL Swimmer I recently encountered the error, “Unable to validate source query” when trying to refresh the metadata for the tables in my tabular model using Tabular Editor. I immediately googled...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Five Nines How much downtime is allowed each year if I am trying to ensure 5 9s of availability for my database (roughly)? 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) Data Analytics Classification II I build a chart that shows me the sales from last year and extrapolates what we expect sales to look like for the next quarter. What type of analytics are being used? Answer: Predictive Analytics Explanation: Predictive analytics helps answer questions about what will happen in the future. Ref: Explore Data Analytics - [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 [How to get Two averages when the Number is defined as nvarchar ?]( - Hi experts, Sorry for not getting you a table or data at this moment but I will if I need to get help tomorrow How do I get Average of Cost 2. Average cost of Home Dept vs Overall Average Cost (Example: Home Department) Average Selling Prices of Each dept against over all selling price […] [Starting a beginner SQL server job - Need books, resources, ideas to learn]( - Could someone please give me some advice regarding SQLserver and SQL in general? I have some experience, but it was too long ago and I need to freshen up. Books, links, ideas, concepts that need to be known not to get fired the first day. Thank you. SQL Server 2016 - Administration [SQL Agent Job]( - Hello, One of the full back up job failed and it was triggered again. The DB's size is big so it takes couple of hrs to complete. My questions is ....if the running job does not finish before the scheduled time when it starts...will it fail or stop current run?  Is there a way […] [Read previous days transaction log .trn]( - Is there a utility or script that I can see the Transactions that happened in a Trn log backup file (.trn). I would like to see what transactions and tables where updated in the Backup log. Thanks. SQL Server 2016 - Development and T-SQL [units divided by quantity and order by date]( - Hi Expert, I am facing challanges for logic to apply all previous units sold divided by next or nearest dates quantity here is the query Create table ratio1 (UNIT1 int,CONS integer,SaleDateId date,consumables integer) insert ratio1 values (4444444,222,'20210407',10), (4444444,333,'20210407',15), (4444444,444,'20210407',24), (4444444,555,'20210407',24), (4444444,777,'20210412',10), (4444444,888,'20210414',16), (4444444,999,'20210414',20), (4444444,000,'20210421',10) ========================================= create table main ( oid int, UNIT1 int,SaleDateId date, quantity […] Development - SQL Server 2014 [List Dates between Start and End Date]( - Hi I have a very simple query as below select Personid, StartDate, endDate from table where startdate >= '01-feb-21' Example Data 223, 01-Feb-22, 04-Feb-22 354, 21,Feb-22, 22-Feb-22 I want to display it now as follows, so listing the days between the startdate and enddate for each personid Data would be as follows 223, 01-Feb-22 223, […] SQL Server 2019 - Administration [Problem with Secure Enclave attestation]( - Hi all, long time lurker, first time posting. Looking for some help with an error I am seeing with our Always Encrypted with Secure Enclaves setup. In our production environment when our user load increases during the day I am seeing exceptions as follows: Failed to create enclave session as attestation server is busy. We […] SQL Server 2019 - Development [Automatically output Extended Events data to table]( - Hi there, I was wondering if/how I would be able to output the results of an Extended Events session to a database table, either in real time or on a regular schedule. I have seen it suggested that the ring buffer could be used as a target, then that could be queried regularly and copied […] [Merge into a subset of the target]( - I have a table with a column named JDX that I wish to merge into and I want to limit the merge considerations to the set where JDX is 180. I reduced the fields being updated for brevity. It works on the "matched " and "not matched by Source" by adding "and jdx = 180" […] [Remove values between single quotes.]( - Hi  So Ive got a SQL trace uploaded into a table and I 'm looking at the ad-hoc calls, I want to summarize them and remove any values from the calls e.g instead of select id,jobcode from table where id = '1' and jobcode in ('s','l') I want to be left with select id,jobcode […] [Extract date from a text field]( - I'm trying to extract date from a text field. I'm using PADINDEX to do this. My results are very inconsistent. Is there anyway I can do this through SQL. I don't have an application to do this for me. I am trying to get this for a report that is needed. The text field has […] [Merging sql and excel]( - I’m trying to merge sql data and excel data to an excel spreadsheet. Is there a way to do this? General Cloud Computing Questions [What exactly is cloud computing?]( - Is this idea that I have correct: Cloud computing is a place in some company that is offering cloud computing where it has some servers there that are shared among applications that are subscribed to this cloud. For example BAAS, uses cloud computing where the company example google offers some services like push notification/storage/database instead […] General [what is a good web dev project for a beginner?]( - So my questions is what is a project for a beginner like me who knows python (very well), C and C++ (comfortable with it), algorithms and datastructuresbut knows nothing about JS HTML CSS and databases. I saw that common suggestion is to create a blog but it seems kind of boring (tho I will start […] SQLServerCentral.com Website Issues [Airline posts?!?]( - What's the deal w/ the sudden spate of airline spam posts? Any way to block these systematically?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -