Server Dashboards in Azure Data Studio (2024-01-29)

SQLServerCentral Newsletter for January 29, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Server Dashboards in Azure Data Studio]( - [PowerShell Dynamic Parameters and SQL Server]( - [From the SQL Server Central Blogs - Troubleshooting SQL Server Error 8623: The query processor ran out of internal resources and could not produce a query plan]( - [From the SQL Server Central Blogs - Fabulous Stuff in Fabric – Part 3: Shortcuts]( - [Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers]( Question of the Day - [High Execution Plan Performance Variance]( The Voice of the DBA  Ask For What You Need Today we have a guest editorial from Andy Warren as Steve is at [THAT Conference](. It’s always interesting to talk to others in IT about their work and I’ve been struck by how often they don’t have all the things they need to support their business efficiently and effectively. Maybe they need more servers or a bigger server, or they need Enterprise Edition, monitoring licenses, utility software, an additional team member, or even technical training. They know what they need, why don’t they have it? Because in most cases they didn’t ask for it. Is it our place to ask? As the people doing the work, feeling the pain, and seeing the opportunities, aren’t we exactly the people that should be asking? If you’re thinking the answer is no, maybe it’s because you think your manager (or customer) should know, that it’s part of their job. That’s a fair expectation, but managers don’t always the time, energy, vision, or experience to know. Or to look at it a different way, if you were managing a team of IT professionals, would you want them to give you suggestions? Even if you think that asking for what you need or otherwise making suggestions is the right thing to do there may be reasons why you don’t ask. Perhaps you’ve asked in the past and been turned down. Or your manager or the entire culture isn’t receptive to some kinds of requests. Not asking is less risk and less aggravation. We all have to figure out the people and the culture, because if you try too hard or try the wrong way you can easily be tagged as the person who doesn’t get it. You might also not be asking for stuff because you think it’s too expensive. I see this a lot. We think about the money in proportion to our personal budget and values because that is our frame of reference. It’s just not the most useful one for business decisions. Instead, frame it as a way to improve the business. It might be reducing overall costs, increasing efficiency, reducing defects, or improving retention just to name a few. That changes the conversation from “that’s a lot of money” to “here is a problem or opportunity worth discussing”. If you decide to ask for something, it’s worth being thoughtful on how and when you ask. You have to sell your manager first. If they see the value, then you have to help them make the case to their manager and I think that is often where things go awry. We aren’t the only ones that are reluctant to ask for stuff and if they don’t make a good case for it, nothing will get done. Assuming that they had a good conversation though, it will hopefully bubble up to the level of whoever manages the budget. At that point it’s an exercise in figuring out how best to allocate the money available across a list of wants and needs from many teams (or potentially to ask for money in the budget). Not everything gets funded, that’s just how it works. If your request does get funded, hurrah! If not, try to understand why it wasn’t. Was it prioritization with the budget? Story not told well enough? Not aligned with the current areas of focus? Business being more cautious due to the economic climate? What you hope to learn is whether you should ask again next year and if so, should you ask differently? Or is this particular idea off the table, at least until a major change in leadership occurs? Have I convinced you to ask for what you need, or ask better, or again? Or is it harder than I’ve suggested here, or more frustrating? I’m looking forward to the discussion (forum link below) and hope to hear many interesting points of view as well as stories of success and failure. Andy Warren [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Server Dashboards in Azure Data Studio]( Steve Jones - SSC Editor from SQLServerCentral Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can customize them. Another article will cover the Database dashboards. […] [External Article]( [PowerShell Dynamic Parameters and SQL Server]( Additional Articles from SimpleTalk Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values. [Blog Post]( From the SQL Server Central Blogs - [Troubleshooting SQL Server Error 8623: The query processor ran out of internal resources and could not produce a query plan]( SQLPals from Mission: SQL Homeostasis SQL Server Error 8623 At least once day, an application for one of the databases I manage gets this error:The query processor ran out of internal... [Blog Post]( From the SQL Server Central Blogs - [Fabulous Stuff in Fabric – Part 3: Shortcuts]( Koen Verbeeck from Koen Verbeeck A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going... [Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers]( Site Owners from SQLServerCentral Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.   Question of the Day Today's question (by Steve Jones - SSC Editor):  High Execution Plan Performance Variance I want to see the top plans that have a lot of performance variation in their execution plans in SQL Server 2022 for a new database I created and deployed. What's the easiest way to 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) Linux Support What platforms does SQL Server on Linux support for SQL Server 2022 (apart from containers)? Answer: Ubuntu, Red Hat Enterprise Linux, or SUSE Explanation: For SQL Server 2022, there are three choices. Red Hat Enterprise Linux, SUSE, or Ubuntu. The Docker engine is supported, but inside the containers will be running one of these distributions. Ref: Linux Supported Platforms - [ [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 [recovery model for model database]( - Hi All, Is it good to leave "model" database recovery model as "FULL:" or change it to simple? is it just to ensure the newly created user databases to have FULL recovery model or is there any other good reason ? I see log backup pending for model database that's why asking this question.  […] SQL Server 2016 - Administration [List Procedure That Creates A Table]( - I've been trying to develop a process that will take the input of a table name and trace that back to a stored procedure that creates, updates, or inserts into it. I've been piecing together queries using the sys.sql_dependencies, sys.sql_expression_dependencies, dbo.sysobjects, and dbo.syscomments tables but I'm not able to get the results that I'm looking […] [Local admin cannot view/launch failover cluster manager]( - hi all. I am new to this and hope someone can help me. We have created a failover cluster for our SQL. When I log in using a Domain Admin user (Domain\user), I can view the cluster manager. But when I log in using a local admin (local administrator group), I cannot/unable to view the […] SQL Server 2016 - Development and T-SQL [SQL Query requirements]( - Hi All  create table #temptable (idValue int) insert into #temptable values(1) insert into #temptable values(2) insert into #temptable values(3) insert into #temptable values(4) insert into #temptable values(5) insert into #temptable values(6) insert into #temptable values(7) insert into #temptable values(8) insert into #temptable values(9) insert into #temptable values(10) In this above Query I need two […] [what parts of an ssas tabular cube should i version in tfs/dev ops]( - Hi, i want to start versioning the critical portions of my ssas tabular cube in tfs. What should i archive the bim file? SQL 2012 - General [SQL Server 2012 - not accepting new connections on occasion ...]( - SQL Server 2012 running on Windows Server 2012 R2. Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86) This occurs occasionally, maybe once every 2 weeks or so, the DB server does not accept new connections. Existing connections are OK, but it will not accept new ones. It requires a restart of the SQL […] [Database mail quit working]( - About a week ago, database mail stopped working. The error message from the log is "Cannot send mails to mail server (Failure sending mail)." the rather generic error message. This is happening both on test emails as well as other production emails I restarted the server, tried temporarily disabling the firewall, recreated the db mail […] SQL Server 2019 - Administration [Size of DB Log File]( - hi I was looking at the size of my db. The log looks really big. It is supposed to be that big? here is the query i used to get this information: SELECT mdf.database_id, mdf.name, mdf.physical_name as data_file, ldf.physical_name as log_file, db_size_MB = CAST((mdf.size * 8.0)/1024 AS DECIMAL(8,2)), log_size_MB = CAST((ldf.size * 8.0 / 1024) […] [SQL Server 2012 - not accepting new connections on occasion ...]( - SQL Server 2012 running on Windows Server 2012 R2. Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86) This occurs occasionally, maybe once every 2 weeks or so, the DB server does not accept new connections. Existing connections are OK, but it will not accept new ones. It requires a restart of the SQL […] [Error delete old audit File]( - Hello , I recently set up a SQL database audit to record a few sessions. The audit configuration is well done with retention of 2 files Everything works correctly except that in the error log I have this message which indicates that SQL server can no longer delete the old audit file because it seems […] SQL Server 2019 - Development [Need help with Pivot query or other mechanism to report below data]( - Hi, I've got below dataset (this is sample dataset) I would like to show dataset following way[…]  srv01 srv02 srv03 srv04 srv05 2024-01-22 10:46:00.000 10 20 30 40 50 2024-01-22 10:47:00.000 10 20 30 40 50 Integration Services [Could not find file]( - Please assist. I don't know if the actual file does not exist( it does not exist in mentioned folder) or if the file path in the variables are the problem. Am i jumping the gun here? [Excel Source - Master Data Reference [14]] Error: System.IO.FileNotFoundException: Could not find file '\\ZADURFS01\Departments\Finance\Business Intelligence, Reporting and Analytics (BIRA)\Source […] Suggestions [What is Data Cleansing and what is the importance of Data cleansing for B2B]( - Hello Recently when I was talking to my friends I came to know about data cleansing, they told me that data cleansing will be helpful for B2B database, but I did not know about data cleansing and it is not useful for B2B business. How important it is for you. Please guide me regarding data […] SQL Server 2022 - Administration [Directory CleanupDir is filling up our drive]( - We recently upgraded to SQL Server Analysis Services 2022 and noticed the CleanupDir has almost 3 million files. The location is H:\MSSQL\MSAS15.SSRSPRO\OLAP\Data\CleanupDir. We have tried to manually delete the files, but no progress. There are files older than 30 days. Two questions. What is this directory used for in the SSAS instance? Is there a […] SQL Server 2022 - Development [SQL to insert row with RefNum to be the next numeric number]( - Hi all, I need some help with SQL. I want to create test data by inserting new rows into an existing table using TSQL. Each row has a RefNum column which is in integer and isn't the primary key. RefNum of the new row should be max. value of RefNum in the table + 1 […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -