sqlpasshistory

ID: 28

24 Hours of PASS: Summit Preview 2013

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
31-07-2013 05:00	Bradley Ball	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Data Internals
31-07-2013 12:00	Brent Ozar	24 Hours of PASS (60 minutes)	Application & Database Development	Practical Performance Troubleshooting
31-07-2013 13:00	Allan Hirt	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	The Cluster Conundrum
31-07-2013 14:00	Kevin Kline	24 Hours of PASS (60 minutes)	Application & Database Development	Hands-on Fundamentals for Good SQL Server Programming
31-07-2013 15:00	Tim Ford	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Periodic Table of DMVs: Part 2012: The SQL
31-07-2013 16:00	Ewan Fairweather, Silvano Coriani	24 Hours of PASS (60 minutes)	Cloud Application Development & Deployment	SQLCAT: Windows Azure Data Platform
31-07-2013 17:00	Grant Fritchey	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Be a Successful DBA in the World of Cloud and On-Premise Data
31-07-2013 18:00	Jason Thomas	24 Hours of PASS (60 minutes)	BI Information Delivery	Geospatial Analytics Using Microsoft BI
31-07-2013 19:00	Christina Leo	24 Hours of PASS (60 minutes)	Application & Database Development	Building Your T-SQL Tool Kit: Window Function Fundamentals
31-07-2013 20:00	Susan O'Connell	24 Hours of PASS (60 minutes)	BI Information Delivery	PowerPivot Data Modeling Techniques
31-07-2013 21:00	Brian Knight	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	0 to MOLAP in 60 Minutes
31-07-2013 22:00	Bradley Ball	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Data Internals
31-07-2013 23:00	Karen Lopez	24 Hours of PASS (60 minutes)	Cloud Application Development & Deployment	Windows Azure SQL Database Design: Silver Lining and Dark Side
01-08-2013 00:00	Thomas LeBlanc	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Slicing and Dicing: Attributes and Hierarchies in SSAS 2012
01-08-2013 01:00	Stacia Varga	24 Hours of PASS (60 minutes)	BI Information Delivery	From Reporting Services Rookie to Rockstar
01-08-2013 02:00	James Serra	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Building an Effective Data Warehouse Architecture
01-08-2013 03:00	Ryan Adams	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	How Active Directory Affects SQL Server
01-08-2013 04:00	Kendal Van Dyke	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Discover, Document, and Diagnose Your Servers on Your Coffee Break
01-08-2013 05:00	Louis Davidson	24 Hours of PASS (60 minutes)	Application & Database Development	How to Design a Relational Database
01-08-2013 06:00	Denny Cherry	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Storage and Virtualization for DBAs
01-08-2013 07:00	Josh Fennessy	24 Hours of PASS (60 minutes)	BI Information Delivery	Delivering Analytics with Excel 2013: 10 Secrets for Success
01-08-2013 08:00	Jen Stirrup	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Big Data Visualization for Business Intelligence Professionals
01-08-2013 09:00	Audrey Hammonds	24 Hours of PASS (60 minutes)	Application & Database Development	Design Matters! The Performance Impact of Database Design
01-08-2013 10:00	Joseph D'Antoni	24 Hours of PASS (60 minutes)	Cloud Application Development & Deployment	Into the Blue: Extending AlwaysOn Availability Groups
01-08-2013 11:00	Glenn Berry	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Scaling SQL Server 2012

SessionID: 5404

Data Internals

Back to calendar

Event Date: 31-07-2013 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Bradley Ball

Title: Data Internals

Description:

Often as DBAs, we learn backwards. You get a DBA job, and you have databases that have tables, which have data in them. Nobody tells you that there are records, stored on pages, grouped in extents, assigned by allocation bitmaps, with IAM pages and allocation units that span partitions and filegroups.

Today is your lucky day! This 24 Hours of PASS session will cover byte swapping and bitmaps and dive a little into decoding Hex and binary, working to give you an understanding of database internals and how you use them every day!

SessionID: 5262

Practical Performance Troubleshooting

Back to calendar

Event Date: 31-07-2013 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Brent Ozar

Title: Practical Performance Troubleshooting

Description:

You’re a developer or DBA stuck with a database server that's not going fast enough. You've got a hunch that the biggest bottleneck is inside the database server somewhere, but where? In this 24 Hours of PASS session, you'll learn how to use a powerful script to identify what your SQL Server is waiting on, and then you can focus on the queries (or settings) that are holding you back.

You'll learn: • What SQL Server waits on when it's executing queries • How to query DMVs to identify your server's bottlenecks • How to identify the most common wait types and their causes

SessionID: 5263

The Cluster Conundrum

Back to calendar

Event Date: 31-07-2013 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Allan Hirt

Title: The Cluster Conundrum

Description:

Clustered SQL Server installations are everywhere, yet there is a general lack of understanding around why you would want to use one, where you may need one, and how clusters fit into the overall availability picture for your instances and databases. This 24 Hours of PASS session will cover the ABCs of clustering and dispel some myths that relate to clustered SQL Server implementations.

SessionID: 5264

Hands-on Fundamentals for Good SQL Server Programming

Back to calendar

Event Date: 31-07-2013 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Kevin Kline

Title: Hands-on Fundamentals for Good SQL Server Programming

Description:

You’ve figured out how to write queries to read data, transactions to write and modify data, and Transact-SQL to bring programmability to your code. However, you’ve never taken your code beyond “It works. Put it in production!” This 24 Hours of PASS session will teach you the fundamentals of writing quality SQL and T-SQL code, code testing, and performance assessment. You’ll learn how to isolate your SQL code with a test harness, evaluate alternative approaches, and determine which version is optimal for your your workload. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries from adequate to outstanding.

SessionID: 5266

Periodic Table of DMVs: Part 2012: The SQL

Back to calendar

Event Date: 31-07-2013 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Tim Ford

Title: Periodic Table of DMVs: Part 2012: The SQL

Description:

SQL Server 2012 exposes a host of new dynamic management objects. Attend this 24 Hours of PASS session to navigate Tim Ford’s updated DMO Periodic Table and examine new and updated DMOs for gaining a better understanding of what’s happening under the covers in your servers.

You’ll see how to baseline performance, identify activity, plan SQL Server migrations and consolidations, and performance-tune your instances using an assortment of DMOs and SQL Server system views. You'll leave this session with a clear understanding of how the DMOs are organized and how you can use them to make your life easier...at least as it pertains to SQL Server.

SessionID: 5267

SQLCAT: Windows Azure Data Platform

Back to calendar

Event Date: 31-07-2013 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Ewan Fairweather, Silvano Coriani

Title: SQLCAT: Windows Azure Data Platform

Description:

Want to learn architectural and implementation best practices directly from those building some of the largest, real-world distributed Windows Azure Data Platform systems? Presented by members of the SQL Server Customer Advisory Team (SQLCAT) and the Data Platform Azure Product Team, this 24 Hours of PASS session will cover key use cases, including migration of traditional applications to the cloud, as well as more modern, greenfield application scenarios and solutions with a specific focus on data platform technologies.

These experiences and lessons learned have been acquired through working with the most complex customer projects to date. We'll also share best practices that you can immediately apply in designing Azure Data Platform solutions of every scale. This session will give you a flavor of what customers are doing today and a taste of the full-day pre-conference session at PASS Summit.

SessionID: 5268

Be a Successful DBA in the World of Cloud and On-Premise Data

Back to calendar

Event Date: 31-07-2013 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Grant Fritchey

Title: Be a Successful DBA in the World of Cloud and On-Premise Data

Description:

In the world of hybrid IT, with data residing on-premise and in the cloud, DBAs play an important role in application architecture and design. In this 24 Hours of PASS session, we’ll touch on the changing DBA tasks to support on-premise and cloud-based performance tuning and monitoring, as well as how to implement high availability and disaster recovery solutions.

You’ll take away practical knowledge, scripts, and a clear understanding that will enable you to leverage tools available in the cloud and on-premise.

SessionID: 5269

Geospatial Analytics Using Microsoft BI

Back to calendar

Event Date: 31-07-2013 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Jason Thomas

Title: Geospatial Analytics Using Microsoft BI

Description:

In this age of Big Data, location matters more than many people imagine. Almost every set of data has some geographic information tied to it, and it’s all the more pertinent to understand and unravel the patterns and trends behind that data.

This 24 Hours of PASS session will explain why geospatial analytics is important in today's world and then continue by exploring how we can share, analyze, and visualize data using the comprehensive Microsoft BI toolset, including Power View, GeoFlow, SQL Server Reporting Services, and more. The session will feature practical demos for each of these tools, during which we’ll work on some publicly available data sets to uncover some interesting facts.

SessionID: 5270

Building Your T-SQL Tool Kit: Window Function Fundamentals

Back to calendar

Event Date: 31-07-2013 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Christina Leo

Title: Building Your T-SQL Tool Kit: Window Function Fundamentals

Description:

Have you pulled a script to identify duplicates from a blog post but couldn’t quite get it to work because you weren’t sure what that ROW_NUMBER() function was doing? Maybe you heard talk about creating running totals without using subqueries, but you got frustrated when the groups weren’t totaling correctly. Or perhaps you’ve never even heard of window functions.

All are good reasons to attend this all-demo 24 Hours of PASS session, which will demystify this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations.

SessionID: 5271

PowerPivot Data Modeling Techniques

Back to calendar

Event Date: 31-07-2013 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Susan O'Connell

Title: PowerPivot Data Modeling Techniques

Description:

SessionID: 5272

0 to MOLAP in 60 Minutes

Back to calendar

Event Date: 31-07-2013 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Brian Knight

Title: 0 to MOLAP in 60 Minutes

Description:

This 24 Hours of PASS session will help you get started with SQL Server Analysis Service (SSAS) by learning about the SSAS architecture and how to create a cube. Attend and learn how to build a highly efficient analytical platform by using SSAS. You’ll also learn how to create and configure a cube to pre-aggregate your data and then how to create hierarchies to make cubes easier for users to navigate. Finally, we'll cover the basic tabs that are available to you in SSAS.

SessionID: 5273

Data Internals

Back to calendar

Event Date: 31-07-2013 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Bradley Ball

Title: Data Internals

Description:

Often as DBAs, we learn backwards. You get a DBA job, and you have databases that have tables, which have data in them. Nobody tells you that there are records, stored on pages, grouped in extents, assigned by allocation bitmaps, with IAM pages and allocation units that span partitions and filegroups.

SessionID: 5274

Windows Azure SQL Database Design: Silver Lining and Dark Side

Back to calendar

Event Date: 31-07-2013 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Karen Lopez

Title: Windows Azure SQL Database Design: Silver Lining and Dark Side

Description:

Data modelers and designers need to understand the technical differences in designing for Windows Azure SQL Databases (WASDs) and traditional on-premise SQL Server databases. In this 24 Hours of PASS session, we'll review the concepts that still work in both and the features that need to be tailored to each target environment.

You’ll see demonstrations of the database design processes and gain best practices for model-driven development for each environment, including tool support. We’ll finish up with five tips for designing databases for both WASD and SQL Server.

SessionID: 5275

Slicing and Dicing: Attributes and Hierarchies in SSAS 2012

Back to calendar

Event Date: 01-08-2013 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Thomas LeBlanc

Title: Slicing and Dicing: Attributes and Hierarchies in SSAS 2012

Description:

This 24 Hours of PASS session will explain how to use attributes and hierarchies in the SQL Server Analysis Services (SSAS) 2012 Semantic Model to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves rows and columns. In SQL Server's Semantic model, these are called attributes and hierarchies, and how you configure them in SSAS is important.

This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension, as well as their configuration for best performance and viewing.

SessionID: 5258

From Reporting Services Rookie to Rockstar

Back to calendar

Event Date: 01-08-2013 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Stacia Varga

Title: From Reporting Services Rookie to Rockstar

Description:

This 24 Hours of PASS session provides an introduction to Reporting Services for report developers who have no prior experience with the product by explaining how to use the development tools effectively, how to present and enhance data in a report, and how to create dynamic reports. This session provides an overview of the content that will be presented as a full-day pre-conference session at PASS Summit 2013. This introduction will describe the key factors in the report development process, explain the Reporting Services the architecture, and introduce the key components you use to manage a report project. We'll also review the types of reports that will be demonstrated at PASS Summit, giving you the techniques you'll learn by attending.

SessionID: 5276

Building an Effective Data Warehouse Architecture

Back to calendar

Event Date: 01-08-2013 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): James Serra

Title: Building an Effective Data Warehouse Architecture

Description:

You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model in SQL Server 2012 change things? What’s the difference between a data warehouse and a data mart anyway? Is there any hardware I can purchase that is optimized for a data warehouse? What if I have a ton of data?

Join this 24 Hours of PASS session for the answers to these questions. You’ll leave with information that will impress your boss and lead to a big raise – or at least lead you down the correct path to adding business value to your organization.

SessionID: 5277

How Active Directory Affects SQL Server

Back to calendar

Event Date: 01-08-2013 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Ryan Adams

Title: How Active Directory Affects SQL Server

Description:

If you’ve ever had a Kerberos or SSPI context error, you won't want to miss this session. SQL Server has a large surface area, and Active Directory can influence a big part of it. This session will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session, you'll have a checklist of things to discuss with your domain administrator when you return to work.

SessionID: 5278

Discover, Document, and Diagnose Your Servers on Your Coffee Break

Back to calendar

Event Date: 01-08-2013 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Kendal Van Dyke

Title: Discover, Document, and Diagnose Your Servers on Your Coffee Break

Description:

Documentation is the bane of every DBA's existence. We know we should do it, but it's time-consuming; by the time you're finally done, it's probably out of date. Throw in the new servers you just found out about last week, and keeping documentation up-to-date can turn into a full-time job.

You need to work smarter, not harder, and automate your documentation. In this 24 Hours of PASS session, you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches – all while on your coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.

SessionID: 5279

How to Design a Relational Database

Back to calendar

Event Date: 01-08-2013 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Louis Davidson

Title: How to Design a Relational Database

Description:

Database design is a seemingly natural process, lending everyone to try to do it themselves, from an administrative assistant with a spreadsheet to a C# programmer with a copy of SQL Server Express. Unfortunately, the finer points of excellent database design are not intuitively obvious, and the difference between building a spreadsheet and a solid enterprise database is like the difference between building a doghouse and a two-story house, or even the Empire State Building.

In this 24 Hours of PASS session, we will look at some of the concepts and practices that go into designing a great database, using a mix of light theory and practical examples to help to make it clear that building a relational database is neither simple nor difficult once you understand the fundamentals.

SessionID: 5280

Storage and Virtualization for DBAs

Back to calendar

Event Date: 01-08-2013 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Denny Cherry

Title: Storage and Virtualization for DBAs

Description:

One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this 24 Hours of PASS session, we’ll look at storage from both the database and storage perspectives, digging into LUNs, HBAs, the fabric, and RAID Groups.

SessionID: 5281

Delivering Analytics with Excel 2013: 10 Secrets for Success

Back to calendar

Event Date: 01-08-2013 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Josh Fennessy

Title: Delivering Analytics with Excel 2013: 10 Secrets for Success

Description:

Long gone are the days of basic table functionality in Excel. The newest version, Excel 2013, includes many features that enable business analysts to create rich interactive reporting. Join this 24 Hours of PASS session to learn the secrets of creating Excel reports that will captivate report consumers.

Among the many insider tips, we’ll see how Pivot Tables – known and loved by many – have been enhanced with visual tools to enable rich reporting capabilities and additional reporting functionality to allow for augmented design possibilities. In addition, expert analysts will be keen to learn about new Excel functions that allow for direct querying of Analysis Services databases, allowing for custom reporting options previously unheard of in tools like Excel.

SessionID: 5282

Big Data Visualization for Business Intelligence Professionals

Back to calendar

Event Date: 01-08-2013 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Jen Stirrup

Title: Big Data Visualization for Business Intelligence Professionals

Description:

What does Big Data mean for the Business Intelligence professional? Microsoft has partnered with HortonWorks to bring Big Data into the hands of business users via their favorite BI tools: Power View, PowerPivot, and Excel.

After the Big Bang explosion of data, how are you going to serve it to business users to derive value for the enterprise? Data, regardless of its size, is only valuable if it is understood. In this 24 Hour of PASS session, we’ll visualize Big Data in our favorite BI tools: Excel, PowerPivot, and Power View. Join us to see where the Microsoft Big Data offering differs from more familiar data visualization methods from Microsoft and learn how it is applicable to your enterprise.

SessionID: 5283

Design Matters! The Performance Impact of Database Design

Back to calendar

Event Date: 01-08-2013 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Audrey Hammonds

Title: Design Matters! The Performance Impact of Database Design

Description:

Time-travel stories all have one common plot element: some action done in the past has a big impact on the future. Sometimes you get lucky...hoverboards! Sometimes, not so much...Morlocks! The same holds true in your application. Design decisions have a huge impact on how you’re going to get data into and out of your database. This 24 Hours of PASS session will illustrate the impact of database design on query performance and why thinking about performance during design time will help your database avoid an H.G. Wellsian future. Come learn a little database design, how to read an execution plan, and some unintended consequences of less-than-optimal design decisions.

SessionID: 5284

Into the Blue: Extending AlwaysOn Availability Groups

Back to calendar

Event Date: 01-08-2013 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Joseph D'Antoni

Title: Into the Blue: Extending AlwaysOn Availability Groups

Description:

For many organizations, having a second data center or co-location center doesn’t make sense, financially or logistically. Typically, this would limit options for building out a disaster recovery (DR) solution. However, now with Windows Azure virtual machines and SQL Server AlwaysOn Availability Groups, you can connect your on-premise solution to a real-time secondary replica, providing read scalability and a solid DR solution.

This 24 Hours of PASS session will provide a discussion of the infrastructure requirements and gotchas involved in implementing a hybrid solution between your data center and Azure.

SessionID: 5285

Scaling SQL Server 2012

Back to calendar

Event Date: 01-08-2013 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Glenn Berry

Title: Scaling SQL Server 2012

Description:

SQL Server implementations can rapidly evolve and become more complex, forcing DBAs and developers to think about how they can scale their solution quickly and effectively. Scaling up is relatively easy but can be expensive, while scaling out requires significant engineering time and effort. As your database server nears its load capacity, what can you do?

This 24 Hours of PASS session, a preview of the full-day PASS Summit pre-conference session, will give you concrete, practical advice about how to scale SQL Server. We’ll explore how to find and alleviate bottlenecks and cover how you can decide whether you should scale up or scale out your data tier. We’ll also cover how to use middle-tier caching and other application techniques to increase your overall scalability.