Greetings All & Happy Pre-New Year!
I try my best to only write blog posts when they are informative and add potential value, thus it has been a while since I've blogged.
Read more →
This morning I passed my next exam, 70-455. This exam is the upgrade to SQL Server 2008 for existing MCITP BI professionals on SQL Server 2005. The exam's corresponding study guide can be found here: http://www.
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 →
I have been working with Microsoft SQL Server for close to ten years now if you include my college days (yes, my college used SQL Server 7.0 for learning RDBMS purposes).
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 →
My friends over at SQL Server Magazine posted this today...SQL Server 2008 RTM!
http://www.sqlmag.com/Article/ArticleID/99953/99953.html
Microsoft continues to up the 'ante' in the Business Intelligence space, cheers.
Update:
Official Press Release:
Read more →
One of my favorite things to do each month is write SQL ServerMagazine's Essential BI column. I write two posts for the column each month. About a month ago I started to focus on SharePoint for Business Intelligence (BI) topics.
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 →
Well, the new SQL Server2008 build Release Candidate 0 (RC0) has been available for a bit now and I have had some time with the new build. The word "build" brings up a good point actually, before we go any further I want to review the last few SQL Server 2008version numbers.
Read more →
Fellow SQL Friends, a colleague of mine notified me today of SQL 2008 (June) RC0's availability at:
SQL Server 2008 RC0: http://www.microsoft.com/downloads/details.aspx?FamilyId=35F53843-03F7-4ED5-8142-24A4C024CA05&displaylang=en
SQL Server 2008 RC0 Feature Pack: http://www.microsoft.com/downloads/details.aspx?FamilyId=089A9DAD-E2DF-43E9-9CD8-C06320520B40&displaylang=en
Cheers
Read more →
With the impending arrival of Microsoft SQL Server 2008 come several new enhancements. These enhancements can be categorized as new capabilities, old constraints removed, and improvements in scalability. In the SQL Server community (including this blog) you can find numerous amounts of information on the new features found in SQL Server 2008…however you seldom see much on deprecated features.
Read more →
Before I get into this new SQL Server 2008 feature I want to briefly review why we have a new command-line in the Windows platform…In the current Windows ‘landscape’ we have a variety of technologies that can be used to programmatically administer various Windows data stores: 1.
Read more →
Finally, we have a Data Profiling Utility w/SQL Server !!!
With SQL Server Integration Services (SSIS) 2008 you will have access to the new Data Profiler task. The SSIS 2008 Data Profiler Task is an easy and effective method to profile your target source systems (tables & views) prior to building ETL solutions consuming their data.
Read more →
Do you find that fulltime MCTs (and other teachers) are somewhat limited in their value to students? To me...all teachers should be practicing in the REAL WORLD what they are educating others on!
Read more →
Long time no blog!
I authored this month's (May 08') cover story on an interesting topic...Does SQL Server 2008 BI enhancements warrant an upgrade? It is quite the question and to be honest I dont think a 'one size fits all' reply would do the question justice AT ALL!
Read more →
With the upcoming arrival of SQL Server 2008, the topic of CLR Integration (SQLCLR) is coming up alot again. Probably the biggest reason to use SQLCLR is to replace existing Extended Stored Procedures (XPs).
Read more →