Happy New Year (2021-01-01)

 SQLServerCentral Newsletter for January 1, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Testing COALESCE with tSQLt]( - [SQL Server Management Studio Database Diagram Support Objects Cannot be Installed]( - [From the SQL Server Central Blogs - DirectQuery for Power BI datasets and Azure Analysis Services (preview)]( - [From the SQL Server Central Blogs - Basic Cursors in T-SQL–#SQLNewBlogger]( Question of the Day - [Starting out 2021]( The Voice of the DBA Daily Coping Tip Choose to give or receive the gift of kindness 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.  Happy New Year 2021! Happy New Year to everyone around the world!!! I think this is the most I've looked forward to a New Year ever. I was worried and nervous about 2000, and there were some times in my younger years when I was excited about celebrating, but this year I'm just glad that 2020 is over. It was a year unlike any other, more change and disruption than I would have believed if I'd read the story in a novel during the 80s. While [2001](_A_Space_Odyssey_(film)) didn't come true, last year was more disruptive than if we'd sent a spaceship to Jupiter. Enjoy the start of a new year and join me in hoping it will be better than the last one. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Testing COALESCE with tSQLt]( Steve Jones - SSC Editor from SQLServerCentral.com Learn how you can use tSQLt to test your COALESCE queries. [SQL Server Management Studio Database Diagram Support Objects Cannot be Installed]( Additional Articles from MSSQLTips.com In this article we look at how to resolve the error database diagram support objects cannot be installed because the database does not have a valid owner. From the SQL Server Central Blogs - [DirectQuery for Power BI datasets and Azure Analysis Services (preview)]( James Serra from James Serra's Blog Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it... From the SQL Server Central Blogs - [Basic Cursors in T-SQL–#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Cursors are not efficient, and not recommended for...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Starting out 2021 It's the start of a new year. What is the best query? 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 last bit of 2020 It's been a long, hard year with a pandemic affecting most of the world. As we say goodbye to 2020, what's the last bit of time I can store about the year in SQL Server 2019? Answer: 2020-12-31 23:59:59.9999999 Explanation: A datetime2 datatype can handle up to 2020-12-31 23:59:59.9999999. I think I'll just be happy we got to 2020-12-31. Ref: datetime2 - [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 2016 - Administration [Updating SQL Server 2016]( - We are currently running SQL Server version: Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) Can we upgrade straight to CU15 for CU12? Or do we have to do each version in between? […] [Change name of a particular step in an existing SQL Agent Job]( - What is the easiest way to change name of a particular step in an Agent Job? SSMS does not seem to allow to do that.  [Could not find a login matching... when access granted via AD group]( - Hello experts, A client just reported the following puzzling error. There is a user ABC\user1 that was added to the AD group ABC\foo_db_readers. The group ABC\foo_db_readers was added to the user-defined database role db_foo_datareader, which has read access to foo_db. The client's goal with this setup is to avoid having to create the login ABC\user1 […] [always on sql server]( - Hi Guys, I have a question to configure always on sql server same subnet vs multi subnet. It is three node cluster, two in same DC HA (node 1, node 2) and other in DR (Node 3). It needs a multi subnet, I am thinking to configure node1 & 2 as well into different subnet, […] SQL Server 2016 - Development and T-SQL [Converting MONEY]( - Hi, running this declare @code VARCHAR( 50 ) = '748.019876'; select [code1] = @code, [code2] = CONVERT( MONEY, @code ), [code3] = CONVERT( VARCHAR( 10 ), CONVERT( MONEY, @code ) ) returns --code1          code2       code3 --748.019876    748.0199  […] Administration - SQL Server 2014 [Full Text Search and Enablement at DB Level - Day One.]( - I have 2 DBs - they are 'vendor' DBs - part of an application. They both originated from a single source DB - so were identical to start with. One DB has been upgraded and has new functionality from the vendor that utilises full text search - the other hasn't. The SQL instance has Full […] Development - SQL Server 2014 [While loop]( - CREATE Table TABLEA(N varchar(50),Q int,R int,Dt1 datetime,Dt2 datetime) DECLARE @I int = 1 DECLARE @R int = 2 DECLARE @Q int = 3 DECLARE @Q1 int SET @Q1 =@Q DECLARE @N varchar(100) SET @N = 'NameA' WHILE (@I <= @R+1) BEGIN WHILE (@I <= @Q) BEGIN SELECT @N as Name,@I,@R,@Q SET @Q = @Q - […] SQL 2012 - General [How to display arrange features where order by display order and column order by]( - How to display arrange features where order by display order and column order by are equal ? I have two features Package and Workflow have same display order nd same columnorder by so How to make order by same values ORDER BY MIN(DisplayOrder),ColumnOrderBy I need to display Workflow first so How to do that  […] [How to get parts that not have same features count on table settings by code typ]( - How to get parts that not have same features count on table settings by codetypeid and PLID ? I work on sql server 2012 . if face issue I can't get parts that not have all features on table settings so I will count distinct features from table settings and compare it with count features […] [How to copy Excel file from Office 365 online to local drive in SSIS?]( - Can anybody help me with problem how to copy Excel file from Office 365 SharePoint online to local drive in SSIS? I never worked with SharePoint before, what is the best practices? Thanks, Aleks SQL Server 2019 - Administration [recover table data which is accidently updated all the row in employee table]( - Hi, I have mistakenly updated all values in employee table how to recover that SQL Server 2019 - Development [Error: Msg 105070, The ODBC data source name was no specified or the driver is m]( - Hello everybody, I am trying to use external table with PolyBase for import data from Oracle to Sql Server 2019. I have an issue about creating an external table. I created external data source OracleExternalData. CREATE EXTERNAL DATA SOURCE OracleExternalData WITH ( LOCATION = 'oracle://145.145.145.145:1521', CONNECTION_OPTION = 'DSN=CData Oracle Sys' CREDENTIAL = OracleProxyAccount ) ; […] Strategies and Ideas [Filtering Customer Specific Data]( - Hi all! Your help would be appreciated. We have a data warehouse that is a single tenant design with multiple reports and widgets that query the data The underlying structure of the DW is modelling invoice data - so essentially header records and line items The widgets and reports show pretty much what you would […] Anything that is NOT about SQL! [Question about using Python in conjunction to SQL Server]( - In a recent months I saw a lot of job ads that require Python in addition to SQL Server. I am SQL Server DBA/developer, and recently learned some Python from videos. I can do some elementary Python coding in PyCharm, but how it is related to SQL Server, or any database coding? If anybody is […] Article Discussions by Author [Download SQL Patch Info]( - Comments posted to this topic are about the item Download SQL Patch Info   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -