Craig Utley

Craig Utley (craig@solidq.com) is a mentor with Solid Quality Mentors and a former program manager with the SQL Customer Advisory Team at Microsoft. He is a SQL Server MVP and the operator of LearnMicrosoftBI.com.

Articles by Craig Utley
Avoid Common SQL Server Analysis Services Problems
It’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.
Creating Dimensions in SSAS, Part 2 4
After 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.
multi-color cubes
Creating Dimensions in SSAS, Part 1 2
Learn 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.
Unveiling PerformancePoint Server 2007
PerformancePoint 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.
Points to Ponder: Delivering BI to the Organization
Many 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.
Bring Cube Data into Focus
Reporting 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.
Delivering Analysis Services Data with Reporting Services
Learn how to use Reporting Services to give business users access to complex Analysis Services data--in a user-friendly format.
MDX for the MDX Phobic
If you don't have experience with MDX then Microsoft's Office Excel Add-in for SQL Server Analysis Services is for you.
Drillthrough on the Fly
Drillthrough 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.
Beating the Odds 1
A 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.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×