SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,894,938 DBAs, developers and SQL Server users

Headlines today   December 18, 2017

Improve Productivity with Collaboration Tools

In order for your team to be productive, communication and collaboration are essential. Collaboration tools allow you to get the most out of your team members.  Read more...
By Peter Davidson 2017/12/18 | Source: SQLServerCentral.com | Category: improve productivity
Rating: (not yet rated) |  Discuss |   Briefcase | 129 reads

Redgate data governance survey reveals database DevOps is the key to GDPR compliance

A major new data governance survey from Redgate demonstrates there are important GDPR compliance issues that need to be addressed – and that a DevOps approach to database development can provide the answers.  Read more...
By 2017/12/18 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 463 reads

Summarizing Data Using the GROUPING SETS Operator

Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in the GROUP BY clause is not that difficult, but what do you do if you need to include different combinations of group by expressions in the same result set? Alfonso demonstrates how to use the GROUPING SETS operator to accomplish this task.  Read more...
By Additional Articles 2017/12/18 | Source: SimpleTalk | Category: grouping sets
Rating: (not yet rated)  Rate this |   Briefcase | 636 reads
Previous headlines

Holidays and Calendar Generation

Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.  Read more...
By Paul Hunter 2017/12/15 (first published: 2016/02/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,400 reads

How to Customize Schema Comparisons using Auto Map in SQL Compare

SQL Compare includes many options to make comparing objects easier on the developer. Auto mapping is one of these, and if often saves a little time and frustration. However, there are times that you many need to customize your mapping, and this gives you a technique for doing so.  Read more...
By 2017/12/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,600 reads

How to use Azure SQL Database features and settings

Vitor Montalvao explains how to work with the basic configuration settings for a SQL Azure database from the Microsoft Azure portal itself.  Read more...
By Additional Articles 2017/12/15 | Source: MSSQLTips.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,833 reads

Changing the Path for the Master Database

We as DBAs, changing or migrating databases to a new path is important part of admin’s world. This article helps you with the steps involved to move the Critical 'master' database.   Read more...
By Sadan Kumar Budde 2017/12/14 | Source: SQLServerCentral.com | Category: master database
Rating: |  Discuss |   Briefcase | 509 reads

So what is GDPR, and why should your customers care?

GDPR is introducing new rights at the same time that the threats to data are the biggest they’ve ever been. The more leaks and breaches there are, the more your customers will learn that GDPR grants them six specific rights, and the louder they’ll ask how you’re meeting those obligations.  Read more...
By 2017/12/14 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 3,009 reads

Questions About the GDPR That You Were Too Shy to Ask

The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask.  Read more...
By Additional Articles 2017/12/14 | Source: SimpleTalk | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,050 reads

Stairway to SQL Server Agent - Level 3: Agent Alerts and Operators

How to be notified when a job succeeds or fails, or be notified when a SQL Server performance condition is met.  Read more...
By Richard Waymire 2017/12/13 (first published: 2011/06/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,429 reads

From the SQLServerCentral Blogs

Restrict the usage of a SQL Server Authenticated Application Id

SQL Server login ids may not be the most secure thing in the world but they are likely to be...  Read more...
By Kenneth Fisher 2017/12/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 378 reads

ARMED - Azure ARM VS Code extension

I have been working with ARM templates for a little while and have found it really annoying to test functions...  Read more...
By Ed Elliott 2017/12/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 358 reads
Question of the Day

Enabling Automatic Tuning

By Steve Jones 2017/12/18 | Category: automatic tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 143 reads

I have created a new SQL Server 2017 database, in which I want to enable automatic tuning with this code:

Before I do that, what... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
42224 503398 SSC Guru  
Jeff Moden
39545 464425 SSC Guru  
Steve Jones - SSC Editor
25715 303116 SSC Guru  
Grant Fritchey
19494 202496 SSC Guru  
Lynn Pettis
17655 204366 SSC Guru  
Latest forum posts