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.
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.
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.
Keynotes
This Friday we look forward to the various tech events of 2008 and which speakers you think are worth seeing. This editorial was originally published on Jan 11, 2008. It is being re-run as Steve is traveling.
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.
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes. This editorial was originally published on Apr 3, 2008. It is being re-run as Steve is out of town.
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.
SQL Server 2012 Integration Services - Implementing Package Security using Access Control
SQL Server 2012 Integration Services offers a wide range of powerful features that allow you to streamline and automate tasks involving data extraction, transformation, and loading. However, incorporating these features into your existing business intelligence framework frequently necessitates additional security measures ensuring that data which is being processed remains protected from unauthorized access.
Stairway to SQL Dialects Level 3: MySQL
As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.
Type A, B, or C
Do personality types matter and did you know there are more than just A or B types? This editorial was originally published on Feb 26, 2008. It is being re-run as Steve is traveling.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers