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

Rss
Headlines today   December 15, 2017

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,326 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 | 927 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,156 reads
Previous headlines

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 | 489 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,608 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,786 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,414 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,598 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,508 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 | 262 reads
 

From the SQLServerCentral Blogs

Testing a Birthday Month Query

I ran across a post from a tester, wondering  how to write a query for birthday months. This makes sense,...  Read more...
By Steve Jones 2017/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,134 reads

New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute

Last night, I received Adam Machanic’s (b | t) newsletter “Announcing sp_whoisactive v11.20: Live Query Plans”. For those who don’t know about...  Read more...
By Cláudio Silva 2017/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,336 reads
Question of the Day

What are the contents?

By Steve Jones 2017/12/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 559 reads

I have a table with a few rows in it.


ContactID FirstName
1 Tom
2 Peyton
3 Eli
5 Drew
I have this code. What happens when I run this?


DECLARE @name VARCHAR(100) = 'Bob';

SELECT @name = c.FirstName...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
42654 499706 SSC Guru  
2.
Jeff Moden
40151 461096 SSC Guru  
3.
Steve Jones - SSC Editor
26176 300956 SSC Guru  
4.
Grant Fritchey
19540 200696 SSC Guru  
5.
Lynn Pettis
17896 202836 SSC Guru  
Latest forum posts