Build Schedule

2,4,8 & 16 - these aren't just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade? 
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe & India) and SQLbits since 2008. 

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading  SQL Server (2000 to  2012),  SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources. 

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday & SQLbits UK.
We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why & how such a solution.

Satya SK Jayanty

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration

Level: Advanced

Session Code:

Date: June 10

Time: 11:00 AM - 12:30 PM

Room: 2065

Add to Schedule

Dealing with SQL Server Failover Clustered Instances and Availability Groups for local high availability is already complicated with a lot of the external dependencies such as the network and the Windows Server Failover Cluster (WSFC.) But it becomes even more complicated when you stretch it out for disaster recovery to Microsoft Azure. In this session, learn the five (5) things that you need to consider when you implement SQL Server Failover Clustered Instances and Availability Group for disaster recovery into Microsoft Azure. We will cover how Active Directory, DNS, WSFC heartbeat and quorum configuration affects deployments of SQL Server Failover Clustered Instances and Availability Group in a disaster recovery site and how to properly configure a client application for connectivity.

Edwin Sarmiento

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 2064

Add to Schedule

Tired to look at colored and nice shape plans? Want to go further and see geek stuff? Came to this session to explore the query trees, internals and deep analysis on execution plans on SQL Server. This is a advanced session, so, expect to see lots of traceflags, undocumented and nasty execution plans.

Fabiano Neves Amorim

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 4

Add to Schedule

This presentation covers the steps necessary to build and use prediction function, along with the development of Power BI visualization. We will apply machine learning method with R Programming language and consider its practical application. In addition to this, we will walk through the steps of creating and integrating a Power BI Dashboard to visualize the enriched data.

Adriano da Silva

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 2072

Add to Schedule

So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements.

You will learn:

- Common design patterns and guidelines that you need to consider when building your architecture
- Proper selection of quorum configuration
- Network configuration for local and geographically dispersed replicas
- Combining SQL Server Failover Clustering with AlwaysOn Availability Groups

Edwin Sarmiento

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 2064

Add to Schedule

Microsoft Cognitive Services are a set of APIs, SDKs and services available to developers to make their applications more intelligent, engaging and discoverable. Microsoft Cognitive Services expands on Microsoft’s evolving portfolio of machine learning APIs and enables developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications. Joe will be demonstrating a wide variety of the APIs in multiple clients including PowerApps, Flow and Power BI. He will also be discussing what he learned at Build about new and expanded Cognitive APIs launched there.

Joe Homnick

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: 2072

Add to Schedule

Let's take a lap around Azure Data Lake Store & Analytics!  We'll cover what it is, how it's architected, why you might want to use it, and what other tools are involved (U-SQL!).  The session will consist of an overview of the data store and analytics options, a live demo, and some discussion of how it all comes together.

Audrey Hammonds

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 2072

Add to Schedule

Innovative Architects has successfully delivered hundreds of projects over the course of our 13 year history using a unique mix of technology excellence and focus on understanding our client’s needs.  The purpose of this session is to discuss these core principles and show how a handful of specific areas of focus can make your projects run more smoothly.  The topics we cover will include technical delivery, likability, resourcefulness, versatility, expectation management and communication. Our time will be spent explaining how we implement these concepts, what we expect from our consultants in each area and how that translates into lower project stress.

Jay Alexander

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 2074

Add to Schedule

In order to ascertain the abilities of cloud computing platform, let us overview what is available & offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.

Satya SK Jayanty

Session Type:
Extended Session (90 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 10

Time: 1:30 PM - 3:00 PM

Room: 2073

Add to Schedule

There are many "social media outlets" but not all of them are "the right one" for you, specially if you don't have a brand. With today tools and methodologies you don't need to be a Kardashian or Zac Efron to build your own brand, or have an army of people to managed it. 
Building a brand has to be intentional. You cannot just be you. Discovering the things that make you unique is not enough. You have to package these things in a way that highlights and perhaps even over exaggerates them.
In this interactive session you will learn how to use Social Media to create you personal brand to positioning yourself as a pro, increasing your self confidence, increasing sales and much more.

Patricia Monica Ojeda

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 2074

Add to Schedule

As IT professionals we can create reports from SQL using  SSRS, SSMS, Business Objects, Crystal Reports or other popular tools.   How many times have we created something fantastic only to hear the CEO, CFO or sales teams say "That's great... but I want it in Excel".  Ugh!  

Instead of fighting your users, make them your partners!  Save time running reports or making small changes for users... empower the business!  You don't have to do the export-import thing!  Learn some basic techniques to interact directly with SQL to create beautiful Pivot Tables and Graphs, right from Excel.  You can even ensure the CxO will always have fresh data and eliminate sync issues with your other reports.

Perry Patterson

Perry Patterson

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 2071

Add to Schedule

SQL Server determines how multiple processes access the same data simultaneously based on the transaction isolation levels.  Because the locking strategy that the database utilizes to control access to data pages is different between the different isolation level settings, the effects on database performance will also be different.  The right isolation level must be chosen to achieve a good balance between data concurrency and performance.  In this session we will review the isolation level options in SQL Server, their effects on data locks, and performance considerations when running under each of the isolation level.

Carlos Colon

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: June 10

Time: 12:30 PM - 1:30 PM

Room: 2064

Add to Schedule

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.

Vishal Pawar [MVP]

Session Type:
Regular Session (60 minutes)

Track:
Power BI and more

Level: Beginner

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: 7

Add to Schedule

Most of us from Engineering background have learnt Statistics to varying degree in college. With the rising popularity of Data Science, there is tremendous opportunity to put the theory to use in various practical applications.

However, if you have not learnt Statistics earlier, this session will provide the basics of some of the concepts and explain how to apply them to solve various business problems. Some of the examples of topics include Regression, Bayesian, Clustering, and Decision Trees. You will also learn techniques to avoid some of the common pitfalls such as Over-fitting the model.

Finally, the session will give you tidbits to explore advanced concepts on your own.

Josh Kodi

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 2072

Add to Schedule

Today's Business Intelligence Tools allow to secure the data for a variety of business scenarios. Learn How Row Level Security and other security data technologies can be implemented in Power BI, SSAS, and SQL Server and can change the design of corporate Apps using Active Directory.
In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design and architecture of data security using different tools: Power BI, SSAS, SQL Server, Web Apps and explain when to use them, their differences and their limitations. Throughout the session, we explore and demo various ways to secure the data and witness how to implement the security in each.

Hector Villafuerte

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: 2071

Add to Schedule

I've been working on a DevOps team for more than year. Join me as I talk about culture, tools, and processes that are all part of the journey to continuous release.  My goal is to get you thinking about how your job as DBA or database developer changes when you're part of a team that is striving to release faster. Part of that will be sharing the tool stack I use right now and why, and some of the many challenges I've hit so far.

Andy Warren

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 2066

Add to Schedule

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!

Luis Figueroa

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 2073

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 biweekly 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 highly interactive group session, you will learn multiple career strategies for maximizing both the Love and the Money of your multidimensional technology career.

Alex Funkhouser

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 2074

Add to Schedule

Power BI is constantly evolving; this session is an overview of the current abilities and ways to implement Power BI, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Pricing models, and intro to SSRS 2016 Preview with Power BI. Sample data set used in this presentation is from @DogRates)

Julie Smith

Session Type:
Regular Session (60 minutes)

Track:
Power BI and more

Level: Beginner

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 2071

Add to Schedule

The SQL Server and Data Access frameworks provide developers a rich set of features that help integrating SQL Server as the system database backend in virtually no time. This simplicity, however, often leads to common database design and code mistakes that introduce severe performance issues later when systems work under the heavy load. 

This session shows several common mistakes and inefficiencies that can be found in many production systems such as excessive code reuse in the database using the views and multi-statement functions and in the data access code; unnecessary joins and I/O operations in pagination queries; storage of multiple entities in the same tables using XML for entities-specific attributes; usage of the optional parameters in the where clause of the queries; and several others. The session explains the root-cause of performance issues those mistakes introduce and demonstrates how to properly address them in the code and database design.

Dmitri Korotkevitch

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: June 10

Time: 4:00 PM - 5:00 PM

Room: 2067

Add to Schedule