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.

Create your own SQL Tools with PowerShell and Windows Forms

Steve:

Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us how to create your very own SQL tool using PowerShell and Windows Form.

Originally posted on JamesDataTechQ:

By combining PowerShell and Windows Forms you can create your…

Read more

0 comments, 5,173 reads

Posted in DataOnWheels on 3 December 2014

Power Testing ETL with Power BI – Creating the Tests with Power Pivot

This is the second deep dive into Power Testing ETL with Power BI. At this point, we have created the source table which will be used in our testing. The next step is to bring in the destination table and create the tests that will be “run” against the… Read more

0 comments, 128 reads

Posted in DataOnWheels on 13 November 2014

Power Testing ETL with Power BI – Shaping The Data with Power Query and Power Pivot

This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to build out the test cases. In the previous post, you were able to get a sense of the bigger picture and how the pieces work together. This post will… Read more

1 comments, 6,286 reads

Posted in DataOnWheels on 12 November 2014

Power Testing ETL with Power BI – The Process

This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on this subject at few SQL Saturdays over the past few years and am finally succumbing to multiple request to turn it into a blog post. Realizing the amount of content… Read more

2 comments, 192 reads

Posted in DataOnWheels on 11 November 2014

Creating a SharePoint Server Farm on Azure from the Gallery

As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help troubleshoot an issue that was working with SharePoint Excel Services and it couldn’t be done in Office365. So, my first attempt was to grab the SharePoint Server 2013 Trial from… Read more

0 comments, 182 reads

Posted in DataOnWheels on 16 October 2014

Lync 2013 Video Issues on Windows 8

Part of the reason I have a blog is to document issues and resolutions I do not want to forget. Yesterday morning I was on two calls using Lync and the video was blank or white. I had great audio and messaging worked fine. So the only part that was… Read more

0 comments, 119 reads

Posted in DataOnWheels on 15 October 2014

Temporary Post Used For Theme Detection (919ceef8-1031-4873-93f5-7a833585812f – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (e5bad5db-3b7d-4641-ba91-15ab900e8f70 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)


Read more

0 comments, 148 reads

Posted in DataOnWheels on 9 October 2014

The Only Constant Is Change

In March of this year, I celebrated 10 years at Magenic. I blogged about it and called out values and reasons for staying (Ten Years and Counting …). Now, I am writing to talk about my departure from Magenic. I can start by saying the decision to leave… Read more

2 comments, 113 reads

Posted in DataOnWheels on 5 October 2014

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,651 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, 307 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, 178 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, 244 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, 382 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, 248 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,762 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, 181 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, 207 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, 212 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, 208 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, 615 reads

Posted in DataOnWheels on 12 March 2014

Older posts