Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/06/01 to 2013/06/08

New Custom Metric: Percentage of blocked connections

This metric reports the number of connections that are currently blocked, divided by the total count of current connections. Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention.  Read more...
By Press Release 2013/06/07 | Source: SQLServerCentral.com | Category: blocking
Rating: (not yet rated)  Rate this |   Briefcase | 2,814 reads

More Uses for Data Explorer for Excel

Microsoft has introduced a new BI product that will help simplify the data discovery phase for Excel users. “Data Explorer” is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Data Explorer is a preview product so these features may appear differently in the final release.  Read more...
By Additional Articles 2013/06/07 | Source: MSSQLTips.com | Category: data explorer
Rating: (not yet rated)  Rate this |   Briefcase | 4,899 reads

Incremental Data Loading Using CDC

Describes a design pattern for using CDC to power fast and efficient incremental data loads.  Read more...
By Mark Murphy 2013/06/07 (first published: 2011/01/17) | Source: SQLServerCentral.com | Category: cdc
Rating: |  Discuss |   Briefcase | 18,905 reads

Continuous integration for databases using Red Gate tools

Once databases are placed in source control, it is possible to integrate them into the existing build automation process. This will ensure that the whole development project, including the database, can be integrated regularly and tested by an automated build system. This, in turn, leads to opportunities for more frequent, reliable deployments.  Read more...
By Additional Articles 2013/06/06 | Source: SimpleTalk | Category: continuous integration
Rating: (not yet rated)  Rate this |   Briefcase | 3,027 reads

Adding new files to a log-shipped database (SQL Spackle)

Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.  Read more...
By Wayne Sheffield 2013/06/06 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,642 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 114,583 reads

Paging Data with TSQL

Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.  Read more...
By Additional Articles 2013/06/05 | Source: Database Journal | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,488 reads

A Beginners Look at Hadoop

Hadoop has been making a lot of noise in the Big Data world. Despite my lack of Linux experience I decided to take the plunge and this is what I found.  Read more...
By David Poole 2013/06/05 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 15,606 reads

High IO Wait on SQL Server Replication Distribution Database

Have you ever heard this question? The database refresh has gone from 10-15 minutes to 1.5 hours. Nothing has changed on the application server and the consultant said ask the DBAs to check the database server. Where do you start to find the problem? Check out this tip to learn more.  Read more...
By Additional Articles 2013/06/04 | Source: MSSQLTips.com | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 3,944 reads

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.  Read more...
By Russ Mulkey 2013/06/04 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,747 reads

SQL Saturday #202 - Edinburgh

Join us for a free day of SQL Server Training on June 8, 2013. There's also a Friday Preconference Training Day with Jonathan Kehayias and Joseph Sack.  Read more...
By Press Release 2013/06/03 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,393 reads

Some "Laws" of Software Development

Despite all the advances in software tools, there seem to be several enduring truths about software development. By understaning these 'laws', Ziv’s law, Humphrey’s Law and Conway’s Law for example, you can remove some of the mystery of the process. Al Noel discusses these and other laws that seem to apply generally to the art of programming.  Read more...
By Additional Articles 2013/06/03 | Source: SimpleTalk | Category: software development
Rating:  Rate this |   Briefcase | 6,382 reads

SSRS Report Content Filtering by User Group

How to get an SSRS user's AD group membership in order to filter report content  Read more...
Rating: |  Discuss |   Briefcase | 5,328 reads