SQL Server Disaster Recovery (DR) and SANs, Remote Mirrors and Geo-Clusters

SQL Server Disaster Recovery (DR) and SANs, Remote Mirrors and Geo-Clusters After some positive comments arising from my High Availability post I’ve decided to Blog on DR earlier than I had intended.  I hadn’t intended to blog on DR for a while because it’s a difficult subject and I was hoping it might get easier…

0

Office Business Scorecards Accelerator – the ultimate marriage of business and intellgence. Another free application from Microsoft

At first glance, particularly if you’re a jaundiced techie like me, you may think the Balanced Scorecard is a concept wholly worthy of its acronym, BS.  You might find a description of its function couched in those seemingly worthless terms like vision, focus, objective, empowerment and strategic alignment.  All the kind of whibble senior management…

0

Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!

There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005.  Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the box’ features.  There is one that is wholly…

0

Business Intelligence (BI):The way it is without the blah blah.

Updated 19th September 2005 – included link (below) to aforementioned Nature article   Business Intelligence (BI):The way it is without the blah blah.   I love BI and I want you to love it too.  Why?  Because I think it can benefit mankind; not just because it can contribute to wealth creation by contributing to…

2

Peer to peer demo code

Here’s the code I used for the Peer to Peer replication demo I did during the SQL Server 2005 TechNet evening on the 14th June at our Reading office.  The code sets up peer to peer replication between two tables, Orders and OrderDetails, in two databases East and West (on the same SQL instance)  Pre-requisites: Make your…

1