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

Headlines today   April 27, 2015

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 | 1,853 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,472 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,569 reads
Previous headlines

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 | 27,959 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 | 3,945 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,111 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,525 reads

Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery

Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery.   Read more...
By Press Release 2015/04/23 (first published: 2015/04/17) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,871 reads

Stairway to SQL PowerShell Level 9: Objects For Everyone

This level will show how to create objects including a login, a database, a filegroup, a file a database user and then we’ll end with a table and an index.  Read more...
By Ben Miller 2015/04/22 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,780 reads

Schema-Based Access Control for SQL Server Databases

Access-control within the database is important for the security of data, but it should be simple to implement. It is easy to become overwhelmed by the jargon of principals, securables, owners, schemas, roles, users and permissions, but beneath the apparent complexity, there is a schema-based system that, in combination with database roles and ownership-chaining, provides a relatively simple working solution.  Read more...
By Additional Articles 2015/04/22 | Source: SimpleTalk | Category: access restriction
Rating: (not yet rated)  Rate this |   Briefcase | 4,230 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Modify SQL Agent Jobs using PowerShell and SMO

So here we are, week 2 of the #SQLNewBlogger Challenge. This is a follow on to last weeks post Monitoring...  Read more...
By cjsommer 2015/04/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,397 reads

Microsoft's 1st MVP Virtual Conference - Everyone's Invited!

  The Microsoft MVP community is very excited to announce it’s very first 2015 Microsoft MVP Virtual Conference (Microsoft V-Conf) coming to directly...  Read more...
By Robert Pearl 2015/04/27 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,006 reads
Question of the Day

Using a Window Aggregate in an Aggregate Query

By Kathi Kellenberger 2015/04/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 922 reads

You have been asked to write a query that lists the sales by year and also displays the percentage of sales overall for each year. Which query will work?

-- 1
SELECT... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
456 3515 Hall of Fame  
322 1339 Ten Centuries  
Grant Fritchey
305 15086 SSCoach  
285 844 SSC Eights!  
271 2910 SSCrazy  
Latest forum posts