Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 43
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.
Speaker:

Accompanying Materials:

No material found.

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

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 6

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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 1

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: 6

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 6

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 8

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 8

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 5

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.
Speaker:

Accompanying Materials:

No material found.

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

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 6

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 5

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 3

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 7

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 8

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)
Speaker:

Accompanying Materials:

No material found.

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: 5

When managing a single instance it can be fairly easy to keep track of the configuration of that instance, but what about when you have more than 10 instances to manage? How do know they are setup correctly?  How do you maintain the databases on each instance and their configurations? How do take care of patching? In this talk we will answer these questions and more as we discuss best practices and technologies (such as PowerShell and CMS) to help keep your instance configurations in-sync.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: 1

If you are a developer+DBA, consultant+DBA, IT Manager+DBA, Intern+DBA, technical support+DBA or just a DBA, this session will be useful to you. After working for many years as developer and consultant, the SQL Server MVP Fabiano Amorim has being working with many day-by-day DBA tasks. In this session he will speak a little about the DBA job and show some very good tips about how to do it with efficiency.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: 1

SQL Server 2016 lifted several limitations from its initial implementation.
This session will cover how to implement InMemory objects, new capabilities (Defaults, Checks, FK validation, Triggers); performance gains; and an introduction to monitoring these objects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: June 10

Time: 2:45 PM - 4:15 PM

Room: 2

Everything in our day to day lives as a DBA is about limits-
•	Limits in space
•	Limits in platform
•	Limits in resources
•	Limits in expertise


This session is about how to remove those limits.  How to provide all the databases you need without having to constantly ask for more disk space.  How to provide a databases as fast as they are needed for new projects, new test cases and new challenges.  How to do more with less time, less people and less hardware and last but not least, how to do all of this without having to become an expert in 20 different languages, products and specialties. 

Join Kellyn Pot’Vin-Gorman as she demonstrates why virtualization is key to empowering the database administrator.  This session will cover how to:
•	Ease patching and upgrading.
•	Offer virtualized environments for every project-  development through production with only a 1/3 or the resources once required.
•	How to change OS and database platforms without losing your mind.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: June 10

Time: 2:45 PM - 3:45 PM

Room: 2

R is a popular scripting language for data science and visualizations. In this talk we will be going over the basics of the ggplot2 library along with data.tables and rtiny for the purposes of data visualization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: June 10

Time: 4:00 PM - 5:00 PM

Room: 5

Sessions Found: 43
Back to Top