Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 54
Corruption can strike at any time. As DBAs, how we alert, investigate, and respond can have a profound impact on our company. In this session we will learn how to detect and respond to various types of corruption. In this introductory session for beginners we will introduce the concepts around how to monitor and respond to corruption incidents in our databases.

First we will 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 our 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 properly manage an incident and discuss some common examples 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:
Database Adminstration

Level: Beginner

Session Code:

Date: January 18

Time: 11:00 AM - 12:00 PM

Room: s330

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Adminstration

Level: Beginner

Session Code:

Date: January 18

Time: 1:30 PM - 2:30 PM

Room: s301

This session will focus on the how to of visual design in Power BI and equip you to take your report designs to the next level! We will create and implement custom report themes, demo how to design reports for different audiences in your organization, and explore how to use Power BI's out of the box formatting options to help you deliver consistent and effective reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics and Visualization

Level: Beginner

Session Code:

Date: January 18

Time: 1:30 PM - 2:30 PM

Room: s334

Microsoft Azure is a daunting thing to look at and think about.  In this session, we'll look at the basics of Azure, what the options are for setting up an Azure account; as well as look at how regions are broken down. We'll take a look at the differences between Infrastructure as a Service, Platform as a Service and Software as a Service as well as the High Availability and Disaster Recovery options that are available to do with these services.  We'll finish the session off by looking at some options for Virtual Machines within Azure as well as the SQL Server offerings that are available in the platform.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 18

Time: 9:45 AM - 10:45 AM

Room: s330

In this session, you'll learn about the different options for your SQL deployments in Azure. After this session, you should be able to: ? Understand the benefits of SQL Server in Azure ? Articulate the key differentiators between SQL Server on-prem, in Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance), and hybrid ? Explain the different service tiers within Azure SQL DB, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 18

Time: 2:50 PM - 3:50 PM

Room: s316

This presentation will cover Overview of Azure Data Strategy, Data modernization on premises, Data modernization to Azure as well and Globally Distributed Data and Cloud Scale Analytics.  Attendees will learn about the different options for on premises modernization.  After reviewing the option for modernization to Azure, we will cover how to migrate to the cloud using examples from the attendees.  Next will be a brief overview of some of the global solutions available.  Lastly, we will focus on how to ingest, store, prepare, serve, and report on all the data every company has.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 18

Time: 1:30 PM - 2:30 PM

Room: s305

We are living in a world full of data but what we need is information.  What is required to transform data into information?  What are the foundational activities your organization needs to do in order to produce analytics that you are confident in sharing?  In this session we will discuss what is needed for your organization to convert data into information, the basics of: Data Governance, Data Modeling and how to have an immediate impact using tools like Power BI to deliver value; and, Data Visualizations and telling stories with the data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Management

Level: Beginner

Session Code:

Date: January 18

Time: 9:45 AM - 10:45 AM

Room: s270

We've all seen, and probably created, a few tabular models that are just dog-slow. For the people just starting with tabular models to those who've been around the block a few times with them, we'll go over a few ways in which I've sped up tabular models to be leaner and faster.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Management

Level: Beginner

Session Code:

Date: January 18

Time: 11:00 AM - 12:00 PM

Room: s301

You have been hearing about Azure CosmosDB but you haven't had a chance to explore it. In this session, you will learn the key concepts of Azure Cosmos DB. I will use many analogies to explain advantages and limitations of Azure CosmosDB. By the end of this session, you will be able to setup CosmosDB and know its available tools.

I will cover the following topics in this session 
Why do we need another database system?
How to setup Azure CosmosDB
How to create database and containers.
How much does it cost?
Multi-Model Apis
CosmosDB vs SQL Server
How to Import Data into CosmosDB
How to use Cosmos DB Emulator
CosmosDB Limitations
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 18

Time: 11:00 AM - 12:00 PM

Room: s270

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

Track:
BI Architecture & Management

Level: Intermedia

Session Code:

Date: January 18

Time: 12:20 PM - 1:20 PM

Room: s301

Deploying a new Big Data initiative is a daunting undertaking in its own right, which can lead many business leaders to forget a crucial piece of the puzzle - changing company culture. What good is new technology if it does not align with the way people in the organization actually make decisions? This session dives into how company leadership can effectively get organization members not just tolerant of, but EXCITED about new technology initiatives.
Attendees will learn:
- Where a data-driven culture really starts
- Why so many companies fail miserably at obtaining the "data-driven culture"
- The single MOST important factor that determines a successful culture shift
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: January 18

Time: 2:50 PM - 3:50 PM

Room: s260

You've heard about Azure Data Lake and Azure Data Warehouse, now called Azure Synapse Analytics.  You've also heard about Azure Data Factory and Azure Data Bricks.  You might even have heard about Python, Spark, and Azure Machine Learning.  In this fast-paced, all-demo session, we will walk through the process of ingesting data into the Data Lake, analyzing it with Spark and Machine Learning, outputting it to the Data Warehouse and reporting on it in Power BI.  You will walk away with working code and an overall understanding of how all these tools can help you develop advanced analytics solutions in the modern data landscape.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Intermedia

Session Code:

Date: January 18

Time: 8:30 AM - 9:30 AM

Room: s260

PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage.  As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances.  In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources.  We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down.  Finally, we will look at several interesting use cases for PolyBase in the modern data environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: January 18

Time: 11:00 AM - 12:00 PM

Room: s334

Are you an inspiring entrepreneur who wants to do more with your data? Have you ever wondered what are some of the differences between different data visualization tools that are available on the market?  In this session I will discuss different data visualization tools and discuss some of pros and cons. By the end of this session you will have more information about each tool which will help you determine which is best for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics and Visualization

Level: Beginner

Session Code:

Date: January 18

Time: 9:45 AM - 10:45 AM

Room: s213

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: January 18

Time: 8:30 AM - 9:30 AM

Room: s316

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:
Database & Application Development

Level: Beginner

Session Code:

Date: January 18

Time: 1:30 PM - 2:30 PM

Room: s330

You have read all about moving to the cloud, spoken to colleagues who are on it and even attended events where they told you about how great it is, and YOU ARE SOLD! You recognize the benefits of storing your SQL Server workloads in the cloud and ready for things to happen. Everyone agrees its the right answer, however, there is one problem. Your organization need to understand the expected costs before moving forward. Understanding the cost to move to Azure and its run rate are questions several companies struggle with and has led to several choosing to stay in their current state. It is not because the cost is too high as some may expect, but oftentimes because simply no one has any idea what to expect. 

In this session, I will walk you through steps that show you how to estimate the cost of your move to Azure and provide several unique considerations along the way that can have an impact on this. Next time someone asks how much, you will be ready!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 18

Time: 9:45 AM - 10:45 AM

Room: s334

Get yer queries ready we're goin' fishin' on the Azure Data Lake. Azure Data Lake is hyper-scale storage service that serves as the foundation for a Modern Data Warehouse. We'll explore what makes this service unique, the pricing structure, and how to start storing data. Then we'll open our tackle boxes to learn how to use tools such as HDInsight, Azure SQL DW, and Data Lake Analytics (U-SQL) to access data for processing, analytics, and machine learning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Management

Level: Beginner

Session Code:

Date: January 18

Time: 2:50 PM - 3:50 PM

Room: s339

Hopefully, you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lunch Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: January 18

Time: 12:20 PM - 1:20 PM

Room: s270

Not everyone has a full time Database Administrator on staff, and in many cases the responsibility of managing the database server falls on the developers.  But as long as the backups are running successfully you're good, right?  Not exactly.  There is ongoing maintenance required to help ensure that your databases are running smoothly.  Are your statistics out of date?  Are your indexes fragmented?  When was the last time the databases were checked for corruption? Has your SQL Server been tuned to fit your workload, or are you still running with the less optimal default settings?

Tailored to the "Non-DBA", this session will cover these topics and more to ensure that you can avoid some performance issues you may not even realize you're having.  Discussing server settings, database configurations, and recommended maintenance, you will leave this session with the knowledge (and scripts!) you need to help ensure that your SQL Server and databases are in top shape.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Adminstration

Level: Intermedia

Session Code:

Date: January 18

Time: 11:00 AM - 12:00 PM

Room: s316

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