Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 54
Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers?

Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.

When you leave, you'll be armed with knowledge and tools to tackle your current workloads and hit the ground running.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 11:00 AM - 12:00 PM

Room: Theater

There is a huge need to use AI and ML in Power Platform to get more insight from data, create smart applications and so forth. In a one day workshop, the process of using AI and ML in Power BI desktop and Power BI Service using Cognitive services, Azure ML Studio, AutoML will be discussed. Next, AUdience will learn how to use AI and ML inside Power Apps and Microsoft Flow to access more insight from the data they have and to create smart applications. In general, new features and tools in Microsoft Machine learning in Power BI, Microsoft Power Apps, and Flow will be shown. 
Some parts of this workshop are hands-on.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Full Day Precon - Friday Session (480 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 11

Time: 9:00 AM - 5:00 PM

Room: 1518

Large tables in SQL Server present challenges on several fronts. For query performance, avoiding accessing data unnecessarily becomes more important. For ETL, loading and modifying data while utilizing compute resource and avoiding lock contention becomes more difficult. For maintenance, making efficient use of resources and time presents challenges. 

In this session, we will introduce the core concepts of partitioning in SQL Server -- partitioning columns, partition schemes, and partition functions. We will configure heaps, rowstores, and columnstores as partitioned tables, and execute queries to compare how they access data. Finally, we will work with the requirements for switching partitions in and out of tables.

After this session, you will be able to configure partitioned tables, explain how partitioning affects query execution, and switch partitions in and out of tables.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 1:30 PM - 2:30 PM

Room: 3275

Implementing a Power BI solution is not just about the report development, dashboard design and DAX queries. Designing the right architecture is an essential part of a Power BI implementation.

There are many areas to consider when you are designing a Power BI architecture. From sharing reports and security to the type of connection and usage of other components such as Dataflow.

Come to this session to learn about important things you need to know about the architecture of a Power BI solution. You will learn some blueprints of what are key things to consider and how to design the architecture for your solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 12

Time: 9:45 AM - 10:45 AM

Room: Theater

Cross-platform and approachably extensible, Azure Data Studio is a new application for database development and management. Azure Data Studio extensions can create efficiencies by automating a workflow or integrating with an external system. 

This session will take the audience through the fundamentals of extension development for Azure Data Studio with Typescript and other open source tools. Our discussion will include available internal APIs, hosting your extension on GitHub, and sharing your work through the extension marketplace. By demonstrating each concept through building an extension in the session, we will end with a working extension utilizing functionality released recently in Azure Data Studio.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 12

Time: 3:00 PM - 4:00 PM

Room: 2220

Databricks is the tool of choice for performing data transformation in Azure. This session gives an overview of Apache Spark and Databricks. We will also perform a non trivial data transformation, publish the resulting data frame to the HIVE metastore, and query it directly from Power BI. Come see what is possible in the Modern Data Platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 11:00 AM - 12:00 PM

Room: 2200

Security, cost, and capabilities are the key questions for any Azure project. Nothing should be implemented today without a tested security surface. Creating a strong and flexible identity perimeter will allow for secure access. Platform security will create a secured perimeter for all of your cloud resources from Virtual Machines and Networks to resource locks and permissions. Manage customized security alerts, and configure a playbook for specific threats. Configure security for data infrastructure, and data encryption at rest. Implement security for applications such as certs, monitoring, and security baselines. Data and applications will not last long if costs are not managed from the beginning. You will need to monitor and analyze the cost of your Azure resources as soon as development begins. Azure Cost Management allows you to create a budget. The biggest factor in security, and cost management is implementing the right capabilities to support your business requirements.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 9:45 AM - 10:45 AM

Room: 2200

Let's talk about Managed Instance, the newest member of the Azure SQL Database family. It's a WHOLE lot closer to out-of-the-box SQL Server than other flavors of Azure SQL DB. But it's still got some differences. Do those matter for you?  What exactly is it? What is it good for (or not)? How much does it cost? Just how compatible is it with existing systems? How can I move data in and out of it? How is my data protected, for HA, DR, and backups? What else do I need to know about it?

Bottom line: Does Managed Instance make sense for me?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 11:00 AM - 12:00 PM

Room: 3190

SQL DB Hyperscale is a cost effective VLDB, fully managed SQL PaaS option. It shares the same Azure SQL Server engine, retaining compatibility for application, the storage is fundamentally redesigned from the ground up to be cloud-born with cache-miss reads of under 2ms. The Hyperscale architecture supports separation of compute and storage, allows for dynamic scaling of CPU, memory, and compute nodes in constant time, regardless of database size. Database backup and restore also in constant time, regardless of database size (RPO 0 minutes, RTO less than 10 minutes). High availability supports one primary read/write, up to four read-only replicas, which also serve as hot-standy in case of automatic failover. Come find out more about this exciting, optimized for OLTP and HTAP database option.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 12

Time: 3:00 PM - 4:00 PM

Room: 2225

Data engineering architectures in recent years have been centralized around large cloud Data Lakes like Azure Data Lake, Azure Blob, S3, and HDFS. These Data Lakes have provided organizations with cheap and easy to use storage of critical and sometimes... very inconsistent data. 

Using Delta Lake, in tandem with Azure Databricks, we'll walkthrough bottling your Azure Data Lake data into clean, validated, and consumable tables for personas from Business Analysts to Data Scientists. All without changing where you keep your data!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 12

Time: 4:15 PM - 5:15 PM

Room: 2225

In this session we will go over and talk about what it means to build your own brand and cover the following topics listed below. We plan for this to be a highly interactive discussion.

- Discussing value of community events & Meetups
- Importance of an active social profile
- Investing in professional development & training
- Give back to the local data community
Speaker:

Accompanying Materials:

No material found.

Session Type:
Full Day Precon - Friday Session (480 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 12

Time: 9:45 AM - 5:45 PM

Room: 2115

Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to leverage the learning curve in Microsoft Data Platform, based on my knowledge and experience,  the proven strategies and techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 12

Time: 4:15 PM - 5:15 PM

Room: R8

Protected Health Information (PHI) and other forms of sensitive data are an area of concern in all industries. Highly regulated industries such as Healthcare and Financial Services have a great deal of person-specific information in their systems, and often restrict the use of self-service Business Intelligence (BI) to prevent the wrong people from seeing the wrong data. This presentation will review new ways to safely enable self-service BI for an enterprise without introducing additional risk of PHI or sensitive data violations. I'll review strategies and architectures that include Power BI DataFlows with Azure Data Lake to eliminate sensitive data from a self-service BI environment. An infrastructure leveraging these tools can still have highly controlled and governed enterprise Power BI reports that carefully distribute PHI and sensitive data to targeted users, while also enabling self-service BI without an increased risk of sensitive data violations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 12

Time: 1:30 PM - 2:30 PM

Room: 2230

CosmosDB is Microsoft’s globally distributed, massively scalable, cloud based database that is hosted in AZURE.  Who cares?  You should if you need to support thousands of transactions a second, global distribution and redundancy, and different consistencies.  

Do you need to support JSON, Graph, et al?  Done.  Join me and see how easy it is to get started.  We will set up a local instance of CosmosDB, load JSON data and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for.  At the end of the session you will then learn how, with a couple of commands, to switch your visualization to the cloud.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 12

Time: 4:15 PM - 5:15 PM

Room: 3150

Are you new to Power BI? Are you looking to extract insights from your Google Analytics and Google Ad Words data? I will walk you through the underlying architecture of Power BI and basic Dax all the while in building a Power BI marketing report for your Ad Words and website data. The attendee will leave the class ready to start using Power BI for their Marketing Dashboards.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 12

Time: 1:30 PM - 2:30 PM

Room: 2215

As DBAs, we are asked all sorts of impossible questions.  Who dropped that important table last month?  Why was everything slow last week?  Who made that user a sysadmin?  You’d have to be a mind reader to know the answers to some of those, right?  Not necessarily!  SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide.  In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 3:00 PM - 4:00 PM

Room: 3190

To get the most from our SSAS Tabular and Power BI models, we must be able to create robust DAX expressions. This requires the right interplay of filtering, context and the myriad of DAX functions. This session will provide a solid working understanding of all three, giving you a firm foundation for fulfilling those demanding user requirements. This session will include examples using some of the most recent additions to the ever-expanding DAX language.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 12

Time: 11:00 AM - 12:00 PM

Room: 2215

Data privacy has never been more relevant than the last few years. Are you doing all you can to protect your data? In this session we will look at different methods to encrypt data and what those methods protect against as well as what they do not protect. I will also demonstrate enabling Transparent Data Encryption (TDE), column level encryption and the new Always Encrypted along with how to encrypt and decrypt your data….no decoder ring needed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 1:30 PM - 2:30 PM

Room: 3190

SQL Server 2019 Big Data Clusters introduce Kubernetes as whole new deployment platform.  For those coming from prior versions of SQL Server on Windows, this can be daunting.  This session will walk through how to do the deployment step-by-step so you can understand how it’s done, the components involved, and what you might need to learn more about as you take the journey to SQL Server 2019 and Big Data Clusters.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 9:45 AM - 10:45 AM

Room: 3190

You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database?

In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short. 

Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 12

Time: 4:15 PM - 5:15 PM

Room: 2220

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