<![CDATA[Latest Content by Douglas McDowell]]>http://www.sqlmag.com/authors/author/author/5036456/rss/5036456en-USFri, 25 May 2012 10:27:31 GMTFri, 25 May 2012 10:27:31 GMT<![CDATA[Master Data Management Challenges]]>http://www.sqlmag.com/article/data-management/master-data-management-challenges
By Douglas McDowell
Microsoft is rebuilding Stratature’s MDM solution for release later this year, so it’s smart to start talking about MDM now.]]>
Douglas McDowellFri, 25 Jan 2008 00:00:00 GMThttp://www.sqlmag.com/article/data-management/master-data-management-challenges
<![CDATA[My PerformancePoint Server Wish List ]]>http://www.sqlmag.com/article/performance/my-performancepoint-server-wish-list-
By Douglas McDowell
Microsoft Office PerformancePoint Server 2007 can enhance your BI and BPM capabilities. But the product could be even better—here’s a wish list for new features and for how to integrate the various components of PPS in future releases.]]>
Douglas McDowellTue, 18 Dec 2007 00:00:00 GMThttp://www.sqlmag.com/article/performance/my-performancepoint-server-wish-list-
<![CDATA[A Total BI Solution from Dell and Microsoft]]>http://www.sqlmag.com/article/business-intelligence/a-total-bi-solution-from-dell-and-microsoft
By Douglas McDowell
A Total BI Solution from Dell and Microsoft]]>
Douglas McDowellMon, 12 Nov 2007 00:00:00 GMThttp://www.sqlmag.com/article/business-intelligence/a-total-bi-solution-from-dell-and-microsoft
<![CDATA[Can’t Wait for SQL Server 2008!]]>http://www.sqlmag.com/article/sql-server-2005/can-t-wait-for-sql-server-2008-
By Douglas McDowell
Maybe it’s not too soon for SQL Server 2008, especially when you consider how 2008 offers strong BI enhancements in three key areas: Reporting Services, Database Services, and operational management.]]>
Douglas McDowellThu, 25 Oct 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2005/can-t-wait-for-sql-server-2008-
<![CDATA[2007 PASS Community Summit and PerformancePoint 2007 Launch]]>http://www.sqlmag.com/article/sql-server/2007-pass-community-summit-and-performancepoint-2007-launch
By Douglas McDowell
2007 PASS Community Summit and PerformancePoint 2007 Launch]]>
Douglas McDowellTue, 25 Sep 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/2007-pass-community-summit-and-performancepoint-2007-launch
<![CDATA[4 Darn Good Reasons for Not Building Cubes on Transactional Systems]]>http://www.sqlmag.com/article/data-management/4-darn-good-reasons-for-not-building-cubes-on-transactional-systems
By Douglas McDowell
Don’t build that cube! OLTP–based cubes are usually poorly designed for BI and contain dirty data. Still not convinced? There’s more.]]>
Douglas McDowellThu, 20 Sep 2007 00:00:00 GMThttp://www.sqlmag.com/article/data-management/4-darn-good-reasons-for-not-building-cubes-on-transactional-systems
<![CDATA[Reasons Why You Might Think You Should Build a Cube on a Transactional Data Model]]>http://www.sqlmag.com/article/data-modeling/reasons-why-you-might-think-you-should-build-a-cube-on-a-transactional-data-model
By Douglas McDowell
SSAS lets developers create OLAP cubes based on relational data models that aren’t designed for BI. Does this mean you should build a cube? No, but here are some reasons why you might think you should.]]>
Douglas McDowellThu, 20 Sep 2007 00:00:00 GMThttp://www.sqlmag.com/article/data-modeling/reasons-why-you-might-think-you-should-build-a-cube-on-a-transactional-data-model
<![CDATA[Back-to-Back SQL Server 2008 CTPs]]>http://www.sqlmag.com/article/sql-server/back-to-back-sql-server-2008-ctps
By Douglas McDowell
Back-to-Back SQL Server 2008 CTPs]]>
Douglas McDowellFri, 24 Aug 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/back-to-back-sql-server-2008-ctps
<![CDATA[What's the Best Way to Carve Up a SAN?]]>http://www.sqlmag.com/article/san/what-s-the-best-way-to-carve-up-a-san-
By Douglas McDowell
Your SAN engineer might not know the finer points of BI database storage. To stave off trouble, you need to be involved in the SAN configuration process. ]]>
Douglas McDowellWed, 22 Aug 2007 00:00:00 GMThttp://www.sqlmag.com/article/san/what-s-the-best-way-to-carve-up-a-san-
<![CDATA[Is BI Agnosticism Always Best?]]>http://www.sqlmag.com/article/sql-server/is-bi-agnosticism-always-best-
By Douglas McDowell
Is BI Agnosticism Always Best?]]>
Douglas McDowellMon, 23 Jul 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/is-bi-agnosticism-always-best-
<![CDATA[SQL Server 2008 CTP1: BI Is Coming, We Promise]]>http://www.sqlmag.com/article/business-intelligence/sql-server-2008-ctp1-bi-is-coming-we-promise
By Douglas McDowell
SQL Server 2008 CTP1: BI Is Coming, We Promise]]>
Douglas McDowellFri, 22 Jun 2007 00:00:00 GMThttp://www.sqlmag.com/article/business-intelligence/sql-server-2008-ctp1-bi-is-coming-we-promise
<![CDATA[Microsoft's First-ever BI Conference Was a Success ]]>http://www.sqlmag.com/article/business-intelligence/microsoft-s-first-ever-bi-conference-was-a-success-
By Douglas McDowell
Microsoft’s First-ever BI Conference Was a Success ]]>
Douglas McDowellMon, 18 Jun 2007 00:00:00 GMThttp://www.sqlmag.com/article/business-intelligence/microsoft-s-first-ever-bi-conference-was-a-success-
<![CDATA[PerformancePoint Server CTP2 Introduces "Planning"]]>http://www.sqlmag.com/article/sql-server/performancepoint-server-ctp2-introduces-planning-
By Douglas McDowell
PerformancePoint Server CTP2 Introduces "Planning"]]>
Douglas McDowellFri, 20 Apr 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/performancepoint-server-ctp2-introduces-planning-
<![CDATA[Do You Know Your MVPs?]]>http://www.sqlmag.com/article/sql-server/do-you-know-your-mvps-
By Douglas McDowell
Do You Know Your MVPs?]]>
Douglas McDowellSat, 24 Mar 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/do-you-know-your-mvps-
<![CDATA[Sleeper BI]]>http://www.sqlmag.com/article/business-intelligence/sleeper-bi
By Douglas McDowell
Sleeper BI]]>
Douglas McDowellMon, 26 Feb 2007 00:00:00 GMThttp://www.sqlmag.com/article/business-intelligence/sleeper-bi
<![CDATA[Microsoft BI: Not Just for SQL Server Anymore? ]]>http://www.sqlmag.com/article/business-intelligence/microsoft-bi-not-just-for-sql-server-anymore-
By Douglas McDowell
Microsoft BI: Not Just for SQL Server Anymore? ]]>
Douglas McDowellMon, 05 Feb 2007 00:00:00 GMThttp://www.sqlmag.com/article/business-intelligence/microsoft-bi-not-just-for-sql-server-anymore-
<![CDATA[‘Tis the season for CTPs: PerformancePoint Server 2007 CTP1]]>http://www.sqlmag.com/article/sql-server/-tis-the-season-for-ctps-performancepoint-server-2007-ctp1
By Douglas McDowell
‘Tis the season for CTPs: PerformancePoint Server 2007 CTP1]]>
Douglas McDowellThu, 21 Dec 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/-tis-the-season-for-ctps-performancepoint-server-2007-ctp1
<![CDATA[One-year Anniversary for SQL Server 2005: CTP for SP2]]>http://www.sqlmag.com/article/sql-server/one-year-anniversary-for-sql-server-2005-ctp-for-sp2
By Douglas McDowell
One-year Anniversary for SQL Server 2005: CTP for SP2]]>
Douglas McDowellMon, 27 Nov 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/one-year-anniversary-for-sql-server-2005-ctp-for-sp2
<![CDATA[Using a Custom Data Extension to Solve a Reporting Services Problem ]]>http://www.sqlmag.com/article/sql-server/using-a-custom-data-extension-to-solve-a-reporting-services-problem-
By Douglas McDowell
Using a Custom Data Extension to Solve a Reporting Services Problem ]]>
Douglas McDowellTue, 21 Nov 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/using-a-custom-data-extension-to-solve-a-reporting-services-problem-
<![CDATA[Get Ready for BI at TechEd 2006 ]]>http://www.sqlmag.com/article/sql-server/get-ready-for-bi-at-teched-2006-
By Douglas McDowell
Get Ready for BI at TechEd 2006 ]]>
Douglas McDowellTue, 21 Nov 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/get-ready-for-bi-at-teched-2006-