Build Schedule

In this session, we will walk through the process of building a spatial data
warehouse from the ground up. We will first design a basic spatial data
warehouse, then identify and import a spatial data source by using Microsoft
SQL Server Integration Services (SSIS), and finally write a spatial query to
provide data to SQL Server Reporting Services (SSRS). We will also review
basic concepts of working with spatial data in SQL Server.

Jason Horner

Session Type:
Regular Session

Track:
3 -BI Treats

Level: Beginner

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date & time functions, windowing functions, analytic functions and sequences.

Bill Fellows

Session Type:
Regular Session

Track:
2 -SQL Dev

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Hossam will be your guided tour to the indexing world! We will visits index types, know where to use them, how they work, interesting facts, and best practices. We will see how to keep our indexes healthy for better performance as well.

Hossam Alfraih

Session Type:
Regular Session

Track:
1 -Indexes

Level: Beginner

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!
Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.

Hugo Kornelis

Session Type:
Regular Session

Track:
1 -Indexes

Level: Advanced

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

This is introduction to WhereScape RED, an agile development environment – building high quality data warehouses native to SQL 2008, R2, 2012 quickly.  No other toolset can beat the productivity which results in a consistent, scalable, supportable and fully documented data warehouse.  Better than that though is engagement with business units during development, ensuring that the data warehouse development is correctly prioritized, relevant and up to date.

Douglas Barrett

Session Type:
Regular Session

Track:
2 -SQL Dev

Level: Beginner

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

You will see why you get NT Anonymous errors and learn to solve them when working with Excel Services, Reporting Services, and PerformancePoint Services when connecting to back end data sources. You will learn how to configure the Secure Store, Kerberos, the EffectiveUserName connection string, embedded credentials, RSD files and BISM files.

Carl Rabeler

Session Type:
Regular Session

Track:

Level: Advanced

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field.

Brent Ozar

Session Type:
Regular Session

Track:
5 -On/Off Prem

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just like hearing talks about data transfer performance?! Have we got the session for you! We’ll cover some common user scenarios, and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more.

Matt Masson

Session Type:
Regular Session

Track:
5 -On/Off Prem

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server.  Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.

Janis Griffin

Session Type:
Regular Session

Track:
7 -Getting it Right

Level: Beginner

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Do you have the right indexes in place to make queries run faster without dragging down write performance? In this session we will diagnose and treat the top five index disorders haunting your production databases. If you're a DBA or developer with 1 year of experience writing T-SQL queries, this session will give you the scripts and knowledge to cure your toughest indexing problems.

Kendra Little

Session Type:
Regular Session

Track:
1 -Indexes

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Your final scripts deployed to the live database a few months ago and almost everything went perfectly. Since then you have heard there were few index patches needed maybe even a new column in one or the tables. The live database has drifted just a little from your deployed SQL scripts. How would you like to update your next baseline code to already resemble the current state of the production database? This is just one of the incredible features you can do with SSDT. Take the statefull nature of your database to create and test your code automatically and declaratively. Database developers can use the SQL Server Object Explorer in VS to easily. See how the new scripting and automation tools are used in SQL 2012 with SSDT.

Rick Morelan

Session Type:
Regular Session

Track:
2 -SQL Dev

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).

MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.

DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.

Peter Myers

Session Type:
Regular Session

Track:
8 -ETL & Analysis

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

No matter how much you tune your code, if the database is slow your application will be slow. While there are as many ways to make a database faster as there are databases, there are universal principles to apply that make the performance tuning process easier. Learn how to identify indexes, understand execution plans, and configure storage.

The database the most critical piece of any environment; performance problems in the database cascade outward to effect everyone. This talk will cover tried and true techniques to ease the pain of growing a database while improving application performance from the perspective of both a large enterprise and a small business. 

Jeremiah Peschka

Session Type:
Regular Session

Track:
6 -Performance

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

In this session, attendees will be treated to an introduction to tabular mode.  Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced.  A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed.  Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.

Josh Fennessy

Session Type:
Regular Session

Track:
8 -ETL & Analysis

Level: Beginner

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Microsoft SQL Server is one of the most commonly virtualized applications in VMware environments. With the release of SQL Server 2012, Microsoft introduces full support for SMB. Now you can install SQL Server 2012 with both system and user databases on SMB file shares.  This  allow you to build end-to-end NAS solutions where the data management capabilities of NAS, such as volume auto grow and the ability to shrink NAS volumes, can be taken advantage of by the SQL Server.  This session will demonstrate how to install and run SQL Server over SMB and VMware NFS storage.  Best practices, caveats, and performance of SQL Server database over SMB and NFS will also be discussed.

Pat Sinthusan

Session Type:
Regular Session

Track:
7 -Getting it Right

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Learn how easy it is to utilize the free download from Microsoft that allows users of Excel to extract business intelligence from a variety of data sources.  This introductory session will demonstrate the power of PowerPivot in analyzing large sets of data quickly and efficiently.

David Eichner

Session Type:
Regular Session

Track:
3 -BI Treats

Level: Beginner

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps.Surprise SQL instances created by vendors without our knowledge crashing around us!It's enough to drive a lesser DBA crazy-insane.  That's why it's important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can't control.  In this session Tim will go over many of performance-enhancing methods he's developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy.

Tim Ford

Session Type:
Regular Session

Track:
6 -Performance

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

The next-generation analytic, self-service reporting tools will knock your socks off! The Power View reporting experience in SQL Server 2012 and SharePoint 2010 takes user reporting to the next level and makes data exploration fun without writing queries and code. Come see the impressive performance capabilities of BI Semantic Tabular models used with high-volume, enterprise data. Two great things that go great together!

Paul Turley

Session Type:
Regular Session

Track:
3 -BI Treats

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

Geographical Analysis is now made easy with Power View and Excel 2013. Simple yet powerful data exploration and segmentation analysis on geography can be performed, without the need of expensive hardware or software. In this session, you’ll learn how to create visually appealing and meaningful maps using Power View.

Julie Koesmarno

Session Type:
Regular Session

Track:
3 -BI Treats

Level: Beginner

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

Aaron Nelson

Session Type:
Regular Session

Track:
4 -Powershell

Level: Intermedia

Session Code:

Date: November 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Add to Schedule