January 2009 Blog Posts

BI in a Tough Economy

The signs of a tough economy surround us all. Many Fortune 500 companies have laid-off workers and those who are still employed fret over their job’s near-term outlook. The housing and financial markets have been shaken to their core and the new president is promising change that cannot seem to come quick enough. So what are businesses to do in such hard times? The same things they do when times are good, continuously improve their organization on a variety of dimensions. Specifically, the application of Business Intelligence (BI) in tough times is a very strategic ‘play’. By leveraging BI to cut...

Game Changing Announcement for Microsoft BI

Adapted from my colleague's (Barry Ralston) post at SQL Server Magazine BI Blog... http://www.sqlmag.com/Article/ArticleID/101322/101322.html   Today, in a message to the Business Intelligence Partner Community, Microsoft announced a major change in the alignment of the BI flagship product, Microsoft Office PerformancePoint Server. The net-net of the announcement is: Supporting the democratization of BI (aka BI for the masses) with the consolidation of PerformancePoint Server Monitoring and Analytics functions into Office SharePoint Server Enterprise. The new capabilities will be called PerformancePoint Services. As I read the announcement, PerformancePoint Planning has been put out of our misery. Service...

Upcoming PASS User Group Presentations

Happy New Year! My colleague Barry Ralston from ComFrame Software (www.comframe.com ) and I are giving a series of local user group presentations starting with the first two below. If you run a local user group in the midwest or southeast regions of the country and would enjoy having us stop and present on Microsoft BI topics please feel free to email us at dcomingore@comframe.com or bralston@comframe.com . Date & Time: 1/20/2009 @6PM Group: Steel City PASS User Group (http://steelcitysql.org/default.aspx ) Location: New Horizons Computer Learning Center on Beacon Parkway , Birmingham, AL Title: Upgrading to SQL Server 2008 for Business Intelligence Solutions Abstract: Microsoft SQL Server 2008...

Extending Integration Services Capabilities with Premier 3rd Party Products

I have evaluated and/or deployed various SSIS 3rd party components over the years. Two of the best 3rd party SSIS companies I have come across are: Attunity & ETI. Attunity (www.attunity.com) extends SSIS’s ‘reach’ by providing connectors for the following systems: Adabas (mainframe and open systems) DB2 (on the mainframe) DB2/400 (iSeries) nscribe (HP NonStop) IMS/DB (mainframe) VSAM (mainframe) SQL/MP (HP NonStop) Additionally, Attunity ships a SSIS Change Data Capture (CDC) Accelerator that generates packages...

OLAP's Ante to Play: OLTP

I'm starting to read various chapters from 'Programming Microsoft SQL Server 2008' by Leonard Lobel and his co-authors. I found his Chapter 14, 'Data Warehousing', contains a very good section on the solutions and technologies that were 'main stream' prior to the deployment of data warehousing and business intelligence solutions. This brings up an excellent (debatable) point. In my opinion, anyone wishing to enter the field of DW/BI (regardless of software vendor) should have good solid prior experience in traditional OLTP-based applications and systems. This is my opinion because (as 'Programming Microsoft SQL Server 2008' mentions), OLTP systems have been around long...

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski