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).
2012-12-12 (first published: 2002-04-22)
9,673 reads
Articles
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.
2012-12-12 (first published: 2012-11-26)
2,382 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.
2012-12-11
15,372 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.
2012-12-11
3,466 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.
2012-12-10
2,453 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.
2012-12-10 (first published: 2011-09-26)
5,192 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.
2012-12-10
2,360 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.
2012-12-10
1,163 reads
Database Deployment: The Bits - Copying Data Out
Occasionally, when deploying a database, you need to copy data out to file from all the tables in a database. Phil Factor shows how to do it, and illustrates its use by copying an entire database from one server to another.
2012-12-07
2,690 reads
Red Gate Wins 8 Awards and You Can Get a Prize
Red Gate won 8 awards in the recent SQL Server Pro annual product reviews. As a celebration, we're giving away a few prizes.
2012-12-06
2,714 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers