Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


Sessions Found: 50
This isn’t your typical presentation on Index Maintenance.

In this 1st of two back-to-back sessions, we'll learn how the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory/disk space, costly/continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance and how it all negatively impacts your code even if it’s perfect code.

We'll also discover the true costs of page splits, how REORGANIZE can perpetuate them, their effect on performance, introduce and learn how to use "sp_IndexDNA™" to see indexes as you've never seen them before, and introduce methods to make even active GUID-based indexes 100% fragmentation free for months at a time, which will also fix the problems we’ve discovered.

This 1st session is also a recommended segue into the second session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: October 05

Time: 2:50 PM - 3:50 PM

Room: 603

This isn’t your typical presentation on Index Maintenance.

In this 2nd of two back-to-back sessions, we’ll learn the 5 main “Insertion Patterns” and how they cause or prevent fragmentation, introduce the additional page splitting/fragmenting horror of “ExpAnsive Updates”, continue to learn about the true costs of using REORGANIZE and why it should be avoided, how it all affects performance and disk/memory usage, how it all affects Index Maintenance, and steps that can be taken to seriously improve all of that. 

We'll also learn that simply reducing Fill Factors isn't the "fix" for fragmentation and can actually cost you serious amounts of additional totally wasted memory while providing little to no value.

Unfortunately, there won’t be time to cover it all but well documented code will be provided to help identify the sources of page splits and “ExpAnsive Updates” so that they can be eliminated.

Session #1 is a strongly recommend prerequisite for this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: October 05

Time: 4:00 PM - 5:00 PM

Room: 603

This session will provide a high level overview of Azure Data Studio and highlight some of the differences from SQL Server Management Studio. We cover saved connections, how to get both the actual and estimated Execution plans, workspaces and one of my favorite features, Notebooks.  We also go over what an extension is and why I would want to use them.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 05

Time: 1:40 PM - 2:40 PM

Room: 613

It's easy to get started with Power BI, but it's also easy to end up with an out-of-control data model that grinds your report visuals and refreshes to a halt.  How can you find and fix the problems slowing down your Power BI performance?  In this session we'll show you common pitfalls to avoid, along with handy tools to help you maintain and optimize your models, whether you created them yourself or inherited them from others.  You'll leave this session armed with the tools and knowledge you need to immediately improve the performance, organization, and readability of your models, as well as monitor for the future to prevent those angry calls.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: 613

When deploying Analysis Services Tabular, where to deploy: Azure Analysis Services or SSAS Tabular on Premises?  Can you use both or not?  
Come to this session to learn: 1-Strengths and weaknesses for each. 2-How to leverage a hybrid model in your organization. 3- Introduction on how to administer both of the environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 05

Time: 11:30 AM - 12:30 PM

Room: 605

Have you heard about Azure Databricks but are not sure about how to or even if you should incorporate it into your existing ETL/ELT processs?  This session will serve as a brief walkthrough of Azure Databricks from a beginner's perspective, with a focus on how you can use it today with existing skillsets such as SQL.  Once we have an idea of the basics, we will use Azure Data Factory operationalize a Databricks Notebook.

By the end of this session, you will have a better understanding of Azure Databricks and how you might take advantage of this new PaaS Big Data offering.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: 605

It has been about a year since Azure SQL DB Managed Instance has been released. What is it? Where does it fit? What limitations does it have? What has changed? What changes should I see next?  These questions will be addressed and more.  Will we see Managed Instance in action? We can, but it is just SQL Server presented in a different wrapper.  Along with Managed Instance, a discussion of Serverless and Hyperscale options will also be included.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 05

Time: 10:15 AM - 11:45 AM

Room: 612

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 05

Time: 11:30 AM - 12:30 PM

Room: 501 (Wanna Be A DBA?)

Columnstore indexes are available to all SQL Server editions, Express to Enterprise, starting with SQL Server 2016 Service Pack 1. They can save disk space, increase query performance, and combine OLTP and OLAP workloads. Should you change all your tables to columnstores? Let's find out!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: 612

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:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 05

Time: 12:55 PM - 1:55 PM

Room: 602

Data collection and usage is all around us, it is what we do. But is what we do with the data ethical? Are we collecting and processing biased data?  We will take a look at ethical data collection and usage, what it means to your models and forecasts, and how being aware of possible biases can impact your bottom line. You might be training on extremely biased data and not know it, skewing your forecasts in the wrong direction.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 05

Time: 1:40 PM - 2:40 PM

Room: 603

Many times developers have to support users by answering the “What happened to the data?”  The task of retrieving data from a specific point in time is not an easy one.  Often this involves retrieving a backup and restoring the data in question (hopefully!).  SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups.  With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 05

Time: 4:00 PM - 5:00 PM

Room: 605

There are so many topics for a DBA to focus on that it can be overwhelming, especially for a new or accidental DBA.  Without knowing what's most important, you can find yourself spending lots of time trying to figure out what's important.  This session focuses on the five topics that matter most to a DBA, whether you're an aspiring DBA, a new DBA or a seasoned professional.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: 501 (Wanna Be A DBA?)

No matter the complexity of your BI application, dimension management can
provide your organization the tools needed to conform, manage and simplify your
dimensions. Attend this session and learn how to unlock more value from your
analytics.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 05

Time: 9:00 AM - 10:30 AM

Room: 613

Keeping up with technology can feel like a treadmill; you keep running but never get anywhere. We'll take a look at ways to keep up with technology without pulling your hair out. We'll balance cost versus benefit for the different types of learning. We will also talk about learning goals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 05

Time: 11:30 AM - 12:30 PM

Room: 501 (Wanna Be A DBA?)

Just like pilots who are prepared for disaster recovery through regular practice, we as database administrators need to actually spend time practicing recovering with those backups. Ransomware has made it critical to prepare to rebuild your datacenter at any moment. 

This session will focus on the kinds of situations that can dramatically affect a data center, and how to practice recovery processes to assure business continuity.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 05

Time: 11:30 AM - 12:30 PM

Room: 612

Data breaches abound! Do you want to keep your company out of the headlines? 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. While we look at the encryption options, we will review both on-premise and cloud offerings.  This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.   
 
You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance.  Also, you will gather information on how to fully protect and review your sensitive data usage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: 603

Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern which actions we take and which actions we avoid.

Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.

This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 05

Time: 10:15 AM - 11:15 AM

Room: 602

Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. 

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: October 05

Time: 9:00 AM - 10:00 AM

Room: 603

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Prerequisites: Have some understanding of Azure, and PowerShell. Familiar with HA/DR terms utilized today.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 05

Time: 11:30 AM - 12:30 PM

Room: 605

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