Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 44
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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 21

Time: 2:45 PM - 3:45 PM

Room: 112

Evaluate Session

Today's enterprise is evolving at a rapid pace by taking advantage of what cloud services can offer.  By leveraging cloud's scalability, companies are re-architecting their data centers while doing cost optimization. 
In this presentation, we will do assess the on-premises environment and determining what workloads and databases are ready to make the move and what can you do to improve their Azure readiness while reducing downtime during the migration. 
Planning and assessment plays a critical role in moving to the cloud. We would see wide range of resources and tools to get assessment completed with ease while identifying workload dependencies with practical tips and tricks focusing on sizing and costs. And finally, we'll assess the SQL instances and identify their readiness for Azure as well. 
By the end of this presentation , you'll be able to confidently identify your on-premises workloads and databases that are Azure-ready, or almost ready.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 21

Time: 4:00 PM - 5:00 PM

Room: 111

Evaluate Session

tSQLt is an easy-to-use database unit testing framework for Microsoft SQL Server. It is ideal for the database developer because tests are written in T-SQL.

This session explores how and why application unit testing is performed, and then focuses on unit testing database code with tSQLt.  We will learn how tests are structured, and how to set up realistic tests. We will talk about how much testing coverage is enough and when you can stop.

Even if you aren't able to fully implement Test Driven Development tomorrow, you'll walk away knowing how to future-protect that next tricky bit of logic with tests that will ensure your code produces desired results, not only the first time, but with all future modifications as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 21

Time: 4:00 PM - 5:00 PM

Room: 311

Evaluate Session

This session will break down the options you have in Azure to build a data analytics ecosystem, and explain why everyone's talking about data lakes and where's best to build your data warehouse. We will cover the fundamentals of data lakes and modern practices in cloud data warehousing on Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PASS Summit Preview

Level: Beginner

Session Code:

Date: September 21

Time: 10:30 AM - 11:30 AM

Room: 309

Evaluate Session

Have you ever thought what would it be like to run SQL Server engine in a small footprint? Well, wait no more. 

Running on Arm and x64 architecture with a reduced footprint, the proven performant and most secure Microsoft SQL engine is coming to the Edge in interactive devices and edge gateways. Combining new capabilities on data streaming and time-series, with in-database machine learning (ML), Azure SQL Database Edge is optimized for low-latency analytics right on the Edge. This session will showcase the scenarios Azure SQL Database Edge can enable.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 21

Time: 10:30 AM - 11:30 AM

Room: 301

Evaluate Session

Windowing functions are when you add a "window" to which rows a function will look at using the OVER clause. We'll start by learning how to add the OVER clause to the commonplace COUNT, SUM, AVG, MIN, and MAX aggregate functions, since the OVER clause is optional. From there, we'll learn some ranking functions, which do require the OVER clause. You'll see examples that use the ROW_NUMBER function to identify and delete duplicate rows. Finally, we'll close with the RANK and DENSE_RANK functions that help you report on the grouping of your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 21

Time: 10:30 AM - 11:30 AM

Room: 112

Evaluate Session

If data is the new oil, then Big Data is the new snake oil. 
For over a decade, Big Data has managed to delude far too many smart, honest, hard-working data practitioners, with nothing but the best intentions.
This session is a plea for your common sense and decency. 
Together, we will use history, facts, authority, and logic to expose it for what it really is. 
Layer by layer, we will peel off the Confusion, Illusion, Deception, Distraction and the Regression that is "Big Data".
You will realize just how much progress and value Big Data has bestowed on us over the past decade.
But more importantly, we will see what we can and must do to make data practice, and consequently the world, a better place. 
Brace yourself for a thought-provoking session, filled with "Aha" moments. 
I promise that after this session, you will never look at big data the same way as you did before you stepped into the room.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 21

Time: 1:30 PM - 2:30 PM

Room: 111

Evaluate Session

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.  
  
Come to this session to get an introduction to the R language including: 

  - installing and Configuring R and RStudio 
  - RStudio Overview and Debugging
  - how to Access and Manipulate Data 
  - install and Manage Packages 
  - create and Use Variables 
  - control Flows 
  - functions 
  - basic Graphing and Statistical Analysis. 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.  
  
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science, Analytics and Visualization

Level: Beginner

Session Code:

Date: September 21

Time: 1:30 PM - 2:30 PM

Room: 112

Evaluate Session

Columnstore indexes are available to all SQL Server editions, Express to Enterprise, starting with SQL Server 2016 Service Pack 1. They can save disk space, increase query performance, and combine OLTP and OLAP workloads. Should you change all your tables to columnstores? Let's find out!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 21

Time: 1:30 PM - 2:30 PM

Room: 315

Evaluate Session

Have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try?  The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?”  Confidence allows us to dream big and gives us the fuel to escape from a world of apathy.  It gets us out of bed ready for action; ready to do something that will move us towards achieving whatever goal we set for ourselves.  Without the confidence to at least try, we are sure to fail.  If we try, but only half heartedly because we lack confidence, we will likely fail.  Confidence will improve your odds of success in any endeavor.  
Confidence is only 25% genetic.  Let’s improve the other 75%.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development/Other

Level: Beginner

Session Code:

Date: September 21

Time: 10:30 AM - 11:30 AM

Room: 315

Evaluate Session

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 21

Time: 12:15 PM - 1:15 PM

Room: 317

Evaluate Session

It is so difficult to model data today. The number of products the average company uses to store data has exploded. The database vendors are competing and releasing features at an astounding rate. The cloud vendors have also accelerated the pace of change. In analytics, some people say there is no need for a star schema. In transactional systems, some people say that the EF Codd era is over and we can repeat data as often as we want. One blog writer says one thing, while another contradicts them.    These things are creating a confusing atmosphere for the data modeler.    

It is true that data modeling has changed, but there is no need to throw out great practices that have served us for years and can continue to do so. This session will cover what has changed for data modeling, why it changed, and how to take advantage of those changes. Combine new thinking with classic data architecture and you will create great analytic and transactional systems for your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science, Analytics and Visualization

Level: Intermedia

Session Code:

Date: September 21

Time: 4:00 PM - 5:00 PM

Room: 309

Evaluate Session

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: September 21

Time: 2:45 PM - 3:45 PM

Room: 309

Evaluate Session

We will discuss ETL software, have an intro to SSIS basics, create a basic package, and implement third-party tools like MelissaData and CozyRoc
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 21

Time: 1:30 PM - 2:30 PM

Room: 301

Evaluate Session

There's an old adage about rebuilding the airplane while you're flying it.  That sounds a bit like our recent project - planning & executing a hardware migration, and SQL/OS upgrade, of a complex Data Warehouse environment.  The components include:  multi-TB DBs, SSIS (mix of SSISDB Catalog & old-school Pkg Store), SSRS (via SharePoint integration), SSIS, SSAS (mix of MDX & Tabular), WhereScape, DNS Aliases, multiple job schedulers, various drivers/scripts/apps, and implementation of an AlwaysOn AG.    

We'll outline pitfalls to avoid, and walk you through hard-won lessons and strategies for success.  We'll discuss our automated process for continuous deployment, which greatly reduced downtime and risk.  Of course, we'll share relevant technical tips & tricks.  Possible guest-starring appearances from Chris and Dan, who were key players in the success of this project.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 21

Time: 1:30 PM - 2:30 PM

Room: 113

Evaluate Session

Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine. It's a fully managed database as a service offering that can handle mission-critical workloads with predictable performance, security, high availability, and dynamic scalability. This session will take you through the basics of Azure Database for PostgreSQL, setting it up, connecting, and building applications on it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 21

Time: 10:30 AM - 11:30 AM

Room: 113

Evaluate Session

Databricks Delta is a single data management tool that combines the scale of a data lake, the reliability and performance of a data warehouse, and the low latency of streaming in a single system for the first time. This session will go over the basics of what Databricks Delta is and how it can be used as part of your Data Platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science, Analytics and Visualization

Level: Beginner

Session Code:

Date: September 21

Time: 4:00 PM - 5:00 PM

Room: 316

Evaluate Session

Many times we look at the success of others and think it is beyond us. In this session, 12 time Microsoft MVP and author of How to Be an MVP in Life, David Lundell, will share stories from fellow Microsoft MVPs, and some sports MVPs illustrating key attribute in professional and personal development relating to becoming a Microsoft MVP, and even more importantly becoming an MVP in Life.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development/Other

Level: Beginner

Session Code:

Date: September 21

Time: 9:15 AM - 10:15 AM

Room: 317

Evaluate Session

What is a T-SQL framework and how will it help you as a developer.

In this session we will create a framework that we can leverage through a template that will take care of the tedious tasks that come with development.  These tasks or features include audit logging, designing a dynamic data driven error handling process, and control level batching in order to document, troubleshoot, and base line your code base.  Once these features are developed you can spend more time in doing what really needs to happen like developing logic to perform processes while allowing the framework to control the necessary error handling tasks for you so you can continue to produce rapid development code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development/Other

Level: Beginner

Session Code:

Date: September 21

Time: 9:15 AM - 10:15 AM

Room: 112

Evaluate Session

Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware.  It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking.  Let’s see how compression, statistics, and indexes bring new life into your existing hardware.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 21

Time: 9:15 AM - 10:15 AM

Room: 309

Evaluate Session

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