sqlsathistory

Nr: 649

SQLSaturday #649 - Jacksonville 2017

Start Time (24h)	Speaker	Track	Title
09:00:00	Ahmad Drshen	Enterprise Database Administration Deployment	Intro to MongoDB for SQL DBAs
09:00:00	Luis Figueroa	BI Information Delivery	Enabling EDW and BI workloads on Hadoop with Hive / LLAP
09:00:00	Adam Jorgensen	Strategy and Architecture	Data Driven Digital Transformation
09:00:00	Taras Kaduk	BI Information Delivery	Migrate your enterprise reporting into Power BI: process canvas, pitfalls best practices
09:00:00	Valentin Iamandi	Professional Development	How to be a Great DBA
09:00:00	Scott Gleason	Enterprise Database Administration Deployment	Database Security Permissions ( you don't need to grant SA )
09:00:00	Eric Wisdahl	Other	Kids Camp
09:00:00	Maximo Trinidad	Enterprise Database Administration Deployment	Working with SQL Server for Linux Cross-Platform
10:15:00	Jeff Taylor	Enterprise Database Administration Deployment	How To Tune A Multi-Terabyte Database For Optimum Performance.
10:15:00	Joshua Corrick	Enterprise Database Administration Deployment	Deploying SQL 2016 with PowerShell DSC
10:15:00	Bob Rubocki	Cloud Application Development Deployment	100% Chance of Clouds – Migrating to Azure SQL DB
10:15:00	Jason Jones	Application Database Development	Data Modeling Student Registration and Student Retention in Higher Education
10:15:00	Susan Schneider	Professional Development	Training by the Twos: Two Sites, Two Tools, Two Tidbits
10:15:00	Brad Raney	Professional Development	Are They Hearing What You Said - or Something Completely Different?!
10:15:00	Dmitri Korotkevitch	Enterprise Database Administration Deployment	Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching
10:15:00	Felix Asencio	BI Information Delivery	Handling Late Arriving Dimension Records in a Datawarehouse using SSIS/SQL
11:30:00	Vishal Pawar	Analytics and Visualization	Create lightning fast Dashboard with Power BI and its Components
11:30:00	Shawn Meyers	Other	Virtualize FCI and Availability Groups
11:30:00	Doug McClurg	BI Platform Architecture, Development Administration	Tracking Change is the Backbone of Your Data Platform
11:30:00	Dustin Ryan	Professional Development	How to Build your Brand and Become a Thought Leader
11:30:00	Paul Williams	BI Platform Architecture, Development Administration	XpressInsight Framework as a Service - Rapid Implementation Data Warehousing Solution
11:30:00	Steve Schneider	BI Information Delivery	Tell the story with Power BI visualizations embedded in your web site based on Azure Data
11:30:00	Mitchell Pearson	BI Platform Architecture, Development Administration	Power BI Administration and Governance
12:45:00	Kenneth Wood	Professional Development	Training: Have It Your Way (Lunch time Session)
12:45:00	Diane Schuster	BI Platform Architecture, Development Administration	Dynamic Data Flows in SSIS without Programming
12:45:00	Brandi Kiehl	Professional Development	Women in Technology Luncheon
13:45:00	Troy Gallant	Enterprise Database Administration Deployment	Supercharge Your Maintenance Plans!
13:45:00	Richard Weiss	Cloud Application Development Deployment	A Tour of Cloud Data Platforms as a Service
13:45:00	Jeff Taylor	Application Database Development	How To Fully Automate Database Deployments
13:45:00	Bradley Ball	Advanced Analysis Techniques	Using R, SQL Server Advanced Analytics, and Baseball to Hit a Home Run
13:45:00	Kellyn Pot'Vin-Gorman	Enterprise Database Administration Deployment	DevOps for the DBA
13:45:00	Ben Cusson	Professional Development	SNI Technology Presents, Creating Your Personal Brand Behind the Staffing Curtain
13:45:00	T.J. Brown	BI Platform Architecture, Development Administration	What's new in Power BI Embedded
13:45:00	Chris Albrektson	BI Information Delivery	What's new in Reporting Services 2016
15:15:00	Brian Carrig	Cloud Application Development Deployment	Running SQL Server in AWS
15:15:00	Thomas Norman	Application Database Development	Database Project Makes Deployment Consistent
15:15:00	Ronald Dameron	Cloud Application Development Deployment	In a Perfect World, Azure is Green… Green as in, all is well
15:15:00	David Liebman	Analytics and Visualization	Embed analytics into your web apps using Power BI
15:15:00	Janis Griffin	Enterprise Database Administration Deployment	Does your performance tuning need a 12-step program?
15:15:00	Haim Shternshus	Analytics and Visualization	DataViz 101 - Creating Effective Visualizations
15:15:00	Thomas Banyan McGowen	BI Platform Architecture, Development Administration	Beyond the Stars…Alternative Date Warehouse Structures
16:30:00	Jeff Taylor	Application Database Development	What's New In SQL Server 2012/2014/2016 For The Developer
16:30:00	Victor Ivantsov	Application Database Development	TSQL Tips and Tricks for Developers
16:30:00	Jorge Novo	Application Database Development	Json document generation using Integration Services
16:30:00	Jonathon Moorman	Strategy and Architecture	Azure Sql PAAS: Lessons from the Real World
16:30:00	Neal Waterstreet	BI Platform Architecture, Development Administration	Master Data Management with SQL Server 2016 MDS
16:30:00	Bogdan Visinescu	Analytics and Visualization	Creating Predictive Models using Azure Machine Learning
16:30:00	Brandi Kiehl	Professional Development	Using Word Clouds to Sneak Past Applicant Tracking System

SessionID: 63438

Intro to MongoDB for SQL DBAs

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ahmad Drshen

Title: Intro to MongoDB for SQL DBAs

Abstract:

MongoDB is an open-source, document-oriented NoSQL database that provides high performance, high availability, and easy scaling. It has become the leader in non-relational database for Fortune 500 companies and SQL DBAs are inheriting the responsibility to deploy and maintain this new technology with little outside help and training. This session will focus on educating SQL DBAs in the necessary skills needed to perform day to day tasks to keep your MongoDB healthy, available and fast.

This presentation will introduce MongoDB, provide a brief overview of the NOSQL platform, how to get started with MongoDb, patching MongoDB instances, intro to replica set, setting up backups restore and if time allows a brief introduction to perform most of these operations through Ops Manager 3.4.

SessionID: 64136

Enabling EDW and BI workloads on Hadoop with Hive / LLAP

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Luis Figueroa

Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP

Abstract:

In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered!

In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!

SessionID: 66812

Data Driven Digital Transformation

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: Strategy and Architecture

Speaker: Adam Jorgensen

Title: Data Driven Digital Transformation

Abstract:

Go beyond the buzzwords and let's get real about how you can help transform your company as a data professional. Adam will walk through the major areas of business that are transforming, how you can help and give you tips on becoming more influential in your organization by leading this change.

SessionID: 67177

Migrate your enterprise reporting into Power BI: process canvas, pitfalls best practices

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Taras Kaduk

Title: Migrate your enterprise reporting into Power BI: process canvas, pitfalls best practices

Abstract:

In this session, we will discuss how to efficiently migrate your retrospective analytics from where it is now to Power BI, and do it in a way that saves you time in the future.

Some of the topics include: • How to create a solution that is simple, automated, standardized and scalable • How to avoid common pitfalls and "death by a thousand reports" • How to most efficiently distribute the reports afterwards

SessionID: 67299

How to be a Great DBA

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: Professional Development

Speaker: Valentin Iamandi

Title: How to be a Great DBA

Abstract:

Please join me in this adventure of being a Great DBA.

In this session you will learn what is needed and how you can get there. Measure / Automate / Promote Measure = How to get the numbers your manager wants to see Automate = Automation as a tool to improve your career Promote = Share your knowledge, create on the side projects

SessionID: 67349

Database Security Permissions ( you don't need to grant SA )

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Scott Gleason

Title: Database Security Permissions ( you don't need to grant SA )

Abstract:

Lets talk about Database Security Permissions Roles and I'll show you how to correctly grant the access needed to allow other to their job without risking the entire database. I will also touch on auditing so you can prove who did what!

SessionID: 68378

Kids Camp

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: Other

Speaker: Eric Wisdahl

Title: Kids Camp

Abstract:

Kids camp! Pre-registered event.

SessionID: 68551

Working with SQL Server for Linux Cross-Platform

Back to calendar

Event Date: 12-08-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Maximo Trinidad

Title: Working with SQL Server for Linux Cross-Platform

Abstract:

I will be showing the latest build of SQL Server vNext for Linux. Everything you need to install and connect to SQL Server. Then, what tools are available to use from either Linux and Windows. Sample on querying for database information using Python and PowerShell between two environments. This will be a demo intensive session

SessionID: 63247

How To Tune A Multi-Terabyte Database For Optimum Performance.

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Taylor

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Abstract:

This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.

SessionID: 64152

Deploying SQL 2016 with PowerShell DSC

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Joshua Corrick

Title: Deploying SQL 2016 with PowerShell DSC

Abstract:

If you need a dependable way to deploy SQL time after time, Powershell DSC provides methods for customizing deployments based on the type of role the Database server will take in your environment. Even though the SQL installer already has a script builder for automating installs, by using PowerShell DSC and community resources you may either push or pull a deployment to a full gui or core server.

SessionID: 64614

100% Chance of Clouds – Migrating to Azure SQL DB

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Bob Rubocki

Title: 100% Chance of Clouds – Migrating to Azure SQL DB

Abstract:

Looking for a simple way to get started with Azure? Not sure if Azure SQL DB is right for you? Try it out by moving an existing database to the cloud!

In this session, you will learn techniques to migrate your on-premises SQL Server databases to Azure SQL DBs, and why backup and restore is not one of the three.

This session will also provide guidance on determining whether your on-premises SQL Server database is compatible with Azure SQL DB.

SessionID: 64717

Data Modeling Student Registration and Student Retention in Higher Education

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Jason Jones

Title: Data Modeling Student Registration and Student Retention in Higher Education

Abstract:

In higher education, student registration leads to student retention. In the session, I will explain the strategy we have used to model star schemas for these two critical business processes in our data warehouse. The presentation will focus on the logical model as well as some physical implementation decisions and successes using SQL Server 2016.

SessionID: 66432

Training by the Twos: Two Sites, Two Tools, Two Tidbits

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: Professional Development

Speaker: Susan Schneider

Title: Training by the Twos: Two Sites, Two Tools, Two Tidbits

Abstract:

Come join Susan Schneider for a new session on how to move from the non-technical realm to the fully employed technical realm, as she explores the latest free learning sites and developer tools for 2017; she will also throw in her top learning tidbits to help you excel in your career. Building on her SQL Saturday session from last year, Susan makes it easy to get started on the technical path by utilizing free learning sites and training.

We can’t learn everything all at once, but we can focus on what will provide us the best leverage in today’s technical job market. We’ll focus on the top two 2017 free training sites to expand your technical skills, the top two Business Intelligence presentation tools you need to know, and the top two tidbits to increase your professionalism and efficiency levels.
Join Susan as we continue our technical journey and increase our learning pace, two at a time!

SessionID: 67179

Are They Hearing What You Said - or Something Completely Different?!

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: Professional Development

Speaker: Brad Raney

Title: Are They Hearing What You Said - or Something Completely Different?!

Abstract:

In this 60 minute interactive workshop, attendees are given the knowledge tools to take charge of their listening skills to improve the quality of their communication with other professionals. Ever have trouble getting the right message across to your co-workers or clients? This topic deals with the ways we communicate – accurately and inaccurately – and includes 2 interactive elements: table exercise about voice inflection called “Really? REALLY?!” volunteer activity called the “Alien Press Conference” – a hilarious take on verbal non-verbal cues. Other topics include: Challenges of Communicating; Listening to Understand, Not Respond; 7 Stages of Communication; Verbal vs Nonverbal Cues; Tone is Everything; 5 Ways to Change Your Listening Habits Now; and more. Attendees will learn:

• How to control their voice tone and inflection to improve their message delivery; • How to develop and improve their active listening skills; • How to use non-verbal cues to their advantage; more

SessionID: 67298

Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dmitri Korotkevitch

Title: Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching

Abstract:

SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.

In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.

SessionID: 67301

Handling Late Arriving Dimension Records in a Datawarehouse using SSIS/SQL

Back to calendar

Event Date: 12-08-2017 - Session time: 10:15:00 - Track: BI Information Delivery

Speaker: Felix Asencio

Title: Handling Late Arriving Dimension Records in a Datawarehouse using SSIS/SQL

Abstract:

Data Warehouse Theory can be a tough nut to crack. A late arriving dimension record tends to occur when you receive a fact record before the dimension record arrives in the data warehouse so you must create a placeholder record.

In this session, we will give you a brief overview of Facts and Dimensions, and then do an in-depth discussion on what late arriving dimension records are, why they are important, and how to handle them. We will explain how not properly handling these can negatively affect your Financial Reports. We will also cover how to correct those records in the data warehouse once the proper dimension record arrives on the doorstep of the data warehouse.

SessionID: 63523

Create lightning fast Dashboard with Power BI and its Components

Back to calendar

Event Date: 12-08-2017 - Session time: 11:30:00 - Track: Analytics and Visualization

Speaker: Vishal Pawar

Title: Create lightning fast Dashboard with Power BI and its Components

Abstract:

Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips, You will learn all latest and greatest features of Power BI.

SessionID: 64610

Virtualize FCI and Availability Groups

Back to calendar

Event Date: 12-08-2017 - Session time: 11:30:00 - Track: Other

Speaker: Shawn Meyers

Title: Virtualize FCI and Availability Groups

Abstract:

High availability can be different when in a virtual environment. Attendees will learn the pros and cons of running SQL server clusters or AlwaysOn Availability Groups in a virtual environment. Comparing all of the different high availability options between all of available technologies. How features of VMware and Hyper-V are impacted and how to work with the administrators of virtual environment. Walking through all of the storage options to determine which one is the best fit. Review key settings and configurations for the virtual platform, the virtual machine, and SQL server, and show which need to be set to ensure proper performance.

SessionID: 64679

Tracking Change is the Backbone of Your Data Platform

Back to calendar

Event Date: 12-08-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Doug McClurg

Title: Tracking Change is the Backbone of Your Data Platform

Abstract:

Features or concepts like Change Tracking, Change Data Capture, Temporal Tables, and other similar delta systems are complex and may carry a stigma or misapprehension in your organization around performance or security or cost. Even if you do not directly implement these features or methods absolutely, most information systems rely on tracking changes especially from legacy line of business applications. I'm here to show you robust techniques for implementing delta systems in SQL Server to increase the trustworthiness of your data warehouse. I will also steer you away from common pitfalls.

SessionID: 65054

How to Build your Brand and Become a Thought Leader

Back to calendar

Event Date: 12-08-2017 - Session time: 11:30:00 - Track: Professional Development

Speaker: Dustin Ryan

Title: How to Build your Brand and Become a Thought Leader

Abstract:

Your personal brand is how you distinguish yourself from other people but how you develop and nurture your brand can be the difference between stagnation and opportunity in your career. We'll discuss your branding, the importance of taking control of your brand, and how to begin developing your personal brand. By the end of this session, you'll have a better idea of how to begin building your personal brand into something that can take your career to the next level.

SessionID: 67306

XpressInsight Framework as a Service - Rapid Implementation Data Warehousing Solution

Back to calendar

Event Date: 12-08-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paul Williams

Title: XpressInsight Framework as a Service - Rapid Implementation Data Warehousing Solution

Abstract:

XpressInsight is a Framework as a Service product that provides the modules and tools to rapidly implement an Enterprise Data Warehouse and Business Intelligence solution, at a fraction of the cost. It is built entirely on the Microsoft BI stack using SQL Server 2016, SQL Server Analysis Services (tabular), SQL Server Reporting Services, and Microsoft Power BI. In this session, we will demonstrate loading a data warehouse from multiple sources (A SQL server on Windows and an ORACLE DB on Linux) into a Kimball style dimensional model. We will demonstrate how to measure and report on data quality, correct data quality issues, load auditing, self-service reporting with SSRS and Power BI, and publishing your Power BI reports and dashboards to the cloud while allowing those applications to retrieve the data from a secure on-premise location.

SessionID: 67312

Tell the story with Power BI visualizations embedded in your web site based on Azure Data

Back to calendar

Event Date: 12-08-2017 - Session time: 11:30:00 - Track: BI Information Delivery

Speaker: Steve Schneider

Title: Tell the story with Power BI visualizations embedded in your web site based on Azure Data

Abstract:

Honey, Let Me Drive!

See how husband and wife tech team, Steve and Susan Schneider, set up a Florida traffic database in Azure and build dynamic interactive presentations using Power BI, without killing each other or ‘driving’ each other crazy!
In this fast pace seminar, you’ll get a quick overview of how to set up an Azure database and move data to Azure; then it’s off for a road trip with Power BI. Using Power BI visualizations, we’ll answer some questions like: 1- What color of vehicle is most likely to be in an accident 2- What make and model get into crashes most often 3- What counties in Florida have the highest amount of accidents? Hint: It is not Duval! 4- Do more accidents really happen on one day of the week over another day? And much more! Come along on this trip to see how you can stand up your own database in Azure and use Power BI to make your data ‘ready for the road’

SessionID: 68160

Power BI Administration and Governance

Back to calendar

Event Date: 12-08-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Mitchell Pearson

Title: Power BI Administration and Governance

Abstract:

Power BI is an incredible tool and as more companies and individuals adapt this new technology it is time to turn our focus from report development to Administration. Noone really wants to discuss Administration but it's important to understand the security risks and how to mitigate those risks through proper administration. In this session, we will discuss an overview of Power BI Administration as it relates to security and governance.

SessionID: 66505

Training: Have It Your Way (Lunch time Session)

Back to calendar

Event Date: 12-08-2017 - Session time: 12:45:00 - Track: Professional Development

Speaker: Kenneth Wood

Title: Training: Have It Your Way (Lunch time Session)

Abstract:

Stagnancy in learning and personal growth often leads to frustration and undesired stress. It is vital to our everyday success that we seek to not only better ourselves through professional and personal development, but it is just as critical to ensure the methods we are using to absorb this content are effectively presented and better suit our learning abilities.

I believe the question we need to answer, is not what we're learning, but rather how do we best learn? In this session, we will discuss three popular training methods and how we can customize these options to best fit our needs.

This session will help the attendees better prepare themselves for Learning Development and will motivate the attendees to take action.

SessionID: 67094

Dynamic Data Flows in SSIS without Programming

Back to calendar

Event Date: 12-08-2017 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Diane Schuster

Title: Dynamic Data Flows in SSIS without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 68748

Women in Technology Luncheon

Back to calendar

Event Date: 12-08-2017 - Session time: 12:45:00 - Track: Professional Development

Speaker: Brandi Kiehl

Title: Women in Technology Luncheon

Abstract:

A panel discussion with some of the great Women of the community.

SessionID: 63278

Supercharge Your Maintenance Plans!

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: Supercharge Your Maintenance Plans!

Abstract:

Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.

SessionID: 63389

A Tour of Cloud Data Platforms as a Service

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Richard Weiss

Title: A Tour of Cloud Data Platforms as a Service

Abstract:

With the proliferation of SQL, NoSQL and Big Data databases, organizations can now target specific fit-for-purpose database platforms that align with their particular application requirements regarding scalability, elasticity, functionality and manageability. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations.

SessionID: 63822

How To Fully Automate Database Deployments

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Jeff Taylor

Title: How To Fully Automate Database Deployments

Abstract:

This session will cover how to setup your database source code in a source code repository and configure continuous integration and continuous deployment of your database alongside your application using Visual Studio Online, Red Gate DLM SQL CI, and Octopus Deploy.

SessionID: 65498

Using R, SQL Server Advanced Analytics, and Baseball to Hit a Home Run

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: Advanced Analysis Techniques

Speaker: Bradley Ball

Title: Using R, SQL Server Advanced Analytics, and Baseball to Hit a Home Run

Abstract:

The last two releases of SQL Server provided the capability to use SQL Server as the hub in a hub and spoke model for big data and data science. Our hub will use R In-database advanced analytics and Power BI. The technology is impressive, but data needs to be interesting. We are using data provided by RetroSheets.org to create a data set of play by play data and box scores for Major League Baseball games from 1922 to 2015. We set out to discover the answer to questions every baseball fan wants to know! Do you have a better chance to see your team win by going to a Double Header or regular game? Is there 'a the best day of the week' to see your favorite team win? How do winning and losing seasons impact this or home and away games? Come for the baseball, stay for the science!

SessionID: 66714

DevOps for the DBA

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: DevOps for the DBA

Abstract:

DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data.

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: • Develop, Rinse, Repeat • Test Until Your Five Year Old Can Do It • Human Intervention Creates Human Error- Automate EVERYTHING.

SessionID: 67044

SNI Technology Presents, Creating Your Personal Brand Behind the Staffing Curtain

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: Professional Development

Speaker: Ben Cusson

Title: SNI Technology Presents, Creating Your Personal Brand Behind the Staffing Curtain

Abstract:

SNI Technology Presents, Creating Your Personal Brand Behind the Staffing Curtain

I will share my experience over the years in Staffing to provide some tips and tricks to help the community. I will discuss online presence, personal branding, selecting a staffing vendor, resume tips and tricks, nailing a technical interview, industry trends and anything else that may come up!

SessionID: 67077

What's new in Power BI Embedded

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: T.J. Brown

Title: What's new in Power BI Embedded

Abstract:

How to embed Power BI visuals on web pages has changed since the launch of Power BI Premium. This session will teach you how to get started on the new, unified Power BI API.

SessionID: 68813

What's new in Reporting Services 2016

Back to calendar

Event Date: 12-08-2017 - Session time: 13:45:00 - Track: BI Information Delivery

Speaker: Chris Albrektson

Title: What's new in Reporting Services 2016

Abstract:

With the release of SQL Server 2016, Microsoft has blown the dust off the tried and true SSRS and injected some much needed life. SSRS 2016 introduces a shiny new portal with a new Dashboard/Mobile report types. In this session, we'll take a look at what has changed in SSRS 2016 and how to get up and running using the new Dashboard/Mobile reports. Through demos we'll walk through everything you need to create your first Mobile ready SSRS 2016 Dashboard!

SessionID: 63260

Running SQL Server in AWS

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Brian Carrig

Title: Running SQL Server in AWS

Abstract:

Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies, security and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.

SessionID: 63302

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

SessionID: 63798

In a Perfect World, Azure is Green… Green as in, all is well

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Ronald Dameron

Title: In a Perfect World, Azure is Green… Green as in, all is well

Abstract:

This session will present the fundamentals needed to setup monitoring and alerting for a global Azure PaaS application to insure the application is available to your customers and is performing correctly.

I'll review the Azure Portal navigation fundamentals in order to demonstrate how to monitor uptime and application performance for a globally deployed Azure PaaS application currently in use by major companies like ATT, Bell, and Vodaphone. Coverage will included how to monitor and alert on individual components in the Azure Portal, setting up alerts in Application Insights and configuring shared dashboards so that a production support team on a Follow-The-Sun schedule can effectively monitor the application.

SessionID: 67051

Embed analytics into your web apps using Power BI

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: David Liebman

Title: Embed analytics into your web apps using Power BI

Abstract:

In this presentation I will be showing you how to get Power BI added to your current web application.

We will be using the Power BI API's to embed the analytics into you company web application.

SessionID: 67222

Does your performance tuning need a 12-step program?

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Does your performance tuning need a 12-step program?

Abstract:

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

Quickly fine tune a SQL statement
Identify performance inhibitors to help avoid future performance issues
Recognize and understand how new SQL Server features can help improve query
performance

SessionID: 68465

DataViz 101 - Creating Effective Visualizations

Back to calendar

Event Date: 12-08-2017 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Haim Shternshus

Title: DataViz 101 - Creating Effective Visualizations

Abstract:

Bar graph, or pie chart?

Color, or grayscale? Percentage, or absolute numbers? If you ever asked yourself these questions before presenting data, ever needed to put together a graph and didn’t know where to start, ever wanted your numbers to make a bigger splash - this talk is for you. We will cover the “why” and “how” of data visualization; and explore the do’s and don’ts. Come learn something new!

SessionID: 68466

Beyond the Stars…Alternative Date Warehouse Structures

Back to calendar

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

Speaker: Thomas Banyan McGowen

Title: Beyond the Stars…Alternative Date Warehouse Structures

Abstract:

Beyond the Stars…Alternative Date Warehouse Structures to Empower Your Reporting and Analytics Team.

Star schema has become ubiquitous with Data warehouses and unless you have a well define cube modeled on top of it, they can be difficult for even experienced report writers to use. In this session, we will explore alternative structures that once built, with allow for rapid report development, by anyone who can write a simple select statement; empowering your developers to provide business insight without the dubious task of ‘starting from scratch’.
The following concepts and structures will be discussed: • Base/Detail Structures • Current State Structures • ‘Point In Time’ Data • Band Structures • Lifecycle/Timeline Structures Additionally, we will discuss the importance of granularity, naming, object selection and refresh rates within the context of the aforementioned SQL structures.

SessionID: 63250

What's New In SQL Server 2012/2014/2016 For The Developer

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Jeff Taylor

Title: What's New In SQL Server 2012/2014/2016 For The Developer

Abstract:

SessionID: 63495

TSQL Tips and Tricks for Developers

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Victor Ivantsov

Title: TSQL Tips and Tricks for Developers

Abstract:

Common mistakes you can avoid to run your queries very effiently

SessionID: 64756

Json document generation using Integration Services

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Jorge Novo

Title: Json document generation using Integration Services

Abstract:

How you can create json documents for sql server 2014 and below using integration services?

On this session we are going to cover what is needed, how it can be done. This session will show you each step of the way to finally deliver that Json document across your organization.

SessionID: 65480

Azure Sql PAAS: Lessons from the Real World

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: Strategy and Architecture

Speaker: Jonathon Moorman

Title: Azure Sql PAAS: Lessons from the Real World

Abstract:

So you're using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how do you do restore? Where are the backup files? When are service packs applied? Can service packs be rolled up thru dev to production? What's a service level and how does it impact database design? How do we encrypt, authorize, query tune, restore...? We'll go over these questions and any others that you may have.

SessionID: 67138

Master Data Management with SQL Server 2016 MDS

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Neal Waterstreet

Title: Master Data Management with SQL Server 2016 MDS

Abstract:

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

SessionID: 67309

Creating Predictive Models using Azure Machine Learning

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: Analytics and Visualization

Speaker: Bogdan Visinescu

Title: Creating Predictive Models using Azure Machine Learning

Abstract:

Azure Machine Learning is a fully managed predictive analytics service that you can use to create predictive models against your data in SQL Data Warehouse, and then publish as ready-to-consume web services.

You will learn how to read data from your database; how to create, train, and score a predictive model; and how write data to your database or create a web service.

SessionID: 68467

Using Word Clouds to Sneak Past Applicant Tracking System

Back to calendar

Event Date: 12-08-2017 - Session time: 16:30:00 - Track: Professional Development

Speaker: Brandi Kiehl

Title: Using Word Clouds to Sneak Past Applicant Tracking System

Abstract:

Ever wonder why your resume ends up in a black hole when you submit it online? You know what your resume looks like, but do you wonder how a computer sees your resume? Let Brandi and Amanda teach you how to use word clouds for job postings and your resume. Guaranteed to be a light bulb moment for your career search efforts!

This site is open source. Improve this page.