Happy Thanksgiving (2020-11-26)

 SQLServerCentral Newsletter for November 26, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Exporting Stored Procedure Results to a Table]( - [Monitoring SQL Server Instance Version and Builds with PowerShell]( - [Win a three-month subscription to Pluralsight]( - [From the SQL Server Central Blogs - Filtering Results in Go]( - [From the SQL Server Central Blogs - Always Encrypted Data Displayed in SSRS with a gMSA]( Question of the Day - [Thanksgiving Visualizations]( The Voice of the DBA  Daily Coping Tip Tell someone how you’re grateful for them in your life 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. Thanksgiving 2020 Today is Thanksgiving in the US. I wrote a bit yesterday about my thanks at work, but today I want to just say that I'm grateful my family is healthy and we can mostly be together. My oldest is in Spain, and we're all thinking of him and missing him, but we're also happy he's on an adventure in life for the next year. Please remember those that are important to you today, whether it's a holiday for you or not. Life is short. Appreciate the time and people you have while you can. Happy Thanksgiving. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Exporting Stored Procedure Results to a Table]( pamelamooney1966 from SQLServerCentral A quick trick from Pamela Mooney for getting results from a proc into a table. [Monitoring SQL Server Instance Version and Builds with PowerShell]( Additional Articles from MSSQLTips.com In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment. [Win a three-month subscription to Pluralsight]( Additional Articles from Redgate Redgate is giving you the chance to win a three-month subscription to Pluralsight (the technical skills training platform) in this month’s forum competition. To enter, simply share ‘how SQL Compare has helped you’. From the SQL Server Central Blogs - [Filtering Results in Go]( Sheldon Hull from Sheldon Hull Where Filtering I explored a bit on filtering objects with Go for the AWS SDK v1. Coming from PowerShell, I’m used to a lot of one-liners that do a lot of... From the SQL Server Central Blogs - [Always Encrypted Data Displayed in SSRS with a gMSA]( Ryan Adams from Ryan Adams Let’s take a look at how to display Always Encrypted Data in SSRS with a gMSA (Group Managed Service Account). We are mixing some technologies […] The post Always Encrypted...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Thanksgiving Visualizations What type of chart is best used for Thanksgiving dinner visualizations? 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) Python Static Methods I have created a class in python 3: class Conference eventstart = '20201109' I want to define a static method inside this class. Which of these code items will define the static method? # One def static GetSession(): # add code here # Two @staticmethod def GetSession(): # add code here # Three def GetSession() as static: # add code here # Four # python doesn't support static methods Answer: Two Explanation: The @staticmethod decorator is used. Ref: staticmethod - [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 [user mapping error]( - Hi All, We have recently migrated SQL 2012 EE to SQL 2017. We are on Microsoft SQL Server 2017 (RTM-CU22) 14.0.3356.20 (X64) EE. Using SSMS, I have logged into SQL 2017 instance as a sysadmin role member and when I go to a specific login -> right click --> Properties -> User Mapping , I […] SQL Server 2017 - Development [Using hierarchyID]( - Hell community, This is my first to try to use hierarchyID, but on my example above my column PATH return always NULL. What i am doing wrong !?? CREATE TABLE #tbl( ID int, ParentId INT, Name VARCHAR(30), [path] hierarchyid null ); --DROP TABLE #tbl INSERT INTO #tbl VALUES (1, Null, 'Corporate_HQ',null), (2, 1, 'South_Region',null), (3, […] SQL Server 2016 - Administration [Simple Recovery Model - Active VLFs cannot be truncated]( - Hi everyone, I am facing a strange situation. I've got 99% of VLFs active and ckeckpoint is not working. No open transactions/long-running transactions. Is there any chance log is holding active VLFs by mistake? Is there any rare situation sql server considers VLFs are active? Some details: SELECT [name] AS 'Database Name', COUNT(li.database_id) AS 'VLF […] [Backup time not reducing even after DB size went down 300 GB]( - Backup time is almost same and did not reduce after the database size went down by 300 GB. What could be the reason?  Thanks in advance. [Mirroring Automatic Failover?..]( - Hello, We are receiving the below Error message in Mirroring and principal server is failovering automatically to Mirror Server. Database mirroring connection error 4 'The connection was closed by the remote end, or an error occurred while receiving data: '64(The specified network name is no longer available.)'' Database mirroring connection error 4 '10054(An existing connection […] [Replaced deprecated types (text, ntext) with Varchar(max) and NVarchar(max) !]( - in 500 tables, on thousands of columns in all databases on entire server, I have replaced deprecated datatypes (text, ntext) with Varchar(max) and NVarchar(max). To detect them and to generate modification scripts, PLEASE HELP YOURSELVES to my and Victor's attached new SP named asp_Get_DeprecatedDatatypes_Columns_withgeneratedmodifyDDL /*Usage examples-are-in-comments-header, you can compile and run it in any database […] Development - SQL Server 2014 [Query performance with ROW_NUMBER function]( - Hello All, Could any of you please let me know why the row_number paging function is having a performance issue when using the "WHERE results.ROWNUMBER BETWEEN 1 AND 50" clause (takes more than 2 mins), but runs in 5 secs when i comment the where clause which will return the entire result set. I see […] SQL Server 2019 - Administration [multisubnet configuration]( - Good morning all , I am in an alwayson multisubnet configuration, the listen and configured with 3 IP addresses in the configuration of my application I am unable to set the value multisubnet failover = true it is an installation script where there is only icon to put the name of the server and the […] [client server encryption]( - Good morning all , how can I check if SSL encryption is enabled on my SQL server, I only have SSMS access on server I have no RDP access on the server I cannot access the service configuration manager to see if this option enabled my problem comes during the installation phase of the application […] [Sql server does not go above 50% CPU]( - Hi everyone, I have this issue: in a single complex processing performed in a virtual machine with 4 virtual processors and 4 sockets, the CPU never manages to exceed 50% thus doubling the previous runtime when it was performed on a physical server. Is it possible that there is a limit imposed by SQL server […] SQL Server 2019 - Development [How to rank the records]( - I am trying to figure how to create rank column in my query with the below logic. I need to group by item category and then rank them by ordbo. Any help appreciated  [IDENTITY only allowed on one table at a time?]( - I am trying to insert some sample data into my database. I ran the INSERT INTO Statements and got the following messages: /* ***************************** * Data Entry Statements for * * Project ACES * * Version 1.1.0 * * Written By: Russell Wright* * Updated by: Russell Wright* * Created: 11/20/2020 * * Updated: 11/20/2020 […] Reporting Services [tablix hierarchy]( - Hello, I would like to have the below requirement in the tablix to call each sub-report for every Code but I am unable to do this. Any suggestions please? Thank you Requirement : Code --> Tablix is grouped on this field Title_1 --> Title as the header for the following subreport subreport_1 --> Detailed row […] [Unable to delete older report]( - Hallo All, Couldn't able to remove the older report folder , tried possible ways though giving an error stating with below message. Please help me out here. Thank You. An error occurred within the report server database. this may be due to a connection failure, timeout or low dis condition within the database.   Analysis Services [Table.NestedJoin in Azure Analysis Services]( - We have an M/Power Query query in Power BI that uses Table.NestedJoin. However, we get errors when we try to use that same command in Azure Analysis Services. Does this command even work in AAS? I don't see any examples of it working properly. Is there a workaround?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -