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

Headlines today   October 31, 2014

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/10/31 (first published: 2012/06/05) | Source: | Category: etl performance
Rating: |  Discuss |   Briefcase | 9,372 reads

The Data Center that Exploded

A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!  Read more...
By Additional Articles 2014/10/31 | Source: SimpleTalk | Category: fun
Rating: (not yet rated)  Rate this |   Briefcase | 182 reads
Previous headlines

Database Design Follies: NULL vs. NOT NULL

It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.  Read more...
By Edward Pollack 2014/10/30 | Source: | Category: null
Rating: |  Discuss |   Briefcase | 7,926 reads

Does NoSQL = NoDBA?

There’s a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can’t find a table. You may have heard it before, but it made Matt Hilbert sit down and ponder. What’s happening? Is there a division opening up between the newly fashionable NoSQL followers and DBAs? Matt enters the world of NoSQL to investigate.  Read more...
By Additional Articles 2014/10/30 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 5,664 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/10/29 | Source: | Category: cluster
Rating: |  Discuss |   Briefcase | 1,941 reads

Automating Red Gate SQL Compare with MSSQL Server Agent

How to compare two databases and email the results to every one who needs to know  Read more...
By Neil Burton 2014/10/29 | Source: | Category: red gate
Rating: |  Discuss |   Briefcase | 687 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/10/29 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 35,816 reads

Data Mining Part 19: Excel and Data Mining, Samples, Queries

This lesson explains how to Clean Data, Explore Data, get Samples of Data, Classify and query a Data Mining Model.  Read more...
By Daniel Calbimonte 2014/10/28 | Source: | Category: excel
Rating: |  Discuss |   Briefcase | 3,669 reads

Data Is Crazier than You Think

As a society, we have an unrealistic respect for data, especially if it has a decimal point somewhere and uses metric units. We who are in the business of data need to cultivate a renewed interest in the sceptical and rigorous science of statistics: it is too important to leave to 'Data Scientists'. If the data is wrong, or the way we analyse or report it is misleading, much of what we do is pointless.  Read more...
By Additional Articles 2014/10/28 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 5,518 reads

SQL Monitor Custom Metric: Average I/O Stalls

This metric is a great general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.  Read more...
By Additional Articles 2014/10/28 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,696 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Database Lifecycle Management

There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...  Read more...
By Grant Fritchey 2014/10/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 294 reads

Writing Fair and Useful Editorial Reviews Is Hard Work

One of my original goals was to be more reporter than editorial writer, but I’ve found that the editorial part...  Read more...
By Andy Warren 2014/10/31 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 607 reads
Question of the Day

Friday Shirts

By Steve Jones 2014/10/31 | Category: humor
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

It's Halloween and in the spirit of dressing up, how many Friday Shirts does Steve Jones own? 

Top Members (last 30 days)
# Name Score Level
30 days All-time
RK Mandava
1137 1836 SSCommitted  
Michael J Clayton
686 742 Right there with Babe  
D C S Vyas
358 3836 Hall of Fame  
Koen Verbeeck
351 13368 SSChampion  
317 926 SSC Eights!  
Latest forum posts