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

Rss
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 | 2,341 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,060 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 | 197 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 | 1,035 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,717 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,997 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,172 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,699 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,186 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 | 507 reads
Question of the Day

Masking emails

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

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


ALTER TABLE users ALTER COLUMN emailaddr ADD MASKED WITH (FUNCTION='email()' )
I have this data...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
16864 85124 SSC Guru  
2.
GilaMonster
14160 86594 SSC Guru  
3.
Steve Jones - SSC Editor
11696 61883 SSC Guru  
4.
Grant Fritchey
10951 39335 SSC-Dedicated  
5.
Lynn Pettis
6215 39031 SSC-Dedicated  
Latest forum posts