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

Rss
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 | 430 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,278 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,550 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,390 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,463 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,358 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,393 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,453 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 | 549 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 | 852 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,640 reads
Question of the Day

Cube v rollup

By Steve Jones 2017/12/14 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 566 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...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
42575 498580 SSC Guru  
2.
Jeff Moden
40266 460171 SSC Guru  
3.
Steve Jones - SSC Editor
26230 300310 SSC Guru  
4.
Grant Fritchey
19385 200115 SSC Guru  
5.
Lynn Pettis
17794 202328 SSC Guru  
Latest forum posts