Featured Article(s)
Tips for using SQL Server 2005 Snapshot Replication (Part 1)
Here are some helpful tips to performance tune and optimize SQL Server 2005 Snapshot Replication.
Data Compare, for SQL Server Express?
Yes. And free too. If you’re working with SQL Server Express, building applications, moving them out to your users and needing to make sure you catch all of the pieces, check out xSQL Software’s database comparison and synchronization tools. You can get a free copy for SQL Server Express, see how it works and then see how big of a difference it can make in making your projects run more smoothly. Get more information here, no need to register or activate.
CDP, Anyone?
We’ve talked a lot on the SelectViews show, in articles and here in the editorials about CDP – "Continuous Data Protection" – and how it can be used with SQL Server. There are a number of products out there, but what continues to befuddle me is the fact that the definition of "continuous" keeps changing from vendor to vendor. For one vendor, "Continuous" is every 15 minutes (!) for others, it’s up to the second current backups and recovery process.
For some, it’s a cohesive, up to date backup, but a slow recovery process. While I don’t suppose CDP is about continuous RESTORE protection, I do think that not paying attention to the fail over recovery process is a crime.
So, my question to you – what CDP products have you implemented and what are your thoughts? Is this something you’ve had success with, or is it better to cluster/failover/mirror your systems for the continuous part, then have a strong backup and restore process defined? Drop me an email with your thoughts.
Featured White Paper(s)
SQL Injection: What it is and how to prevent it
SQL injection is the hacking technique which attempts to pass SQL commands through a web application for execution by a backe… (read more)
SQL Injection: Are your Web Applications Vulnerable?
Are you vulnerable to a SQL Injection attack? SQL Injection can deliver total control of your server to a hacker giving them … (read more)
Top 10 Database Hacks and How to Stop Them
Corporate databases contain the crown jewels of an organization, which means a break-in, by insiders or outsiders, can cost m… (read more)
The One Essential Guide to SQL and MS Exchange Availability: Zero Downtime, Zero Data Loss
Get the Facts – 4 Essential Steps to Real-Time, On-Demand Information for the Right Organization – Protect your SQL and Excha… (read more)
The Failure of Relational Database, The Rise of Object Technology and the Need for the Hybrid Database
Hybrid databases provide the speed and rapid development capabilities of object technology PLUS robust SQL access…. (read more)