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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,884,052 DBAs, developers and SQL Server users

Headlines today   April 24, 2017

Should I Type * or 1 With the EXISTS Logical Operator

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.  Read more...
By Viacheslav Maliutin 2017/04/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 806 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/24 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,021 reads

Building Dynamic React Apps with SQL Server Data

This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.  Read more...
By Jerod Johnson 2017/04/24 | Source: SQLServerCentral.com | Category: react
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

6 shades of masking your data

The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six.  Read more...
By Additional Articles 2017/04/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 550 reads
Previous headlines

Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2017/04/21 (first published: 2015/04/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,671 reads

Extending DevOps practices to SQL Server databases

In this free demo webinar, Grant Fritchey and Arneh Eskandari will show how Redgate tools enable you to push and pull database changes in Git, then set up an automated database build and deployment process using TeamCity and Octopus Deploy.   Read more...
By 2017/04/21 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,886 reads

Performance Tuning Using Extended Events: Part 1

In this article, learn how to identify performance tuning opportunities using Extended Events.  Read more...
By Brian Davey 2017/04/20 | Source: SQLServerCentral.com | Category: extended events
Rating: |  Discuss |   Briefcase | 1,112 reads

The right way to approach a legacy code base

Andrea Angella shares what he learned from attending Michael Feather's workshop on working effectively with legacy code.  Read more...
By Additional Articles 2017/04/20 | Source: Redgate | Category: software development
Rating: (not yet rated)  Rate this |   Briefcase | 2,605 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Server 2016 enhancements – Truncate Table and Table Partitioning

The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate...  Read more...
By Prashanth Jayaram 2017/04/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 577 reads

SQL Doc by RedGate

I recently was on a call where a technical unit indicated they did not receive any form of documentation around...  Read more...
By CYates 2017/04/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 227 reads
Question of the Day

Masking emails

By Steve Jones 2017/04/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 167 reads

With Dynamic Data Masking in SQL Server 2016+, I have the following mask applied to this table:

I have this data... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
16971 84897 SSC Guru  
14353 86457 SSC Guru  
Steve Jones - SSC Editor
11760 61753 SSC Guru  
Grant Fritchey
11351 39255 SSC-Dedicated  
Lynn Pettis
6317 38991 SSC-Dedicated  
Latest forum posts