Steve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. He also provides insights from the field on his blog at http://dataonwheels.wordpress.com.

Archives: June 2012

This will be the easiest entry in this series. This is a reblog of an article I wrote last year. Simple batch script to generate XMLA and deploy SSAS DB As I was working through some issues with my cube design, I realized that I wanted to deploy my SSAS…

I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”. I get the privilege to present on some awesome new technologies released in SQL Server 2012. Here are my sessions for this year’s Summit: A Window into Your Data: Using SQL…

The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services databases in Visual Studio, you often use target development server to validate the design and data with. This blog will focus on moving that development database to other environments and…

Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized that I wanted to deploy my SSAS databases using XMLA in SSMS. This can be easily scripted from SSMS, but I had not deployed the database yet. As a…

When in Portland… This week I am in Portland, Oregon working with a customer. While I was here, I thought about checking out a local user group. After going through the list of PASS groups in the Northwest, I found that the Eugene user group was meeting last night, June…