sqlsathistory

Nr: 522

Back to Main list

SQLSaturday #522 - Jacksonville 2016

Start Time (24h)	Speaker	Track	Title
09:00:00	Phillip Labry	BI Platform Architecture, Development Administration	Why do I need Analysis Services?
09:00:00	Devin Knight	Other	Kids Camp
09:00:00	Shabnam Watson	BI Platform Architecture, Development Administration	A SQL Developer’s Guide to MDX Basics
09:00:00	Daniel Taylor	Enterprise Database Administration Deployment	More than Just a basic Database Backup and Recovery
09:00:00	Steve Schneider	BI Platform Architecture, Development Administration	Breaking into the Azure-PowerBI World
09:00:00	Dustin Ryan	BI Platform Architecture, Development Administration	Designing a Data Warehouse from the Ground Up
09:00:00	Adam Jorgensen	Strategy and Architecture	Step by Step - How to Build World Class Data Culture
09:00:00	Alexey Bogomolov	Advanced Analysis Techniques	Azure Machine Learning with Stock Data
10:15:00	Jorge Novo	BI Information Delivery	Parent, Child development Using SSIS Framework
10:15:00	Valentin Iamandi	Enterprise Database Administration Deployment	Index Sql Server databases for high performance
10:15:00	Susan Schneider	Professional Development	From Non-Technical to Fully Employed Technical: The Road Less Traveled.
10:15:00	Adam Jorgensen	Professional Development	The Future of the Data Professional
10:15:00	Chris Albrektson	Analytics and Visualization	Building your First Cube with SSAS
10:15:00	Michael Mollenhour	BI Platform Architecture, Development Administration	SSIS Destination Fast
10:15:00	Scott Gleason	Enterprise Database Administration Deployment	Database Security Permissions ( you don't need to grant SA )
12:00:00	Mike Byrd	Application Database Development	SS2014/2016 In-Memory Tables: Formula 1 Performance Unleashed!
12:00:00	Jonathon Moorman	Application Database Development	Database Projects: An Introduction
12:00:00	Mitchell Pearson	BI Information Delivery	Advanced T-SQL for BI Developers
12:00:00	Bradley Ball	Enterprise Database Administration Deployment	Inside the Query Optimizer
12:00:00	Jeff Taylor	Application Database Development	Changing Inline Dynamic SQL Statements To Stored Procedures
12:00:00	Alan Faulkner	Cloud Application Development Deployment	Introduction to Azure Data Factory Service
13:15:00	Troy Gallant	Enterprise Database Administration Deployment	Indexing your Data Warehouse
13:15:00	Kevin Feasel	BI Platform Architecture, Development Administration	Data Migration Using BIML
13:15:00	Devin Knight	BI Platform Architecture, Development Administration	Advanced Power BI: Solving the Hard Problems
13:15:00	Robert Biddle	Application Database Development	.NET for Data Professionals
13:15:00	Brad Gall	BI Information Delivery	What's new in Reporting Services 2016
13:15:00	Paco Gonzalez	BI Information Delivery	Enterprise Machine Learning with R and SQL Server
13:15:00	Gareth Swanepoel	Enterprise Database Administration Deployment	SQL 2012 2014 Extended Events
14:45:00	Thomas Grohser	Enterprise Database Administration Deployment	SQL Server Storage Engine under the hood
14:45:00	Arvin Meyer	Application Database Development	Intelligent Indexing
14:45:00	Shawn Meyers	Enterprise Database Administration Deployment	Availability Groups: Monitoring and Alerting
14:45:00	Rowland Gosling	BI Platform Architecture, Development Administration	Accelerating Batch Processing with Apache Spark
14:45:00	Bradley Ball	BI Platform Architecture, Development Administration	BI DBA Performance Tuning
14:45:00	Keith Seedorf	Analytics and Visualization	Introduction to the R programming language
14:45:00	Gareth Swanepoel	Enterprise Database Administration Deployment	What’s New in SQL Server 2016 ?
16:00:00	Sayed Saeed	BI Information Delivery	The Business Intelligence Side of SQL Server
16:00:00	Michael Keleher	Enterprise Database Administration Deployment	Building Defense in Depth Using the Full Spectrum of SQL Server Encryption
16:00:00	Shawn Harrison	BI Platform Architecture, Development Administration	SSIS Performance Tuning
16:00:00	Mike Davis	Professional Development	Mastering the Technology Interview
16:00:00	Jeff Taylor	Application Database Development	What's New In SQL Server 2012/2014/2016 For The Developer
16:00:00	Alan Faulkner	BI Information Delivery	SSAS Design and Performance Best Practices
16:00:00	Matt Berseth	Advanced Analysis Techniques	Automated Cancer Detection with Deep Learning

SessionID: 45541

Why do I need Analysis Services?

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Phillip Labry

Title: Why do I need Analysis Services?

Abstract:

Do you write a lot of SSRS reports with SQL queries or stored procedures? Have you heard about analysis services but don't know if it's a good fit for you? Are you trying to decide whether you should go with Tabular or OLAP? Are you thinking about using Power BI? In this session Phillip will go over use cases for Analysis Services and highlight the differences and strengths of each flavor of SSAS. If you have a data warehouse and aren't using SSAS come learn how SSAS will make your users love you.

SessionID: 46799

Kids Camp

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: Other

Speaker: Devin Knight

Title: Kids Camp

Abstract:

For SQL Saturday attendees' children only (children 9-15)

Registration for this event must be done from our meetup site. You cannot register on the day of the event for Kids Camp.

http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/228535929/

The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program.

An Adult must remain on campus at SQL Saturday during the day.

SessionID: 48501

A SQL Developer’s Guide to MDX Basics

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: A SQL Developer’s Guide to MDX Basics

Abstract:

You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL.

In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.

SessionID: 48901

More than Just a basic Database Backup and Recovery

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Daniel Taylor

Title: More than Just a basic Database Backup and Recovery

Abstract:

During our time together we are going to take a quick look into backup and recovery techniques for Full, Differential, and log backups. We will then take a look at how SQL Server keeps track of what will be included within out differential backups. While we’re at it lets look at our transactions logs prior to and post log backups. Next up we will look into advanced recovery scenarios such as piecemeal, point in time, file group, and page recoveries. If you manage databases or like doing recoveries let’s have some fun together during this sessions.

SessionID: 49036

Breaking into the Azure-PowerBI World

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Schneider

Title: Breaking into the Azure-PowerBI World

Abstract:

How to get started in Azure-PowerBI from a DBA background.

You know SQL. You probably have SQL installed on your own box; you’re familiar and comfortable with SSMS. There’s all this talk of Azure. There’s all this talk of PowerBI. You're not sure how to start. You're not sure where you even want to go. You're not sure why you would use Azure... You're not quite sure what tools you need, let alone how to tie them together. That's why you want to come to this session. I'll start you off with what you know...SSMS, and add tools and connections until you have filled Azure with data from SSMS and then tied Azure to PowerBI. Along the way we'll highlight key parts of the techniques that tie all these pieces together. At the end you'll see a PowerBI presentation sourced from Azure that you saw created from your favorite, comfortable tool...SSMS. This set of knowledge can help you in your career planning, and if nothing else, should help you in creating a technical strategy!

SessionID: 49092

Designing a Data Warehouse from the Ground Up

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dustin Ryan

Title: Designing a Data Warehouse from the Ground Up

Abstract:

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes.

SessionID: 49169

Step by Step - How to Build World Class Data Culture

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: Strategy and Architecture

Speaker: Adam Jorgensen

Title: Step by Step - How to Build World Class Data Culture

Abstract:

Most organizations are struggling to figure out how to use data to drive their organization. Their biggest challenge is building it into the culture of the firm. Over 96% of the Fortune 100 are developing these types of cultures and you'll learn how to get started in this session. Using data to communicate is the key. This takes confidence in the data, the people and the mission. Let's talk about how we bring all these together to add a rocket booster to your businesses. Get a step by step plan you can start using Monday!

SessionID: 49308

Azure Machine Learning with Stock Data

Back to calendar

Event Date: 07-05-2016 - Session time: 09:00:00 - Track: Advanced Analysis Techniques

Speaker: Alexey Bogomolov

Title: Azure Machine Learning with Stock Data

Abstract:

This session is focused on leveraging Microsoft Azure Machine Learning with stock data to build a predictive model. This session will cover gathering and loading the data, building a predictive model, evaluating the model, publishing and using the web service for predicting stock movement.

SessionID: 45631

Parent, Child development Using SSIS Framework

Back to calendar

Event Date: 07-05-2016 - Session time: 10:15:00 - Track: BI Information Delivery

Speaker: Jorge Novo

Title: Parent, Child development Using SSIS Framework

Abstract:

Learn how to extend and reuse SSIS development using package controllers and drivers. Extend parallel process and view the different options for SSIS package configurations and become the GURU on ETL development for your organization

SessionID: 46128

Index Sql Server databases for high performance

Back to calendar

Event Date: 07-05-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Valentin Iamandi

Title: Index Sql Server databases for high performance

Abstract:

1. Missing indexes for queries and sprocs

2. Rank missing indexes based on logical reads and/or execution time
3. Record missing indexes and query plans for later analysis
4. Verify indexing results Bonus: Update only necessary statistics using Ola Hallengren Index Optimize sproc

SessionID: 48931

From Non-Technical to Fully Employed Technical: The Road Less Traveled.

Back to calendar

Event Date: 07-05-2016 - Session time: 10:15:00 - Track: Professional Development

Speaker: Susan Schneider

Title: From Non-Technical to Fully Employed Technical: The Road Less Traveled.

Abstract:

My technical path started at a SQL Saturday event in Jacksonville in 2010. Today I am Microsoft Certified and working full time as a Business Intelligence Report Developer. Sometimes it’s hard to envision the finished product of your labors when you’re in the middle of the construction mess. And it’s hard not to become frustrated when you can’t instantly learn all the great technical stuff out there. Well, you’re heard that Rome wasn’t built in a day, and neither will your technical studies. Building a solid technical foundation takes time and a ‘no quit’ attitude. If there was another way to do it, I would have found it by now!

Three foundation bricks for your technical base:

1. How to learn/improve T-SQL on your own? The Best and the Cheapest Way to Learn T-SQL
2. The Importance of the Technical Community in the learning process
3. Finding a Mentor and being a good mentee!

SessionID: 49168

The Future of the Data Professional

Back to calendar

Event Date: 07-05-2016 - Session time: 10:15:00 - Track: Professional Development

Speaker: Adam Jorgensen

Title: The Future of the Data Professional

Abstract:

The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field. What does the future look like for DBA's, BI Developers and Architects? Come get the lay of the land and guidance on keeping your career and learning on the right path. I will go through the updated landscape and decisions facing data professionals today and help chart a course to make sure your plans are right for you and your organization.

SessionID: 49256

Building your First Cube with SSAS

Back to calendar

Event Date: 07-05-2016 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: Chris Albrektson

Title: Building your First Cube with SSAS

Abstract:

So now that your data warehouse is complete now what? In this session Chris will show you how to create your first fully functional Cube in 1 hr. In this session we will cover all of the basics including some best practices to get you up to speed when working with analysis services. This session was designed for someone with little to no experience with SSAS.

SessionID: 49269

SSIS Destination Fast

Back to calendar

Event Date: 07-05-2016 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Michael Mollenhour

Title: SSIS Destination Fast

Abstract:

Ever face the problem of having slow SSIS packages due to either large lookups on dimensions or complicated merge methods used in SSIS? Free yourself from this tasks with no third-party tools or stage tables required. In this session Mike will demonstrate a totally different way of Increasing speed of destination merges and also eliminating large dimension lookups in SSIS via SQL triggers. He will also demonstrate how to use this same code to create a "Fast" even customizable slowly changing dimension insert.

SessionID: 49352

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

Back to calendar

Event Date: 07-05-2016 - Session time: 10:15: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! Furthermore, I'll show you some tips and tricks to getting SQL itself to accomplish task that you may not to grant access to a human.

SessionID: 45962

SS2014/2016 In-Memory Tables: Formula 1 Performance Unleashed!

Back to calendar

Event Date: 07-05-2016 - Session time: 12:00:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: SS2014/2016 In-Memory Tables: Formula 1 Performance Unleashed!

Abstract:

Query performance is what it is all about. SQL Server 2014 gave us the new in-memory functionality that takes a completely different approach to data access and manipulation. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.

This session is all about when and how to apply in-memory tables in a production environment. After this session you will

1. Understand what in-memory tables are and how to create and maintain them including their limitations
2. Be able to identify performance gains over equivalent disk back tables
3. Comprehend the new data monitoring needed for in-memory table

SessionID: 48205

Database Projects: An Introduction

Back to calendar

Event Date: 07-05-2016 - Session time: 12:00:00 - Track: Application Database Development

Speaker: Jonathon Moorman

Title: Database Projects: An Introduction

Abstract:

A look at the advantages of using Database Projects within Visual Studio. We'll look at partial database projects, tools for sql developers, TFS integration, DACPACs, and what happens during the build and publish steps. This will be demo heavy with a slide deck to remind you of the key points of the session.

SessionID: 48753

Advanced T-SQL for BI Developers

Back to calendar

Event Date: 07-05-2016 - Session time: 12:00:00 - Track: BI Information Delivery

Speaker: Mitchell Pearson

Title: Advanced T-SQL for BI Developers

Abstract:

So you know the basics and fundamentals of T-SQL, what's next? Come join Mitchell in this demo heavy session as he walks through more advanced T-SQL concepts and how they can make you more efficient in your T-SQL development. Some of the items covered in this session include CTEs, Window Functions, Merge Statement, and more!

SessionID: 49105

Inside the Query Optimizer

Back to calendar

Event Date: 07-05-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Bradley Ball

Title: Inside the Query Optimizer

Abstract:

When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

SessionID: 49342

Changing Inline Dynamic SQL Statements To Stored Procedures

Back to calendar

Event Date: 07-05-2016 - Session time: 12:00:00 - Track: Application Database Development

Speaker: Jeff Taylor

Title: Changing Inline Dynamic SQL Statements To Stored Procedures

Abstract:

If you are a Developer or a DBA and have dynamic SQL statements in your application, you need to attend this session! In this session we will walk through a simple method to change inline dynamic SQL statements to stored procedures. This method will allow Developers and DBA’s to have reusable execution plans and the ability to more specifically tune stored procedures.

SessionID: 49363

Introduction to Azure Data Factory Service

Back to calendar

Event Date: 07-05-2016 - Session time: 12:00:00 - Track: Cloud Application Development Deployment

Speaker: Alan Faulkner

Title: Introduction to Azure Data Factory Service

Abstract:

Data Factory is a cloud-based data integration service that orchestrates and automates the movement and transformation of data. Just like a manufacturing factory that runs equipment to take raw materials and transform them into finished goods, Data Factory orchestrates existing services that collect raw data and transform it into ready-to-use information.

In this session, we will review key concepts associated with Azure Data Factory to understand how key entities work together to define input and output data, processing events, and the schedule and resources required to execute the desired data flow.

SessionID: 45606

Indexing your Data Warehouse

Back to calendar

Event Date: 07-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: Indexing your Data Warehouse

Abstract:

One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.

SessionID: 46087

Data Migration Using BIML

Back to calendar

Event Date: 07-05-2016 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Feasel

Title: Data Migration Using BIML

Abstract:

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

SessionID: 49095

Advanced Power BI: Solving the Hard Problems

Back to calendar

Event Date: 07-05-2016 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Devin Knight

Title: Advanced Power BI: Solving the Hard Problems

Abstract:

By now you have probably seen many Power BI demos and likely love what you see in the product. However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try. So what do you do when your data is not perfect or your business problem is more complex? In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work. This session will give you many tips on how to solve real world problems with Power BI.

SessionID: 49253

.NET for Data Professionals

Back to calendar

Event Date: 07-05-2016 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Robert Biddle

Title: .NET for Data Professionals

Abstract:

Are you a DBA who knows nothing or very little about .NET? It's a more common than you might think, but most DBA's cringe at the thought of seeing C# code. Still, there are a lot of gems in this tried and tested toolbox. In this session, we'll cover the portions of .NET that are useful for any data professional. If you're into database development, administration, or ETL - .NET has some useful implementations that you can leverage easily.

No .NET experience is needed for this session. Basic understanding of programming concepts such as if/then logic and loops is suggested.

SessionID: 49331

What's new in Reporting Services 2016

Back to calendar

Event Date: 07-05-2016 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Brad Gall

Title: What's new in Reporting Services 2016

Abstract:

With the upcoming 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: 49359

Enterprise Machine Learning with R and SQL Server

Back to calendar

Event Date: 07-05-2016 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Paco Gonzalez

Title: Enterprise Machine Learning with R and SQL Server

Abstract:

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.

SessionID: 50176

SQL 2012 2014 Extended Events

Back to calendar

Event Date: 07-05-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Gareth Swanepoel

Title: SQL 2012 2014 Extended Events

Abstract:

In this session, come and learn how to perform monitoring and troubleshooting of your SQL Server using the new and improved Extended Events that are found in SQL Server 2012 and 2014. You will also learn about the improved XEvents interfaces and how to use XEvents to performance tune your server by tracking issues. This session will dive into the internals of XEvents and investigate the details of some of the events themselves.

SessionID: 45859

SQL Server Storage Engine under the hood

Back to calendar

Event Date: 07-05-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: SQL Server Storage Engine under the hood

Abstract:

How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up. #160; Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.

SessionID: 46813

Intelligent Indexing

Back to calendar

Event Date: 07-05-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Arvin Meyer

Title: Intelligent Indexing

Abstract:

Using indexing to improve performance

SessionID: 47008

Availability Groups: Monitoring and Alerting

Back to calendar

Event Date: 07-05-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Availability Groups: Monitoring and Alerting

Abstract:

So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Were you notified when it failed over last night?

This session will answer all these questions and more, and will show you what you should be looking at to ensure no surprises... We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts to show what to monitor in your AG and how to setup alerting so you know when to take action.

SessionID: 48116

Accelerating Batch Processing with Apache Spark

Back to calendar

Event Date: 07-05-2016 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rowland Gosling

Title: Accelerating Batch Processing with Apache Spark

Abstract:

The Apache Spark framework can accelerate processing 100x or more on Hadoop from diverse data sources such as Cassandra, Hive, or HBase. Using Azure’s HDInsight and Spark we’re going to look at the architecture and go step by step through examples with R and Python against public data sources.

SessionID: 49104

BI DBA Performance Tuning

Back to calendar

Event Date: 07-05-2016 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bradley Ball

Title: BI DBA Performance Tuning

Abstract:

Data Warehouses and OLTP systems are different! But there are some core concepts that we need to understand for managing and maintaining both. Do you want to know how you can load data faster, just by setting up your database correctly? Are your queries running slow? Want to understand how you can reduce locking and blocking in reporting queries? Do you have a system with views, that reference views, which reference more views? Let's discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!

SessionID: 49554

Introduction to the R programming language

Back to calendar

Event Date: 07-05-2016 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Keith Seedorf

Title: Introduction to the R programming language

Abstract:

This will be an introduction to the R programming language. The Session will cover the history, basic structure and syntax of the Language along with a demonstration of some basic scripts using the application (IDE) RStudio. A use case will be presented from a Voter Identification project currently underway.

SessionID: 50175

What’s New in SQL Server 2016 ?

Back to calendar

Event Date: 07-05-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Gareth Swanepoel

Title: What’s New in SQL Server 2016 ?

Abstract:

SQL Server 2016 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s and architects to some of the exciting features available in that version. Topics covered in this session include Query Store, Polybase, Stretch Database, JSON Support, Row Level Security, Always Encrypted, Enhancements to In-Memory OLTP tables and enhancements to AlwaysOn. If you are a SQL Server DBA or developer, an architect, or an IT professional who is excited about the new SQL Server 2016 features and are looking forward to learn more about them, this session is for you.

SessionID: 48142

The Business Intelligence Side of SQL Server

Back to calendar

Event Date: 07-05-2016 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Sayed Saeed

Title: The Business Intelligence Side of SQL Server

Abstract:

This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.

SessionID: 48315

Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Back to calendar

Event Date: 07-05-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Keleher

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract:

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

SessionID: 48387

SSIS Performance Tuning

Back to calendar

Event Date: 07-05-2016 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shawn Harrison

Title: SSIS Performance Tuning

Abstract:

SSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation we will cover many basic options and features that you can use to performance tune any SSIS package.

SessionID: 48796

Mastering the Technology Interview

Back to calendar

Event Date: 07-05-2016 - Session time: 16:00:00 - Track: Professional Development

Speaker: Mike Davis

Title: Mastering the Technology Interview

Abstract:

Mike shows you how to be prepared for technology job interviews. Learn the do's and don'ts of interviewing for technology jobs. Learn what your resume says about you and your ability to grow. Learn how passion can overcome a lack of skills. If you are the hiring manager and you are struggling to find the right people, come learn techniques to find the right fit for your company.

SessionID: 49343

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

Back to calendar

Event Date: 07-05-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Jeff Taylor

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

Abstract:

This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.

SessionID: 49365

SSAS Design and Performance Best Practices

Back to calendar

Event Date: 07-05-2016 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Alan Faulkner

Title: SSAS Design and Performance Best Practices

Abstract:

A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

SessionID: 50167

Automated Cancer Detection with Deep Learning

Back to calendar

Event Date: 07-05-2016 - Session time: 16:00:00 - Track: Advanced Analysis Techniques

Speaker: Matt Berseth

Title: Automated Cancer Detection with Deep Learning

Abstract:

Deep Learning as a general approach to image processing tasks like detection, recognition and localization have enjoyed tremendous success in recent years. However, deep learning has not yet been applied to certain ripe areas of medical imaging - specifically detecting cancer in gigabit sized scanned slides (commonly referred to as whole slide images or WSIs). In this session Matt will describe the development of an end-to-end image processing system that NLP Logix developed to automate the process of detecting WSI that contain cancer cells. The session will walk through the process of designing the system, training a deep model using TensorFlow (expect a discussion on GPUs) and call out all challenges encountered along the way.

The system developed by NLP Logix received an IEEE award for image process as part of the 2016 Grand Challenges in Biomedical Image Analysis.

This site is open source. Improve this page.