Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type





Sessions Found: 41
Truly automate complex monthly SPREADSHEET IMPORTS without monthly code changes!

Right or wrong, spreadsheets still constitute a source of data that many of us have to import every week or month. The trouble is that most spreadsheets aren’t setup to look like an SQL table. Rather, they are setup as multiple dimensions to aid in user readability and that makes column mapping and importing seriously automation resistant.

This “Black Arts” session provides an introduction to a relatively simple method to quickly, easily, and automatically import such spreadsheets and the code to do so frequently requires no changes to be used across multiple disparate spreadsheets. Creation of the necessary staging table and the related mapping is all done automatically and the monthly addition of columns is automatically handled, as well. Some of the pitfalls of more traditional import methods will also be examined.

Don’t let the “Advanced” rating of this session scare you away. We make it simple!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Development

Level: Advanced

Session Code:

Date: February 01

Time: 3:00 PM - 4:00 PM

Room: SQL Development

In this session I will introduce Azure Data Factory and will demonstrate how easy it is to start using the service and how to get your ETL going forward in a matter of minutes. I will go through the best practices and, based on my experience, will expose some scenarios when I had to rethink the way ti should work because of some of the limitations of the service. I will explore the limitations and some ideas on how to overcome them.
There will be some live demos and by the end of the session we may have a working ETL solution that will move data from a SQL database as well as from a Blob Storage into an Azure SQL Datawarehouse (or a PaaS) instance.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: February 01

Time: 9:45 AM - 10:45 AM

Room: Cloud

Break
Speaker:

Accompanying Materials:

No material found.

Session Type:
Break (15 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: February 01

Time: 9:30 AM - 9:45 AM

Room: Database Architecture and Design

Closing
Speaker:

Accompanying Materials:

No material found.

Session Type:
Close (15 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: February 01

Time: 5:15 PM - 5:30 PM

Room: Database Architecture and Design

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: February 01

Time: 4:15 PM - 5:15 PM

Room: Cloud

Databricks Delta is the new standard for building a data lake as a part to your data warehouse. In this sessions we will learn how we can automate the development and ETL of a Data Hub\PSE in Databricks Delta that can process 1000's of tables with minimal code.

Agenda:
 - Data Lake Design and the Modern Data Warehouse
 - Databricks Delta 
 - Automating Databricks Delta
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: February 01

Time: 3:00 PM - 4:00 PM

Room: Cloud

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I can't tell you how many times I've heard these phrases.  This session will help you understand why choosing the correct data type for your data is so important.  It affects data quality, storage and performance.  It can even produce incorrect query results.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Architecture and Design

Level: Beginner

Session Code:

Date: February 01

Time: 11:00 AM - 12:00 PM

Room: Database Architecture and Design

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:
Database Monitoring, Maintenance, and Tools

Level: Beginner

Session Code:

Date: February 01

Time: 1:30 PM - 2:30 PM

Room: Database Monitoring, Maintenance, and Tools

When done right, data visualization informs users quickly and efficiently with a minimum of distraction.  When done wrong, we end up with spinning 3D pie charts.  In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience.  We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image.  When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards.  Finally, we will take an awful dashboard and turn it into something which end users will appreciate.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 01

Time: 8:30 AM - 9:30 AM

Room: Analytics and Visualization

Every expert has their own set of tools they use to find and fix the problem areas of queries, but SQL Server provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues, right in the box. In this session we will examine a variety of tools to analyze and solve query performance problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Monitoring, Maintenance, and Tools

Level: Beginner

Session Code:

Date: February 01

Time: 11:00 AM - 12:00 PM

Room: Database Monitoring, Maintenance, and Tools

The query store, introduced with SQL 2016, has proven to be a valuable tool for gaining insight into performance issues and applying some basic first aid to troublesome queries.  With SQL 2017, the ability to do automatic regression correction was introduced.  Still, there are some limitations on what the query store can handle.  In this session we'll review some query store basics, talk about limitations, and explore a way to work around some of those limitations by using data stored in the query store.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Performance

Level: Intermedia

Session Code:

Date: February 01

Time: 9:45 AM - 10:45 AM

Room: Database Architecture and Design

Most IT departments are stretched thin and do not usually have the opportunity to fully investigate the true needs of the database infrastructure.  In this session, we will cover a number of aspects that will help the SQL DBA have informed conversations with IT in order to ensure that better decisions are made when it comes to compute and storage hardware in order to deliver improved performance and reduced licensing cost.
This session will also cover some options that the DBA can investigate if they have been handed hardware that is not quite up to par.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Performance

Level: Beginner

Session Code:

Date: February 01

Time: 8:30 AM - 9:30 AM

Room: Database Performance

Completing a full assessment on a SQL Server is essential to learning about not only the current state of the server, but also any area that may be impacting performance or security.  If you have more than one DBA, it is also important to have all the DBA team members review the same areas when completing an assessment.  During this session we will discuss when assessments are useful, what should be included in the assessment as well as how to interpret the results.  We will use a SQL script that will capture all the data needed.  This script will more than 88 data points, including fragmentation of indexes, performance counter values, server and database security information, queries that consume the most CPU time including execution plans as well as many other data points. This session will also cover how to document your findings and recommendations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Monitoring, Maintenance, and Tools

Level: Intermedia

Session Code:

Date: February 01

Time: 8:30 AM - 9:30 AM

Room: Database Monitoring, Maintenance, and Tools

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Architecture and Design

Level: Intermedia

Session Code:

Date: February 01

Time: 3:00 PM - 4:00 PM

Room: Database Architecture and Design

Kusto is a service for storing and running interactive analytics over Big Data, easy to query using Kusto Query Language (KQL). As we make progress in our migration to cloud, we are learning new ways to monitor and alert on resources and services. Microsoft has consolidated many services under the umbrella of ‘Azure Monitor’. Whether you are ‘detecting and diagnose issues across applications’, ‘correlate infrastructure issues for VMs’, ‘drill into your SQL database monitoring data with Log Analytics’ you will be using ‘Azure Monitor’. Azure Monitor uses a version of the KQL that is suitable for simple log queries but also includes advanced functionality such as aggregations, joins, and smart analytics. Going forward, KQL must be your primary resource for querying the Azure Monitor log.

In this 95% demo session, I will show you some ‘getting started’ tips and a few sophisticated queries using KQL. Come learn about the future of monitoring and investigations of Azure services.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: February 01

Time: 8:30 AM - 9:30 AM

Room: Cloud

This session is for the absolute beginner to learn the basic components of the Database Engine (Relational Engine, Storage Engine, and SQLOS) and what is the purpose of each of these three components in the execution of a simple query. The relational engine to process a query, the storage engine to access data and the SQLOS to manage resource access. The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Performance

Level: Beginner

Session Code:

Date: February 01

Time: 8:30 AM - 9:30 AM

Room: SQL Development

When it comes to getting your data into Excel or Power BI, M is your best choice. The M Language (A.K.A Power Query) is a powerful tool for self-service data preparation. However, it's not clear where it fits compared to tools like SSIS or TSQL. It's also not clear what it's limitations are. This session will cover the basics of M and when to use it.

In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 01

Time: 3:00 PM - 4:00 PM

Room: Analytics and Visualization

The most popular databases in the world all speak SQL, and almost 60% of Stack Overflow members use SQL. SQL is the query language that dominates when it comes to interacting with data. Data has changed since the 1970s; it’s no longer just stored in flat tables, but as rich, hierarchical object structures like JSON. SQL isn’t dead though, it just needed to evolve a little bit. In this session, you’ll learn about the next iteration of SQL: SQL++. Born from a UCSD research project, SQL++ is backwards-compatible and can work with heterogeneous data, with or without schemas and indexing. It is still the readable, declarative, highly composable language that you’re used to, but with extra super-powers. This session will focus on the enhancements that SQL++ brings, will show some of the databases that are already implementing it (including Couchbase, AsterixDB, Drill), and guidance on why and when to use it. You will enter with SQL skills and leave with big data skills.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 01

Time: 11:00 AM - 12:00 PM

Room: Analytics and Visualization

When you see those little green checkmarks, then you know your new SQL Server instance is ready to go, right? Not exactly. Your fresh installation has some questionable default settings that could cause headaches and heartburn in the future. In this session, we identify several instance and database defaults that could lead to disaster, and discuss how you can modify them to improve performance and avoid unnecessary problems.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Performance

Level: Beginner

Session Code:

Date: February 01

Time: 11:00 AM - 12:00 PM

Room: Database Performance

Developers and DBAs have had a long, sometimes strained relationship. Some developers see DBAs as roadblocks standing in the way of getting their work shipped; some DBAs see developers as agents of chaos bent on ruining their perfect database environments.

In this talk designed for application and database developers, we’ll talk about why SQL Server behaves the way it does, common database and query design pain points, and how we look for them. With real-world examples and tales of troublesome T-SQL, past and present, you’ll start to get a picture of what to do and not to do in your applications. Along the way, you’ll learn how to build a better relationship with both SQL Server and the DBAs responsible for it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Development

Level: Beginner

Session Code:

Date: February 01

Time: 3:00 PM - 4:00 PM

Room: Database Monitoring, Maintenance, and Tools

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