Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type

Sessions Found: 30
The SQL Server Query Processor does a great job of hiding all the dirty work necessary to display, store, and delete data. But when it's time to tune performance, the more you know, the better decisions you will make. In this T-SQL demo-heavy deep-dive session, we'll follow the Query Processor as it rips through a database and discover the steps it takes responding to our queries.
Attend this advanced session and you will be able to: * View and interpret raw data and metadata with DMVs, XEvents, and DBCC commands, including some undocumented ones (all demo scripts included in session download) * View and describe, with precise details, exactly what data and metadata actions any given query took, and, * Attack and destroy query performance problems with some neat new weapons.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: July 11

Time: 10:50 AM - 11:50 AM

Room: Room 1

Do you need to devise a backup and restore plan to meet the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) of your business?  I'll show you how to pick the right backup type, method, and recovery model to meet your business needs.  You'll learn how the network and drive format can have an effect on your backups and avoid the pitfalls that slow down your backup and restore plan.  You'll also learn how to keep your transaction log from growing uncontrollably while speeding up your backups and restores using the native tools without any added cost!
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 11

Time: 1:00 PM - 2:00 PM

Room: Room 1

You're looking to protect your SQL instance from a machine failure.  Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides.  Let's learn what a cluster is and why it might be the right thing for you.  We'll explore the system, network, storage and database administration sides of the equation.  And, when it's all said and done we'll even have built a SQL clustered instance!
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 3:20 PM - 4:20 PM

Room: Room 5

Power up your data presentations with Power View and Power Map. Charts and maps can be made interactive, generated on the fly, or recorded as video with a soundtrack and special effects. Instead of trying to make your point with a boring list of names, numbers, and dates, put on your movie director's hat and give your data the Hollywood treatment as you yell, "Lights! Cameras! Action!"
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 9:40 AM - 10:40 AM

Room: Room 3

Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 9:40 AM - 10:40 AM

Room: Room 2

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, 5 common troublemakers, and where to learn more. If an execution plan looks like hieroglyphics, this course is for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 1:00 PM - 2:00 PM

Room: Room 4

Custom proximity search is a new feature introduced in SQL Server 2012 Full-Text Search. It's facilitated using the NEAR operator, allowing it to be used in the CONTAINS predicate or CONTAINSTABLE function. The NEAR operator allows for searching words near each other. It also allows the user to specify the maximum number of non-search terms separating the first and last search terms in a match. In addition, an optional parameter can be used to specify an exact order match.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 11

Time: 9:40 AM - 10:40 AM

Room: Room 1

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this simple and painless. This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 11

Time: 8:30 AM - 9:30 AM

Room: Room 3

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 1:00 PM - 2:00 PM

Room: Room 2

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). Automating your installs doesn't just save you time, it improves standardization and adherence to best practices. There are multiple ways to automate your installs, but FineBuild goes above and beyond by allowing you to automate every part of the install from file locations to clusters, service accounts to custom databases, Reporting Services, Integration Services, Master Data Services, configurations and settings as well as many common 3rd party tools and more.  We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 1:00 PM - 2:00 PM

Room: Room 3

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data? 
We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! 
We will then secure our database connections with a simple self-signed SSL certificate. 
Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. 
*Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 11

Time: 2:10 PM - 3:10 PM

Room: Room 3

This session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for certification..
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 8:30 AM - 9:30 AM

Room: Room 1

We will have a conversation of what is APS and specifically how it differs from the normal SQL Server instances we work with daily.  By the end of this talk, you will have a very good understanding of the differences between the APS' MPP architecture compared to SMP SQL Server.  We will cover the topic of Polybase and what Hadoop Components are supported by Polybase.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 11

Time: 3:20 PM - 4:20 PM

Room: Room 2

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it.  This session includes demonstration and use case scenarios.  The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 2:10 PM - 3:10 PM

Room: Room 2

Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 2:10 PM - 3:10 PM

Room: Room 4

Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate.  This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: July 11

Time: 1:00 PM - 2:00 PM

Room: Room 5

Is it the end of the day, your brain is mush, but you want to stay for the raffle? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: July 11

Time: 3:20 PM - 4:20 PM

Room: Room 1

You have a million rows you need to move into a table.  Because of constraints, this import process is very slow.  In this session I will show you how you can speed up this process greatly by partitioning the table and moving partitions from one table to another.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 11

Time: 2:10 PM - 3:10 PM

Room: Room 1

How do you as a developer take database activity into account when designing and writing your code? What works well on a small scale can often fall down as traffic picks up. In this session, attendees will learn methods for making their SQL scripts run faster, avoid blocking, and remain stable in a busy environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 11

Time: 3:20 PM - 4:20 PM

Room: Room 4

Power BI (Business Intelligence) is a new and emerging self-service business intelligence and business analytics framework that brings together and enhances a few key Microsoft technologies.  We will answer the following questions:

?What makes Power BI different from the Microsoft Office I have known for years?

?What are the major Power BI features in Excel 2013 and 2010?

?What are the major features for Power BI for Office 365?

?How can our team license Power BI?
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: July 11

Time: 9:40 AM - 10:40 AM

Room: Room 5

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