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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,885,689 DBAs, developers and SQL Server users

Headlines today   May 25, 2017

The OUTPUT Clause for INSERT & DELETE Statements

In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.  Read more...
By Amarendra Reddy Thummeti 2017/05/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,137 reads

Training: Zero to BIML

A four-day course aimed at BI developers who want to use Business Intelligence Markup Language (BIML) to generate SQL Server Integration Services packages.  Read more...
By Andy Leonard 2017/05/25 | Category: training
Rating: (not yet rated)  Rate this |   Briefcase | 1,433 reads

Getting Started with Azure SQL Data Warehouse - Part 4

Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed tables, and how to create them. He also discusses how partitioning works in SQL Data Warehouse and looks at the impact of choosing the right distribution key. As a bonus Arshad shows you how to leverage PolyBase to quickly and easily import or export data from SQL Data Warehouse.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,270 reads
Previous headlines

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?  Read more...
By Hugo Kornelis 2017/05/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 533 reads

Masking your on-premise database with SQL Data Mask

In the last update from Redgate Foundry three weeks ago, they announced their intention to build a version of SQL Data Mask that would mask on-premise SQL Server databases, as well as Azure SQL Databases. They're pleased to say this version of the prototype is now available - here are the details.  Read more...
By Additional Articles 2017/05/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,110 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2017/05/24 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 81,080 reads

Yet another SSIS XML Destination

See a simple script to generate an XML file in SSIS.  Read more...
By Adán Bucio 2017/05/23 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 716 reads

Azure Networking for SQL Server DBAs

The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone get the right access. DBAs generally need not become experts in Azure networks, but it helps to understand the concepts and language. If you are running a SQL Server Virtual Machine in Azure, then VNets, Subnets, Network Security Groups, VNet peering and VPN gateways are all worth knowing about in order to to keep SQL Servers running smoothly.  Read more...
By Additional Articles 2017/05/23 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,541 reads

How to document multiple SQL Server databases using SQL Doc and PowerShell

You can use SQL Doc’s command-line parameters to automate database documentation, but when you try with a group of databases on a server, they sometimes don’t give you enough control over the job. Phil Factor provides a solution that allows both automation and flexibility.  Read more...
By Additional Articles 2017/05/23 | Source: Redgate | Category: sql doc
Rating: (not yet rated)  Rate this |   Briefcase | 1,988 reads

Azure DWH part 9: Azure PHP and ASDW

In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.  Read more...
By Daniel Calbimonte 2017/05/22 | Source: SQLServerCentral.com | Category: php
Rating: |  Discuss |   Briefcase | 247 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

T-SQL Tuesday #90 – The Elephant’s Name is Database

T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community  It is the brainchild of Adam Machanic (B|T)...  Read more...
By SQLRUs 2017/05/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 985 reads

T-SQL Tuesday 90 - Shipping Database Changes

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...  Read more...
By cjsommer 2017/05/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 858 reads
Question of the Day

Masking short domains

By Steve Jones 2017/05/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 476 reads

I've got this email address in my database: bob@b.net. If I have an email masking function applied on this column, what data is returned to users that see masked data?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
29226 114947 SSC Guru  
27621 114682 SSC Guru  
Steve Jones - SSC Editor
19673 81955 SSC Guru  
Grant Fritchey
15134 54819 SSC Guru  
Lynn Pettis
11814 51047 SSC Guru  
Latest forum posts