January 2009 Blog Posts
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...
posted @ Tuesday, January 27, 2009 5:14 PM |
Adapted from my colleague's (Barry Ralston) post at SQL Server Magazine BI Blog...
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...
posted @ Friday, January 23, 2009 2:42 PM |
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 firstname.lastname@example.org or email@example.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...
posted @ Saturday, January 17, 2009 3:05 PM |
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)
nscribe (HP NonStop)
SQL/MP (HP NonStop)
Additionally, Attunity ships a SSIS Change Data Capture (CDC) Accelerator that generates packages...
posted @ Thursday, January 15, 2009 3:00 AM |
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...
posted @ Friday, January 02, 2009 8:52 AM |