How to Find the SQL Server Version (2023-06-23)

SQLServerCentral Newsletter for June 23, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Call for Panelists – WIT Panel at PASS Data Community Summit, 2023]( - [How to Find the SQL Server Version]( - [Pipelining Configuration Information Securely to Flyway]( - [Troubleshoot SQL Server Deadlocks in Stored Procedures]( - [From the SQL Server Central Blogs - Notes from SQLSaturday Jacksonville 2023]( - [From the SQL Server Central Blogs - Create and Verify Microsoft Fabric Capacity]( - [From the SQL Server Central Blogs - ChatGpt Experiments–Getting Documentation]( - [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Question of the Day - [Central Management Server Credentials]( The Voice of the DBA  The Reliable DBA This editorial was originally published on Mar 13, 2018. It is being republished as Steve is on vacation. Many of us would consider ourselves to be reliable at work. Our employers count on us, co-workers may assume we're handling certain tasks, and it's human nature to think that we are meeting our obligations and responsibilities. Maybe not 100% of the time, but certainly I know my goal is to complete tasks I've committed to, on time, and to avoid dropping any balls that I'm juggling. I think I am mostly successful here, but certainly am late or forgetful about things at times. However, as a group, department, or even a set of services, does your organization think highly of the databases? Are your systems meeting their SLAs for performance and availability? If not, does your group respond in a timely manner? We sometimes think that we are, but without feedback and communication can we be sure? This certainly could be taken the other way, with other groups constantly complaining about your performance, even while you are meeting your commitments. I ran across [a talk from Uber on reliability](. It's more of a high level architecture talk about distributed systems and being able to detect and respond to issues. Certainly Uber works at a rate and scale that few of us will reach in our organizations. Add to the highly public nature and real time demands, and reliability is extremely important for their business. Mistakes can have dramatic hard dollar effects instantly, and there is a lot of pressure on their staff. For most of us, our databases do continue to become more important, and even when we are meeting our SLA commitments, are we providing reliable service from the entire staff? Is information being shared, with root cause analysis or retrospectives that help knowledge transfer among all of the individuals that might respond to an issue? Are you dependent on a superstar that must be called in to solve issues with the database, network, or storage? I've been the main person on call, the expert for a system that received calls on weekends, vacation, and other downtime. It's no fun to be in this position, and it certainly distorts work life balance, not to mention upsetting the rest of my family. My goal is to be there if necessary, but train others so that they can provide a consistent, similar level of service to customers and clients if need be. Becoming too dependent on any one person isn't much different than becoming too dependent on one server or disk drive or network cable. At some point you'll have a failure and that item will no longer be available. If you don't have a spare, you'll have regrets. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Call for Panelists – WIT Panel at PASS Data Community Summit, 2023]( Steve Jones - SSC Editor from SQLServerCentral Take a moment and submit to be on the WIT panel at the PASS Data Community Summit in Seattle this November. We would like to see more women taking part in this. [SQLServerCentral Article]( [How to Find the SQL Server Version]( Nisarg Upadhyay from SQLServerCentral This article shows a number of ways in which you can find out the version of your instance. [External Article]( [Pipelining Configuration Information Securely to Flyway]( Additional Articles from Redgate This article demonstrates two techniques for allowing Flyway to read extra configuration information from a secure location, possibly encrypted. The first technique pipes the contents of the config file to flyway via STDIN, and the second uses PowerShell splatting. This makes it much simpler to use Flyway to manage multiple development copies of a database using role-base security. [External Article]( [Troubleshoot SQL Server Deadlocks in Stored Procedures]( Additional Articles from MSSQLTips.com Deadlocks can occur in any database system, and SQL Server is no exception. In this article, we look at the steps I used to detect and resolve deadlocks in stored procedures. [Blog Post]( From the SQL Server Central Blogs - [Notes from SQLSaturday Jacksonville 2023]( Andy Warren from SQLAndy Year 15 for Jacksonville! SQLSaturday Jax was held on May 6 this year, back at the usual location on the campus of the University of North Florida. At the... [Blog Post]( From the SQL Server Central Blogs - [Create and Verify Microsoft Fabric Capacity]( dharmendra.keshari from SQL Geek From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal. Now, we can provision Microsoft fabric easily using Microsoft PowerBI premium per capacity or using... [Blog Post]( From the SQL Server Central Blogs - [ChatGpt Experiments–Getting Documentation]( Steve Jones - SSC Editor from The Voice of the DBA I get asked questions by salespeople all the time. Usually this is because a customer is struggling and I try to educate the salesperson as well as give them... [Expert Performance Indexing in Azure SQL and SQL Server 2022]( [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Site Owners from SQLServerCentral Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]   Question of the Day Today's question (by Steve Jones - SSC Editor):  Central Management Server Credentials How can I store credentials for each instance in a Central Management Server (CMS)? 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) Managed Instance Managed Log Backups I have an Azure SQL Managed Instance in May 2023 with one database. Microsoft is managing my log backups as part of this PaaS service. How often are they backing up logs? Answer: every 10 minutes Explanation: Managed Instance performs one log backups every 10 minutes. Ref: Automated backups in Azure SQL Managed Instance - [ [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 [Listener IP]( - I have a listener which is listening to IP which is online. However, I have one of the IP which is showing failed status instead of offline. Is that something to be concern? [delete as head blocker]( - Hi All, Need some help in finding out of what is the problem in the query and how can we make the query faster. On one of the production environment, a DELETE statement was running over 50 mins and blocked more than 100 sessions. I wasn't able to get the actual plan. However, including estimated […] [Availability group]( - Looking for the options whenever the primary replica is refreshed then synching the secondary replica would need to be done and which would take long time if there are more that 1 secondary replica's. Checking to see is there a faster way to sync the secondary replica after the primary replica refresh? Thanks in Advance! SQL Server 2016 - Development and T-SQL [SQLCLR functions]( - Hi all  We've written some SQLCLR functions in C# to try and get rid of the UDF's we'd written (that were a lot slower). Is there any way to add in some sort of help text to explain what the functions does, what parameters are required, what format the parameters should be in, etc? […] [Converting rows into columns]( - I have a table that contains three columns with ID, dates and value. I want to convert the contents into rows so that the date column will become a row and the FldVal will become the contents. Date and FldVal could contain different values. I think I can use Pivot, but not sure what to […] SQL Server 2019 - Administration [Insert Token Replication in AG]( - Hello , I work in a context where my transactional replication is configured in AG the replication monitor is configured in a single node sometimes when I try to trace a Token for monitoring replication I get a message that tells me my database is in read ony Does anyone of you have an […] [Restore script is not working]( - Below script is not working .Not sure what is wrong in it. Any suggessions pls.  --get the last backup file name and path Declare @FileName varChar(255) Declare @cmdText varChar(255) Declare @BKFolder varchar(255) Declare @DT datetime set @FileName = null set @cmdText = null set @BKFolder = '\\xxxxx\xxxxx\' set @DT = getdate() create table #FileList […] [Best Practice Analyzer for SQL Server 2019]( - Hello All I am looing to run the BPA for SQL Server 2019 version , but don't see BPA available for SQL 2019. Please help me if any other same as BPA available ( replacing BPA ) to use for SQL Server 2019. Thanks, [XE Module start histogram not show all]( - Hi, module_start doesn't find some events in non-filtered session, and finds them when filtering for database name. I exec manually from ssms procedure and it count in filtered XE but wasn't in non filtered XE. tried also NO_EVENT_LOSS option but still same. I found the same problem in other SQL instances. This can be problem […] SQL Azure - Administration [Finding Last Time the Users Connected to a Particular Azure PaaS Database.]( - Can we Find the Last Time the Users Connected to a Particular Azure PaaS Database. If yes then please could the logic for that be shared as well. Reporting Services [Redirecting HTTP to a new server being blocked by SSRS]( - We have migrated SSRS between servers as part of a SQL version upgrade. The original server has IIS on it (for MDS) and I want to use HTTP Redirection to send the traffic from the old server to the new one. If I go to "" it redirects without issue but if I go to […] [SSRS REPORT]( - Hi I have report in Crystal looks like below Is possible to create similar to this in SSRS? here is the one I already start working on Analysis Services [Excel PivotTable Fields order different after upgrade to SQL 2022 SSAS tabular]( - Hello, We have upgraded one of our SSAS Tabular environments to SQL 2022, and are noticing changes in the way the measures and dimensions are shown in the “PivotTable Fields” section in Excel when connecting to models on this server. The tabular model we are using has compatibility level 1500, and when we deploy this […] SQL Server 2022 - Administration [Devil's Advocate]( - We're planning to start upgrading all of our 200+ SQL Server 2016 instances to SQL Server 2022 over the coming year or two. We have a Volume Licence Agreement and all of our instances run either Enterprise or Developer edition. We have one Azure instance for a chatbot. The rest is on-premises. I'm combing through […] SQL Server 2022 - Development [Why do my queries lose connection?]( - I've used SSMS for many years (currently v18.12.1) and only in the last few months have I seen this problem. I tend to open SSMS at the start of the working week and close it down at the end (5 days later). During that time I might open a dozen or more query windows and […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -