Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,798,259 DBAs, developers and SQL Server users

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: SQLServerCentral.com | Category: password cracking
Rating: |  Discuss |   Briefcase | 26,960 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,529 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: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 6,724 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: MSSQLTips.com | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 3,191 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: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,542 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,661 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,004 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2015/04/22 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 60,414 reads

Data Mining Part 26: Introduction to Cubes

In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.  Read more...
By Daniel Calbimonte 2015/04/21 | Source: SQLServerCentral.com | Category: data mining
Rating: (not yet rated) |  Discuss |   Briefcase | 3,120 reads

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image

There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.  Read more...
By Additional Articles 2015/04/21 | Source: Database Journal | Category: iaas
Rating: (not yet rated)  Rate this |   Briefcase | 3,924 reads
 
Ask SQL Server Central



Question of the Day

Drop Databases

By free mascot 2015/04/24 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 1,098 reads

While executing the following command, what will be the message you will receive? (choose the closest answer)

USE master
GO
DROP DATABASE tempdb
GO  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Eirikur Eiriksson
449 3504 Hall of Fame  
2.
zzalina0
322 1339 Ten Centuries  
3.
ArnoKwetters
285 844 SSC Eights!  
4.
Grant Fritchey
284 15065 SSCoach  
5.
patricklambin
260 2899 SSCrazy  
Latest forum posts