Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type

Sessions Found: 23
Adoption of Cloud is at an all time high, with no end in sight. Managing a small fleet of databases on-premises was something you used to understand. In this session, we'll cover the 10 most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs. One of the great things about Azure SQL is that the skill set your team has developed over the years translates well. The tools and technologies you're familiar with are all there. So much is the same but some of the tasks that DBAs do are different.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 25

Time: 3:30 PM - 4:45 PM

Room: 2

Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you?

Let's jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work! We will start by looking at the different options that are available to us in SQL Notebooks. Then we will examine real world scenarios and create notebooks for them. Finally, we will learn how we can share the notebooks with our coworkers.

When you leave, you will have the practical knowledge and comfort level to use SQL Notebooks in your day-to-day work.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 25

Time: 1:00 PM - 2:15 PM

Room: 4

You've been given an awful task of comparing two of the most prominent cloud vendors. What would you do?

Amazon Web Services (AWS) and Microsoft Azure are two of the biggest names in public cloud computing. Which one is right for you? To help you make that decision, let’s talk about what each provider brings to the public cloud table, and key differences between them.
We will look into the following aspects and more:
- Computer Power
- Storage
- Network
- Pricing Models
- Support Plans
- Integration and Open Source
- Database
- Big Data
- Containers and Orchestration Support
- Compliance 
- User-friendliness
- Licensing
- Intelligence
- IoT
- Management and Monitoring
- Mobile Services
- Security
- Developer Tools
- Hybrid Cloud Capabilities
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 25

Time: 10:45 AM - 12:00 PM

Room: 2

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Power Automate, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 25

Time: 3:30 PM - 4:45 PM

Room: 3

The data lake has become extremely popular, but there is still confusion on how it should be used. In this presentation I will cover common big data architectures that use the data lake, the characteristics and benefits of a data lake, and how it works in conjunction with a relational data warehouse. Then I’ll go into details on using Azure Data Lake Store Gen2 as your data lake, and various typical use cases of the data lake. As a bonus I’ll talk about how to organize a data lake and discuss the various products that can be used in a modern data warehouse.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: July 25

Time: 1:00 PM - 2:15 PM

Room: 1

As with all other items in your toolbox the datacenter (local or in the cloud) needs to be used correctly. 

This session will show the various types and sizes of workloads, show you how to categorize them, look at the requirements of your SLA (Service Level Agreement), and find the right location (cloud, datacenter, hybrid) for the data. To wrap things up, we look at ways to validate that the SLA can be fulfilled and how to estimate and compare the costs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 25

Time: 8:15 AM - 9:30 AM

Room: 4

We, as data professionals, are dealing with increasingly large amounts of data. And, increasingly, we're asked to generate insights from this data. For that, the relationships between data points matter more than simple aggregations of individual data points. In our interconnected world, interconnected businesses, interconnected applications, graph databases lend themselves to answering relationship questions far more easily than...relational databases.

In this session we'll look at graph databases for
	how to model graph databases
	how to easily express relationships between interconnected data
	how to efficiently retrieve interrelated data 

We'll look at the MATCH predicate in T-SQL and the MATCH statement in Cypher, the query language for Neo4j.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 25

Time: 1:00 PM - 2:15 PM

Room: 3

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 (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 25

Time: 9:30 AM - 10:45 AM

Room: 2

Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019. This collection of new features is a game changer that will improve performance across the board. Come to this overview session to learn more about how these capabilities will benefit you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 25

Time: 2:15 PM - 3:30 PM

Room: 4

Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.

Coverage:

1 – Granting correct user access is vital.
2 – DML triggers to keep a DATA audit trail.
3 – DDL triggers to keep a SCHEMA audit trail.
4 – Preventing unwanted DATA modifications.
5 – Preventing unwanted SCHEMA changes.
6 – Preventing table TRUNCATIONS.
7 – LOGIN triggers to control who, what, and when.
8 – Change data capture (CDC) an alternative to triggers.
9 - Which of these techniques apply to an Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data Architecture & Design

Level: Intermedia

Session Code:

Date: July 25

Time: 10:45 AM - 12:00 PM

Room: 3

As we all know, SQL Server loves memory and will use as much as it can get.  However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure.  During this session we will explore how SQL Server uses memory and how to properly configure memory settings.  We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 25

Time: 8:15 AM - 9:30 AM

Room: 2

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 (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 25

Time: 3:30 PM - 4:45 PM

Room: 4

Five fast-paced 10-minutes-or-less sessions on a variety of topics:

Paresh Motiwala: Exploring Azure Data Studio
Thomas Grohser: New in SQL Server 2019: Persistent Memory
John Miner: Don't Lose Your Integrity - Talking about Constraints
Sunil Kadimdiwan: Plotting Graph DB in Power BI
Andy Yun: How to Utilize Index Tipping Point Data in Plan Explorer
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 25

Time: 9:30 AM - 10:45 AM

Room: 1

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: July 25

Time: 2:15 PM - 3:30 PM

Room: 1

Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, public cloud CPU selection, and SQL Server instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers for both on-prem and cloud-based SQL Servers.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 25

Time: 2:15 PM - 3:30 PM

Room: 2

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 the 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 and learn about the future of monitoring and investigations of Azure services.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: July 25

Time: 1:00 PM - 2:15 PM

Room: 2

Networking. You keep hearing that word throughout your career development, but you don’t know much about it, much less, how to do it. You want to connect with technical and data professionals, so you attend events such as SQL Saturday and your local user group. But what about your book club, your gym, your church group, or your kid’s soccer game? Those are prime — and overlooked — opportunities to network!

In this interactive session, we will discuss networking — what it is, why it’s important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn’t previously have!  Bring business cards if you have them!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 25

Time: 2:15 PM - 3:30 PM

Room: 3

SQL Server 2019 is a modern data platform designed to meet the current challenges of data professionals. We will review the new functionalities related to Performance, Security and High Availability
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: July 25

Time: 10:45 AM - 12:00 PM

Room: 4

Power BI usage and report development is quite simple to get started. You can produce fantastic reports in a relatively short amount of time.

How about extending the available functionality? How to achieve consistent look and feel? These are important topics, as we get deeper into creating more than couple of views and PBIX files.

In this session, I will show you how you can database queries, custom theme files, custom visuals, parameters and other techniques to make your development efforts easier and keep your users happier.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: July 25

Time: 10:45 AM - 12:00 PM

Room: 1

So you've decided to take the leap into presenting. Maybe it's at your local user group, maybe it's at SQL Saturday. This talk will guide you through the process of selecting a topic, preparing for it and actually giving it. We'll talk about what can go wrong and how to handle that. We'll also talk about what can be done to prevent something from going wrong in the first place. What are some good guidelines to follow and when can, or even should, you break them. This will be partly interactive so come with questions and be prepared to be asked some.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 25

Time: 9:30 AM - 10:45 AM

Room: 3

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