Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 29
There is a steep learning curve moving from a traditional application development role into writing database code.  Your experience is telling you one thing and the DBAs are telling you another.  Making sense of what's going on can be quite a struggle.  Join me and let's try to smooth out some of the biggest points of confusion.  Including subjects like, the anatomy of a table, what's up with NULLs, why should I be cautious with functions, and how can I start tuning my queries.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 27

Time: 9:45 AM - 11:15 AM

Room: Room D

Ever wondered what the craze of Server Core is all about? There is a lot of power in Core and with it comes the admin challenge of NO GUI.  But there are settings that you want to change in the OS, how do you do that? This session will take you through some of the challenges that are not really challenges when you know. We will use the builtin method of making some changes and also use PowerShell and commandline tools to get you where you want to be with Core. I built a 6 node cluster on Server Core and created it with PowerShell (Cluster and all) and it runs very nicely with a little footprint in RAM for the effort.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 2:00 PM - 3:00 PM

Room: Room C

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: August 27

Time: 2:00 PM - 3:00 PM

Room: Room B

Could your seemingly-normal SSIS package be hiding a disaster, waiting to detonate at the most inconvenient time? Integration Services is an incredibly flexible product, and that flexibility can lead to good - and occasionally bad - design patterns. Small and seemingly trivial design decisions can lead to big issues down the road, including leaky data flows, data quality issues, paralyzing performance issues, and other explosive behaviors.

In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we'll demonstrate what can go wrong and show some alternative designs to prevent these types of problems from developing into bigger issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 2:00 PM - 3:00 PM

Room: Room D

This session is designed to teach DBAs and developers the best strategy to transfer large data. 

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode. 
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 9:45 AM - 11:15 AM

Room: Room A

Loading large amounts of data into SQL Server can be challenging. Many factors may challenge your goal for tuned performance. To make the decision making process more difficult, many of the choices listed below have both Pros and Cons to their implementation. For this reason, bulk loading large amounts of data requires a strategy.

Create a strategy to optimize your massive data loading processes.
•	High Performance Data Loading
•	Minimal Logging and Bulk Loading
•	Indexing Considerations
•	Delayed Durability
•	Eager Write

This session uses a Virtual Sandbox to demonstrate “real” data loads using these techniques listed above. We will look at the T-SQL used in these data loads. We will briefly discuss how the different settings and configurations effect the data loads. Power Point slides and sample SQL will be provided.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 27

Time: 12:45 PM - 1:45 PM

Room: Room B

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:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 3:15 PM - 4:15 PM

Room: Room B

Microsoft Azure  provides multiple options to migrate SQL  Server to the Cloud.  But migrating SQL Server requires good understanding of the different options and the constraints.  This session focuses on Microsoft Cloud option for SQL Server, how to deploy SQL Server on Azure Virtual Machine,  how  SQL Licensing works on Azure Virtual Machine, deploying Alwayson AG and Hybrid Cloud Scenarios.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 8:30 AM - 9:30 AM

Room: Room A

Bradly Crowe will be presenting for EMC on the below Abstract:

2016 is the year of All-Flash for primary storage and EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type. 

Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 27

Time: 11:15 AM - 12:45 PM

Room: Room C

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:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: August 27

Time: 9:45 AM - 11:15 AM

Room: Room E

In this session you will understand how the SQL Server Query Store can be used to take you to the next level for query performance monitoring, tuning, and troubleshooting. You will see how the Query Store works, what its capabilities are, and even how to troubleshoot when problems occur with its execution. There will be plenty of demos in this session covering both SQL Server 2016 and Azure SQL Database scenarios/
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 9:45 AM - 11:15 AM

Room: Room C

Data Warehouses are expensive, right? I mean, companies charge hundreds of thousands of dollars to build them for you.  We all know the hardest part is just getting started, in this session we will talk about general dimensional design, how to start modeling your schemas, and by the end of this session you will have built your first star schema.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: August 27

Time: 3:15 PM - 4:15 PM

Room: Room C

You have a lot of data to move and a lot of pieces to manage. Perhaps you're a developer and know that SSIS is the best way to move it, but you naturally dislike GUI-based development or you're just not looking forward to the tedium.

Or perhaps you're a team lead/architect and are looking for an efficient platform that best utilizes the development skills of your team.

Jeremy Marx will introduce BIML, a language you can quickly pick up to develop SSIS solutions with code, and BIMLscript, intelligently mixing in C# to make your BIML practically build itself.

Jeremy will demonstrate how to build a simple, single-table SSIS package using BIML, then extend it to many tables with just a few lines of code, and finally apply a more robust data flow designed for reuse. You'll leave with tools and resources to begin coding SSIS solutions faster and more efficiently.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 27

Time: 8:30 AM - 9:30 AM

Room: Room D

ORMs - oh how I LOVE them! As a consultant when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance and scalability you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 27

Time: 2:00 PM - 3:00 PM

Room: Room A

Powershell has become the defacto standard for scripting Microsoft products.  However, putting data in text files doesn’t scale.  Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections.  We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting.  This is a no holds barred session taught by an enterprise SQL Server scripting expert.  You can’t afford to miss this session if you do any level of scripting in your shop.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 3:15 PM - 4:15 PM

Room: Room E

none
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 27

Time: 11:15 AM - 12:15 PM

Room: Room A

Lunch Sponsor Session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 27

Time: 11:15 AM - 12:45 PM

Room: Room B

This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some outside modules created to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour and never try to reuse a click again. 
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 27

Time: 9:45 AM - 11:15 AM

Room: Room B

You have heard all the hype how the cloud can help you scale your databases horizontally, providing you limitless capacity, but how do you do that? In this presentation we will take a look at the Elastic Database tools. We will focus on the key use cases for shard map management, data dependent routing and multi-shard querying.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 27

Time: 8:30 AM - 9:30 AM

Room: Room B

Join me in taking a deep dive and a behind the scenes look at how SQL Server 2016 ‘It Just Runs Faster’, focused on scalability and performance enhancements. This talk will discuss the improvements, not only for awareness, but expose design and internal change details. The beauty behind ‘It Just Runs Faster’ is your ability to just upgrade, in place, and take advantage without lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense for your business, you won't want to miss this session.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 27

Time: 8:30 AM - 10:00 AM

Room: Room C

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