Oracle-CDC for SSIS - an Easy-to-use Solution for Real-time Data Integration Join Attunity & SQL Server MVP Derek Comingore of BI Voyage for a Webinar on September 22 https://www1.
Read more →
Update: Check out Richard's (he posted a comment on this post) about his own thoughts on MSFT BI Delivery and Leadership Topics here: http://thoughtsonbi.blogspot.com/ . I agree with just about everything he states.
Read more →
If you have not yet checked out Attunity and their line up of data integration components for SSIS your missing out!
Attunity is without question one of the elite SQL Server Integration Services (SSIS) 3rd Party Providers and the company's recent award of a Reader Choice Award from Visual Studio Magazine is yet another sign of the company's commitment to SSIS Excellence.
Read more →
Learn how to strengthen your company's overall health and help your business thrive in this tough economy - without ever leaving your desk.
Attend this exclusive series and discover how to quickly deliver actionable information without any significant software costs or long running data warehouse projects.
Read more →
SQL Serverdata mining has always been somewhat of an overlooked, niche technology. There are several logical reasons for SQL Server data mining’s slow adoption. First, there are few companies that take the time to consider if they can benefit from the technology (OLAP tends to be the technological “stop point” in modern day).
Read more →
Silverlight 2.0 & 3.0 About a year ago now I witnessed my first Silverlight dashboard in a product Microsoft created called Microsoft Enterprise Cube (MEC). The dashboard was amazingly rich and interactive.
Read more →
This is my biggest frustration with the advanced certification programs at Microsoft. Microsoft has clearly identified the need to create advanced certification programs yet Business Intelligence has zero representation! I have created past Connect suggestions and even made in-person suggestions on live meetings yet I keep receiving a response of “not now”.
Read more →
Tomorrow’s Business Intelligence Platform
One of my favorite aspects about Microsoft is the company never stands still from a product development standpoint. The company is constantly driving innovation and releasing new products to the market.
Read more →
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.
Read more →
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.
Read more →
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.
Read more →
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.
Read more →
Business Intelligence (BI) systems exist for one sole purpose: to support improved organizational decision making. BI can be accomplished using a variety of techniques and solutions. There is however pros and cons of the various methods one can implement to support BI.
Read more →
With the arrival of SQL Server 2008 we gained access to a new feature called Change Data Capture (CDC). CDC enables you to constantly stream change data to a consuming process, most notably Extract, Transform, and Load (ETL) applications.
Read more →
Intro.
A recent project has forced me (which is a good thing) to learn both the internals of SSAS 2005 as well as various performance tuning techniques to get maximum performance out of the OLAP server.
Read more →
Business Intelligence projects (like software development projects) are prone to bad or completely absent planning prior to their start. Most of us that work in the technology industries are busy professionals that can never seem to find enough time.
Read more →
A common question I hear from my clients is “how much storage do we need?” Now wait a second, I thought storage was cheap these days right? Wrong, consumer storage is cheap; enterprise storage is still not what I would classify as cheap.
Read more →
As a follow up to some recent feedback (actually a question) here is some more in depth information on becoming proficient in the Microsoft Data Warehousing/Business Intelligence stack.
Get the terms straight Business Intelligence or BI is an umbrella term for various business processes, tools, and methodologies which support improved organizational decision making.
Read more →
Hope everyone is doing well out there. A good friend of mine across the pond mentioned that he has started to read a lot of my content across the blogs, my SQL Magazine Articles/BI Column, etc.
Read more →