Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DataOnWheels

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.

Exploring Excel 2013 for BI Tip #1: Quick Explore

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 543 reads

Posted in DataOnWheels on 8 February 2013

Join Me at Modern Apps Live! Las Vegas

If you are familiar at all with Visual Studio Live! then you should check out this new conference.  At the Vegas conference, I am participating in this unique three-day event which is a series of sessions that build on each other as the conference progresses called Modern Apps Live! The… Read more

0 comments, 238 reads

Posted in DataOnWheels on 5 February 2013

Exploring Excel 2013 as Microsoft’s Business Intelligence Client

A little over six months ago, I wrote an article on Magenic.com about Excel 2013’s Impact for BI Users.  This coincided with the Office 2013 Preview release.  I discussed the addition of Power View and PowerPivot into the product.   Last week, I followed that article up with another on… Read more

2 comments, 525 reads

Posted in DataOnWheels on 4 February 2013

Are You Signed Up for 24 Hours of PASS–Business Analytics?

If you have not signed up for the 24 Hours of PASS-Business Analytics you should be.  This is a great chance to hear 12 speakers (they will be repeated in the following 12 hours).  Topics are varied from Big Data to Strategy to Collaboration.  Most importantly you can’t beat the… Read more

0 comments, 525 reads

Posted in DataOnWheels on 29 January 2013

Cultural Anthropology and Business Intelligence–A Tribute to Dr. Thomas C. Correll

A tribute is an expression of gratitude or praise. Last year I started a series about individuals who have impacted my career. I do this as a tribute to my father-in-law, Ed Jankowski who passed away a few years ago. Check out my original post about him and his impact… Read more

1 comments, 430 reads

Posted in DataOnWheels on 29 January 2013

PASSMN–Passing the Baton: A Board Transition Story

Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team.  I have been on the board for the past three years during which we switched term lengths to two years with staggered elections, but more about that later.

During the PASS Summit this… Read more

0 comments, 314 reads

Posted in DataOnWheels on 12 December 2012

PASS Summit 2012 Wrap Up

Wow, what a week. Once again, PASS put on a great event that provided much in the way of events and training for the SQL Server community. If you followed my countdown you know some of what I love about PASS. Last year I blogged everyday but I did not… Read more

1 comments, 332 reads

Posted in DataOnWheels on 13 November 2012

T-SQL Window Functions on LessThanDot and at SQL Saturday 149

Reblogged from Data on Wheels - Steve Hughes: I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions.  The enhancements to SQL Server 2012 in this area are phenomenal.  They solve a myriad of issues including calculating running totals with SQL.  Check it out if you…

Read more

0 comments, 314 reads

Posted in DataOnWheels on 12 November 2012

Countdown to PASS Summit 2012 – 1 to Go – See You There

IT’S MONDAY! You ready to enjoy the fun and to learn a bunch? I know I am. Besides my schedule of sessions, I also will be attending a series of meetings tomorrow on leading user groups from the Chapter Leader and Regional Mentor levels. Should be fun to collaborate with… Read more

0 comments, 321 reads

Posted in DataOnWheels on 5 November 2012

Countdown to PASS Summit 2012 – 2 to Go – I’m Presenting Again

I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions. If you are, enjoy them. Many are now in the process of traveling to the conference including myself. So, if you are still looking at the schedule, consider hitting one… Read more

0 comments, 290 reads

Posted in DataOnWheels on 4 November 2012

Countdown to PASS Summit 2012 – 3 to Go – Setting My Schedule

Three days to go. I need to get my schedule sorted out, how about you. What influences your schedule? Since this is my schedule, here are some of the things that influence my schedule choices: 1. When do I speak? J I have to make it to those sessions for…

Read more

0 comments, 321 reads

Posted in DataOnWheels on 3 November 2012

Countdown to PASS Summit 2012 – 4 to Go – SQL Karaoke, Really?

Four days to the Summit. Will you be singing? Last year was my first time attending SQL Karaoke. While I did not sing, it was a fun night and a great opportunity to have some fun with peers. Check out Jason Strate (@StrateSQL) and friends. This year there are two…

Read more

0 comments, 342 reads

Posted in DataOnWheels on 2 November 2012

Countdown to PASS Summit 2012 – 5 to Go – Communities in the Community

Just 5 days to Summit kick off. Today’s discussion is about communities within the community. That’s right. There is more to this community than meets the eye. Here are some examples which include some great opportunities at the conference. Local User Groups These communities are the heart of PASS. Without…

Read more

1 comments, 339 reads

Posted in DataOnWheels on 1 November 2012

Countdown to PASS Summit 2012 – 6 to Go – Magenic Brings 9

Getting closer, 6 days to Summit 2012! Today, I just have to give kudos out to Magenic, my current employer. You may have seen my #Meme15 post a while back on why I like my job. That post was about Magenic. Well, in this post, I wanted to talk about…

Read more

0 comments, 402 reads

Posted in DataOnWheels on 31 October 2012

Countdown to PASS Summit 2012 – 7 to Go – My First Summit Presentation

Seven days, one full week, until opening night at Summit 2012. Getting excited yet? In my first post of the series where I discussed my first Summit, I mentioned that I also spoke at that conference. In 2007, I was accepted to speak on the fairly new XML Data Type…

Read more

0 comments, 421 reads

Posted in DataOnWheels on 30 October 2012

Countdown to PASS Summit 2012 – 8 to Go – What Is PASS Anyway?

Eight days to go. So after going to my first conference, I was surprised that I did not know more about PASS at the local or national level. I had been involved with the Minnesota SQL Server User group from early on. However, the conference highlighted this national organization. When…

Read more

0 comments, 415 reads

Posted in DataOnWheels on 29 October 2012

Countdown to PASS Summit 2012 – 9 to Go – My First Summit

We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to put together a countdown blog series so here goes. My first blog is about my first PASS Summit. I attended my first PASS Summit in 2007 in Denver, Colorado. At…

Read more

0 comments, 288 reads

Posted in DataOnWheels on 28 October 2012

Using Word 2013 to Create Blog Entries

Over the past few years, I have used Windows Live Writer to create my blog entries on WordPress. Given the nature of Microsoft’s push to use Office for more including social and other online presence, I thought I would see if Word 2013 would actually work to create and edit…

Read more

2 comments, 415 reads

Posted in DataOnWheels on 26 October 2012

X-XMLA: vii. Partition Management with XMLA

In the 7th article of this series, I will discuss how to manage your partitions with XMLA.   We will be focused on the partition structures as opposed to partition processing which was covered in the previous post. Creating or altering a partition I have already discussed object creation with XMLA…

Read more

0 comments, 268 reads

Posted in DataOnWheels on 10 October 2012

T-SQL Window Functions on LessThanDot and at SQL Saturday 149

I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions.  The enhancements to SQL Server 2012 in this area are phenomenal.  They solve a myriad of issues including calculating running totals with SQL.  Check it out if you want to learn more and get some simple…

Read more

0 comments, 434 reads

Posted in DataOnWheels on 26 September 2012

Newer posts

Older posts