http://www.sqlmag.com/authors/author/author/5535175/rss/5535175en-USFri, 25 May 2012 11:11:53 GMTFri, 25 May 2012 11:11:53 GMThttp://www.sqlmag.com/article/net-framework2/moving-from-ado-to-ado-netJust when we were getting used to ADO, Microsoft tells us toforget about it and start learning ADO.NET. Craig Utley maps the differencesbetween ADO and ADO.NET.]]>Craig UtleyFri, 30 Oct 2009 12:09:11 GMThttp://www.sqlmag.com/article/net-framework2/moving-from-ado-to-ado-nethttp://www.sqlmag.com/article/visual-basicnet/vb-net-vs-cYou’re ready to start coding your first ASP.NET page. Whatlanguage do you use? Craig Utley gives us the lowdown on these two .NET programminglanguages.]]>Craig UtleyFri, 30 Oct 2009 12:09:11 GMThttp://www.sqlmag.com/article/visual-basicnet/vb-net-vs-chttp://www.sqlmag.com/article/aspnet2/what-is-netCraig Utley addressestwo key areas of .NET: the underlying .NET Framework and the ability to createdistributed applications.]]>Craig UtleyFri, 30 Oct 2009 12:09:11 GMThttp://www.sqlmag.com/article/aspnet2/what-is-nethttp://www.sqlmag.com/article/data-management/avoid-common-sql-server-analysis-services-problemsIt’s easy to create a usable and high-performance set of cubes with SSAS as long as you know the pitfalls to watch out for and possess the patience and savvy to thwart them.]]>Craig UtleyFri, 21 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/data-management/avoid-common-sql-server-analysis-services-problemshttp://www.sqlmag.com/article/data-management/creating-dimensions-in-ssas-part-1Learn how to build proper dimensions, add useful hierarchies that support user’s navigational needs, then perform the important step of adding attribute relationships to make your users’ data analysis fast and easy. ]]>Craig UtleyTue, 29 Apr 2008 00:00:00 GMThttp://www.sqlmag.com/article/data-management/creating-dimensions-in-ssas-part-1http://www.sqlmag.com/article/data-management/creating-dimensions-in-ssas-part-2After you build the proper dimensions of a cube, you need to add attribute relationships to help the cube engine better process queries for faster data analysis. ]]>Craig UtleyTue, 29 Apr 2008 00:00:00 GMThttp://www.sqlmag.com/article/data-management/creating-dimensions-in-ssas-part-2http://www.sqlmag.com/article/performance/unveiling-performancepoint-server-2007PerformancePoint Server 2007 might be in your future, especially if your users find out about its BI features. Get the lowdown before they do about the 3 parts of PerformancePoint Server, what it needs to run, and what exactly it delivers. ]]>Craig UtleyFri, 25 Jan 2008 00:00:00 GMThttp://www.sqlmag.com/article/performance/unveiling-performancepoint-server-2007http://www.sqlmag.com/article/data-access/points-to-ponder-delivering-bi-to-the-organizationMany options exist for delivering BI data to end users. Here are some important considerations to keep in mind as you choose the delivery tools for the various users you serve. ]]>Craig UtleyFri, 23 Feb 2007 00:00:00 GMThttp://www.sqlmag.com/article/data-access/points-to-ponder-delivering-bi-to-the-organizationhttp://www.sqlmag.com/article/tsql3/bring-cube-data-into-focusReporting Services gives you an inexpensive way to deliver Analysis Services data to business users. Here’s how you can provide greater flexibility in your reports so users can easily change the ways they view BI data.]]>Craig UtleyWed, 23 Aug 2006 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/bring-cube-data-into-focushttp://www.sqlmag.com/article/sql-server-analysis-services/delivering-analysis-services-data-with-reporting-servicesLearn how to use Reporting Services to give business users access to complex Analysis Services data--in a user-friendly format.]]>Craig UtleyThu, 22 Jun 2006 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/delivering-analysis-services-data-with-reporting-serviceshttp://www.sqlmag.com/article/administration-tools2/mdx-for-the-mdx-phobicIf you don’t have experience with MDX then Microsoft’s Office Excel Add-in for SQL Server Analysis Services is for you.]]>Craig UtleyMon, 08 May 2006 00:00:00 GMThttp://www.sqlmag.com/article/administration-tools2/mdx-for-the-mdx-phobichttp://www.sqlmag.com/article/quering/drillthrough-on-the-flyDrillthrough lets you look at the individual records in a cube, but you can’t modify a drillthrough query on the fly. You can create a drillthrough report, then use a cell-level action to call the report and pass the parameters.]]>Craig UtleyTue, 22 Mar 2005 00:00:00 GMThttp://www.sqlmag.com/article/quering/drillthrough-on-the-flyhttp://www.sqlmag.com/article/data-access/beating-the-oddsA well-designed data warehouse can help your organization make faster and more informed decisions, but data-warehousing projects are risky business. Here’s why so many data-warehousing projects fail and how to increase your project’s chances for success.]]>Craig UtleyTue, 22 Jun 2004 00:00:00 GMThttp://www.sqlmag.com/article/data-access/beating-the-odds