Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 17
Moving data around in On-Prem databases is easy. 

Moving data around when involving Azure - may be not. Especially if you don't have a VM or an On-Prem server to move things around on. 

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: October 05

Time: 8:45 AM - 9:45 AM

Room: 203

Would you like to create Pivot Tables in SQL with ease? 

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris.
*Not Possible
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 05

Time: 2:45 PM - 3:45 PM

Room: 226

Deploying a new Big Data initiative is a daunting undertaking in it's own right, which can lead many business leaders to forget a crucial piece of the puzzle - changing company culture. What good is new technology if it does not align with the way the organization actually makes decisions? This session dives into strategies to obtain stakeholder buy-in and get organization members not just tolerant of, but EXCITED about new technology initiatives.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 05

Time: 11:15 AM - 12:15 PM

Room: 225

With the most recent release of SQL Server 2017 and the upcoming release of SQL Server 2019, there are several enhancements that were introduced for the T-SQL language. This includes new string functions, bulk access options and approximate query processing among others that address several challenges that SQL developers have to confront.  

In this demo heavy session, we will go over several of the new features, provide a demonstration of how you can use them, and share any considerations that you may need to consider before doing so. This session is intended for anyone interested in what’s new in the T-SQL language and will focus primarily just on enhancements to traditional T-SQL for the database engine.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 05

Time: 10:00 AM - 11:00 AM

Room: 227

Have you tried implementing source control? How has your continuous integration (CI) process gone? 

This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging. 

At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.

Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: October 05

Time: 1:30 PM - 2:30 PM

Room: 226

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated?  In this session, we will examine details the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient.  Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos?  We'll do just that, and then take it a step further with a unique visualization tool that I have created.  With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 05

Time: 8:45 AM - 10:15 AM

Room: 226

Get yer queries ready we're goin' fishin' on the Azure Data Lake. Azure Data Lake is hyper-scale storage service that serves as the foundation for a Modern Data Warehouse. We'll explore what makes this service unique, the pricing structure, and how to start storing data. Then we'll open our tackle boxes to learn how to use tools such as HDInsight, Azure SQL DW, and Data Lake Analytics (U-SQL) to access data for processing, analytics, and machine learning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 05

Time: 11:15 AM - 12:15 PM

Room: 203

This session is for the absolute beginner to learn the basic components of the Database Engine (Relational Engine, Storage Engine, and SQLOS) and what is the purpose of each of these three components in the execution of a simple query. The relational engine to process a query, the storage engine to access data and the SQLOS to manage resource access. The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 2:45 PM - 3:45 PM

Room: 225

Recent years have seen an uptick in the adoption of alternative data storage methods.  While the traditional RDBMS is still the de-facto Swiss Army knife for backing applications, technologies such as NoSQL and time series databases are increasingly used due to their performance and usability characteristics in certain use cases.

One of the latest entrants on the scene is the graph database.  In this session we’ll discuss what they are and how they are used.  The introduction of graph database support in MSSQL 2017 provides us with a convenient mechanism for presenting our existing data through a graph.

•	What is a Graph Database?
•	Basic Graph Theory
•	Relational vs Graph data models
•	Graph Databases in MSSQL
•	Use cases
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 05

Time: 1:30 PM - 2:30 PM

Room: 203

Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a  daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, Database Projects in Visual Studio add a bit of an "easy" button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 8:45 AM - 9:45 AM

Room: 225

The process of designing a relational database is not overly complex, and may be done by almost anyone on the development team. The process requires one to take the time to understand the requirements, when they exist, and apply a straightforward set of transforms to produce table structures that meets the needs. The tough part is that the process requires time and experience, neither of which anyone has enough of. In this session, to help the attendee differentiate right-enough designs from overly simple or overly complex designs, we will look at a variety of database snippets, each inspired from a real life design. We will discuss the pros and cons of the approach taken, and consider possible remediations to learn from a failure that was made by someone else.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 2:45 PM - 3:45 PM

Room: 227

DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process.  In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded.   Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing.  "Near production data" is used in Staging, and finally production is upgraded.  This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process.  Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages.   Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes.  Learn how leading enterprises are simplifying SQL DevOps.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 10:00 AM - 11:00 AM

Room: 203

Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well?  Or need to provide security information to auditors or your security team?

SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

- Document your database schema objects such as procedures, functions, tables, columns and indexes
- Investigate performance and look for bottlenecks and tuning opportunities
- Discover metadata to administer your databases backups, index maintenance, and security
- Apply your own metadata using extended properties

We will also cover the official Microsoft documentation on these features and other resources on how to use them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 1:30 PM - 2:30 PM

Room: 227

Join us as we (yes, including attendees) discuss incidents and look for ways as victims, as by-standers and as event host to react.  Let’s enable each other to do what is right, speak up and support one another. It’s time for the community to come together, make their voice be heard and share ways and tools to deal with these difficult situations. Although some stores are inspired in part by a true incident, they are fictional and do not depict any actual person or event.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 05

Time: 11:15 AM - 12:15 PM

Room: 227

Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 05

Time: 2:45 PM - 3:45 PM

Room: 203

Power BI continues to become one of the best ways to report and analyze business data.   With recent announcements in Power BI roadmap around Dataflows, Composite models, AI integration, Common Data Service and Power Suite integration there are many more ways to add value to your existing Power BI environment.   Come learn about all the key new features in Power BI you should be using and what new features are coming down the roadmap so you can increase value and usage of Power BI across the organization.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 05

Time: 10:00 AM - 11:00 AM

Room: 226

User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway? 
Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that give the best user experience? 
In this session we will explore in a hands-on exercise what UX and Design thinking is, how to apply the methodologies to our daily work and then how we could apply it to BI to make kick ass dashboards and reporting for our internal and external customers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 05

Time: 1:30 PM - 2:30 PM

Room: 225

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