SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Kicking off SQL in the City 2018

I'm off today. Not taking a break, though perhaps it's a touch of a break. I'm actually in an airplane, heading to the UK for the first 2018 SQL in the City. We'll be broadcasting this Wednesday, and you can still register and watch. Let your boss know that you can get some cheap training (it's free), refresh yourself away from work, and you'll appreciate the perk as a part of your job. Maybe you'll even get to watch from the comfort of home.

Grant and Kathi are already in the UK enjoying SQL Bits, but this year I've been trying to do less travel and coaching volleyball more. My team of 14 year olds had a tournament yesterday, so I was blowing whistles and giving (loud) advice in a high school gym. Today I've got a laptop on a plane and am making my way a third of the way around the world. I may get to watch a movie, but there will certainly be a little demo practice as well.

The theme for this SQL in the City broadcast is Data Privacy and Protection. GDPR will start being enforced this spring, and many people around the world with be affected. Those outside the EU might not be sure of the ramifications of the regulation, but I wouldn't be surprised if similar legislation gets passed in other countries. In any case, the idea of ensuring you can control and protect data, with an eye on designing privacy for users into the system, is a good idea.

You can read the GDPR text, but that's what many of us have done and tried to interpret it for you. We have a great piece at SQLServerCentral and our product teams have been working hard to ensure that our products will help you improve your compliance. Lots of other vendors are doing the same thing, either working to change their policies or enhance products. Microsoft has certainly spent a lot of effort getting ready, and I'm sure they're not along in their efforts.

We all want better security for our data. Many of us empathize with the customers and clients about whom we collect data and often wish our systems provided better security, controls, and options. Sometimes our management doesn't agree, but certainly they feel the impact if we suffer a data breach. This Wednesday we'll be talking about Redgate products specifically, but also including general knowledge and ideas that you might use within your organization.

Register for the event and watch along on Wednesday. Ask questions and see how you can improve your data privacy. Most of our applications could use a little work on security, and we hope to help educate you on what you can do and how Redgate might be able to help.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 3.8MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL Prompt

Write, format, analyze, and refactor SQL fast 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 code analysis you get suggestions to improve your SQL as you type. 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


Transaction Replication: Multiple Publishers, Single Subscriber

Suresh Kumar from SQLServerCentral.com

How to configure multiple publishers and single subscriber replication? More »


So what is a Data Privacy Impact Assessment and why should organizations care?

If you’ve read anything about the upcoming General Data Protection Regulation (GDPR), you’ll probably have seen the phrase Data Privacy Impact Assessment (DPIA) used. This article explains exactly what it is, and outlines the four areas its expected to address. More »


How to Suck at Database Administration

Additional Articles from Brent Ozar Unlimited Blog

Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA. More »


From the SQLServerCentral Blogs - Execute Multiple Files Using SQLCMD/SQLClient – Which Is Faster?

Richie Lee from SQLServerCentral Blogs

Hello! I’ve been working on a PowerShell module that will migrate the schema of an Azure Data Warehouse from one database... More »


From the SQLServerCentral Blogs - Synonyms, how and why.

Kenneth Fisher from SQLServerCentral Blogs

Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even... More »

Question of the Day

Today's Question (by Evgeny Garaev):

How would you optimize a query against JSON data query on a SQL Server 2016 instance?

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 1 point in this category: JSON.

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


Exam Ref 70-761 Querying Data with Transact-SQL

Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Evgeny Garaev):

What would you get by executing this query:

with cnumbers as
select 1 as i
select i+1
from cnumbers
where i < 10
select i
from cnumbers;

Answer: The error - Recursive common table expression 'cnumbers' does not contain a top-level UNION ALL operator.


All anchor-member query definitions must be positioned before the first recursive member definition, and a UNION ALL operator must be used to join the last anchor member with the first recursive member.

Ref: Recursive CTEs - click here

» Discuss this question and answer on the forums

Featured Script

Logins for Windows Groups

Patrick Slesicki from SQLServerCentral.com

Simply connect to the instance and execute.

Output will list members of logins that are Windows Groups.

More »

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

deadlocks and Stats - Hi I was getting alerts about deadlocks continuously every min on the server, I updated stats and alerts stopped. Again after ...

SQL Server 2016 : SQL Server 2016 - Administration

SQL 2016 Always Encrypted feature - Hi All, Can we setup the always encrypted feature using tsql? What I mean is, if i want to enable...

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

Delete 5 lac records from table - I have a table where there is a column called nationality having possible values "US" and "Non -US'. I need to...

SQL Server 2014 : Administration - SQL Server 2014

Agent Jobs fail in time frame - Hello, My SQL Server Agent does not process any of my jobs between 12am and 2am.  The job runs for about...

Restore database from 2014 to 2008. - How can I restore the DB which is on SQL Server 2014 to the server which is running on 2008...

Can we execute sp_updatestats in heavy transaction time - Our database becomes very slow in heavy transaction day after being transaction about 7000 with in 2 hours even i...

SQL Server 2014 : Development - SQL Server 2014

upsert in ssis for large tables - I have 40 tables having different structure in one of DB on one server that is being updated by data...

Question about a composite key and autoincrement - Hello all, I was recently assigned to convert an Access database to Sql Server.  I have to try and keep the...

SQL Server 2012 : SQL 2012 - General

SQL Server (MSSQLSERVER) keeps Stopping - Hello, Trying to connect to sql server database engine, via ssms, but won't connect. I get the standard error: A network-related or...

SQL Server 2005 : Administering

Error: Could not apply log backup file - hi i have a sql 2005 db with log shipping enabled. the secondary server is suddenly giving me the below errors, anyone...

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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com