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

Headlines today   May 26, 2017

How to deploy a database plus static data using SQL Compare and SQL Data Compare

This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.  Read more...
By Tony Davis 2017/05/26 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 1,877 reads

Datetime vs. Datetime2

Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.  Read more...
By Robert Hartmann 2017/05/26 (first published: 2016/01/05) | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 13,551 reads

It’s not you, it’s me (I/O troubleshooting)

Monica Rathburn talks about a few of the more common elements she always checks for when troubleshooting I/O problems.  Read more...
By Additional Articles 2017/05/26 | Source: SQLPerformance.com | Category: io performance
Rating: (not yet rated)  Rate this |   Briefcase | 1,397 reads
Previous headlines

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,286 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,683 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,548 reads

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 | 556 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,208 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,190 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 | 742 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Shipping Database Changes–T-SQL Tuesday #90

This is a good T-SQL Tuesday topic from James Anderson: shipping database changes. It’s especially poignant for me since I...  Read more...
By Steve Jones 2017/05/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 589 reads

Pester Test Inception and the Show Parameter

My fantastic friend Andre Kamman b | t  and I presented at PSConfEu last week and whilst we were there we were...  Read more...
By Rob Sewell 2017/05/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 394 reads
Question of the Day

Data Types

By Stanley Kapfunde 2017/05/26 | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 513 reads

Which of the following is not an exact numeric data type?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
29670 115889 SSC Guru  
28275 115718 SSC Guru  
Steve Jones - SSC Editor
19916 82587 SSC Guru  
Grant Fritchey
15285 55229 SSC Guru  
Lynn Pettis
11959 51366 SSC Guru  
Latest forum posts