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.

T-SQL Window Functions – Part 4: Analytic Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links to the original blogs on my Series page.

In the final installment of my series on SQL window functions, we will explore using analytic functions. Analytic functions were introduced… Read more

0 comments, 9,474 reads

Posted in DataOnWheels on 17 July 2014

T-SQL Window Functions – Part 3: Aggregate Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links to the original blogs on my Series page.

This is part 3 in my series on SQL window functions. In this post, we will explore using aggregation functions with… Read more

0 comments, 184 reads

Posted in DataOnWheels on 7 July 2014

Happy Independence Day America and 10 Years Packt Publishing!

 

 

If you are in the USA, I hope you take some time today to enjoy your family and friends and see some fireworks.

 

Packt Publishing Celebrates 10 Years – $10 eBooks and Videos

This month marks 10 years since Packt Publishing embarked on its mission to deliver… Read more

0 comments, 142 reads

Posted in DataOnWheels on 4 July 2014

T-SQL Window Functions – Part 2: Ranking Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links to the original blogs on my Series page.

This is part 2 in my series on SQL window functions. In this post, we will explore using ranking functions. SQL… Read more

0 comments, 154 reads

Posted in DataOnWheels on 26 June 2014

T-SQL Window Functions – Part 1: The OVER() Clause

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links to the original blogs on my Series page.

SQL Window functions were introduced in SQL Server 2005. At the time, only a small set of functionality was available. Window… Read more

0 comments, 236 reads

Posted in DataOnWheels on 26 June 2014

Exploring Excel 2013 for BI Tip #16: Exposing “Values” from a Tabular Model

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, 177 reads

Posted in DataOnWheels on 19 June 2014

Exploring Excel 2013 for BI Tip #15: Locking Slicer Position

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

1 comments, 2,590 reads

Posted in DataOnWheels on 18 June 2014

A Month, Almost Two Months Offline–Was the Silence Deafening?

The past couple of months has been very busy at home and at work so I have fallen behind a bit on my blogging. The big event was the graduation of my oldest child, Kristyna, from Burnsville High School. It was our first grad party and a lot had to… Read more

0 comments, 132 reads

Posted in DataOnWheels on 18 June 2014

Techfuse, a New Laptop, and How Microsoft Azure Helped Save the Day

On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a session on the differences between tabular and multidimensional models with a focus on the developer’s experience. My deck has ten  slides including title, references, and bio. The rest of the… Read more

2 comments, 162 reads

Posted in DataOnWheels on 24 April 2014

Oracle Tips for MSBI Devs #6: Supporting SSAS Tabular Development

As SQL Server Analysis Services Tabular Models become more popular, models will use Oracle databases as sources. One of the key issues whenever you work with Oracle is understanding how to properly configure the necessary components to enable development.

Getting Started

If you have worked with Oracle before, you are… Read more

0 comments, 136 reads

Posted in DataOnWheels on 14 April 2014

Ten Years and Counting …

On March 8, 2014, I reached ten years of service at Magenic Technologies. When I started in 1999 (don’t do the math just yet), Magenic had only been around a few years and it was my first consulting job. I stayed at Magenic for about 5 1/2 years. During that… Read more

2 comments, 150 reads

Posted in DataOnWheels on 14 March 2014

Setting Up Tabular Models on Windows Azure

In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were questions about using SQL Server Analysis Services (SSAS) tabular models with Azure. This post will walk through setting up an Azure VM and deploy a tabular model to that… Read more

0 comments, 489 reads

Posted in DataOnWheels on 12 March 2014

Oracle Tips for MSBI Devs #5: Working with Oracle on Windows Azure

As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work with Oracle through the years while delivering BI solutions. One of the pain points of working with Oracle in development is setting up an Oracle development server. Even though… Read more

0 comments, 62 reads

Posted in DataOnWheels on 24 February 2014

Rochester – Welcome to the PASS MN Family

It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At the time, Paul Timmerman ( T | B ) and I were discussing the fact that only one user group existed in Minnesota. As we looked at other areas and… Read more

0 comments, 141 reads

Posted in DataOnWheels on 23 January 2014

Work Ethic and Family – A Tribute to My Parents

A tribute is an expression of gratitude or praise. A couple of years ago, 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… Read more

1 comments, 141 reads

Posted in DataOnWheels on 9 January 2014

Exploring Excel 2013 for BI Tip #14: Sparklines and Pivot Tables

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

2 comments, 208 reads

Posted in DataOnWheels on 7 January 2014

2013 – A Year In Review

It is in our nature as humans to look back in order to understand where we have been.

Warning – some of this blog contains stuff about my family… In case you only want the technical stuff.

Family Fun

This past year has been very interesting for me personally and… Read more

1 comments, 217 reads

Posted in DataOnWheels on 3 January 2014

Exploring Excel 2013 for BI Tip #13: Connecting Slicers in Pivot Tables Sourced from a Power Pivot Model

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

1 comments, 203 reads

Posted in DataOnWheels on 17 December 2013

Exploring Excel 2013 for BI Tip #12: Icon Sets

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

1 comments, 1,432 reads

Posted in DataOnWheels on 3 December 2013

Traveling, Talking, and a PASS Attack Have Happened

Well, this fall has been crazy. As you may have noted from a couple of my previous posts, link to speaking and pass attack, I have been busy this fall. With multiple speaking engagements and additional travel for work, I have been on the road more than I have been… Read more

0 comments, 140 reads

Posted in DataOnWheels on 1 December 2013

Older posts