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,842 DBAs, developers and SQL Server users

Headlines today   December 14, 2017

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 | 425 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 | 2,254 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 | 1,525 reads
Previous headlines

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,388 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2017/12/13 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 89,449 reads

Partition Level Locking: Explanations From Outer Space

Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.  Read more...
By Additional Articles 2017/12/13 | Source: Brent Ozar Unlimited Blog | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 1,345 reads

Azure DWH part 20: Create External and Internal tables As Select

CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.  Read more...
By Daniel Calbimonte 2017/12/12 | Source: SQLServerCentral.com | Category: ctas
Rating: |  Discuss |   Briefcase | 253 reads

The four pillars of DevOps

DevOps isn’t just about tools. DevOps isn’t just about process. DevOps isn’t just about the people. DevOps isn’t just about culture. If you try and focus on one thing only, you’ll probably do it wrong and fail. You need to embrace all of the pillars. You wouldn’t build a house with only two walls and expect to have a wonderful experience the next time it rained.  Read more...
By 2017/12/12 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,381 reads

Checking SQL Server with Policy-Based Management

Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL Server instances. It's used for monitoring and enforcing a standard set of policies for SQL Server throughout an organization. While there are many built-in conditions from which to choose, Dennes demonstrates how to set up a custom policy as well as a standard one. Viewing the policy status over many servers can be tedious, so he also explains how DBAs can evaluate the states of multiple servers with just one glance.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,445 reads

SQL-On-Hadoop: Hive - Part II

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/12/11 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 548 reads

From the SQLServerCentral Blogs

Azure SQL Database – Using sp_BlitzIndex

I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...  Read more...
By Arun Sirpal 2017/12/14 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 838 reads

Overview of Encryption Tools in SQL Server

More and more people are considering some level of encryption against their data stored in SQL Server. In many cases...  Read more...
By Matthew McGiffen 2017/12/14 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,626 reads
Question of the Day

Cube v rollup

By Steve Jones 2017/12/14 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 563 reads

I have a table with data that looks like this:

OwedTo OwedBy Beer
Steve Ally 2
Steve Tugberk 1
Steve Dave 1
Steve Grant 4
Grant Ally 4
Grant Dave 2
Grant Steve 1
Ally Grant 2
Ally Dave 3
Ally... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
42535 498468 SSC Guru  
Jeff Moden
40220 460061 SSC Guru  
Steve Jones - SSC Editor
26188 300238 SSC Guru  
Grant Fritchey
19339 200057 SSC Guru  
Lynn Pettis
17780 202280 SSC Guru  
Latest forum posts