Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 58
SQL Server 2016 introduces a new way of deploying an availability group: Distributed Availability Groups. This new form of an AG allows you to span different underlying Windows Server Cluster topologies which can enable both disaster recovery and migration scenarios. This session will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario, as well as show a demo of one in action.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 3:05 PM - 4:05 PM

Room: 211

Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and Power BI. Get ready to go beyond bars and bubble charts!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: March 11

Time: 12:25 PM - 1:25 PM

Room: 218

Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in Power BI? Do you you have a need for analysis  services but don't want to have to deal with the hassle of buying and installing a server?  Is your organization using Office 365?  If you answered yes to any of these questions, you might need Azure Analysis Services.  The wait is almost over! Azure Analysis services is the platform as a service version of the wildly popular Analysis Services Tabular product. Join Phillip as he builds and deploys an Azure Analysis services solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 10:55 AM - 11:55 AM

Room: 218

Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: March 11

Time: 8:15 AM - 9:15 AM

Room: 224

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

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 11

Time: 3:05 PM - 4:05 PM

Room: 216

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

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 11

Time: 9:35 AM - 10:35 AM

Room: 211

TBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 11

Time: 10:55 AM - 11:55 AM

Room: 211

Power BI Query Editor (AKA Power Query / Get & Transform in Excel) is a magnificent tool for self-service ETL. While it is so easy to perform basic data cleansing with its user interface, there are common data patterns that are not easily achieved. Many users will shy away from Power BI Desktop when confronting these patterns. But not you! Join this session to learn the almost secret sequence of transformation steps in the UI to resolve the most common data wrangling challenges.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: March 11

Time: 3:05 PM - 4:05 PM

Room: 214

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 11

Time: 10:55 AM - 11:55 AM

Room: 214

Continuous Integration & Delivery isn’t a new concept.  Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up.  Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I'll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments.   We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 11

Time: 9:35 AM - 10:35 AM

Room: 217

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about: 

Asking the right questions to set yourself up for success
Making the case for stored procedures over ad hoc code and other objects
Pro tips for standardization and cross-version compliance
Reevaluating and expanding on your solution
Limiting inputs to reduce unexpected behaviors and errors
Choosing between alternate solutions
Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 11

Time: 12:25 PM - 1:25 PM

Room: 216

This will be a presentation on the native Task Schedulers of the world (Windows Task Scheduler, SQL Agent and Cron), and the gaps that can be filled by JAMS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 11

Time: 12:25 PM - 1:25 PM

Room: 222

A "Disaster" doesn't need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA's toolbox.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 12:25 PM - 1:25 PM

Room: 214

It's been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we've needed all along. In this session you'll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you'll approach your next project ready to answer all of the questions that constant change brings to the table.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 11

Time: 1:45 PM - 2:45 PM

Room: 209

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 12:25 PM - 1:25 PM

Room: 217

Come to this session to find out why SQL Server 2016 SP1 revolutionized SQL Server allowing a consistent feature and functionality surface area for developers and organizations across all SQL Server 2016 editions, a first in the industry. This will enable developers, ISVs and customers to build advanced applications that scale across editions and cloud as you grow.  SQL Server 2016 SP1 Standard Edition sets the bar for rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Then easily upgrade to Enterprise Edition for mission critical capabilities as your workload scales, without having to re-write your application. 

Key Learning:
Learn the new features made available with SQL Server 2016 SP1 Standard Edition
Develop more powerful application that were not possible before with Standard Edition
Learn how to upgrade to SQL Server 2016 Service Pack 1
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 8:15 AM - 9:15 AM

Room: 211

The audience will be presented with a number of broken-down replication scenarios and they will hunt down the cause of each failure and find ways to correct the problem and/or prevent it from happening again. Throughout the adventure, the various replication types will be discussed and pro-active methods of monitoring and fault tolerances will be discussed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 11

Time: 12:25 PM - 1:25 PM

Room: 224

Are you a lone DBA shop or a big shop with too many servers to handle?  If so, how do you keep up with the availability and performance of your SQL Servers? Have you rolled your own monitoring solution…even that’s hard to keep up with. It’s time for a professional grade monitoring tool to help YOU do your job…more efficiently. In this session we’re going to discuss why you should monitor your SQL servers, and specifically why you should use a monitoring tool. We’ll introduce Redgate’s SQL Monitor and demonstrate how you can use this tool to make YOU faster and your SQL Servers!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 11

Time: 10:55 AM - 11:55 AM

Room: 209

This session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for certification..
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 11

Time: 3:05 PM - 4:05 PM

Room: 218

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks.  This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 11

Time: 8:15 AM - 9:15 AM

Room: 215

Sessions Found: 58
Back to Top cage-aids
cage-aids
cage-aids
cage-aids