sqlpasshistory

ID: 22

Back to Main list

24 Hours of PASS: Fall 2012

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
20-09-2012 00:00	Cindy Gross	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	What’s All the Buzz about Hadoop and Hive?
20-09-2012 00:00		24 Hours of PASS (60 minutes)	Application & Database Development	Taking SQL Server Into the Beyond Relational Realm
20-09-2012 00:00	Jen Underwood	24 Hours of PASS (60 minutes)	BI Information Delivery	Mobile Business Intelligence
20-09-2012 00:00	Kevin Cox	24 Hours of PASS (60 minutes)	Application & Database Development	What are the Largest SQL Server Projects in the World?
20-09-2012 00:00	Kevin Kline	24 Hours of PASS (60 minutes)	Professional Development	Leadership - Winning Influence in IT Teams
20-09-2012 00:00	Denny Lee	24 Hours of PASS (60 minutes)	BI Information Delivery	Introduction to Microsoft's Big Data Platform and Hadoop Primer
20-09-2012 00:00	Davide Mauri	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Agile Data Warehousing with SQL Server 2012
20-09-2012 00:00	Denny Cherry	24 Hours of PASS (60 minutes)	DBA	Using SQL Server 2012 Always On
20-09-2012 00:00	Jason Strate	24 Hours of PASS (60 minutes)	Application & Database Development	Digging Into the Plan Cache
20-09-2012 00:00	Steve Howard	24 Hours of PASS (60 minutes)	Cloud Application Development & Deployment	Best Practices and Lessons Learned Using SSIS for Large Scale Azure Data Movement
20-09-2012 00:00	Andy Warren	24 Hours of PASS (60 minutes)	Professional Development	Mentoring for Professional Development
20-09-2012 00:00	Devin Knight, Brian Knight	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Choosing the Right Reporting Platform
20-09-2012 00:00	Grant Fritchey	24 Hours of PASS (60 minutes)	Application & Database Development	Three Ways to Identify Slow Running Queries
20-09-2012 00:00	Robert Davis	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Best Practices for Upgrading to SQL Server 2012
20-09-2012 00:00	Allan Hirt, Ben DeBow	24 Hours of PASS (60 minutes)	Cloud Application Development & Deployment	SQL Server Private Cloud != Azure
20-09-2012 00:00	Allen White	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	PowerShell 101 for the SQL Server DBA
20-09-2012 00:00	Michelle Ufford	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	SSIS Design Patterns for Fun and Profit
20-09-2012 00:00	Stacia Varga	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Slow MDX Queries: The Case of the Empty Tuples
20-09-2012 00:00	Erin Stellato	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	DBCC, Statistics, and You
20-09-2012 00:00	Mark Tabladillo	24 Hours of PASS (60 minutes)	Application & Database Development	Practical Demos of Text Mining and Data Mining using SQL Server 2012
20-09-2012 00:00	Peter Myers	24 Hours of PASS (60 minutes)	Application & Database Development	Big Data Analytics with PowerPivot and Power View
20-09-2012 00:00	Rod Colledge	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	BI Architecture With SQL 2012 & SharePoint 2010

SessionID: 3739

What’s All the Buzz about Hadoop and Hive?

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Cindy Gross

Title: What’s All the Buzz about Hadoop and Hive?

Description:

Everyone is buzzing about Hive, which is trumpeting the virtues of Hadoop. But what does it mean? Why does it matter to a SQL Server and/or BI professional? Come get a taste of the Hive honey and see why this new technology is worth buzzing about!

SessionID: 3740

Taking SQL Server Into the Beyond Relational Realm

Back to calendar

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

Speaker(s):

Title: Taking SQL Server Into the Beyond Relational Realm

Description:

Many applications need to go beyond traditional relational data processes. This is done by managing unstructured data, semistructured data, or objects and incorporating services beyond the standard SQL queries such as searches and reliable messaging. This PASS Summit preview session will provide an overview of Beyond Relational capabilities in SQL Server such as Spatial and XML support, Service Broker, and unstructured data management.

SessionID: 3738

Mobile Business Intelligence

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Jen Underwood

Title: Mobile Business Intelligence

Description:

Get mobilized! Mobile business intelligence is a hot and growing market trend. Learn how to leverage Microsoft Business Intelligence technologies with a variety of mobile devices. The session will cover several mobile delivery options with a focus on browser based delivery and what can be done today with the SharePoint 2010 December 2011 CU. We will also peek at mobile BI with Excel 2013, SharePoint 2013 and Office 365. The content includes real-world implementation tips, tricks, best practices and lessons.

SessionID: 3736

What are the Largest SQL Server Projects in the World?

Back to calendar

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

Speaker(s): Kevin Cox

Title: What are the Largest SQL Server Projects in the World?

Description:

This session will cover SQL Server both on-premises and in the clouds. We will look at the top metrics for projects in several categories including BI and OLTP. Knowing the possibilities and capabilities of SQL Server is a great starting point when considering a database solution for very large and complex projects

SessionID: 3737

Leadership - Winning Influence in IT Teams

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development

Speaker(s): Kevin Kline

Title: Leadership - Winning Influence in IT Teams

Description:

It's hard to achieve notoriety among your peers and win influence with your manager without an idea of how to do it. This session will teach you the major steps it takes to achieve a position of prominence on your team. You'll also learn the most effective ways to motivate IT professionals and eight ways to achieve prominence.

SessionID: 3741

Introduction to Microsoft's Big Data Platform and Hadoop Primer

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Denny Lee

Title: Introduction to Microsoft's Big Data Platform and Hadoop Primer

Description:

In this session, Denny will describe Microsoft’s Big Data Platform vision with a primary focus on Microsoft’s Hadoop. More specifically, he will explain how and why Microsoft is betting on Hadoop. The session will provide an overview of Hadoop on Windows and Azure, as well as a primer on Hadoop.

SessionID: 3784

Agile Data Warehousing with SQL Server 2012

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Davide Mauri

Title: Agile Data Warehousing with SQL Server 2012

Description:

Now that in-memory technology is all the rage, people tell you that a Business Intelligence solution can be created just by connecting directly to the source of the data. Wrong! A data warehouse is still vital for the success of a BI solution, no matter which technology you use to read, process, and present the collected data.

This 24 Hours of PASS session will provide a glimpse into Davide’s full day pre-con at PASS Summit 2012. It will touch on the basic theory of data warehousing, well-known models and design patterns, best approaches, and the tools needed to build and maintain a data warehouse that's flexible enough to support today's fast-changing business needs.

SessionID: 3789

Using SQL Server 2012 Always On

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: DBA

Speaker(s): Denny Cherry

Title: Using SQL Server 2012 Always On

Description:

In this session we will look at the features provided by Microsoft SQL Server 2012 as part of the "Always On" option. This includes site to site configuration to facilitate a large scale high availability solution without the need for any high end SAN storage.

Additionally we will examine redundant servers which can be used for reporting or for taking your backups thereby reducing the load from the production database. We will also look a unique use case using SQL Server 2012's "Always On" feature to scale out the reads to synchronize read only copies. Learn how to set up “Always On” and how to leverage it to increase production performance by offloading reporting and backups.

SessionID: 3744

Digging Into the Plan Cache

Back to calendar

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

Speaker(s): Jason Strate

Title: Digging Into the Plan Cache

Description:

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. Through this insight, we can identify where performance issues are occurring. In this session, we'll look at some of the basics to querying the plan cache and some performance issues you can immediately begin identifying from your plan cache.

This session complements Jason’s PASS Summit spotlight session, Discovering the Plan Cache.

SessionID: 3742

Best Practices and Lessons Learned Using SSIS for Large Scale Azure Data Movement

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Steve Howard

Title: Best Practices and Lessons Learned Using SSIS for Large Scale Azure Data Movement

Description:

As people move larger and larger databases to Azure, the challenges of data movement between on-premises systems and Azure significantly increase. In this session, we will cover real life examples of large scale hybrid data movements with SSIS. We will then examine the lessons learned and developments resulting from those engagements. We will include the architecture and the approach used to move 1 TB of data from on-premises, to Windows Azure SQL Database. We will then discuss ongoing SQLCAT lab testing on moving data to Hadoop.

SessionID: 3743

Mentoring for Professional Development

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development

Speaker(s): Andy Warren

Title: Mentoring for Professional Development

Description:

This session is designed to get you thinking about mentoring as part of your professional development plan, not as a separate "bonus" activity. We'll discuss planning for time to work with your mentor, engaging your mentor in reviewing and monitoring your professional development plan, and in particular how they can help you decide how much time to spend on various aspects of your development. Then we'll flip it around and look at the ways that being a mentor can and should be part of your plan and how it will benefit you as well as your mentee. We'll also discuss some of the challenges you'll face in finding and working with a mentor/mentee and some potential solutions. By the end of the session you'll be chomping at the bit to add a mentor to your plan!

SessionID: 3715

Choosing the Right Reporting Platform

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Devin Knight, Brian Knight

Title: Choosing the Right Reporting Platform

Description:

The decision on which of the Microsoft BI reporting tools to use for can be daunting. Choosing the right one early on can save you months off your projects schedule; choosing the wrong one and your project may never finish! In this session, we will cover when to use PerformancePoint, Reporting Services, Power View, PowerPivot or Excel Services and where is their grey area. Brian and Devin will also show the tools in action.

SessionID: 3716

Three Ways to Identify Slow Running Queries

Back to calendar

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

Speaker(s): Grant Fritchey

Title: Three Ways to Identify Slow Running Queries

Description:

Tuning the performance of your queries in SQL Server can be a lot of work. But, in order for your systems to receive the full benefits of query tuning, you need to tune the queries that need it the most. This session will show you three different methods for determining which of the queries on your system are being called the most frequently, take the longest period of time to run, or are using the most resources. You'll be able to use the information in this session to quickly set up your own metrics gathering processes in order to understand what is happening on your systems and which queries will benefit most from tuning. The information presented is a sub-set of a much larger set of information that will be made available to you during my PASS Summit 2012 pre-conference seminar, Query Performance Tuning: Start.

SessionID: 3714

Best Practices for Upgrading to SQL Server 2012

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Robert Davis

Title: Best Practices for Upgrading to SQL Server 2012

Description:

This introduction to best practices will cover the best practices that you need to know to plan, prepare for, and upgrade to SQL Server 2012. It will also cover which best practices may need to be reevaluated as a result of moving to SQL Server 2012. This session will provide a snapshot of how to analyze your existing environment for possible breaking changes, how to migrate a production system while protecting data and minimizing downtime, and how to be prepared in case the upgrade is not a smashing success.

SessionID: 3710

SQL Server Private Cloud != Azure

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Allan Hirt, Ben DeBow

Title: SQL Server Private Cloud != Azure

Description:

Many of us roll our eyes at the mention of the word “cloud” since it is used so much these days from private computing at home all the way to the largest enterprises. In the SQL Server world, it’s most commonly associated with Microsoft’s Azure – but that’s not the only application for the term cloud when it comes to databases. Like virtualization a few years back, the cloud hasn’t completely permeated the database world just yet, but it will be something all DBAs need to be comfortable with down the road. This session will lay a foundation of what the cloud, and specifically, the private cloud means for SQL Server DBAs. So get a jump start on tomorrow by attending this today.

SessionID: 3713

PowerShell 101 for the SQL Server DBA

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Allen White

Title: PowerShell 101 for the SQL Server DBA

Description:

The more you have to manage, the more likely you'll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. But it's more than just a scripting language - it's an interactive shell that stores data for you and allows you to implement ad-hoc solutions quickly and easily. Within the PowerShell environment you can easily manage both SQL Server instances and the Windows servers themselves, giving you a 'best of both worlds' environment that puts you in control. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances.

SessionID: 3718

SSIS Design Patterns for Fun and Profit

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Michelle Ufford

Title: SSIS Design Patterns for Fun and Profit

Description:

As a preview of the PASS Summit 2012 pre-conference session "SSIS Design Patterns" by Andy Leonard, Matt Masson, Tim Mitchell, Michelle Ufford, and Jessica Moss, Michelle and Jessica will present design patterns to assist in the day-to-day day activities of SSIS 2012 development. Learn how best to set up a template package, to utilize the framework for your SSIS development, to review the metadata of executions, and more. This online session will provide you information you can use today as well as provide a preview of the types of things you can learn in this fall's pre-conference session.

SessionID: 3723

Slow MDX Queries: The Case of the Empty Tuples

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Stacia Varga

Title: Slow MDX Queries: The Case of the Empty Tuples

Description:

At the PASS Summit, Stacia will delve into the Secrets of SSAS Storage and will discuss how the Analysis Services storage engine affects MDX query performance, among other storage-related topics. However, the formula engine can have an impact on query performance too, so join Stacia in this 24Hours of PASS session to get an additional perspective for improving the overall performance of your Analysis Services implementation. In this session, Stacia will demonstrate how you can tell which engine is causing the bottleneck in a slow query. In particular, this session will focus on the problems that empty tuples can add to query performance, and demonstrate strategies for removing empty tuples from the calculation space.

SessionID: 3735

DBCC, Statistics, and You

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Erin Stellato

Title: DBCC, Statistics, and You

Description:

Whether you are a DBA or a developer, it is important to understand statistics and their application. It is equally important to understand the various DBCC statements at your disposal and their impact. This session will review two commands: DBCC SHOW_STATISTICS and DBCC CHECKDB. With SHOW_STATISTICS we will cover the basics of statistics and how they are used by the Query Optimizer. We will then explore CHECKDB to understand what it means to verify integrity, how that affects performance, and what users can do when corruption exists

SessionID: 3722

Practical Demos of Text Mining and Data Mining using SQL Server 2012

Back to calendar

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

Speaker(s): Mark Tabladillo

Title: Practical Demos of Text Mining and Data Mining using SQL Server 2012

Description:

SQL Server 2012 provides enterprise-level tools for advanced analytics. Microsoft was the first vendor to put analytics at the database, and this release continues Microsoft's analytics leadership. This presentation includes practical demos of text mining and data mining, a sampler from two separate longer sessions to be presented at PASS Summit. This online presentation has complete examples, but only the later (and longer) PASS Summit sessions will have more complete explanations.

SessionID: 3720

Big Data Analytics with PowerPivot and Power View

Back to calendar

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

Speaker(s): Peter Myers

Title: Big Data Analytics with PowerPivot and Power View

Description:

Join Peter Myers as he presents big data analytics for the business analyst with PowerPivot and Power View. This presentation will be of interest to those new to the concept of big data, new to self-service data modelling with PowerPivot, and those interested to understand what is new for PowerPivot and Power View in the upcoming release of Office and SharePoint.

Demonstrations will include creating a big data solution by using Apache Hadoop-based Services for Windows Azure; producing a PowerPivot model based on the big data solution; using PowerPivot to integrate big data with on-premise data; and, analyzing the PowerPivot model data by using Power View.

SessionID: 3721

BI Architecture With SQL 2012 & SharePoint 2010

Back to calendar

Event Date: 20-09-2012 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Rod Colledge

Title: BI Architecture With SQL 2012 & SharePoint 2010

Description:

This session will cover new BI features in SQL Server 2012 including Power View, PowerPivot, Report Alerts and SSRS Integration with SharePoint Server 2010. It will then focus on the importance of Self-Service BI and how it fits into an overall enterprise Business Intelligence architecture. This session will be rich with demos of all the new BI tools and the use of PerformancePoint Services to create Business Intelligence Dashboards. Attend and discover the awesome power of the latest release of the Microsoft BI Platform.