-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

Thoughts about the Microsoft Data Amp Announcements

Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL Server on premises and data platforms in Azure (such as Azure SQL DB and Azure Data Lake). Some of these include features that I have been waiting to see. Here… Read more

2 comments, 1,112 reads

Posted in DataOnWheels on 20 April 2017

Power BI and Data Security – Row Level Security (RLS)

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security available with their data. Companies… Read more

1 comments, 1,252 reads

Posted in DataOnWheels on 14 April 2017

Power BI and Data Security – Data Classification and Privacy Levels

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security available with their data. Companies… Read more

2 comments, 288 reads

Posted in DataOnWheels on 13 April 2017

Power BI and Data Security – On-premises Data Gateway

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security available with their data. Companies… Read more

1 comments, 452 reads

Posted in DataOnWheels on 12 April 2017

Power BI and Data Security – Sharing Data

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security available with their data. Companies… Read more

4 comments, 545 reads

Posted in DataOnWheels on 11 April 2017

Power BI and Data Security – Compliance and Encryption

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security available with their data. Companies… Read more

0 comments, 1,159 reads

Posted in DataOnWheels on 10 April 2017

T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT

Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.

Splitting Strings in SQL

A problem that has plagued SQL developers through the years is splitting strings. Many techniques have been used as more capabilities were added to SQL Server including XML datatypes, recursive CTEs and even CLR. I have… Read more

3 comments, 184 reads

Posted in DataOnWheels on 14 February 2017

Consumption Based Architecture for Modern Data Analytics

Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data in one location so it could be easily consumed by reporting and analysis tools from SQL Server Reporting Services to Microsoft Excel. We have followed the dimensional modeling processes promoted… Read more

4 comments, 349 reads

Posted in DataOnWheels on 9 February 2017

North Texas SQL Server User Group – September 2016 Follow

Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any… Read more

0 comments, 200 reads

Posted in DataOnWheels on 19 September 2016

Power BI Is Finally in the Azure Trust Center

With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI security and compliance as it relates to various customer needs. I do a lot of work with financial, energy, and medical customers.… Read more

0 comments, 2,196 reads

Posted in DataOnWheels on 28 April 2016

JSON in SQL Server 2016 – The Good, The Bad, and The Ugly

Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see this functionality coming. As an early user of XML when it was introduced, my expectations were high. Microsoft has done some really good work with JSON support, but I find… Read more

0 comments, 414 reads

Posted in DataOnWheels on 20 April 2016

SQL Saturday #492 Follow Up – A Window into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post… Read more

0 comments, 270 reads

Posted in DataOnWheels on 16 April 2016

VS Live 2016 – Las Vegas Follow Up

I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were available for attendees, the code was not distributed yet as an oversight on my part. In this post, I will do a quick summary of the sessions and… Read more

0 comments, 220 reads

Posted in DataOnWheels on 11 April 2016

SQL Saturday #486 Richmond – A Window Into Your Data

 

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session… Read more

0 comments, 293 reads

Posted in DataOnWheels on 19 March 2016

Excel Tip #30: Excel Services Visual Limitations – Displaying Images

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 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

1 comments, 1,414 reads

Posted in DataOnWheels on 4 March 2016

Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)

On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group.  This session is based on five blog posts that I created in August 2015.

You can find the presentation here: Powering Up HDInsight with Power BI (pdf).

The details can be found in the… Read more

0 comments, 350 reads

Posted in DataOnWheels on 4 February 2016

Five Years, A Quiet Quarter, A Look Ahead to 2016

Five Years of Blogging

From to

My blogging story started on December 7, 2010. I have now had a blog for over 5 years. I want to thank all of you who have read my blog and interacted with me through it. You have seen me change the theme… Read more

1 comments, 308 reads

Posted in DataOnWheels on 18 January 2016

Boston BI User Group Meeting–Dashboard Design with Microsoft: Power BI vs Datazen (10/13/15)

Thanks for joining Anthony Martin (@SQLMartini) and I at the Boston BI User Group Meeting in October. During the session, we demo’d and built dashboards in Power BI Desktop and Datazen Publisher.

Power BI

www.powerbi.com

Couple of thoughts from our demo:

  • Power BI is a way to get…

Read more

0 comments, 2,238 reads

Posted in DataOnWheels on 20 October 2015

SQL Saturday #437–Boston BI Edition 2015–You Can Still Analyze Data with T-SQL

Thanks for attending my session on analyzing data with TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post… Read more

2 comments, 344 reads

Posted in DataOnWheels on 17 October 2015

SQL Saturday #453–Minnesota 2015–A Window Into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post… Read more

0 comments, 312 reads

Posted in DataOnWheels on 10 October 2015

Older posts