Featured Contents
 Question of the Day
 The Voice of the DBA

 Merry Christmas 2019 Merry Christmas and Happy Holidays, everyone. A day off, hopefully for most of you, and an enjoyable time with family and friends. I'm just hanging out with family today, relaxing and playing games. See you tomorrow. Steve Jones - SSC Editor Join the debate, and respond to today's editorial on the forums

 Featured Contents
 Steve Jones - SSC Editor from SQLServerCentral.com An index to the build list articles for various versions of SQL Server.
 Additional Articles from MSSQLTips.com In this tip we will implement a polling mechanism to verify if the Power BI dataset has refreshed successfully.
 Press Release from SQLServerCentral.com This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.

 Question of the Day
 Today's question (by Steve Jones - SSC Editor): Merry Christmas 2019 I want to calculate the total number of gifts from the song, The Twelve Days of Christmas. I have this code: ```WITH myTally(n) AS (SELECT n = ROW_NUMBER() OVER (ORDER BY (SELECT null)) FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) a(n) CROSS JOIN (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) b(n) ) SELECT SUM(x) FROM myTally WHERE n <= 12``` With which piece of code should I replace SUM(x)? 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)
 Knocking off early It's the day before Christmas, and everyone in the Redgate office in the UK is knocking off at noon. I want to know when I can stop working in the US, since everyone else in the UK will go home. I have this code set up: `DECLARE @t DATETIMEOFFSET = '2019-12-24 12:00+00:00'` What should I add to my SELECT below to determine the time in Colorado (7 hours behind) that I can safely stop working? `SELECT` Answer: @t AT TIME ZONE 'US Mountain Standard Time' Explanation: The AT TIME ZONE function allows me to convert a time from another time zone to my own. In this case, I don't even have to go to work. They'll knock off at 5:00am my time. Merry Christmas and Happy Holidays. I'll see you Thursday. Ref: AT TIME ZONE - https://docs.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-ver15 Discuss this question and answer on the forums

 Database Pros Who Need Your Help