Difference between log shipping and database mirroring
Compiled by Abi Chapagai (April 2010)
Implementation of High Availability depends in the need of the business. Each of the technologies...
2010-04-18
24,371 reads
Blog Posts
Opportunities in (I.T.) Chaos
I just finished reading “The next wave of technologies” by Phil Simon. A great read! It proposes a new Enterprise 2.0 - not related to earlier Web 2.0 related...
2010-04-18
8 reads
Opportunities in (I.T.) Chaos
I just finished reading “The next wave of technologies” by Phil Simon. A great read! It proposes a...
2010-04-18
8 reads
SQL Server 2008 Database Mirroring – Abi Chapagai
Introduction
In any distributed environment, database synchronization between two different locations or different servers’ is very essential for mission critical applications....
2010-04-18
2,246 reads
Three Speaking Events in Six Days
AlantaMDF SQL Server Users Group. Photo courtesy of www.sqlvariant.com.
I have just finished up a three event speaking tour that, which...
2010-04-18
645 reads
A DMV a Day – Day 17
The DMV for Day 17 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-17
903 reads
Latest Simple-Talk.com Article Published on Deployment Management - to be Front Page Starting Monday
After several months of reflection/rewrites with colleagues (because orignally I forgot the Rollback plan - oops), and reworking the bilingual templates,...
2010-04-17
721 reads
A DMV a Day – Day 16
We have two DMVs for Day 16. The first one is sys.dm_exec_cached_plans, which is described by BOL as:
Returns a row...
2010-04-16
664 reads
Book Review – SQL Server Integration Services: Problem – Design – Solution
I usually don't do book reviews (at least publicly, anyway), but when I find a piece of work that I...
2010-04-16
2,160 reads
Confio Ignite: Part II
I’m continuing to evaluate Confio’s Ignite database monitoring tool. I’ve had it collecting data on a couple of production servers...
2010-04-16
1,812 reads
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
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers