Build Schedule

We will speak about the current BI Market, current BI trends and we will explain how the capabilities of Necto on top of the Microsoft SQL & SSAS are a game changer for the BI market and specially for the Microsoft segment. 

Yoav Yetinson

Session Type:
Lunch Sponsor Session (45 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 18

Time: 12:30 PM - 1:15 PM

Room: BI/SSAS (Rm 2065)

Add to Schedule

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, SQL Server Management Studio and other third party tools, to use as practical examples of how to write MDX queries.

Shabnam Watson

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 18

Time: 1:30 PM - 2:30 PM

Room: BI/SSAS (Rm 2065)

Add to Schedule

SQL Server R Services provides a platform for developing intelligent applications that uncover new insights. In this session we will show how to get started with SQL Server R Services to operationalize R solutions or to create powerful data exploration and predictive modeling solutions.

Jose L. Rivera

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: June 18

Time: 9:45 AM - 10:45 AM

Room: BI/SSAS (Rm 2065)

Add to Schedule

In this session we will review our database as a service offering, Azure SQL Database. We will also recap and demo the recent advancements such as Threat Detection, Query Performance Insight, Query Store, Database Index Advisor and more.

Pankaj Satyaketu

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 18

Time: 1:30 PM - 2:30 PM

Room: Azure /Big Data (Rm 2066)

Add to Schedule

Today we live in a world where quad core cell phones is becoming a common theme.  Cloud computing is cheap and the services are advanced.  The sheer quantity of services can blow your mind.  This talk goes through how to deliver product where intelligence is at the core of the product.  We will cover building intelligence into the device, retrieving data from the device, analyzing it in the cloud and then surfacing important insights back into the device.

David Crook

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: June 18

Time: 2:45 PM - 3:45 PM

Room: BI/SSIS (Rm 2074)

Add to Schedule

Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. 
Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about  performance, scale, availability and support for what is usually considered their most critical applications.  In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience  and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the author of the official SQL server on VMware best practices guide.  

Niran Even-Chen

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 18

Time: 1:30 PM - 2:30 PM

Room: DBA (Rm 2071)

Add to Schedule

This session provides case studies in rewriting bad SQL, with a lot of discussion on what makes sql code "bad"

Jeffrey Garbus

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 18

Time: 11:00 AM - 12:00 PM

Room: Developers (Rm 2067)

Add to Schedule

Becoming certified in SQL Server is a great career move and can be very rewarding for a new or seasoned database professional. This session will provide you with an overview of the SQL Server Certification program, including the changes made to the program for certification on SQL Server 2012 and 2014. You’ll also discover the benefits of becoming certified, and some of the best ways in which to do so. You’ll leave the session armed with great tips and tricks to pass the exams on the first try. If you are thinking about getting certified in SQL Server in the near future, then this session is definitely for you.

Marilyn Rousseau

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 18

Time: 1:30 PM - 2:30 PM

Room: Professional Developement (Rm 3044)

Add to Schedule

This session is designed to teach DBAs and developers the best strategy to transfer large data. 

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode. 

Simon Cho

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 18

Time: 9:45 AM - 10:45 AM

Room: BI/SSIS (Rm 2074)

Add to Schedule

Learn how Cisco and Microsoft's strategic partnership has led to the creation of a powerful joint solution-MSFT SQL Server on Cisco UCS-to help companies migrate their SQL Server workloads to 2014/2016 versions. 

Ed Cho

Session Type:
Lunch Sponsor Session (45 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: June 18

Time: 12:30 PM - 1:15 PM

Room: Developers (Rm 2067)

Add to Schedule

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.  

Michael Keleher

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 18

Time: 11:00 AM - 12:00 PM

Room: DBA (Rm 2071)

Add to Schedule

Join Joe on a fun and informative session on the current state of Microsoft Business Intelligence (BI) offerings. We will look at the array of tooling around BI in SQL Server 2016, Power BI and Cortana Intelligence. There have been major changes in reporting and cognitive data source capabilities the last few months. This session will get you caught up on your current BI possibilities with many dazzling demos.

Joe Homnick

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 18

Time: 11:00 AM - 12:00 PM

Room: BI/SSAS (Rm 2065)

Add to Schedule

You've used every database trick you know and the latencies and user experience are still unacceptable. Now what?

Join Kaminario as we discuss a number of Use Cases where helped clients database challenges by deploying a cost effective All Flash Array (AFA).

Olivier Renard

Session Type:
Lunch Sponsor Session (45 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: June 18

Time: 12:30 PM - 1:15 PM

Room: DBA (Rm 2071)

Add to Schedule

Power BI has a many moving parts that can make it difficult to know when and where each part of the tool is necessary.  In this half day session get a clear end to end journey through creating a Power BI solution.  Start with the data discovery phase by importing and applying business rules to your data.  Then load that data into a data model where you can apply hierarchies and calculations.  Finally using that data model design reports to visualize the results.  Once complete learn how the results can be shared with others by creating dashboards on the Power BI service.  Taking this end to end trip through the tool will allow you to fully understand how each piece fits together.

Devin Knight

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 18

Time: 9:45 AM - 10:45 AM

Room: Power BI/more (Rm 2073)

Add to Schedule

Come see Dell Software’s premier SQL Server diagnostics solutions Spotlight.  Spotlight can ensure peak performance around the clock with unmatched monitoring, diagnosis and optimization of SQL Server environments.  Come learn how Spotlight can provide intuitive overviews of performance health, automated alerts with actions, and mobile device support.  Everyone who attends will also receive a free 3 month license of the solution!

Gordon Cornelius

Session Type:
Lunch Sponsor Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 18

Time: 12:30 PM - 1:15 PM

Room: Performance Tuning (Rm 2072)

Add to Schedule

• Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?
• Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are using the latest, most marketable technologies?  
In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career. 

Alex Funkhouser

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: June 18

Time: 2:45 PM - 3:45 PM

Room: Professional Developement (Rm 3044)

Add to Schedule

Power BI is the future of Microsoft's reporting platform. It is a powerful tool allowing users to import data, model data and create stunning reports all with very little effort. Power BI Desktop gets a lot of updates and you can be sure this session will show you the latest and greatest.  

Learn how to organize your data, create relationships and build useful calculations. Next, we will visualize the data with a variety of beautiful charts, graphs, maps and gauges. Finally, we will show you how easy it is to deploy and consume the report. It sounds like a lot of work, but you will be surprised at how quickly and easily an actionable model and report can be built. We will do it all in less than 60 minutes!

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 18

Time: 1:30 PM - 2:30 PM

Room: Power BI/more (Rm 2073)

Add to Schedule

Salvi works on a non-profit that connects thousands of Cubans to the web, via email. In Cuba, 25% of the population can access to email only, while 5% access to the Web without restrictions. After three years of work, his non-profit organization has collected several gigs of data that can re-shape our understanding about Cuba. 

Salvi will show data collected by this great technology, and how fascinating can be interpreting row information from a country that has been censored internally and externally for generations . The audience will have a unique opportunity to learn this technology, access this data and to use their skills to make a worldwide impact.

Salvi Pascual

Ibis Arrastia

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 18

Time: 4:00 PM - 5:00 PM

Room: Professional Developement (Rm 3044)

Add to Schedule

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.

Sebastian Meine

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 18

Time: 2:45 PM - 3:45 PM

Room: Performance Tuning (Rm 2072)

Add to Schedule

It's Monday morning and everyone is complaining that the database is slow. You see the problem - even though indexes aren't fragmented and statistics are up to date the query optimizer is choosing a bad plan. Users want it fixed (now!) and you know a way to get things working again but you're not allowed to change code because...it's production. What's a good DBA going to do? Show the query optimizer that you're the boss with plan guides! In this session you'll learn what plan guide are, how they work, and when to (and not to) use them to make under-performing queries behave.

Kendal Van Dyke

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 18

Time: 11:00 AM - 12:00 PM

Room: Performance Tuning (Rm 2072)

Add to Schedule