blogs.conchango.com

The first session today was ''Real-time OLAP'' as delivered by Aaron Solomon from Hitachi Consulting. A really great session - I learned alot about pro-active caching, SSIS tasks & components that integrate with Analysis Services, AS partitions and various other cool stuff. As I said to Aaron, I'm worried about varying query ...

Over the last few years, I've been a consultant for a major IT Services company; worked for a UK-based support services company; contracted for Australia’s largest independent magazine distributor; worked in-house designing and project managing a Europe-wide infrastructure refresh for a major fashion design, marketing and retail organisation; and ...

In the course of developing some stored procs today I learned some stuff I didn't know. 1) SELECT 'abc' AS column1 can be rewritten as SELECT column1 = 'abc' 2) SELECT SUBSTRING('qwerty', 1, LEN('qwerty') - 1) & SELECT SUBSTRING('qwert ', 1, LEN('qwert ') - 1) don't give the same result because LEN strips off trailing white spaces. Yes, this ...

My colleague Matt has directed me to a quality paper explaining the difference between all of Microsoft's integration technologies and where each is appropriate. It covers Indigo, MSMQ, SQL Server Broker, SQL Server Replication, SQL Server Integration Services, BizTalk and Host Integration Server. You can get it from here although you'll ...

Previously I have talked about ETL and EII, Analysis Services's support for EII & SQL Server Integration Services's (SSIS's) support for EII without explaining too much about what EII actually is - largely because I didn't know. Well, I have now come across a very useful article that explains the differences between ETL, EAI ...