Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 24
Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 21

Time: 2:30 PM - 3:30 PM

Room: LowerLevel 180

What do you do when the performance of a single query suddenly goes bad, bringing down your production system?  We will walk through several possible solutions for a specific example, showing how to identify when each one is the root cause.  We will delve through query plans, statistics and the optimizer on our way to discovering the true origin of the example's deterioration.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: November 21

Time: 2:30 PM - 4:00 PM

Room: LowerLevel 110

This is a deep dive into data compression in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in busy production systems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 21

Time: 1:20 PM - 2:20 PM

Room: LowerLevel 110

The “Gold” record.  The “master maintainable list”.  

There is so much data in so many systems that businesses may have no way of telling which record is accurate and up to date.  Even if a given record is accurate, how do we correct the inaccurate records in other systems?  The dissonance between these systems costs businesses time and money and can lead to poor customer relations.

Master Data Services (MDS) provides tools to get all of your databases singing from the same sheet of music.  This hour will include an overview of key master data management concepts, an introduction to MDS and how that fits in a data quality strategy and demonstrations integrating MDS systems using SSIS. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: November 21

Time: 3:40 PM - 4:40 PM

Room: LowerLevel 110

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:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: November 21

Time: 9:00 AM - 10:00 AM

Room: LowerLevel 170

In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits. We will also visualize this data using PowerBI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: November 21

Time: 2:30 PM - 3:30 PM

Room: LowerLevel 160

Access 2013 web apps feature a new, full integration with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data in Access apps.  In this session you will learn to easily create an Access Web Apps with automatic views, view the online development environment and see a real-world, production web app in action.  We’ll discuss different the use of hybrid applications and integrating office web apps as well as learn about app distribution, deployment and upgrades.  And lastly, see the pros/cons of Access Web Apps in a corporate environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: November 21

Time: 10:10 AM - 11:40 AM

Room: LowerLevel 110

How to keep the database parts of three tier server environments (Development, Staging [QA], Production) in alignment so you can minimize risk to your production release process.  I'll show you how we have been able to keep application database releases from spiraling out of control and give us the ability to rollback and respond to rapidly changing environments and how to release what was truly testing in the staging tier. Rapid development requires rapid changes to the database schema and with the change of database schema come some difficulties that can be managed to reduce downtime and scale-ability. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 21

Time: 10:10 AM - 11:10 AM

Room: LowerLevel 170

The EXEC statement provides plenty of flexibility, and sp_executesql offers even more benefits on top of that. But both have their drawbacks, their nuances, and their impact on performance. After this session, you will know what to expect from the query processor when using these features in your code and how to get the most performance out of them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: November 21

Time: 3:40 PM - 4:40 PM

Room: LowerLevel 180

Flash storage is a game changer for virtually every app in which it is used.  Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head.  Contemporary IT environments should standardize their architecture including a tier of flash.  Virtualized or non-virtualized, standardizing on in-server flash is vital for optimizing performance, scalability, efficiency (technical and cost), reliability, & availability.  Learn how flash flips the /faster bit & the significant impact flash makes not just in terms of performance, but also best practices, & the massive savings in licensing driven by consolidation on flash.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: November 21

Time: 3:40 PM - 4:40 PM

Room: LowerLevel 170

In order to implement a successful big data project, Hadoop Cluster needs to be installed successfully. To successfully install a Hadoop Cluster on physical servers, the operating system must be prepared with many configuration changes. I will discuss a few tips & tricks about the overall process, right from the operation system installation, potential processes to follow, some features to consider along with steps for public key authentication (PKE). These steps will provide you with great confidence, save lots of time and a good starting point to successfully install a Hadoop Cluster.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: November 21

Time: 9:00 AM - 10:00 AM

Room: LowerLevel 160

Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: November 21

Time: 2:30 PM - 3:30 PM

Room: LowerLevel 170

After spending the last decade or so completely devoted to the Microsoft stack, I spent the last year supporting the SQL Server instance for a team of Java developers. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. I did find, however, that there were cultural differences which made my biggest challenges different from what I was used to dealing with in the .Net world. Come hear about my misadventures with JBoss, server side cursors, and NOCOUNT settings.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 21

Time: 9:00 AM - 10:00 AM

Room: LowerLevel 180

For many engineers, interpreting disk I/O is a black art.  Yet analyzing perfmon & virtual file stats is typically straightforward. This session provides authoritative, clear guidance on collecting & interpreting disk I/O metrics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: November 21

Time: 1:20 PM - 2:20 PM

Room: LowerLevel 160

Think of all the tools you use in managing your SQL Servers. All those SQL Servers being managed by tools and man that is a lot of clicks. We will show practical scripts and techniques to help you get a handle on all those clicks. Whether you are gathering data or statistics from your SQL Servers or deploying an object to all of them. Configuration items are not excluded from the need for good tools. PowerShell is that tool that will let you get away from all those clicks. Reusable scripts that let you manage all those instances with ease. This session will give you a great start on how to think about admin tasks using PowerShell scripts or modules. Many items are already out there to help you and we will take a good look.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 21

Time: 10:10 AM - 11:10 AM

Room: LowerLevel 160

Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different.  Join Tim as he reviews what to look for when tweaking your index strategy: poor clustering key decisions, underutilized indexes, covering indexes gone wrong, overlooked heaps and fill factor failures are just a few of the blunders to be identified.  

Pointing out what is sub-par is only part of the process though.  As a group we will discuss what the better options are based upon what we uncover.  In a combination of instructor-led training and group discussion formats we will use Dynamic Management Objects, System Catalog Views and even Ola Hallengren's SQL Server Maintenance Solution to identify improvement points and next steps.  

Tim then goes one step further and introduces you to how Power BI takes this collected metadata to the next level of performance analysis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 21

Time: 9:00 AM - 10:00 AM

Room: LowerLevel 110

In today’s tech world, IT professionals are being driven to perform tasks faster and more consistently. Automation is the watchword for our success, whether we are deploying SQL Server to private virtual clouds or public platforms such as Azure IaaS.  This session will focus on rapidly creating and configuring SQL Servers using Powershell and Desired State Configuration.  You will see practical examples of how you can create repeatable builds of SQL Server that can be deployed in a matter of minutes. We will also review how these techniques can be applied to both public and private cloud platforms, ensuring your success for any situation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: November 21

Time: 1:20 PM - 2:20 PM

Room: LowerLevel 180

Powershell can be hard. As a language, it is fairly complex and provides a large array of functionality.  Fortunately, you can teach yourself how to use Powershell with tools that are built right into the language. This session will cover some Powershell fundamentals, how you can use Powershell itself to learn about concepts and syntax, and techniques for using Powershell with SQL Server. We will focus on core language patterns that you can use immediately, taking the mystery out of the code and helping you start writing your own Powershell scripts. The key to learning Powershell is using it and this session will give you a launchpad to start building your own tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: November 21

Time: 11:20 AM - 12:20 PM

Room: LowerLevel 160

We have all heard of Table level partitioning in SQL Server. It has been around for a few years but isn't something that is highly used. In this session, we will walk through the definition, setup and maintenance of table partitioning on SQL Server.  We will also highlight some advanced concepts like Sliding Windows and Partition Switching. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: November 21

Time: 10:10 AM - 11:10 AM

Room: LowerLevel 180

How well do you know your SQL components, methods and fundamentals?  Come test your SQL foo against your peers and co-workers Jeopardy™ style!  Questions will cover a broad scope of SQL development, administration and BI basics up to a 300 level. There will be time to discuss the correct answers and (as time allows) dig deeper into explanations.  No one will be required to participate, but everyone who wishes to will have an opportunity to lead their team to glory as SQL Champions!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: November 21

Time: 11:20 AM - 12:20 PM

Room: LowerLevel 110

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