SQLSaturday #674 - Phoenix - BI 2017

Event Date: 09/23/2017 00:00:00

Event Location:

  • Galvanize
  • 515 E Grant St
  • Phoenix, Arizona

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: Move You SQLServer Database to “The Cloud” with Almost No Downtime

Abstract: In this presentation, we’ll review “What is ‘the Cloud’” and then describe the different methods you can use to migrate your on-premise SQLServer databases into this new environment. We’ll cover migrations to both infrastructure and database as a service. We’ll describe in detail how the use of a database replication tool can help you migrate your databases to the cloud with almost no downtime, and reduce the risk of data loss. We’ll also show you how you can use replication after migration to keep on-premise and cloud databases synchronized, which can help you migrate to the cloud in phases, rather than all at once.

Speaker(s):

  • Clay Jackson

Track and Room: Cloud Application Development Deployment - Pinal


Title: The first ever SQL Server Drone controlled by Server less Architecture in Azure

Abstract: Using the latest version of SQL Server 2017 , we will control a Drone using NodeJS and with the help of Azure SQL DB , IoT Hub and Azure Bots we will create a continuous integration pipeline .

Join me in a presentation on how to create your Azure environment for server less Architecture the first ever drone controlled by SQL Server.

  • creating a template to make Proof of Concepts possible
  • real world situations and lessons learned in Azure situations
  • consumption of that data through Power BI.

This presentation will include using Azure SQL DB to call commands to the drone through Raspberry Pi 3, then we will use serverless architecture to connect a cortana channel to make those calls to azure bots which write to the azure sql db, producing seemless intergration with out any on-prem solution.

Continuous development is done through github and Heroku to provide on demand fixes w the drone is still flying.

The future of fast and the furious IoT development coupled wi

Speaker(s):

  • Joseph Barth

Track and Room: Analytics and Visualization - Amphitheater


Title: Managing SSRS Reports using PowerShell and SSRS Web Services

Abstract: When you have to do something more than once, you should script it! That’s true for SQL Server maintenance tasks. It’s also important for Business Intelligence projects as well. Microsoft has provided web services to manage your reporting service and to download reports in various forms. In this session I demonstrate how to leverage these web services from PowerShell to handle common SSRS administrative tasks: uploading and copying a report; checking the parameter values, setting the parameter defaults, scheduling a cache refresh. I addition, I demonstrate how to download a report top PDF using PowerShell. You will not only come away with a set of PowerShell scripts to manage your SSRS server, you will learn how to work around some of the less intuitive features of PowerShell to use and extend these scripts.

Speaker(s):

  • Russel Loski

Track and Room: BI Platform Architecture, Development Administration - Pinal


Title: Querying Semistructured Data in Azure Data Lake with USQL

Abstract: Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.

Speaker(s):

  • Russel Loski

Track and Room: Cloud Application Development Deployment - Pinal


Title: Advanced Analytics with SQL Server 2017 and Python

Abstract: Looking to find out what is coming next with SQL Server? Thinking about learning a new analytical language to keep up with market demand? You will want to attend this session. SQL Server 2016 added R to the analytical toolset and SQL Server 2017 is adding Python. When looking at various lists of the most popular programming languages, Python always has one of the top positions. This session provides an introduction to Python, including why it is a good choice for analyzing data.
If you have not had a chance to review SQL Server 2017 yet, please attend to see some of the new changes coming later this year. One of the features covers will show what is needed to incorporate Python into SQL Server and how Python can be incorporated in stored procedures to provide the ability to analyze data using arguably the most popular programming language to review data.

Speaker(s):

  • Ginger Grant

Track and Room: Advanced Analysis Techniques - Amphitheater


Title: The 10 Commandments of ETL

Abstract: ETL (Extract, Transform Load) processes are fundamentally important in any data warehouse environment, and there are many different ways in which to develop the components.

In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I’m sure it will work for you too!!

Speaker(s):

  • Martin Schoombee

Track and Room: BI Platform Architecture, Development Administration - Skyline


Title: Rounding The Polybases

Abstract: This session with cover the basics of setup, architecture, configuration, and a brief demo of a SQL Server Polybase instance utilizing an Azure Blob Storage service for a data repository.

Speaker(s):

  • Nathan Strack

Track and Room: BI Platform Architecture, Development Administration - Pinal


Title: Power BI: What you need to know

Abstract: This session will explore every aspect of Power BI…from the technology used behind the scenes and the tenant/service in Azure, to data refresh options and development best practices. We’ll cover everything you need to know (and more) before you embark on your first Power BI project.

Speaker(s):

  • Martin Schoombee

Track and Room: Analytics and Visualization - Skyline


Title: The journey to data viz

Abstract: You probably have been part of this scenario before…the business needs to answer question Z, without knowing ABC… We will walk you through the steps we follow to efficiently reach the desired outcome.

Steps:

  1. Identify sources of data
  2. Data profiling
  3. Data cleansing / Business rules
  4. Data visualizations (Tableau)
  5. Rinse and repeat

P.S - Oh i forgot to say that the business wanted it yesterday. By the end of the session we will outline a frame work that you can adapt to your use case.

All are welcomed to attend the session. Ann is a world class data viz creator with many years of experience and I love to share data solutions.

We both are open to answering questions related to this topic.

Speaker(s):

  • Ricardo Mawcinitt

Track and Room: Analytics and Visualization - Skyline


Title: Data Modeling for the Modern Enterprise

Abstract: Explore data modeling and process modeling.

Enterprise Data Model Conceptual Data Model Logical Data Model Physical Data Model Star Schema Data Model Business Process Model

Modeling Tools: IDERA ER/Studio Data Architect ERWin Visual Studio Visio

Speaker(s):

  • Ryan Casey

Track and Room: BI Platform Architecture, Development Administration - Amphitheater


Title: Leverage Docker for Hosting SQL Server and Beyond

Abstract: Docker has gained a great deal of traction over the past five years, and as of recently, it managed to find a new home in the Microsoft and SQL Server communities. In this session, we will cover the basics of Docker in regard to hosting SQL Server. We will also cover the benefits of Docker in concern to managing your Business Intelligence workloads.

Speaker(s):

  • Chris Myers

Track and Room: Application Database Development - Skyline


Title: Introduction to Python for Data Science

Abstract: Learn Python and also some of the libraries that make it awesome for Data Science! In this talk we will briefly discuss the Python language and get you started using Python. We will also touch on useful tools, best practices, and libraries specifically for aspiring data scientists.

Speaker(s):

  • Chris Huie

Track and Room: BI Information Delivery - Amphitheater


Title: Implementing R in SQL Server 2016

Abstract: Since Microsoft incorporated the R language into SQL Server 2016, there has been a lot of interest in learning not only R, but how incorporating R into SQL Server can provide a greater level of analysis through the use of the complex analytical methods R provides. This session will show how to run R on SQL Server 2016, learn about the internals for how R runs within SQL Server, and cover in depth the settings which should be set to optimally run R on SQL Server. This session will also show some R code to handle some tasks which DBAs now use other tools to complete.

Speaker(s):

  • Ginger Grant

Track and Room: Application Database Development - Pima


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Ryan Casey

Twitter: - @AimYourData

LinkedIn: Ryan Casey

Contact: https://www.AimYourData.com/

Microsoft Data Platform MVP, Public Speaker, and Group Moderator

SQLSaturday Speaker @ • Houston, TX 2018 • Dallas, TX 2018, 2017 (BI), 2016, 2015 • Phoenix, AZ 2018, 2017 (BI) • Kansas City, MO 2017 • Baton Rouge, LA 2017 • Oklahoma City, OK 2016 • San Antonio, TX 2016

SQL User Group Speaker @ • NTSSUG, Dallas, TX • CACTUSS, Austin, TX • OKCSQL, Oklahoma City, OK • MSBIC, Dallas, TX • SALSSA, San Antonio, TX • FWSSUG, Fort Worth, TX

AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object-oriented programming and business intelligence (data warehouses).

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.

Joseph Barth

Twitter: - @sql_da

LinkedIn: Joseph Barth

Contact: http://sqlda.com

An eight year Microsoft SQL Server Specialist in SQL Server 2005-2016, Azure SQL DB, he has held many development positions, including SQL query tuner, SSIS and SSRS . Joseph’s early focus as an SQL tuning professional, fixing long running queries by techniques; join order,use of temporary object, also implementing Index optimization, maintenance and design to fix slowness. Joseph has focused on ETL solutions using SSIS for the last 4 years, data warehousing and cloud architecture using Azure. Currently working on a Modern Data Warehouse project involving Azure Data Lake and Azure SQL DW using external tables. MCSE Data Management and Analytics 2016 MCSA: SQL Server 2012 Co-found CASSUG Albany NY 2 yrs AZSSUG Chapter Leader 3 yrs

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Clay Jackson

Twitter: - n7qnm

Clay Jackson is a Database Sales Engineer for Quest, specializing in Database Performance Management and Replication Tools. Prior to joining Quest, Jackson was the DBA Manager at Darigold. He also spent over 10 years managing Oracle, SQLServer and DB2 databases and DBAs at Washington Mutual and was employee number 66 at Microsoft, spending time in Product Support, MIS and OS/2 Development. While at WaMu, Jackson was the Enterprise Database Compliance Officer, with responsibility for Database Security and Disaster Recovery. He also worked at Microsoft and Starbucks, is a CISM, and has a Masters in Software Engineering from Seattle University.

Chris Myers

Twitter: - https://twitter.com/myerscj

LinkedIn: Chris Myers

Contact: http://bloggedbychris.com

Chris started his software development career in the telecommunications industry in 2007 and moved to consulting in 2012 where he has had the opportunity to work with numerous industry verticals, such as Healthcare, Hospitality and Gaming, Finance / Banking, and Intelligent Transportation Solutions. Chris is a custom application developer that specializes in using the Microsoft technology stack to create solutions that run on-premise and in the cloud

Chris Huie

LinkedIn: Chris Huie

I hang out at the intersection of coding, math, and nerd culture. He also tries to do cool stuff in the developer community.

Martin Schoombee

Twitter: - sqlmartin

LinkedIn: Martin Schoombee

Contact: http://www.martinschoombee.com

Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.

Ricardo Mawcinitt

Twitter: - @ricomawcinitt

LinkedIn: Ricardo Mawcinitt

Ricardo has over 10 years of technical experience ranging from data modeling and data warehouse design to building custom business intelligence solutions.

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Martin Schoombee

Twitter: - sqlmartin

LinkedIn: Martin Schoombee

Contact: http://www.martinschoombee.com

Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.

Nathan Strack

LinkedIn: Nathan Strack

With over a decade of technology experience Nathan has architected and delivered on a variety of projects across several technologies and industries. Managing programs as both a technical and program leader he has designed, developed, and led implementations for large scale application and data systems including many for global Fortune 500 companies. Specializing in Information Management Analytics he brings a unique perspective to enterprise data and how to execute successful strategies utilizing it.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page