Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Connect with someone from a different generation

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.

Finding Thanks

Tomorrow is Thanksgiving in the US. While my family often gives thanks to each other over a big meal in the afternoon, I know plenty of people that make it a point to post about something that they are grateful for during each day of the month.

This year we won't be having family over. A couple local members of our extended family are worried about COVID, for good reason. Others are out of town and not looking to travel. With a situation worsening in Colorado and a request from the state to avoid mixing households, I'll have the smallest dinner we've had in decades.

This has been a challenging year for many of us, and certainly me. Despite the things that have been bothering me, I have made it a point with my coping tips to look for the good things I can find.

Today I want to acknowledge some career things that I'm thankful for. Apart from my SQLServerCentral founding partners, I am really grateful for the closeness that I have with people at Redgate. My trips over there have netted many friends, thoughtful conversations, memorable events, and tight bonds. As I think back across the last decade, I realize just how many of them have influenced me in life across that time.

I miss being able to visit Cambridge, but I am thankful for the times I have gone and the memories I can call on until I can go back.

I hope you find some things that you are thankful for in your career, your job, your coworkers, or somewhere else. Take a moment and enjoy some of them today. If you don't have enough, then start working to find a place where you can build some.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents

Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD

Sebastian Meine from SQLServerCentral.com

The first article in this Stairway Series makes the case for test-driven development.

SQL Snippets Galore, Added to SQL Prompt

Additional Articles from Redgate

Imagine having at your fingertips all the metadata queries you need to explore your SQL Server databases and then, a few clicks later, all your diagnostic queries to troubleshoot their performance. Phil Factor demonstrates how it can be done, by storing each set of snippets in a standard JSON collection and using PowerShell to convert them to SQL Prompt snippet files.

Exploring errors to reveal unauthorized information

Additional Articles from SimpleTalk

Database administrators can never stop thinking about security. In this article, Fabiano Amorim shows how data can be revealed through error messages when views are used to secure rows.

Free eBook: Defensive Database Programming

Press Release from Redgate

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.

From the SQL Server Central Blogs - The Learning Curve for DevOps

Grant Fritchey from The Scary DBA

If you’re attempting to implement automation in and around your deployments, you’re going to find there is quite a steep learning curve for DevOps and DevOps-style implementations. Since adopting...

From the SQL Server Central Blogs - PASS Summit 2020 – My experience

Diligentdba 46159 from Mala's Data Blog

This was the first year in 16 years for me that there has been a fall season without the PASS Summit to go to. Every year, during the fall,...

 

 Question of the Day

Today's question (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

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)

The Compression Type

I have compressed indexes in my SQL Server 2019 database. Where can I find out what type of compression is in use for a particular index?

Answer: sys.partitions

Explanation: The sys.partitions DMV has a data_compression column that lets you know the type of compression: 0 = NONE 1 = ROW 2 = PAGE 3 = COLUMNSTORE : Applies to: SQL Server 2012 (11.x) and later 4 = COLUMNSTORE_ARCHIVE : Applies to: SQL Server 2014 (12.x) and later You  can join this with sys.indexes to get the index name. Ref:

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 FeedTwitter

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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -