Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 42
Continuous integration, delivery, and deployment are common elements of modern DevOps practices. However, it’s rare to see these practices put into place for data-centric applications, like databases, ETL, data warehouses, or reports. In this session, we’ll cover why these approaches are beneficial for the data organization and the pieces you need to have in place to be successful. We’ll also cover some of the prime trouble spots that organizations run into, as well as some tools that can help jump start your efforts.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Perform

Level: Intermedia

Session Code:

Date: April 27

Time: 9:45 AM - 10:45 AM

Room: 301

Automating extract packages is trivial., you simply use INFORMATION_SCHEMA.  The problem is not all your data sources have easy to read metadata like SQL Server.  How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.  

With that schema, automatically generating your extract package is a matter of seconds!  Join me while I share my interrogator project with you and start saving hours at work today!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Innovate

Level: Intermedia

Session Code:

Date: April 27

Time: 9:45 AM - 10:45 AM

Room: 117

Azure ML Studio provides the tools to easily build and deploy machine learning models.  In this session we will discuss the process of building a model with Azure ML using a case study.  
We will also share practical tips including pitfalls to avoid when using customer data, how deployment affects the machine learning model, and how to build trust in the predictions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Innovate

Level: Intermedia

Session Code:

Date: April 27

Time: 2:30 PM - 3:30 PM

Room: 117

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:
Vendor Session (45 minutes)

Track:
Vendor Session

Level: Intermedia

Session Code:

Date: April 27

Time: 12:15 PM - 1:00 PM

Room: 221

Every DBA should know about database corruption because it can be a resume generating event. A corrupt database can ruin your day, affect system stability, lead to unnecessary downtime, and possibly data loss. 

In this presentation we will explore database corruption, learn how to diagnose, and see what we can do to fix it. We will discuss the causes, dispel some myths, and learn what questions to ask. After this, we dive into discovering the root cause and putting a plan in place to stop it in the future. Demos will illustrate diagnosing, troubleshooting, and fixing database corruption. Prepare to break a database and go through the steps to return it back to a usable state. 

Beginners will benefit along with others who may one day find themselves with a corrupt database. By the end of the session, you will have the tools and understanding necessary to take corrective action and prevent your databases from corruption!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Support

Level: Beginner

Session Code:

Date: April 27

Time: 8:30 AM - 9:30 AM

Room: 301

DevOps is a software delivery philosophy that focuses on delivering quality, faster.  The purpose of this session is to cover some of the basic principles of DevOps and how they apply to database development and administration.  Everyone's environment is different, but the strategies discussed within can be translated into basic tactical gains that are easy to implement.

Topics covered include:
* a (VERY) brief history of DevOps
* why DBA's make the best DevOps engineers
* what admins can teach developers, and what developers can teach admins
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Innovate

Level: Beginner

Session Code:

Date: April 27

Time: 2:30 PM - 3:30 PM

Room: 223

How to identify when there are IO bottlenecks by walking through the Windows storage IO stack.  Starting at the top with SQL Server all the way down to miniport driver, collect and analyze data using DMV queries, PerfMon, storport tracing and WPR tracing to identify and isolate IO bottlenecks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Perform

Level: Beginner

Session Code:

Date: April 27

Time: 8:30 AM - 9:30 AM

Room: 223

Do you have multiple servers in your environment?  
Do you have have multiple databases that share the same schema on the same instance (sharding)?
Do you wish you had a simple way to run a TSQL script against an instance without having to use SSMS?
Do you tire of other people forgetting to deploy to one of your servers?
Do you wish you had a way to communicate when someone deployed code to an instance?
Do you enjoy ASCII art?
Are you lazy?

If you answered yes to any of the above and wish you had an easier way to "Right click file(s)" and just deploy them to instance(s), I think I might have the solution for you.  This is a free and open source PowerShell based solution that you are welcome to use.  It can rely on a CMS (Central Management Server) or CSV file for server list.  

This doesn't solve the need for a proper release process or CI Automation but sometimes you just need to do things manually.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: April 27

Time: 9:45 AM - 10:45 AM

Room: 221

Data breaches abound! Do you want to keep off of the data breach list? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt?  What else can you do to protect your sensitive data?

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.  

You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance.  In addition, you will gather information on how to fully protect and review your sensitive data usage.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Design

Level: Beginner

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: 117

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

Level: Beginner

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: 221

Extended Events was introduced in SQL Server 2008. Every release since then, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Innovate

Level: Beginner

Session Code:

Date: April 27

Time: 1:15 PM - 2:15 PM

Room: 223

R, R Studio, Microsoft R Services, Microsoft R Server, Machine Learning Server. What is R and how do you make sense of all these R options?

Join me for a quick R timeline and description followed by some use cases and live demonstrations.

Take with you a better understanding of why analysts, developers, DBAs, PMs, CIOs, and others want to know what is up with R.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Evolve

Level: Beginner

Session Code:

Date: April 27

Time: 2:30 PM - 3:30 PM

Room: 221

Chris Skorlinski, Microsoft SQL Escalation Support Engine will share a collection of short stories, how it happened, the consequences, and most important, how to avoid your own horror story.  Come along and share your own SQL Server tales of the deep and macabre.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Support

Level: Beginner

Session Code:

Date: April 27

Time: 3:45 PM - 4:45 PM

Room: 223

Azure Machine Learning services is an integrated, end-to-end data science and advanced analytics solution that provides professional data scientists and data engineers with tools not only to develop ML models, but also tools for data preparation and wrangling, data visualization, model deployment and model management at cloud scale. The session will teach the attendees how to get their hands on each tool in the stack.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Innovate

Level: Intermedia

Session Code:

Date: April 27

Time: 3:45 PM - 4:45 PM

Room: 117

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query.  Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.  

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Scale

Level: Beginner

Session Code:

Date: April 27

Time: 3:45 PM - 4:45 PM

Room: 237

When learning something new, it’s helpful to have a foundation.  Yet, indexes are often taught with only one or two sentences of explanation before CREATE INDEX.  I recall a student, exasperated by the textbook definition saying, “Will someone just SHOW ME an index!”  The goal of this high level presentation is to do just that.  In this 60 minute mission, we’ll explore nonclustered and clustered indexes as well as the strange new world of columnstore indexes.  Rather than focus on space and time requirements of indexes and index maintenance, we’ll seek out new understanding:

•	Why well-designed indexes speed up queries.
•	Why queries must be engineered carefully to use indexes.
•	Why indexes have both benefits and drawbacks.

After the mission, you’ll be prepared to further explore the galaxy of indexes.  
  
This presentation was co-produced with Stéphane Faroult, author of The Art of SQL and Getting the Message Across: Using Slideware Effectively for Technical Presentations.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Perform

Level: Beginner

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: 223

Are you a SQL developer, or a DBA responsible for squeezing every last drop of performance out of your instances? If so, few things are more important than a solid understanding of SQL Server indexes. In this session you will learn the basics of index internals and design, and then use that understanding to explore some common indexing anti-patterns. This session starts from the ground up, so it is suitable for anyone wanting to learn more about indexes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Design

Level: Intermedia

Session Code:

Date: April 27

Time: 1:15 PM - 2:15 PM

Room: 302

SQL Server has evolved many times over the years. SQL Server 2019 introduces “Intelligent Query Processing”, greatly enhancing the “Adaptive Query Processing” which was introduced in SQL Server 2017. Intelligent Query Processing allows your queries to operate more efficiently (resulting in better query performance) – without needing to make changes to the code or the application.

In this session we will explore all the Intelligent Query Processing features in SQL Server 2019. Time permitting, we will go into other changes in recent versions of SQL Server (such as execution plan changes and new Dynamic Management Objects) that will help improve your efficiency at troubleshooting and tuning SQL Server.

Coming away from this session, you will have plenty of reasons to want to upgrade to SQL Server 2019 immediately!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Support

Level: Intermedia

Session Code:

Date: April 27

Time: 1:15 PM - 2:15 PM

Room: 301

From the basics to the advanced, we will explore techniques that will ensure you leave a positive impression and help you land that role!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Support

Level: Beginner

Session Code:

Date: April 27

Time: 1:15 PM - 2:15 PM

Room: 221

You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session expects that attendees are already familiar with Availability Groups.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Intermedia

Session Code:

Date: April 27

Time: 11:00 AM - 12:00 PM

Room: 301

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