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

Headlines today   September 1, 2015

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 | 5,466 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: (not yet rated)  Rate this |   Briefcase | 1,440 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 | 925 reads
Previous headlines

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 | 7,578 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,173 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 | 584 reads

Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

Designing databases to use distributed tables effectively will help you to achieve the storage and query processing benefits of the Azure SQL DW Service (SQL DW). In this article, Murshed Zaman explains the various Azure SQL Data Warehouse distributed table types, and offers guidance for choosing the type of distributed table to use and when to use it.  Read more...
By Additional Articles 2015/08/31 | Source: SQLCAT | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 793 reads

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS.  Read more...
By Steve Moore 2015/08/28 (first published: 2013/06/20) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 20,298 reads

SQL Server 2016 – Introduction to Stretch Database

Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. Tim Radney introduces Stretch Database by looking at the applications and limitations of the new feature.  Read more...
By Additional Articles 2015/08/28 | Source: | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,285 reads

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework  Read more...
By David Poole 2015/08/27 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,322 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Getting Started With Power BI Desktop: Getting Data

Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get...  Read more...
By MarlonRibunal 2015/09/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,153 reads

Setting Up an HDInsight Cluster (No Scripts Required)

Let me start by saying, I am not a fan of scripting. It definitely has its place and a lot...  Read more...
By DataOnWheels 2015/09/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 507 reads
Question of the Day

Mount Points

By Steve Jones 2015/09/01 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 705 reads

If I were searching for information about which databases might be stored on mount points, which DMV or DMF would I query?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Piotr Ryszkowski
867 3333 Hall of Fame  
500 508 Mr or Mrs. 500  
451 506 Mr or Mrs. 500  
406 406 SSC-Addicted  
389 413 SSC-Addicted  
Latest forum posts