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

Headlines today   April 28, 2015

Comprehensive Baseline Collector Solution (Updated)

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution  Read more...
By Robert Virag 2015/04/28 (first published: 2014/10/21) | Source: | Category: baseline
Rating: |  Discuss |   Briefcase | 5,556 reads

Mobile BI with SQL Server Reporting Services

For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device. Adam Aspin demonstrates some of the ways that we can deliver easy-to-use Business Intelligence to tablets and smartphones using Reporting Services.  Read more...
By Additional Articles 2015/04/28 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 1,631 reads

Survey on SQL Server Monitoring

If looking after the health of SQL Server is part of your responsibility, Redgate would love to hear your views on monitoring server health through this 10 minute survey. Complete the survey by May 15th to be in with the chance to win one of three $50 Amazon vouchers.  Read more...
By Press Release 2015/04/28 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,358 reads
Previous headlines

Data Mining Part 27: Microsoft Data Mining with Cubes

In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.  Read more...
By Daniel Calbimonte 2015/04/27 | Source: | Category: ssas
Rating: |  Discuss |   Briefcase | 2,003 reads

Time Testing SQL Azure Point In Time Database Restores

If you need to do a time test for restoring an Azure SQL database from a point in time, and wonder about automating this through PowerShell, here are the guidelines that Tim Smith would you recommend?  Read more...
By Additional Articles 2015/04/27 | Source: | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,813 reads

Learn Continuous Integration for Databases in Bellevue, WA

Redgate Software has teamed up with Northwest Cadence to present a workshop on May 15, 2015. Come learn how to implement continuous integration in your database development software pipeline.  Read more...
By Press Release 2015/04/27 | Source: | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,908 reads

How to Recover a SQL Server Login Password

I will describe a simple method anyone can use to obtain lost password information for a SQL Server login.  Read more...
By Geoff Albin 2015/04/24 (first published: 2013/03/04) | Source: | Category: password cracking
Rating: |  Discuss |   Briefcase | 28,144 reads

Understanding Cross-Database Transactions in SQL Server

Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit.  Read more...
By Additional Articles 2015/04/24 | Source: SimpleTalk | Category: distributed transactions
Rating: (not yet rated)  Rate this |   Briefcase | 4,007 reads

Adding Slicers to a Reporting Services Report

This article shows you how to create dynamic slicers from a data set in an SSRS report  Read more...
By Adam Aspin 2015/04/23 | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 7,185 reads

Continue a Foreach loop after an error in a SQL Server Integration Services package

Say you have a SQL Server Integration Services (SSIS) package with a Foreach Loop container. Inside that container you have a task that sometimes can fail. Koen Verbeeck provides a tip on how to implement SSIS so that, if it fails, the loop will just continue, skip the current step and go to the next iteration.  Read more...
By Additional Articles 2015/04/23 | Source: | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 3,640 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

T-SQL Tuesday #65 – Learning Computed Columns for XML

It’s T-SQL Tuesday time again, and this month the invite comes from Mike Donnelly (@sqlmd). The topic is Teach Something...  Read more...
By Steve Jones 2015/04/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,161 reads

Exam Prep 70-463: Master Data Services Models

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...
By Colleen M. Morrow 2015/04/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,061 reads
Question of the Day

CTE Problem Redux

By Steve Knox 2015/04/28 | Category: cte
Rating: (not yet rated) |  Discuss |   Briefcase | 419 reads

Recently there was a QoTD about providing column aliases in CTEs. The discussion revolved around providing them within the query or in parentheses after the table name. 

But what happens... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
444 3518 Hall of Fame  
332 1349 Ten Centuries  
Grant Fritchey
309 15090 SSCoach  
285 844 SSC Eights!  
271 2910 SSCrazy  
Latest forum posts