Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,752,927 DBAs, developers and SQL Server users

Headlines today   September 30, 2014

Synchronize Salesforce with SQL Server using SSIS

Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.   Read more...
By Eric Madariaga 2014/09/30 | Source: | Category: integers
Rating: |  Discuss |   Briefcase | 2,608 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 51,940 reads

Webinar: 7 Steps to Build a Database Deployment Pipeline

Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.  Read more...
By Press Release 2014/09/30 | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,092 reads

Change All Computed Columns to Persisted in SQL Server

Aaron Bertrand recently answered a question from a user who wanted to convert all of their SQL Server computed columns to be persisted. This allows you to shift the SQL Server cost of performing the computation from query time to the time of the insert/update, at the cost of storage. In this tip, Aaron shows you how.  Read more...
By Additional Articles 2014/09/30 | Source: | Category: change column
Rating: (not yet rated)  Rate this |   Briefcase | 3,173 reads
Previous headlines

Removing SQL Server Management Data Warehouse (Data Collector)

Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.  Read more...
By Bruno Silva 2014/09/29 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 1,931 reads

You Can Still Vote for PASS

If you couldn't vote last week or didn't get a ballot, you still can. Please go to and learn more.  Read more...
By Steve Jones 2014/09/29 | Source: | Category: pass
Rating: |  Discuss |   Briefcase | 257 reads

Azure Diagnostics for Virtual Machines

Hosting a scalable application in Azure seems ideal, but what happens when things go wrong? Azure Cloud Services provide extensive diagnostics, and this feature has now been extended to Azure web sites and Azure Virtual Machines. You need to set up diagnostics on the VM, but once this is done, all your logs, traces and performance counters can be collected from many VMs in one place for easy management.   Read more...
By Additional Articles 2014/09/29 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,907 reads

An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.  Read more...
By Dwain Camps 2014/09/26 (first published: 2012/08/02) | Source: | Category: cross apply values unpivot
Rating: |  Discuss |   Briefcase | 15,157 reads

Integrating Big Data into the Enterprise Data Warehouse

Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse. It is therefore only natural that your big data application must be integrated with the existing warehouse.  Read more...
By Additional Articles 2014/09/26 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 7,357 reads

SQL Saturday #318 - Orlando

This is Orlando's 8th SQLSaturday and this year will be better than ever with more than 50 different speakers giving over 50 presentations - all for FREE. Sept 27, 2014.  Read more...
By Press Release 2014/09/26 | Source: | Category: sqlsaturday
Rating: (not yet rated)  Rate this |   Briefcase | 5,008 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

A Bad Day with Backups

I learned a hard lesson when I first started as a DBA.  Although to be honest, it’s not a lesson...  Read more...
By Ryan Adams 2014/09/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,988 reads
Question of the Day

How Many Different Random Numbers?

By Amit Goswami 2014/09/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 834 reads
Editor: We are marking this as a bad question and returning points. The results can vary dramatically, depending on the database in which this is run. The correct answer is...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
882 882 SSC Eights!  
741 741 Right there with Babe  
590 3267 Hall of Fame  
353 550 Mr or Mrs. 500  
Steven Wittek
346 450 SSC-Addicted  
Latest forum posts