Build Schedule

Advanced Filters:
  • Track

    clear all




















  • Speaker


  • Level


  • Session Type




Sessions Found: 42
2017 marked the 10th anniversary of when I left the world of being a full time employee to being an independent consultant. Back then I was just trying to make it to year two. Ten years later, I've learned a lot and I'm still standing with a few battle scars to prove it. Join me as I discuss what it takes to be (and survive as) a consultant, lessons learned - both good and bad, and how you can apply the principles of consulting even if you are a full time employee to step up your game.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 22

Time: 10:00 AM - 11:00 AM

Room: 1

Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have profound impact on our company. In this session we will learn how to detect and respond to various types of corruption.
First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll also look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.
Then we will move onto how to respond to some common example of corruption.  We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: September 22

Time: 4:00 PM - 5:00 PM

Room: 6

Would you like to fix database performance issues without changing code, adding indexes or changing system resources?
SQL Server database engine doesn’t differentiate between workloads but Resource Governor can and gives flexibility for resource allocation preference. You can prioritize you workload based upon importance.
In this session we will deep dive to learn how to use Resource Governor to cap different facets of CPU, Memory, IOPs utilization with demos and examples.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: September 22

Time: 10:00 AM - 11:00 AM

Room: 7

Let us connect DBAs and Infrastructure Admins providing to DBAs vital information how to get best SQL Server deployment on top of VMware virtual platform.

The session will cover both the design and the configuration of a SQL Server virtual machine with the special focus on:

vCPU allocation and deep dive in vNUMA

Memory allocation and configurations options

Storage configuration best practices including PMem/NFS/Snapshots

Network configuration myths and best practices

It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the tom of hands-on from the Professional Services
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (40 minutes)

Track:
Sponsor

Level: Beginner

Session Code:

Date: September 22

Time: 12:35 PM - 1:15 PM

Room: 2

What is CosmosDB and why should I care about it? It is a schema-less JSON documents database engine with rich SQL querying capabilities. We will go over Cosmos database, collections, and documents creation. CosmoDB's SQL API supports relational and hierarchical queries. Azure CosmosDB Emulator is a free tool which provides local development with CosmosDB without connecting to the Azure portal. 
This session will also cover CosmosDB Explorer in Public View. It can be used to access the database with read-only or read-write permissions without requiring access to Azure subscription.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: September 22

Time: 11:15 AM - 12:15 PM

Room: 6

Azure Data Factory (ADF) has done some mileage since it's beginning in 2015. It has evolved and is now able to integrate your SSIS loads and do lots of work with your data in Azure. In this session, you will learn the new features of Azure Data Factory V2 and how SSIS packages can be triggered from it. 
This session will also introduce concepts like the modern data warehouse and what are the new challenges that comes with data integration both on-premise and cloud based.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Intermedia

Session Code:

Date: September 22

Time: 2:45 PM - 3:45 PM

Room: 6

Azure Databricks is the hottest new service being offered on Azure! Designed in collaboration with Microsoft and Databricks, the creators of Apache Spark, Azure Databricks combines the best of Databricks and Azure to help customers accelerate innovation with one-click set up, streamlined workflows and an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts. Databricks was founded by the creators of the Spark big data platform to make creating creating and managing clusters a snap and provide a first class secure data science team collaboration environment. In this presentation, we'll explain key concepts and features while demonstrating this amazing service.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Intermedia

Session Code:

Date: September 22

Time: 11:15 AM - 12:15 PM

Room: 2

Success of a good BI infrastructure is measured by two most important factors: 
a) Better access to data and 
b) Increased operational efficiency
How can you set up your own BI infrastructure in the cloud to address these? 
What components do we consider?
We can do that by proper selection of technology and vendors from Azure Market Place. How do we keep an eye on possible use of Big Data for your BI. We will also look at the best practices for doing so. We will take a fleeting look at some of the storage options for us in Azure and some Big Data concepts as well.
We will learn about Copy Data Virtualization in Azure Market Place that can help you provision terabytes worth of information in matter of minutes. 
We will also learn about setting up teams and ways to train them(and yourself) in this fast evolving world of Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Intermedia

Session Code:

Date: September 22

Time: 1:30 PM - 2:30 PM

Room: 7

Traditional DR tests may include application-specific recovery tests, or perhaps your workplace holds an annual "DR weekend" when you test the recoverability of your applications, and measure yourself against your own RPO's and RTO's.

With our applications now running in cloud, whether IaaS, PaaS, or SaaS, we typically must trust vendors' SLA's, and sometimes must design our own DR plan. 

This case study is a real-world story about how we decided to test our DR plans when our various applications run in the cloud. We used Azure Site Recovery, Azure Backup Services, some Inf-as-Code solutions, a lot of automation, and some pre-configured but powered down infrastructure. I'd be happy to share our lessons learned.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: September 22

Time: 2:45 PM - 3:45 PM

Room: 7

What are containers? When would you use them? Are they supported for production? Do they run on Windows? Do they run on Linux? Can they persist data?

These are just a few of the questions we will answer in this session. Containers are all the rage today - don't get left behind!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: September 22

Time: 1:30 PM - 2:30 PM

Room: 4

Ensuring the ongoing protection of personally identifiable information is mandatory in today's business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting.  This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can't go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: September 22

Time: 10:00 AM - 11:00 AM

Room: 4

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: September 22

Time: 2:45 PM - 3:45 PM

Room: 2

With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done,  how to extract data from a tabular model using Data Analysis Expressions (DAX).
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Intermedia

Session Code:

Date: September 22

Time: 11:15 AM - 12:15 PM

Room: 5

You can use Microsoft Azure to quickly build, deploy, scale and manage your SQL Server databases, while seamlessly integrating SIOS DataKeeper for synchronized data and high availability.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (40 minutes)

Track:
Sponsor

Level: Beginner

Session Code:

Date: September 22

Time: 12:35 PM - 1:15 PM

Room: 6

Do you know what your SQL Server environment looks like? Using PowerShell along with dbatools and PowerBI we will cover how to collect, store, and document this information.

Finding a free and simple method to gather information about my SQL Server environment was difficult. Using a combination of PowerShell, the dbatools module, and a PowerBI report I finally found something that works for me. I hope it can be helpful for you as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: September 22

Time: 10:00 AM - 11:00 AM

Room: 2

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?

This presentation will review the following techniques to fix your woes.

Coverage:

1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Advanced

Session Code:

Date: September 22

Time: 4:00 PM - 5:00 PM

Room: 4

Getting started reading execution plans is very straight forward. The real issue is understanding the plans as they grow in size and complexity. This session will show you how to explore the nooks and crannies of an execution plan in order to more easily find the necessary information needed to make what the plan is telling you crystal clear. The information presented here will better empower you to traverse the execution plans you’ll see on your own servers. That knowledge will make it possible to more efficiently and accurately tune and troubleshoot your queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: September 22

Time: 1:30 PM - 2:30 PM

Room: 3

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them.  This session will cover the basics of Extended events as well as an introduction to the system_health session.  This session will give someone who has never used Extended events before the skills to start using them!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: September 22

Time: 11:15 AM - 12:15 PM

Room: 4

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2017 Integration Services (SSIS 2017) 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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Intermedia

Session Code:

Date: September 22

Time: 11:15 AM - 12:15 PM

Room: 3

If you work in an agile environment, design requirements often come to us as stories with the phrase: "As a type of user, I want to ..."

For example: As a DBA, I want to be able to break down user stories to understand how they translate into our current database design and usage and have an understanding as to how it will affect future needs.

That user story is also the goal for the session. This will present one approach to how we can think about these user stories to find the data that we need to design our databases for. We'll even work through an example together. 

This is for DBAs who are involved in any part of designing databases, who want to practice how to come up with database designs, or who just another way to think about how they approach their database development in general.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: September 22

Time: 2:45 PM - 3:45 PM

Room: 4

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