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

Headlines today   April 21, 2014

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.  Read more...
By Sujeet Singh 2014/04/21 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 2,110 reads

Monitoring SQL Server: An Interview with David Bick

Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.  Read more...
By Additional Articles 2014/04/21 | Source: SimpleTalk | Category: interview
Rating: (not yet rated)  Rate this |   Briefcase | 1,089 reads

SQL Saturday #308 - Houston, TX

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014. Register while space is available.  Read more...
By Press Release 2014/04/21 | Source: SQL Saturday | Category: events
Rating:  Rate this |   Briefcase | 461 reads
Previous headlines

Unexpected View Performance

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.  Read more...
By Thom Bolin 2014/04/18 (first published: 2011/01/11) | Source: | Category: views
Rating: |  Discuss |   Briefcase | 11,518 reads

SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide

This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.  Read more...
By Additional Articles 2014/04/18 | Source: SimpleTalk | Category: wait statistics
Rating: (not yet rated)  Rate this |   Briefcase | 3,028 reads

SQL Saturday #305: Dallas, BA Edition

Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available  Read more...
By Press Release 2014/04/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 171 reads

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.  Read more...
By Eirikur Eiriksson 2014/04/17 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 2,913 reads

Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS

The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.  Read more...
By Additional Articles 2014/04/17 | Source: | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 1,268 reads

Call for participants in deployment process research

The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.  Read more...
By Press Release 2014/04/17 | Source: SimpleTalk | Category: research
Rating: (not yet rated)  Rate this |   Briefcase | 1,744 reads

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.  Read more...
By Richard Waymire 2014/04/16 (first published: 2012/01/11) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,798 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

The system_health Extended Event Session

When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...  Read more...
By Patrick Keisler 2014/04/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 446 reads
Question of the Day

Azure Data Files

By Steve Jones 2014/04/21 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 461 reads

True or False: You can run SQL Server in your existing data center and store data files for a database in the Azure cloud storage?

Top Members (last 30 days)
# Name Score Level
30 days All-time
499 499 SSC-Addicted  
442 2664 SSCrazy  
378 387 Old Hand  
373 401 SSC-Addicted  
355 3734 Hall of Fame  
Latest forum posts