PHOTO CREDIT: Pat Wright

 

 

PASS Summit 2011 Sessions

You can browse all sessions or use filters to search for sessions you are interested in. The Keyword filter lets you enter a term to search for in the session title or abstract. The Category drop-down lets you set the session type (such as Regular session), and the Track drop-down lets you specify which topic track you want to search. You can also filter by speaker name and session skill level. To start a new search or return to the list of all sessions, simply click the Clear button.
Keyword:
Category:
Track:
Speaker:
Level:
Page:  of 3  |   [NEXT]
Sessions Found: 28
.NET scripting for SQL Server BI and T-SQL scripts [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Alex Grinberg
SQL Server 2005 has brought the new era for SQL Server DBAs. Today's activities require additional knowledge in different areas, which were secondary before SS 2005, such as .NET, XML, classes, dll libraries, name of few. In this session I will demonstrate how to utilize .NET code with SSIS, SSRS and T-SQL script (include CLR integration). Explain how important it is for DBA to know at least basic .NET development techniques, describe what is Namespaces in .NET. Real code examples give a starting point to beginners in .NET (or DBAs who never use .NET before) and additional way to utilize .NET for those who have experience in this technology. Also I'll include T-SQL techniques, how to create small "consol application" entirely from within T-SQL.

Avoiding Cursors, While Loops, and other forms of RBAR [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Jeff Moden
If you’re new to T-SQL, don’t let the “400” rating of this session scare you away. This heavily code-based "Developer-to-Developer" session starts at the ground floor of "Set-Based" programming and quickly ramps up through a wide array of lightning fast code examples to please your “need for speed”.

Here are some of the highlights that will be taught and demonstrated in this extended T-SQL "Black Arts" session:

1. What is "RBAR" and "Hidden RBAR"?
2. Make the Paradigm Shift to Set-Based Programming using “Pseudo Cursors”.
3. Introduction to the “Tally Table” and the Incredible Power of the Cross Join.
4. The “No Reads” Tally CTE Explained.
5. Generating Random Numbers, Dates, and Data.
6. Building the “Million Row Test Table” in less than a minute.
7. Some uses of the “Tally Table” including a new CSV splitter that almost keeps up with CLR’s.
8. Concatenation and “Impossible” Comparisons.
9. Converting Rows to Columns: The “back-bone” of high performance reporting.
10. Converting Columns to Rows: Normalization of unknown numbers of columns and tabular data.
11. Grouping the Un-Groupable.
12. Solving the “Running Total” and other “Previous Row” problems.
13. A High Performance Method for Converting Adjacency Lists to Nested Sets.
14. Pre-aggregating the “Million Row Hierarchy” in About a Minute.

To support the highlights being taught above, a large number of various "Tip'n'Tricks" will be explained throughout this session, as well.


Become a PowerShell Rockstar While Still Hating the SMO [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Aaron Nelson
Checking database space, last backup date, table sizes and server/database configuration settings is great. But how do you not run out of memory when you have 400 instances to check? We will explore deploying new users, groups, tables and columns. We’ll build on these multi-server tasks and automate with SQL Agent, some with SQLPSX, some with PowerShell 2.0. We’ll then turn these into nice looking reports to monitor your environment.

We’ll dive into advanced topics like gathering Performance Counters from multiple servers, detecting worst performing queries, scripting out and comparing databases, importing data from websites, atom feeds, and spreadsheets. We’ll also cover parameter binding, splatting, remote jobs, remote installs, and SQLPSX in depth to maximize functionality and keep you productive. We’ll wrap things up with some language nuances that will help you avoid getting bogged down.
This is a hands-on workshop, bring a laptop if you can.


Database Design Patterns In Practice [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Louis Davidson
In this ½ day session, we will look at some of the patterns of applying the tools that SQL Server provides to build rich database solutions. The first part of the session will be a review of the types of constraints, triggers, and other coded objects that SQL Server provides us to do development, including some examples of their usage. From there, we will look at applications of these objects, working through solutions together on the projector or white board. Some of the topics we will cover will include: methods of implementating uniqueness (and the practicality thereof), cardinality enforcement, cascading operations (insert, update, and delete), complex data validations, and more. The attendee will be challenged to be involved with the process as much as possible to create small model sections that work and can be loaded with data.

Implementing Partitioning Strategies in SQL Server [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Julie Koesmarno, Victor Isakov
When designing a modern database solution you should be concerned about the volume of data that can potentially be saved within your database in your future! It will directly impact the performance and various operational tasks such as index rebuilds, backups a archiving. Partitioning represents a key part of your database solution that addresses these concerns. Did we forget to add that it should be considered during the initial design phase and not after you have deployed into production...
In this session Julie Koesmarno (MCITP) and Victor Isakov (MCA, MCM, MCT, MVP) will cover all of the different partitioning techniques and strategies that can be implemented in SQL Server. From table/index partitioning and partitioned views to federated partitioned views and sharding, Julie and Victor will give a comprehensive analysis of what can be done in SQL Server, how these different techniques actually work in the field, and what to watch out for when partitioning your data in SQL Server.


The Other Side of the Fence: Lessons Learned from Leaving Home [200]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Jeremiah Peschka
Traveling the world changes your outlook on things, home just doesn't look quite the same once you've traveled. The same can be said for SQL Server; working with databases like PostgreSQL, Cassandra, and Hadoop forced Jeremiah Peschka to re-learn concepts that he took as a given. Learn from his experiences about the importance of understanding isolation levels, data storage and retention, querying patterns, and even database functionality in this talk drawn from his experiences as a DBA, consultant, and developer.

The Ultimate Session on Indexing [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Victor Isakov
You can have the best hardware possible: SSDs, TBs of RAM and 100s of processors. (Don't we all wish we had such budgets.) But if you don't have the correct indexing strategy in place your database can still perform poorly. With the next version of SQL Server there are even more options available. Confused about what indexing strategy to use? Then this is the session for you!
In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover all of the indexing options that are available in SQL Server and when best to use them. Victor will cover "practical" internals that will help you understand how indexes work and why you need to maintain them. Finally he will cover what indexing strategies to use given the most important considerations: your users, their query patterns and your data.
This should prove to be a most informative and practical session that will enable you to optimize your database performance.


The Ultimate Session on Indexing [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Victor Isakov
You can have the best hardware possible: SSDs, TBs of RAM and 100s of processors. (Don't we all wish we had such budgets.) But if you don't have the correct indexing strategy in place your database can still perform poorly. With SQL Server 11 there are even more options available. Confused about what indexing strategy to use? Then this is the session for you!
In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover all of the indexing options that are available in SQL Server and when best to use them. Victor will cover "practical" internals that will help you understand how indexes work and why you need to maintain them. Finally he will cover what indexing strategies to use given the most important considerations: your users, their query patterns and your data.
This should prove to be a most informative and practical session that will enable you to optimize your database performance.


Using SQLCLR & Service Broker to Create a Scalable Application Server [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Davide Mauri
Creating scalable application means, sooner or later, that you have to implement a parallel and asynchronous architecture in your application. Without this approach, and application cannot really scale-out effectively.
During the past years, SQL Server has become more than a Relational Database Management System and inside its engine lies a complete infrastructure that allows us to leverage parallelism and asynchronous calls with the minimum effort possible. SQL CLR and Service Broker are the names of the technologies that can help us to create a scale-out solution for our application. In this session, where're going to take and existing solution and change it so that we can distribute complex operations over a number of "compute nodes" that will allow to have a scalable solution able to satisfy and present or future performance requirement. Even more interesting we're going to use SQL Express and commodity hardware to do such scale out, effectively maximizing compute power and minimizing the costs.

In this session you'll get the architectural vision of how to build such scale out solution and immediately after you'll see the code needed to implement it with your own eyes, understanding all the steps you have to follow to setup a Service Broker solution, to load and use .NET inside SQL Server and to do load balancing between the compute nodes we're going to create. If you have to improve the performance of your solution so that you can process 10 million complex invoices instead of 10 thousand and you cannot scale-up, this session is for you!


Analysis Services the Right Way [200]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Craig Utley
This session offers an in-depth look at each step of the process in creating an SSAS solution using best practices. You'll learn why best practices exist, and the trade-offs you make at each step. You'll see the proper way to create dimensions, learn how and why cube partitions should be used, a road map for good aggregation design, a discussion about cube security, and much more. Craig Utley has been working with the Microsoft BI stack since the betas of SQL Server 7.0 and is a former Program Manager with the Microsoft SQL Server Customer Advisory Team (SQLCAT), where he worked with some of the world’s largest SQL Server data warehouses. He has seen warehouses at over fifty companies worldwide and draws on that experience to give you a no-nonsense approach to building an SSAS solution.


Page:  of 3  |   [NEXT]

 

 
 

Why Attend?


■ All SQL Server. All the time

■ Over 170 technical sessions

■ Dr. David DeWitt Keynote

■ 2 days of Pre-Con Seminars

■ Networking with MVPs, experts, and peers

■ Face-to-face support with     Microsoft CSS and SQLCAT

■ Ask the Experts Pods
 

 
 
 

 

 

 


Premier Sponsor

 

Platinum Sponsor