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

Headlines today   September 3, 2015

Configuring Service Broker Architecture

Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing highly available, scalable applications based upon the service–oriented architecture.  Read more...
By Valerij Urban 2015/09/03 | Source: | Category: service broker
Rating: |  Discuss |   Briefcase | 1,447 reads

Understand the Limitations of SQL Server Dynamic Data Masking

Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep in mind that it is not true encryption and that the data cannot be protected in all scenarios. Aaron Bertrand explains.  Read more...
By Additional Articles 2015/09/03 | Source: | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 959 reads
Previous headlines

Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions

In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.  Read more...
By Gregory Larsen 2015/09/02 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,251 reads

Creating Dashboards for Mobile Devices with Datazen – Part 3

With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can download and use Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional cost. In this article, Arshad Ali demonstrates creating data source, data views and then creating dashboards using them with Datazen Publisher.  Read more...
By Additional Articles 2015/09/02 | Source: Database Journal | Category: datazen
Rating: (not yet rated)  Rate this |   Briefcase | 2,010 reads

SSIS Package documentor

Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.   Read more...
Rating: |  Discuss |   Briefcase | 6,606 reads

Free Workshop: Microsoft Data Platform Modernisation - London, Sep 24

Are you an ISV and/or commercial software developer using SQL Server? Are you considering how to upgrade your application to take advantage of new SQL Server 2014 and would like to know more about how Microsoft can help your migration and sales/marketing efforts? Register using this invitation key 9ABED3   Read more...
By Additional Articles 2015/09/01 | Category: workshop
Rating:  Rate this |   Briefcase | 2,126 reads

Selective Updates with ASP.NET SignalR

Many developers get the misleading perception that ASP.NET SignalR merely helps to build a chat application or provides live updates of news, stock and score tickers. In reality, ASP.NET SignalR has a broader scope. In this article, Dino Esposito covers a few techniques to make selective SignalR updates to pages behind an ASP.NET authentication layer.  Read more...
By Additional Articles 2015/09/01 | Source: SimpleTalk | Category: asp .net
Rating: (not yet rated)  Rate this |   Briefcase | 1,209 reads

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2015/08/31 | Source: | Category: json
Rating: |  Discuss |   Briefcase | 8,185 reads

Free Webinar: Should your databases be Continuously Delivered?

If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering why databases are an essential component of CD, and how to start modernizing your software development practices.  Read more...
By Additional Articles 2015/08/31 (first published: 2015/08/13) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,394 reads

Learning Managed Backup

References and Links to using the Managed Backup feature in SQL Server 2016  Read more...
By Site Owners 2015/08/31 | Source: | Category: managed backup
Rating: (not yet rated) |  Discuss |   Briefcase | 634 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Outlier Detection with SQL Server, part 7: Cook’s Distance

By Steve Bolton[ …………I originally intended to save Cook’s and Mahalanobis Distances to close out this series not only because the...  Read more...
By SQLServerSteve 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 648 reads

Automatic Roll Forward Transaction Log Backups

Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...  Read more...
By eitan 35333 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 541 reads
Question of the Day


By Naveen PK 2015/09/03 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 704 reads

What is the output of this SELECT query?


SET @TrueValue = '';

SET @TrueValue = STUFF(@TrueValue, 1, 1, '123');


    @TrueValue AS TrueValue;

Top Members (last 30 days)
# Name Score Level
30 days All-time
Piotr Ryszkowski
771 3376 Hall of Fame  
533 544 Mr or Mrs. 500  
489 513 Mr or Mrs. 500  
449 506 Mr or Mrs. 500  
406 406 SSC-Addicted  
Latest forum posts