Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type


Sessions Found: 57
In this session, you'll learn how to use an open source PowerShell module to create advanced PowerShell commands that generate dynamic SQL queries without having to actually know PowerShell. You'll learn how to start with a SQL query and build a fully functioning advanced PowerShell function, complete with parameters that allow for result filtering, PowerShell help, tab completion, and custom formatting, all without having to know how to do any of that in PowerShell. You'll learn how creating these cheap, yet powerful, commands allows you to build entire modules that can be distributed to other users that need to access this data that might not know how to build their own queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PowerShell

Level: Beginner

Session Code:

Date: July 29

Time: 10:30 AM - 11:30 AM

Room: 1835 (PowerShell/Scripting)

Have you been thinking about moving your custom web app to Azure? You'll need to consider several aspects, and this session focuses on some of the technical ones. An existing demo application developed in ASP.NET MVC with a SQL Server backend will be moved over to run in Azure App Service and Azure SQL DB. Along the way, you'll see how to navigate the Azure Portal, consider benefits of Visual Studio Team Services, and have opportunities to see how an app can take advantage of additional Azure services.?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Beginner

Session Code:

Date: July 29

Time: 2:45 PM - 3:45 PM

Room: 1620 (Mobile Dev)

I have frequently seen developers confuse async and parallel programming, not understanding that the purpose of each are quite different.  Well designed modern .NET development is full of the async/await model,  async/await is built on the Task model, but also async is not parallel.  So understanding these concepts is key to long term success in building apps in .NET that are both responsive and most efficient.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: July 29

Time: 2:45 PM - 3:45 PM

Room: 1510 (.NET Dev)

How do you know whether or not all of the SQL Servers in your environment are configured based on your organizations standards? How do you know whether or not they are all operating properly when maintenance is performed on the systems in your environment? During this session, Microsoft MVP Mike F Robbins will discuss and demonstrate how to use PowerShell and Pester to automate operational readiness and operational validation testing of your SQL Servers and the systems in your environment that depend on them. Prior experience with PowerShell is recommended.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PowerShell

Level: Intermedia

Session Code:

Date: July 29

Time: 2:45 PM - 3:45 PM

Room: 1835 (PowerShell/Scripting)

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PowerShell

Level: Intermedia

Session Code:

Date: July 29

Time: 1:30 PM - 2:30 PM

Room: 1835 (PowerShell/Scripting)

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 29

Time: 9:15 AM - 10:15 AM

Room: 1325 (Career)

DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Development

Level: Beginner

Session Code:

Date: July 29

Time: 12:15 PM - 1:15 PM

Room: 1510 (.NET Dev)

Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session.  This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Career

Level: Beginner

Session Code:

Date: July 29

Time: 10:30 AM - 11:30 AM

Room: 1325 (Career)

This session will build on the "Code Like a Pirate ... Intro to R and Data Science Tools in MS" session. We will cover intermediate R techniques and packages around data wrangling, plotting and statistics. 

The session will work through a real data science example from Import, Tidy, Transform, Visualize, Model and finally Communicate your results. No prior statistics knowledge is needed just a basic understanding of R.

In this session, we will use Microsoft R Server, R Tools for Visual Studio and Power BI to work through a Data Science problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: July 29

Time: 1:30 PM - 2:30 PM

Room: 1305 (Big Data/Analytics)

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:
Business Intelligence

Level: Beginner

Session Code:

Date: July 29

Time: 12:15 PM - 1:15 PM

Room: 1305 (Big Data/Analytics)

Indulge me as I fan the eternal flames of the so-called "impedance mismatch" between your domain objects and the RDBS that stores them. We'll talk about how to augment or even (gasp) forego heavy hitters like Entity Framework when appropriate.  We'll discuss good code design and the merits and trade-offs of interchangeable database implementations.  The presentation will include c#, SQL, EF, SimpleInjector, a dab of Dapper, and my own new secret weapon: FluidDbClient.

You'll find this session helpful if:
- You want to map data to nested domain models of titanium stature (look ma, no public setters!)
- You don't mind getting your c#-coddled hands a little dirty with SQL.
- There are parts of your app where read/write performance is critical 
- You're ready to put some fresh eyes on crusty old terms like Unit of Work, Identity Map, and the Mememto pattern.
- You appreciate things like programming to interfaces, dependency injection, and the subtleties of the Open-Close Principle.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: July 29

Time: 9:15 AM - 10:15 AM

Room: 1510 (.NET Dev)

Explore data modeling and process modeling. 

Enterprise Data Model 
Conceptual Data Model 
Logical Data Model 
Physical Data Model 
Star Schema Data Model 
Business Process Model 

Modeling Tools:
IDERA ER/Studio Data Architect 
ERWin
Visual Studio 
Visio
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: July 29

Time: 2:45 PM - 3:45 PM

Room: 1845 (Business Intelligence)

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Administration

Level: Intermedia

Session Code:

Date: July 29

Time: 12:15 PM - 1:15 PM

Room: 1321 (SQL Admin)

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed.  Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL.  From parameter based searches to building dynamic SELECT statements at run time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Development

Level: Beginner

Session Code:

Date: July 29

Time: 10:30 AM - 11:30 AM

Room: 1220 (SQL Dev)

For years, SQL Server Reporting Services chugged along with very few updates. Although it remained a reliable and popular reporting tool, the feature set largely remained unchanged for a decade. With the release of SQL Server 2016, everything changed. Microsoft delivered a brand new SSRS. This session will review and demonstrate the new features of SQL Server Reporting Services 2016. You'll walk through the essential changes in SSRS, from the new report manager to the new visualizations. You'll also discuss the SSRS ecosystem and how it fits together with PowerBI and other Microsoft reporting/analytics platforms.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: July 29

Time: 1:30 PM - 2:30 PM

Room: 1845 (Business Intelligence)

Power BI is all the rage right now in visualizing data on the Microsoft BI stack.  We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization.   Make your visualization count.  Come join us on the journey.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PowerBI

Level: Beginner

Session Code:

Date: July 29

Time: 2:45 PM - 3:45 PM

Room: 1700 (Power BI)

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Administration

Level: Advanced

Session Code:

Date: July 29

Time: 2:45 PM - 3:45 PM

Room: 1321 (SQL Admin)

Heard of .NET Core, but not taken the time to look in to it? Started looking at it, but been discouraged by the seemingly endless stream of breaking changes to the architecture? Played around with it, but want to know what the framework code you're typing is actually doing? This talk aims to answer some of your questions about .NET Core, what it is, how it's structured, middleware, and the differences between it and the .NET Framework. We'll also have a brief introduction to ASP.NET Core.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: July 29

Time: 10:30 AM - 11:30 AM

Room: 1510 (.NET Dev)

Javascript generators are a fascinating addition to the language. In this session we will go deep into how they work, how they're useful, and culminate with a discussion of how they are used in the gimgen library to create a novel reactive programming library.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Mobile App Dev

Level: Advanced

Session Code:

Date: July 29

Time: 12:15 PM - 1:15 PM

Room: 1620 (Mobile Dev)

As a manager or team leader giving effective feedback is vital to the success of projects.  In this session we will discuss soft skills and best practices to give feedback, performance improvement, and even disciplinary actions. Learn how to handle confrontation tactfully.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 29

Time: 10:30 AM - 11:30 AM

Room: 1425 (IT Management)

Sessions Found: 57
Back to Top