sqlsathistory

Nr: 674

SQLSaturday #674 - Phoenix - BI 2017

Start Time (24h)	Speaker	Track	Title
09:15:00	Ryan Casey	BI Platform Architecture, Development Administration	Data Modeling for the Modern Enterprise
09:15:00	Clay Jackson	Cloud Application Development Deployment	Move You SQLServer Database to "The Cloud" with Almost No Downtime
09:15:00	Ginger Grant	Application Database Development	Implementing R in SQL Server 2016
09:15:00	Chris Myers	Application Database Development	Leverage Docker for Hosting SQL Server and Beyond
10:45:00	Russel Loski	Cloud Application Development Deployment	Querying Semistructured Data in Azure Data Lake with USQL
10:45:00	Martin Schoombee	BI Platform Architecture, Development Administration	The 10 Commandments of ETL
10:45:00	Chris Huie	BI Information Delivery	Introduction to Python for Data Science
13:00:00	Nathan Strack	BI Platform Architecture, Development Administration	Rounding The Polybases
13:00:00	Ricardo Mawcinitt	Analytics and Visualization	The journey to data viz
13:00:00	Ginger Grant	Advanced Analysis Techniques	Advanced Analytics with SQL Server 2017 and Python
14:30:00	Russel Loski	BI Platform Architecture, Development Administration	Managing SSRS Reports using PowerShell and SSRS Web Services
14:30:00	Joseph Barth	Analytics and Visualization	The first ever SQL Server Drone controlled by Server less Architecture in Azure
14:30:00	Martin Schoombee	Analytics and Visualization	Power BI: What you need to know

SessionID: 66263

Data Modeling for the Modern Enterprise

Back to calendar

Event Date: 23-09-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ryan Casey

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

SessionID: 66315

Move You SQLServer Database to "The Cloud" with Almost No Downtime

Back to calendar

Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Cloud Application Development Deployment

Speaker: Clay Jackson

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.

SessionID: 66965

Implementing R in SQL Server 2016

Back to calendar

Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Ginger Grant

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.

SessionID: 68520

Leverage Docker for Hosting SQL Server and Beyond

Back to calendar

Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Chris Myers

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.

SessionID: 66959

Querying Semistructured Data in Azure Data Lake with USQL

Back to calendar

Event Date: 23-09-2017 - Session time: 10:45:00 - Track: Cloud Application Development Deployment

Speaker: Russel Loski

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.

SessionID: 68386

The 10 Commandments of ETL

Back to calendar

Event Date: 23-09-2017 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Martin Schoombee

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!!

SessionID: 68825

Introduction to Python for Data Science

Back to calendar

Event Date: 23-09-2017 - Session time: 10:45:00 - Track: BI Information Delivery

Speaker: Chris Huie

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.

SessionID: 68387

Rounding The Polybases

Back to calendar

Event Date: 23-09-2017 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Nathan Strack

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.

SessionID: 68429

The journey to data viz

Back to calendar

Event Date: 23-09-2017 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Ricardo Mawcinitt

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:

Identify sources of data
Data profiling
Data cleansing / Business rules
Data visualizations (Tableau)
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.

SessionID: 68601

Advanced Analytics with SQL Server 2017 and Python

Back to calendar

Event Date: 23-09-2017 - Session time: 13:00:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

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.

SessionID: 66958

Managing SSRS Reports using PowerShell and SSRS Web Services

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Russel Loski

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.

SessionID: 67170

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

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Joseph Barth

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

SessionID: 68385

Power BI: What you need to know

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Martin Schoombee

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.

This site is open source. Improve this page.