Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type


Sessions Found: 55
Get extreme performance and flexibility with modern day infrastructure from Dell EMC.

This discussion will cover new and upcoming infrastructure technologies, such as Flash, Storage Class Memory, NVMe, and NVDIMM. These exciting new technologies can super charge your database and transaction log performance.
Speaker:

Accompanying Materials:

Session Type:
Gold Vendor Lunch Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 12:30 PM - 1:15 PM

Room: 1.141

Does this sound like you? You've been BI curious and now you've been given access to SSRS and you want to make a report. Or, you're a DBA or DBA Dev and could use a report to reduce daily task. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed.  We’ll use SSRS (SQL Server Reporting Services) 2016. The query makes no difference, this time it's all about the output.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 23

Time: 4:00 PM - 5:00 PM

Room: 1.142

Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood. 

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: June 23

Time: 4:00 PM - 5:00 PM

Room: 1.113

Join John Sterrett, Principal Consultant at Procure SQL LLC to learn how execution plans get invalidated and why data skew could be the root cause of seeing different execution plans for the same query. We will look at the options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using new features in SQL Server 2016 and SQL Server 2017 called Query Store and Automatic Tuning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 1:30 PM - 2:30 PM

Room: 1.113

SSIS was originally designed to work in a world where all data was structured and on premise. As modern enterprise data projects increasingly move online, tools like Azure Data Factory (ADF) can extend SSIS capabilities to the cloud. Azure Data Factory is a flexible and powerful cloud based ETL service, but it doesn't replace the functionality of SSIS. 

In this session you will learn the advantages and disadvantages of both ETL platforms; how to use both in tandem to maximize productivity; and how both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script. 

All of the code used in this presentation can be downloaded by attendees, customized, and used in their production environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 23

Time: 2:45 PM - 3:45 PM

Room: 1.117

You can't wait to move your databases to an Azure PaaS offering so you don't have to patch and maintain an operating system and SQL Server.  You looked at Azure SQL DB, but there are some limitations that prevent you from migrating to this service. Don't worry, you're not stranded.  There is a new option designed to "Lift and Shift" your workload to Azure PaaS.  It's a brand new offering that just came out of private preview and into public preview.  We'll discuss this new offering, its advantages, and how you can migrate with ease.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 9:45 AM - 10:45 AM

Room: 1.148

Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success.  Often times we focus on showing how smart we are instead of showing what a good team member we can be.  We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills?  We will explore innovative and fun ways in which to do just that!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 23

Time: 9:45 AM - 10:45 AM

Room: 1.117

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 23

Time: 4:00 PM - 5:00 PM

Room: 1.117

Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the data – only that which is new or changed since the last load. For that to work properly, there must be a reliable system for detecting delta data touched since the most recent load. 

In this session, we will review the tools and design patterns available in SQL Server for performing change detection. From source detection methods including change tracking and change data capture, to in-flight comparisons using hashed values, and even brute-force methods as a last resort, we’ll cover the spectrum of change detection tools in SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 23

Time: 2:45 PM - 3:45 PM

Room: 1.141

Cloud (AWS, Azure, Google or whatever else out there) is a reality now and for most of the organizations question is not "if", it is "When". 

Cloud has and will continue to transform DBA's role from tactical to strategic. We will start our session with a quick discussion about Cloudy DBA and cloud computing fundamentals. 

After that we will dive deep into Amazon and explore different options for running SQL Server database in AWS. We will compare available options, evaluate their differences and suitability for different workloads. We will also cover cloud migration approaches, connectivity, AD Authentication, backup and recovery, performance, monitoring, HA/DR, security, compliance, licensing and related best practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 8:30 AM - 9:30 AM

Room: 1.142

Unless you are developing code by yourself, you face challenges of working with several team members. Different people are changing code which affects the code someone else is working on. In addition, there will be teams working on different projects at the same time.  In the middle of the projects, an emergency fix needs to be deployed to Production. So where is the code, when do you shared it with others, when do you get the code that has been shared, where is the production code branch located.  How do I branch and when do merge? How do I get a release branch? Let me share with you how we are handling this area of DevOps.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 23

Time: 8:30 AM - 9:30 AM

Room: 1.149

So, you have heard the buzz and your development team wants to use Cosmos DB. But what does that mean to you? As your company's data architect or DBA, you are ultimately responsible for things like data security, query performance, scale, costs, and availability. Your management wants you to handle all data assets. This will be an opportunity to be introduced to Cosmos DB and understand some of the areas that matter most to a DBA in an enterprise. Not only will we cover enterprise topics, but we will create a Cosmos DB using the SQL API and demo some of the capabilities. The world of data is still changing, this is one area to understand as the technology marches on.

What you will learn
	- Basics of Cosmos DB, the what, where and how
	- Enterprise considerations for the data pro when using Cosmos DB 
	- How to create a Cosmos DB and get more hands on experience with the technology
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 4:00 PM - 5:00 PM

Room: 1.149

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Gold Vendor Lunch Session (45 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 23

Time: 12:30 PM - 1:15 PM

Room: 1.142

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 23

Time: 4:00 PM - 5:00 PM

Room: 1.141

A theoretical discussion on the topic of graphical data modeling using enterprise modeling tools.

I this session, we will discuss why we model data, the different modeling types, and different modeling techniques. We will explore why and when to use different modeling techniques and we will explain how to use dimensional modeling when developing data warehouses, SSAS Cubes, and Power BI Analytics.

“Real World” sample model diagrams will be used to explain these different modeling techniques in an attempt to bring a more tangible aspect to the theoretical aspects of the discussion.

Why Model Data
	The Value of Enterprise Data
	Business Benefits of Data Modeling

Different Model Types
	Conceptual / Logical / Physical
	Dimensional

Different Modeling Techniques
	Star & Snow Flake Schema
	Slowly Changing Dimensions
	Many to Many Relationships
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 23

Time: 9:45 AM - 10:45 AM

Room: 1.149

In this session, you will learn the basics of building a data vault to organize and store your companies disparate data on SQL Server.  Learn how Hubs, Links, and Satellite tables create options for storing a variety of data from multiple systems.  The data vault structures will then be used as the data source to create views designed for SQL Server Analysis Services Tabular models.  Finally, Power BI will be used to visual the data for your end users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 23

Time: 8:30 AM - 9:30 AM

Room: 1.141

Have you wanted monitoring tools but know it is not feasible to procure them for your whole SQL Server enterprise?  In this session, you will learn how to implement multiple solutions to help you be a Proactive DBA instead of retroactive DBA. You will understand which checks should be mandatory for every SQL Server environment.  You will also learn common pitfalls with implementing your own monitoring solutions and how to customize them to work for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 8:30 AM - 9:30 AM

Room: 1.148

Dynamic SQL is one of the best tools to have in your Developer tool chest.  Dynamic SQL helps you design flexible code that can be manipulated at runtime.  This session will walk you through the Pros and Cons of Dynamic SQL.  Will give you the knowledge to build dynamic tables, pass in parameters and display your material in a pivot table.  New this year, this session will give you the first steps to build multiple databases, alter tables dynamically across databases and do simple backups all through Dynamic SQL.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 23

Time: 2:45 PM - 3:45 PM

Room: 1.142

The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/2017 and Azure SQL DB with predicate based RLS and in Power BI, as well.

This session will show how organizational & asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/2017, Azure SQL Database and Power BI without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations.

Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 9:45 AM - 10:45 AM

Room: 1.142

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 11:00 AM - 12:00 PM

Room: 1.117

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