Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type

Sessions Found: 93
What if we could analyze a single query with thirteen different performance problems? In this session we’ll explore a query, understand and fix all thirteen problems. 

1- There is a nonsargable filter
2- An index is missing
3- It is a query optimizer mistake
4- The subquery is unnecessary
5- Query join order is incorrect
6- A filtered statistic is missing
7- Scalar functions are running twice per each row
8- High number of reads on worktable
9- An unknown syntax could be used
10- Memory grant wasn’t enough
11- Distributed query doesn't look good
12- Residual predicates
13- Avoid window spool ondisk
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 10:30 AM - 11:30 AM

Room: Lumbergh's Office-223

Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 18

Time: 9:15 AM - 10:15 AM

Room: The Memo-331

Have you been watching SSAS Tabular develop? What about the Azure Analysis Services product? Power BI's data modeling? These technologies are all effectively the same, but live in different places and can serve different roles. Now's the time to dive in and figure all of this out.
In this session, we will talk about what Tabular is and what it does, in addition to the various "flavors" it comes in. We'll explore development processes and will wind up with a model ready for ad-hoc querying through Excel or Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 18

Time: 2:15 PM - 3:15 PM

Room: The Memo-331

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations?  This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 18

Time: 8:00 AM - 9:00 AM

Room: Flingers-215

Do you know what makes a great data model?  What does it mean to be Third Normal Form or a Star Schema?  When would you use one over the other and why?  How can you identify bad designs?  In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 18

Time: 9:15 AM - 10:15 AM

Room: Lumbergh's Office-223

Are you investing enough time and in right place when it comes to learning new stuff? Or do you feel like you're spending too much time? Or, more commonly, that you're setting goals and then falling off track? All of us struggle to manage learning while sustaining a career and family. But it IS possible! This session is designed to give you a prescriptive solution to the challenges of managing learning; identifying what you need to learn, how much time to invest in learning each topic, scheduling and tracking your learning, and recovering from the interruptions that life throws at us.  My system won't make you rich, but it will make you feel in control of your career learning goals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 18

Time: 2:15 PM - 3:15 PM

Room: Initech-216

Are you curious about Visual Recognition and Object Detection in Azure?  Are you wondering what the difference is between the Computer Vision API and the Custom Vision API?  Do you want a quick introduction to get you up to speed on both, so that you can quickly build and deploy a Cognitive Services model?

Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.

In this session, we will look at the basics of Cognitive Services Vision.  First learn how to create your Cognitive Services model.  Then you can see how to train and improve accuracy.  Finally, we will step through python code in Azure Notebooks to call the APIs.

After this session, you will get up and running in Cognitive Services Vision in under an hour!

Prerequisites: Attendees who would like to follow along should have an Azure account, as well as an account on Azure Notebooks.  Experience with coding in python is helpful, but not required.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
101 Beginner Level Sessions

Level: Beginner

Session Code:

Date: May 18

Time: 10:30 AM - 11:30 AM

Room: The Printer-226

In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 18

Time: 8:00 AM - 9:00 AM

Room: TPS Report-330

Moving data around in On-Prem databases is fairly easy with SSIS. 

Moving data around when involving Azure - may be not. Especially if you're just seeing ADF v2 for the first time.

We'll look at moving data around from On-Prem to Azure, moving files to Azure, and moving data between Azure databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 18

Time: 10:30 AM - 11:30 AM

Room: Initech-216

This presentation focuses on the value proposition for Azure Databricks for Data Science.  First, the talk includes an overview of the merits of Azure Databricks and Spark.  Second, the talk includes demos of data science on Azure Databricks.  Finally, the presentation includes some ideas for data science production.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: May 18

Time: 9:15 AM - 10:15 AM

Room: TPS Report-330

The Internet of Things (IoT) is one of the most talked about emerging technologies nowadays. But what is it and how can it help by business? Most importantly, how do I get started? In this presentation, we will do an interactive demo with a Raspberry PI and a Microsoft Sphere MCU along with several sensors and components to capture and analyze data from a connected device in Azure IoT Hub and IoT Central. Learn how to connect, monitor and manage connected devices using Azure IoT Hub. We will also discuss how Azure IoT Edge can simplify secure deployment of complex event processing, ML, and AI functionality to connected devices to reduce the latency of decision making.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 18

Time: 9:15 AM - 10:15 AM

Room: 37 Pieces of Flair-333

Many organizations would like to take advantage of the benefits of using a platform as a service database like Azure SQL Database. Automated backups, patching, and costs are just some of the benefits. However, Azure SQL Database is not a 100% feature compatible with SQL Server—features like SQL Agent, CLR and Filestream are not supported. Migration to Azure SQL Database is also a challenge, as backup and restore and log shipping are not supported methods. 

Microsoft recently introduced Managed Instances—a new option that provides a bridge between on-premises or Azure VM implementations of SQL Server and Azure SQL Database. Managed Instances provide full SQL Server surface compatibility and support database sizes up to 35 TB.

In this session, you will learn about migrating your databases to Managed Instances, developing applications for managed instances. You will also learn about the underlying high availability and disaster recovery options for the solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 18

Time: 2:15 PM - 3:15 PM

Room: The Field-236

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 18

Time: 9:15 AM - 10:15 AM

Room: I Love Kung Fu-329

Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together. 

This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
101 Beginner Level Sessions

Level: Beginner

Session Code:

Date: May 18

Time: 3:30 PM - 4:30 PM

Room: The Printer-226

As an IT Pro, you don't enjoy saying "I can't do that" in response to the needs of your boss or business users. So I will introduce a tool to help you say "yes".

Discover how to build front-end apps in less time, and with less hassle than you might imagine... apss that that powerfully surface your SQL data for end users in an effective UX.

In this session you will learn how to:
- Get started with a free Skuid developer account
- Connect to Azure SQL DB
- Create Skuid pages
- Add components to enable end-users to interact with your data

Leave the session empowered with a new tool in your toolkit to get things done better and faster for all of your end-users’ needs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 18

Time: 11:45 AM - 12:45 PM

Room: Milton's Cubicle-225

You’ve all heard about data scientists, and seen job postings for them.  But what is the job like, really?  Let me share the story of my first official data science project.  While sharing the story I’ll stop to point out the skills used that many DBAs, PowerShell junkies, BI developers and architects already have. There may be a few new topics you’ll want to pick up.  This is a show and tell session.  It’s my hope that you come away with a better understanding of what a data scientist is, and be able to measure how far between where you are and your own first project.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: May 18

Time: 3:30 PM - 4:30 PM

Room: 37 Pieces of Flair-333

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected.  In this class, we'll cover the basics of the big five administrator tasks:

* Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
* Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
* Index maintenance – Databases need regular upkeep so they'll continue to run well.
* Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
* Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.

Being a database administrator is a big job, but we can cover the basics in one session!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
101 Beginner Level Sessions

Level: Beginner

Session Code:

Date: May 18

Time: 2:15 PM - 3:15 PM

Room: TPS Report-330

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at
	Container Fundamentals with Docker
	Common Container Scenarios
	Automation with Kubernetes
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 18

Time: 1:00 PM - 2:00 PM

Room: The Bobs-112

Back in 2003 Microsoft released an addition to SQL Server 2000 named SQL Server Reporting Services (SSRS).  This is a story of the journey of the BI Engine that could. From updates, to periods or rest and updates again. Not only has it been updated, but new features, capabilities and event a new project has been born from its humble beginnings. Now, paginated reports, the only type of report that was available when SSRS was initially released, are available in both on-premises and cloud-based solutions.  Join this session to experience the journey of SSRS and how to create and deploy reports across all the different products available in the Microsoft Ecosystem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 18

Time: 3:30 PM - 4:30 PM

Room: Chotchkies-110

Learn common patterns for testing data, and the anti-patterns that trip developers up.

Data is a critical asset for many companies, but often it's not treated that way. During this session, we'll discuss common patterns for testing, validating, and monitoring your data to ensure that it is accurate and complete. This will include patterns for 
•	data warehousing
•	data integration
•	data migration
We will also discuss the common pitfalls that organizations encounter when they start treating their data as an asset, including:
•	treating data testing like application testing
•	testing the wrong things
•	not supporting your data testing initiatives for the long term
Attend this session, and you will gain valuable information on ensuring your data is a real asset to your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: May 18

Time: 8:00 AM - 9:00 AM

Room: O Face-332

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