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.

Part2 Adding a New CheckBox – Create your own SQL tools with PowerShell and Windows forms

Steve:

This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for the management of a large number of SQL Server instances.

Originally posted on JamesDataTechQ:

This blog post is about adding a new CheckBox to the SQL Tool…

Read more

0 comments, 5,989 reads

Posted in DataOnWheels on 14 January 2015

Intro to Data Factory–Training on the T’s Follow Up Post

This is a follow up blog post based on the Intro to Data Factory session I gave on the Training on the T’s with Pragmatic Works. Find more free training from the past and upcoming here. I did my session on January 13, 2015.

 Intro To Data Factory

In… Read more

0 comments, 409 reads

Posted in DataOnWheels on 13 January 2015

She Taught Me to Code–A Tribute to Sheila, My Wife

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 five years ago this past December (2014). Check out my original… Read more

1 comments, 259 reads

Posted in DataOnWheels on 12 January 2015

2014 Year In Review

As is our want, we must look back over the past year to see what happened. While I normally focus on work related items, this year was a crazy year for our family as well as my career. So let’s have a look at what happened this year.

Traveling Family

Read more

0 comments, 169 reads

Posted in DataOnWheels on 11 January 2015

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, 6,251 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, 444 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,777 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, 371 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, 280 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, 198 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, 237 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, 192 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, 10,028 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, 563 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, 238 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, 447 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, 938 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, 407 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, 3,105 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, 257 reads

Posted in DataOnWheels on 18 June 2014

Newer posts

Older posts