SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

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 - https://docs.python.org/3/library/functions.html#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?

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.