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,069 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 | 1,976 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,048 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 | 164 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 | 919 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,691 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,948 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,149 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,647 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 | 1,041 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 | 428 reads
Question of the Day

Masking emails

By Steve Jones 2017/04/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 415 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
16940 85024 SSC Guru  
14290 86542 SSC Guru  
Steve Jones - SSC Editor
11756 61829 SSC Guru  
Grant Fritchey
11181 39291 SSC-Dedicated  
Lynn Pettis
6257 39011 SSC-Dedicated  
Latest forum posts