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

Headlines today   September 3, 2014

Stairway to XML: Level 4 - Querying XML Data

You can extract a subset of data from an XML instance by using the query() method, and you can use the value() method to retrieve individual element and attribute values from an XML instance.  Read more...
By Rob Sheldon 2014/09/03 (first published: 2012/10/08) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,325 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2014/09/03 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 9,644 reads

Not unit testing your databases? You should be

Releasing a product without testing it is generally accepted as an unforgivable sin in the software development world. And frankly, there really isn’t an excuse not to test when we have whole suites of testing tools available to us  Read more...
By Additional Articles 2014/09/03 | Source: PluralSight | Category: testing
Rating:  Rate this |   Briefcase | 525 reads
Previous headlines

Clustered Columnstore Index Gives "Unable to find index entry" Error

The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table  Read more...
Rating: |  Discuss |   Briefcase | 1,177 reads

Quick Survey: PostgreSQL in Your Organization

Do you use PostgreSQL in your organization? Are you thinking about using it? Take our short survey and tell us about what you think about it.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,823 reads

SQL Monitor Custom Metric: Time Since Last Restore

If your log restores aren't happening when they’re meant to, you want to know about it. You’ll be relying on restoring from logs should anything happen to your databases, and if you can’t restore to a certain point in time, you risk losing valuable data.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,927 reads

Implementing Azure Blob Storage (ABS) With SQL Server 2014

With any application organizations face consistent key challenges such as high efficiency and business value, complex configuration, and low total cost of ownership. Extending applications to the cloud in hybrid scenarios addresses many of these challenges, whether distributing SharePoint content across on-premises and Office 365 while leveraging search as a service (hybrid search) or externalizing data, extending it to the cloud with Remote Blob Storage or related technologies.   Read more...
By Additional Articles 2014/09/02 | Source: Microsoft MSDN | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,711 reads

Using the Script Task in SSIS to Process Data Files When They Arrive

Learn how you can process data files with SSIS as soon as they arrive using the Script Task.  Read more...
By Orlando Colamatteo 2014/09/01 (first published: 2012/10/25) | Source: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 23,259 reads

New toys in SQL Server 2012

In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.  Read more...
By Daniel Calbimonte 2014/09/01 (first published: 2012/05/15) | Source: | Category: insert
Rating: |  Discuss |   Briefcase | 17,335 reads

More Text Analysis with the SSIS Term Lookup Component

As mentioned before, we will use the same use case in this tip as used with the Term Extraction component, which is an archive of all my tweets I've downloaded from Twitter. Using this archive and the Term Extraction transformation I found out which topics I particularly tweeted about in the past years or which persons I mentioned the most.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,758 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Automated Source Control: A Librarian For Your Database Objects, Part 3

As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are...  Read more...
By Tracy McKibben 2014/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 443 reads

SSRS report: Multi-value parameter going after Data-driven subscription

It is always good to enrich SSRS reports with multi-value parameters; users have more flexibility to combine different reporting scenario...  Read more...
By Rayis Imayev 2014/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 426 reads
Question of the Day


By Stewart Campbell 2014/09/03 | Category: table valued parameters
Rating: (not yet rated) |  Discuss |   Briefcase | 160 reads

You are required to maintain customer adress information received from an application.

to effect this, you create a Table Type:

[Counterparty] [int] NOT NULL,
[AddressType] [varchar](16) NOT NULL,
[Addressline1] [varchar](128) NOT... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
402 1796 SSCommitted  
369 931 SSC Eights!  
343 42849 SSC-Forever  
317 344 Old Hand  
295 2677 SSCrazy  
Latest forum posts