Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type




Sessions Found: 51
Amazon Aurora is the result of being asked this question by Andy Jassy, Amazon CEO & the person responsible for the conception of AWS: "In a world where AWS exists, how would you re-design the relational database?"  What the data team came up with is a whole new paradigm shift: they built a service-oriented & decoupled architecture applied to a database engine.

Aurora has 5x the throughput comparable to enterprise commercial databases at 1/10th the cost. It’s built on AWS for the cloud, it's self-managing & self-healing. You can perform 6M inserts & 30M selects per minute, scaling out further via Read Replicas. Storage automatically grows storage up to 64 TB, and more. 

Come hear about the hottest new AWS RDS database, its unique architecture and features, and learn why it's known as an "RDS Game Changer"!
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: #6 MTC - Tintri (30)

In this session we talk about the importance of proper development methodology and why it's critically important with the database.  We'll discuss working with large teams that change and improve database objects.  We'll emphasis the importance of testing, deployment, and value delivery.  Come learn how to make the process of shipping database changes enjoyable, reliable, and repeatable.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 10

Time: 8:30 AM - 9:30 AM

Room: #1 VDMS - Verizon (120)

Today, many 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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: Sponsor

Date: June 10

Time: 1:00 PM - 2:00 PM

Room: #1 VDMS - Verizon (120)

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having all your data totally in-memory with no waiting for I/O or locks!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code: 90 minutes

Date: June 10

Time: 11:00 AM - 12:30 PM

Room: #1 VDMS - Verizon (120)

Learn about Azure SQL Data Warehouse (SQL DW) which is a fully managed elastic database built for data warehouse workloads from a few hundred gigabytes to petabytes of data. It has truly unique features like disaggregated compute and storage allowing customers to be able to utilize the service to match their diverse needs. In this session, we take a look at the architecture of SQL DW and features such as elastic scale (grow, shrink, and pause) and Polybase and how you take advantage of them for your data warehousing solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 10

Time: 2:15 PM - 3:15 PM

Room: #2 VDMS - Pure Storage (30)

Learn the benefits of Azure SQL Database in Azure.  Come see how to set up, monitor, and administer this "a-la-carte" SQL Server database up to 4 TB in size.   With Azure SQL DB your DBA staff can manage many more databases due to Azure SQL DB's Platform as a Service (PaaS) features.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 10

Time: 8:30 AM - 9:30 AM

Room: #2 VDMS - Pure Storage (30)

Many companies have small tasks that need to be accomplished regularly. Sometimes these tasks require a number of steps to be successful. Need a basic workflow app but aren't a .Net developer?  We have a solution for you.  

This session will be demo intensive, focusing on how to use SSIS, SSRS, and SQL Server standard edition to stitch together a process that emulates a proper workflow.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 10

Time: 3:30 PM - 4:30 PM

Room: #2 VDMS - Pure Storage (30)

Are you trying to understand what’s the fuzz around Machine Learning? Are you working with a lot of data analysis and wondered how SQL Server 2016 R Services might be able to help?
 
This session will provide a gentle and fun introduction to SQL Server R Services for SQL Nerds. We will walk through pragmatic examples of using R through demos, to illustrate Machine Learning in boosting your Data Analysis capabilities. The goal of this session is to provide quick tips and tricks for attendees to get started on SQL Server R Services, either for fun or for work.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: #1 VDMS - Verizon (120)

DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code: 90 minutes

Date: June 10

Time: 11:00 AM - 12:30 PM

Room: #4 MTC - Microsoft (80)

Demonstrate the steps to import raw data from text file, Access Database and Excel file into Excel 2016, and then build a dashboard using PowerPivot, Power Map and Power BI.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 10

Time: 3:30 PM - 4:30 PM

Room: #4 MTC - Microsoft (80)

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo-heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn why top down design is not always the best pattern as well as why implicit conversions can slow down your queries. You’ll learn how to rewrite most cursors as well as finding out how user defined functions affect performance. You’ll learn some simple ways to troubleshoot these types of issues using execution plans and extended events. Finally, we’ll take a look at how standards can help quicken turnaround time when refactoring T-SQL. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 10

Time: 4:45 PM - 5:45 PM

Room: #3 VDMS - AWS (30)

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 10

Time: 8:30 AM - 9:30 AM

Room: #4 MTC - Microsoft (80)

Why not create a report that only sends information if there is data?  Oh, don't have the Enterprise Edition?  I'll show you how with SQL Server Standard Edition.  This demo will walk you through the steps to create these data driven subscriptions.  We'll be using Reporting Services, Integration Services and SQL Agent Jobs to setup and schedule data driven subscriptions.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: #7 MTC - Wardy (20)

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 10

Time: 4:45 PM - 5:45 PM

Room: #6 MTC - Tintri (30)

When doing agile development, whether you have 1 production target database or in case of a SaaS solution, multiple targets, database change management becomes extremely crucial. One of the challenges with traditional SSDT projects are that they work on the "as-is" model through the development cycle and obfuscate the details of how actual changes would be applied. In this session, we will look at how to use the RedGate tools now available inside Visual Studio 2017 to manage the development process and gain better control over your deployments. 

This session will cover my experiences, tips and tricks with managing a Cloud SaaS solution and we will look at how Visual Studio 2017 and the RedGate family of tools provide tremendous value and higher confidence with our product releases.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 10

Time: 8:30 AM - 9:30 AM

Room: #6 MTC - Tintri (30)

There’s more to non-uniform memory access (NUMA) than physical boundaries in your server hardware. Putting the DEEP back into Deep Dive, this session will deliver everything you ever wanted to know about pNUMA & vNUMA settings within VMware vSphere, Windows, & SQL Server to aid you in getting the settings right to maximize performance. In addition to an overview on NUMA, we’ll discuss some nuances of NUMA that are not commonly known, effects of memory & CPU hot-add, selecting cores vs. sockets for your VMs, default calculation behavior, performance penalties for getting it wrong, and MORE!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code: Sponsor

Date: June 10

Time: 1:00 PM - 2:00 PM

Room: #4 MTC - Microsoft (80)

Pyramid Analytics' BI Office platform is one that appeals to both IT and business user requirements. BI Office offers enterprise capabilities such as wizard-driven data modeling, self-service analytics/data discovery, interactive dashboards, and narrative reporting on any device.  BI Office is a true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis.  Having a centralized platform that supports the volume and variety of data, subject areas, and users across the enterprise, BI Office allows these to all come together as an integrated, interactive solution.  Complete with role-based security that enables the right access for the appropriate audiences across the platform, BI Office enables quick and powerful insights to provide users with perspective to address challenging problems more quickly.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code: Sponsor

Date: June 10

Time: 1:00 PM - 2:00 PM

Room: #5 MTC - VMware (60)

Are you tired of doing mundane tasks repeatedly and wished there was something or someone to help?  What if you could go from nothing to having amazing new code that would automate backups AND restores, fix those pesky SPN issues, query your inventory of servers and databases and give you some quick answers to managers, auditors and everyone else asking about your databases and servers.

In this session, you'll learn about the Powershell community that is creating awesome solutions to ease your life as a DBA.  This session is aimed at DBAs from zero to heroes who want to see the new Powershell DBA in action.  Come see brand new techniques and demos and become the hero that others will envy.

Come and join me for a momentous session of PowerShell and SQL, full of demos and useful solutions that you will be able to take back to your workplace. This will improve your knowledge and skills, show you how the modern DBA will work and future proof your career by becoming a new Powershell DBA.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 10

Time: 9:45 AM - 10:45 AM

Room: #4 MTC - Microsoft (80)

Do you really know storage? A lot of DBA's think they know storage but there are a lot of misconceptions and a lot is changing in storage.  Learn how to talk to your storage admin and what questions to asks. Databases are the largest consumer of storage space and storage matters.
Speaker:

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code: Sponsor

Date: June 10

Time: 1:00 PM - 2:00 PM

Room: #2 VDMS - Pure Storage (30)

Are you tired of users constantly coming to you for data?  Would like to be able to quickly and easily enable your uses to go get the data themselves?  Do you simply not have the budget/executive buy-in to purchase a BI solution?  In this session you will see how easy this often overlooked and underutilized feature of SQL Server is to use.  The session will start with a quick overview of some reporting examples followed by a live demo that will cover the basics of developing, publishing and using an SSRS report.  It will cover all aspects of report creation from connecting to the data source through putting the data on the page and publishing to the report server.  You will learn how to use this powerful feature of SQL Server that can relieve you from data delivery tasks and thrill your end users.  Return to the office and present meaningful data to your end users with minimal time and effort with the tips learned in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes) (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 10

Time: 2:15 PM - 3:15 PM

Room: #1 VDMS - Verizon (120)

Sessions Found: 51
Back to Top