Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/12/09 to 2012/12/16

Planning for Disaster

There is a certain paradox in being advised to expect the unexpected, but the DBA must plan and prepare in advance to protect their organisation's data assets in the event of an unexpected crisis, and return them to normal operating conditions. To minimise downtime in such circumstances should be the aim of every effective DBA. To plan for recovery, It pays to have the mindset of a pessimist.   Read more...
By Additional Articles 2012/12/14 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 1,543 reads

Disaster Recovery Week

This week we highlight the practice of being prepared for disasters at SQLServerCentral.  Read more...
By Steve Jones 2012/12/14 (first published: 2012/12/10) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,512 reads

Win a Collection of SQL and .NET Books. And a Bookshelf

After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.  Read more...
By Press Release 2012/12/18 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 6,863 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,497 reads

Database Deployment Cribsheet

As part of Simple-Talk's long-running Cribsheet series, they asked William Brewer to write a guide to deployment that described in general terms what is involved in the deployment of a database application, and the sort of issues you're likely to come up against.  Read more...
By Additional Articles 2012/12/14 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 1,926 reads

Unteachable Disaster Recovery Techniques

There are some skills which are extensions of your instincts, and which you can only learn though years of experience. Matt Simmons has this brought home by the fact that he was recently minutes away from a data-loss disaster, and he doesn't quite know how he prevented it.  Read more...
By Additional Articles 2012/12/13 (first published: 2010/03/25) | Source: SimpleTalk | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 7,041 reads

Preparing for the Unthinkable - a Disaster/Recovery Implementation

Functionality to help maintain a Disaster/Recovery (D/R) Environment synchronized with production is introduced and the associated challenges are discussed.  Read more...
By Marios Philippopoulos 2012/12/13 (first published: 2011/03/31) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 9,660 reads

Handling Backups for Rapid Resilience

The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth in the typical size of databases. When disaster strikes, and an important service is taken offline while a restore is performed, there is often time to reflect on whether it might be possible to design databases for a more rapid recovery of the most critical parts of a database application.  Read more...
By Additional Articles 2012/12/12 (first published: 2012/11/26) | Source: SimpleTalk | Category: backups
Rating:  Rate this |   Briefcase | 1,832 reads

Logging – Level 11 of the Stairway to Integration Services

Learn how you can add custom logging to your Integration Services packages in this installment of our Stairway to Integration Services.  Read more...
Rating: |  Discuss |   Briefcase | 6,367 reads

In The Real World - Disaster!

A real world account of disaster recovery. (This article is being republished after the recent hurricane that hit the US East Coast).   Read more...
By Steve Jones 2012/12/12 (first published: 2002/04/22) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 9,620 reads

Free eBook: Inside the SQL Server Query Optimizer

This free ebook from Red Gate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2013/02/07 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 11,180 reads

SQL Server Backup Questions We Were Too Shy to Ask

During presentations about doing database backups and restores, there seem to be two two types of questions that are commonly asked, Those that come from the floor during the presentation, and those that are asked in private afterwards. These are sometimes more interesting, and challenging to answer well.  Read more...
By Additional Articles 2012/12/11 | Source: SimpleTalk | Category: backup / restore
Rating:  Rate this |   Briefcase | 3,125 reads

Reporting Services Disaster Recovery

Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.  Read more...
By Dave Lumley 2013/10/17 (first published: 2010/04/21) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 14,464 reads

Departures from Origins and Arrivals at Destinations

A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.  Read more...
By Dwain Camps 2012/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,417 reads

Disaster Recovery Planning for Data: The Cribsheet

Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant to any Database Administrator who is responsible for the safety and integrity of the companies' data, since data is a key part of business continuity.  Read more...
By Additional Articles 2012/12/10 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 2,232 reads

What’s in YOUR Recovery Plan?

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.  Read more...
By Craig Outcalt 2012/12/10 (first published: 2011/09/26) | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 5,100 reads

Data Distribution with SQL Server Replication

This paper provides a foundation for understanding data replication as well as a discussion of the criteria for selecting an appropriate replication technology.   Read more...
By Ron Johnson 2012/12/10 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 1,915 reads

Fixing Gatekeeper Row Cardinality Estimate Issues

The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator in order to select the best query plan from the most likely alternatives. Sometimes these estimates can go so wildly wrong as to result in a very slow query. Joe Sack shows how it can happen with SQL Queries on a data warehouse with a star schema.  Read more...
By Additional Articles 2012/12/10 | Source: SimpleTalk | Category: cardinality estimates
Rating:  Rate this |   Briefcase | 1,063 reads