Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 34
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

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

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: 11:00 AM - 12:00 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

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

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

In this session I will provide an overview of the Azure Service Bus and how to use it directly from SQL Server to send messages between multiple SQL Server databases across the globe. Sending messages to a service allows database administrators to replicate data from one database to another, or to multiple databases using a subscription model. This demo introduces a technology called Enzo Unified to allow direct connectivity to the cloud from SQL Server databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

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

“Performance dreams  wait for you at SQL Server 2014 and Come true at SQL Server 2016 “, it is just like this because you there are unbelievable performance reads and substantial improvements that can drive your DB environment to a distinct level of stability and Performance to be a leading environment in a very short time ..! It looks like apparently a myth or legend to see those new SQL Server 2016 features how they could flipped up SQL Server Powers from the old generation to the new generation of in-advanced analytics using In-memory and CCI (Colmnstore indexes) where no longer need for any DWH solutions at all but just reading data directly from production DBs with ZERO performance impacts on end users  ..! come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 & 2016 regarding performance particularly like  Microsoft project “Hekaton” for In-memory built in for OLTP , CCI( columnstore index) ,Resource Governor for IO consumpti
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 2

As PowerShell is the main technology for automation in Windows Datacenters Infrastructure, now becomes clear its importance in other non-Windows Operating Systems. The way I see it, Windows Admin has the advantage with PowerShell as the Linux Admin has the upper hand with Bash/PHP/Python. Here’s where we can collaborate and work with each other.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: June 10

Time: 11:00 AM - 12:00 PM

Room: 4

Dynamic Data Masking (DDM) allows database administrators to obfuscate data columns containing sensitive data from unauthorized users without changing the data stored in the database.  This new features has some limitations that prevent it from being used as the only mechanism for securing sensitive data, but it does provide additional flexibility to administrators, developers, and support personnel on querying sensitive data and maintaining compliance.  In this session we will explore how to set up Dynamic Data Masking for use in production support and for generating production-like test data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: June 10

Time: 1:30 PM - 2:30 PM

Room: 3

Sessions Found: 34
SQLSaturday