Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 32
Love it or hate it, you just can't ignore DAX, the amazing language of Power BI. In this session, I'll show you it's true power and how knowing it can even make you completely rethink your data models.
No more hundreds of columns and weird aggregations in the database. With the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at its core.
I'll show you real-world applications of DAX and lots of tips and tricks that you will be able to use quickly and with little effort!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: August 29

Time: 8:00 AM - 9:00 AM

Room: Room 3

Newer releases of SQL Server have introduced many new functions developers may not know or use. This includes functions for type conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, in addition to some best practices for using these functions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 29

Time: 1:00 PM - 2:00 PM

Room: Room 1

The SQL Server Query Optimizer creates an execution plan for every statement running in the database. Since SQL is a declarative language, we describe what data we want to see, then the SQL Server Optimizer figures out a plan to retrieve that data efficiently.  However, sometimes the Optimizer chooses a bad query plan which not only makes the query run slow, but eats up resources so other processing can’t get done.  

This presentation will show how to read and fine tune the query plan for better performance. We’ll quickly go over the different types of execution plans and when to use them. We’ll examine the different operators, their statistics and costs, then determine which steps to focus on tuning.  Finally, several trouble shooting techniques will be shown so you can increase your tuning skills.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 29

Time: 9:10 AM - 10:10 AM

Room: Room 4

The popularity and push for adopting DevOps as a way of developing software continues to grow. Do you wonder how to get started and what tools are out there? TFS and Azure DevOps are the way that more and more Microsoft developers look to try and automate parts of their software development process. Join this session for a look at how the capabilities of Azure DevOps/TFS are integrated together to help you track your code and automate the process of getting it to your production environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 29

Time: 3:20 PM - 4:20 PM

Room: Room 2

In 2010, SentryOne gave the community a completely free execution plan analysis tool: Plan Explorer, that is widely used today. But many users only utilize basic features and only scratch the surface of its capabilities.

Join me to learn how you can go beyond the basics. This demo-heavy (and marketing free) session will teach you advanced use of Plan Explorer by exploring practical T-SQL anti-patterns.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 29

Time: 3:20 PM - 4:20 PM

Room: Room 1

Database development and administration require temporary objects for ETL, staging, data processing, and many other common tasks.

In this session, we will delve into temporary tables, table variables, and memory-optimized table variables, as well as memory-optimized TempDB metadata, discussing their differences, how they work, and the optimal scenarios for using each of them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 29

Time: 2:10 PM - 3:10 PM

Room: Room 2

Everyone has strong opinions and reactions to which cloud database platform companies should be using but how different are they, really?  What features does one cloud provider support that the other might not?  How will normal DBA activities, such as backups and restores, change depending on the cloud provider your company uses?  Join me in this session as I share my migration stories and discuss the results of my research about how AWS and Azure are different and how many of my daily tasks and tools changed as our company migrated to AWS.  Come and listen as I share what I have learned on this journey from on-premises to the cloud.  Join me and find out which platform I would use.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 29

Time: 11:50 AM - 12:50 PM

Room: Room 4

Azure Data Studio (ADS) cross-platform database development tool which runs on Windows, Linux, and MacOS. ‘ADS’ supports SQL Server and Postgres (with more DB platforms soon) and works both on-prem and in the cloud. ADS is highly extensible, open source, and can dramatically change the way you approach SQL coding.

In this session, we will cover ‘ADS’ features and capabilities such as
 - Connections
 - Code Snippets
 - Notebooks
 - Extensions
And demonstrate why Azure Data Studio is in fact Way Cool.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 29

Time: 10:20 AM - 11:20 AM

Room: Room 4

Azure Synapse provides a complete platform to ingest and process data at scale in the cloud. In this workshop we will be learning and applying its features to all stages of data processing and understanding some best practices and pitfalls. From ingesting to data lakes to transform data in big data services to apply machine learning models, including data remodeling, this workshop will guide to through a full implementation of Azure Synapse all the way to presentation and reporting.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 29

Time: 4:30 PM - 5:30 PM

Room: Room 3

We all start using business intelligence tools by using a single dataset, like a flat file.  Then, we hit a plateau in our learning curve, or we add a second flat file into our BI product, and we get incorrect results.  One reason is that we haven't modeled our solution correctly.

In order to move to the next level of our journey along the BI learning curve, we need to understand how a tool like Power BI works.  Only then will we understand why we design our data models the way we do.

In this session, we will review how tools like Power BI work under the covers and how that impacts the way we construct our data models.  This is an introductory level course, so we will not get too technical, just enough to get us to the next level and moving back up that learning curve!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 29

Time: 10:20 AM - 11:20 AM

Room: Room 3

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 Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 29

Time: 9:10 AM - 10:10 AM

Room: Room 3

You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially when it comes to indexes. Some of the things you have probably heard are: 

• keep clustered index width small 
• unique indexes perform better 
• keep non-clustered index width small 
• compressed indexes have fewer logical reads 
• add one index for each column 

But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. 

Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 29

Time: 8:00 AM - 9:00 AM

Room: Room 4

Maybe you’ve had some experience writing SQL, but no one’s ever told you what not to do. Or maybe you’re aware of some bad habits to avoid when writing SQL, but no one has ever shown you why a bad practice can hurt your query – or SQL Server.  Perhaps you feel a little more confident with your TSQL, but don’t understand why your queries aren’t running as quickly as you would like.

Bad SQL coding practices are known in the SQL community as “code smells”.  Sign up for this hour-long workshop where you will work with me through five common coding mistakes that can make performance stink. By the time we’re done, you’ll have a better idea of how to freshen up some problem queries.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 29

Time: 1:00 PM - 2:00 PM

Room: Room 2

During a recent SQL Server User Group meeting the question came up, "How do I get my data team to create a data warehouse that is more than just another database with DW in the name?" During this session we will discuss 10 tips to successfully create a data warehouse with an emphasis on having a data warehouse that will be consumed by your organization.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 29

Time: 3:20 PM - 4:20 PM

Room: Room 3

Unlike CI/CD pipelines for applications, we can't just delete the database and pop up a new one with each new version. Let's start with the production database, and get SQL Server content to developers in containers, and then flow schema and lookup data back into production with migration tools. You can bring the reliability and automation of CI/CD pipelines to Database DevOps with containers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 29

Time: 11:50 AM - 12:50 PM

Room: Room 1

As DBAs we oversee the safety and security of our databases. Integrity, Backup and ability to restore in a timely fashion are most important responsibilities. 
In addition to Microsoft's own Maintenance Plans and Ola Hallengren's awesome scripts, there are many tweaks available that can be exploited for our success; we will learn about those too. 
I will share with you my own experiments that I conducted over a period of one month. I will share supporting data, to show how I helped save several hours of downtime for my company. 
We'll also some of the best practices to help you cut down the maintenance window and give max up-time for your discerning customer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 29

Time: 8:00 AM - 9:00 AM

Room: Room 2

You always wanted to troubleshoot a slow running query. But you just don’t know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 29

Time: 8:00 AM - 9:00 AM

Room: Room 1

We are really _really_ smart but can we show our best side when we interview?  I’ll show you how to interview and a few tips and tricks to get over the interview jitters.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 29

Time: 9:10 AM - 10:10 AM

Room: Room 2

For anyone new to Power BI, we'll cover all the main features and walk through getting data into the tool (using both the desktop and online versions), creating visualizations, turning them into reports and adding them to dashboards. When we're through we'll have several BI components available to share via the Cloud!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 29

Time: 11:50 AM - 12:50 PM

Room: Room 3

In this demo-filled session, we will go through everything you need to start using PowerShell to automate your day-to-day tasks as a DBA. We will go through the tools you need such as PowerShell IDE & Visual Studio Code. We will be using the Microsoft SqlServer PowerShell module and the very popular and powerful community-driven, DBATools module. We will walk through the process of building a script to do a simple task from start to finish. By the end of the session, you will have the confidence, knowledge and tools to start your journey in automating your day-to-day tasks using PowerShell.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 29

Time: 4:30 PM - 5:30 PM

Room: Room 2

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