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

Headlines today   September 4, 2015

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2015/09/04 (first published: 2013/03/06) | Source: | Category: delete
Rating: |  Discuss |   Briefcase | 18,411 reads

An Introduction to the OpenPOWER Foundation

In a bid to challenge Intel's dominance of high performance computing environments, IBM have introduced OpenPOWER, a flexible open-source framework based on their POWER processor architecture. Robert Sheldon looks at the potential of this new platform.  Read more...
By Additional Articles 2015/09/04 | Source: SimpleTalk | Category: openpower
Rating: (not yet rated)  Rate this |   Briefcase | 1,563 reads
Previous headlines

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 | 2,084 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 | 1,417 reads

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,694 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,284 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,928 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,455 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,374 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,405 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)

As I noted in my previous post, I am not a fan of scripting. In that post we set up...  Read more...
By DataOnWheels 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 470 reads

5 Tips for #PowerBI

After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that...  Read more...
By dustinryan 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,119 reads
Question of the Day

Open Transactions

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

I am trying to track down the number of open transactions for each process to evaluate the workload on my SQL Server instance. Where would I easily get this information...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
Piotr Ryszkowski
783 3419 Hall of Fame  
542 566 Mr or Mrs. 500  
541 554 Mr or Mrs. 500  
446 506 Mr or Mrs. 500  
406 406 SSC-Addicted  
Latest forum posts