SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

The End of Summer

Today is Labor Day in the US, and a federal holiday. Not much of one for me as I'm flying to the UK today for a week of meetings and the Redgate Community Hub livestream on Wednesday. Register, tune in and watch if you can. I don't feel too bad about working today as I've had a few light days in the last few weeks.

When I was younger, Labor day was the end of summer. School typically started the next day, so this was our last day to go to the beach and surf, play volleyball, or enjoy ourselves with few responsibilities. It was the last day off for quite some time, usually until late October or even Thanksgiving in November. We appreciated this holidays as only schoolchildren can.

These days I view the world differently. Labor Day often means the start of conference season, with deadlines approaching and travel ramping up. So many events seem to occur in the Sept/Oct/Nov timeframe that it's a busy part of my year. This year is no different with travel this week and 4 more events before December. Hopefully I'll meet more of you at one of those stops.

Most of us are the laborers, working for an organization and receiving a paycheck in response. We don't usually have organized unions in our industry, but we have helped spur economic growth in our countries with our with in technology and this is a good day to remember our contributions and celebrate them in the US.

Happy Labor Day.

Steve Jones from SQLServerCentral.com

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

SQL Prompt

Write, format, and refactor SQL effortlessly with SQL Prompt

Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial

SQL Source Control

How to track every change to your SQL Server database

See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more

Featured Contents


Time Traveling with Temporal Tables on SQL Server 2016

Johan Åhlén from SQLServerCentral.com

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates. More »


Protecting production data in non-production environments

Additional Articles from Redgate

In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment. More »


Statistics in SQL: The Mann–Whitney U test

Additional Articles from SimpleTalk

Phil Factor shows how to use the Mann-Whitney U test in SQL to to find out whether two samples come from the same distribution. More »


From the SQLServerCentral Blogs - SQL Puzzle 3: Knights and Queens

matthew.mcgiffen 73574 from SQLServerCentral Blogs

I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem: SQL Puzzle... More »


From the SQLServerCentral Blogs - Redgate Hub LiveStream

Grant Fritchey from SQLServerCentral Blogs

Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub.... More »

Question of the Day

Today's Question (by Steve Jones):

Today is Labor Day in this US. This holiday was first designated as an official federal holiday in 1894. What is the unofficial name?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 7 points in this category: humor.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What is a Table Valued Constructor?

Answer: A VALUES clause with multiple rows


A TVC is a VALUES caluse that contains a set of rows which act as a table.

Ref: Table Valued Constructor - click here

» 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 : SQL Server 2016 - Administration

SQL Server and SSAS together in the box - I have a server where SSAS and SQL instances are running in the same box. SSAS activity usage seems to...

Filegroup status - Hi, Does anyone know a way to check a filegroups status to see if it has been restored and is online. We...

moving from tx replication to ao/ag possibly without fci.... - hello, we are due to upgrade our production cluster within the next 6 months and have been advised by our hosting...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Zero to Many relationship - One to Many is easy with a Foreign Key. How can we create a Zero to Many relationship in SQL Server?...

Dynamic tsql help - have a form that had 5 rows with 3 dropdowns per row. The first dropdown in each row is list...

SQL Server 2014 : Administration - SQL Server 2014

AG Listener creation failed - Hi Folks, I'm using the following script to create AG listener. But it failed. Error has been attached. Any thoughts on...

SQL Server 2012 : SQL 2012 - General

Need to remove punctuation characters - Hi,  I need to remove any punctuation characters at the end and before new line. Please help.

SQL Server 2008 : T-SQL (SS2K8)

splitting column into two - Hello I am working to split one colume named "name" that includes the LastName/Firstname seprated with "/" i tried to create the...

This email has been sent to {user_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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com