sqlsathistory

Nr: 64

Back to Main list

SQLSaturday #64 - Baton Rouge 2011

Start Time (24h) Speaker Track Title
00:00:00 Wesley Brown SQL Admin I Understanding Storage Systems and SQL Server
00:00:00 Al Manint .NET II Introduction to MVC 3
00:00:00 Arnoldo Ruiz SharePoint Storage Optimization and Data Availability
00:00:00 Brian Sullivan .NET II Building a Maintainable Model w/ EF Code-First
00:00:00 Brian Rigsby .NET I Zen Coding
00:00:00 Cade Roux SQL Admin II Get a Lever and Pick Any Turtle: Lifting with Meta
00:00:00 Carlos Bossy BI Business Intelligence for Managers/Decision Makers
00:00:00 Carlos Bossy Bonus Track Tune a Star Schema for High Performance Reporting
00:00:00 Cody Gros SharePoint PowerShell Cookbook for SharePoint 2010
00:00:00 Cherie Sheriff SSIS/SSRS Auditing and SQL Forensics in SQL Server 2008 (r2)
00:00:00 Chris Koenig Windows Phone Garage Windows Phone Garage - Develop a Phone App
00:00:00 Cory Roth SharePoint Getting the most out of SharePoint Search
00:00:00 Chander Dhall .NET I MVc3 - Solid principles, IOC and ORM
00:00:00 Eric Trivette SharePoint BCS Best Practices in SharePoint 2010
00:00:00 Ira Warren SSIS/SSRS Creating a Metadata Mart w/ SSIS - Data Governance
00:00:00 Janis Griffin SQL Admin II Looney Tuner? No, there IS a method to my madness
00:00:00 Jose Chinchilla SSIS/SSRS Learning SSIS under 1 hour
00:00:00 Jose Chinchilla BI Designing and Optimizing SSAS Hierarchies
00:00:00 Jennifer McCown SQL Admin II TSQL Brush-up: The Best Things You Forgot You Knew
00:00:00 Jennifer McCown SQL Admin I Unraveling Tangled Code–Tale of Victory Over Chaos
00:00:00 John Welch SSIS/SSRS Do More (ETL) with Less (Effort) - Automating SSIS
00:00:00 John Welch BI Handling Advanced Data Warehouse Scenarios in SSIS
00:00:00 J Sawyer Bonus Track Data in the Stream: Introducing StreamInsight
00:00:00 Justin Yesso SSIS/SSRS SSRS for .Net Developers
00:00:00 Kyle Kelin .NET II Back to Basics - Threading in .NET
00:00:00 Chris Eargle .NET II Fundamental OOP with C#
00:00:00 Chris Koenig Windows Phone Garage Introduction to Windows Phone Development
00:00:00 Chris Koenig Windows Phone Garage Windows Phone Demo Walk-through
00:00:00 Mike Huguet .NET II Leveraging Open XML to Create More Dynamic Docs
00:00:00 Michael Moles Bonus Track Introduction to Agile/Scrum
00:00:00 Peter Myers SQL Admin I Developing Rich Reporting Services Visualizations
00:00:00 Peter Myers BI Introduction to Analysis Services 2008 R2 Cubes
00:00:00 Ryan Duclos Bonus Track Introduction to Windows Azure
00:00:00 Ryan Duclos Bonus Track Introduction to SQL Azure
00:00:00 Rob Vettor .NET I Must-Know Design Patterns
00:00:00 Rob Vettor .NET I EntityFramework 360: Getting Started
00:00:00 Ryan Richard .NET I Using the MVVM pattern in Silverlight and WPF
00:00:00 Sean McCown SQL Admin I Understanding Backups
00:00:00 Sean McCown SQL Admin II Beginning Powershell for DBAs 1.0
00:00:00 Latish Sehgal Bonus Track Extending Visual Studio Sql Server Mgmt. Studio
00:00:00 Steve Jones SQL Admin I The Top Ten SQL Server Skills You Need
00:00:00 Stacy Vicknair .NET II Introduction to Visual Studio LightSwitch
00:00:00 Stuart Ainsworth SQL Admin II Basic Guidelines for VLDB's
00:00:00 Kevin Boles SQL Admin I SQL Server Partitioning from A to Z
00:00:00 Kevin Boles SSIS/SSRS Advanced TSQL Solutions
00:00:00 Tim Costello BI Visualizing SQL Saturday.
00:00:00 Victor Chataboon SharePoint You want [Me] to do what?
00:00:00 William E Pearson III BI An Overview of PowerPivot
00:00:00 William E Pearson III SharePoint An Overview of PowerPivot in SharePoint
00:00:00 William Assaf SQL Admin II SQL Admin Best Practices with DMV's
00:00:00 Zain Naboulsi .NET I Advanced Visual Studio Tips and Tricks

SessionID: 28479

Understanding Storage Systems and SQL Server

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin I

Speaker: Wesley Brown

Title: Understanding Storage Systems and SQL Server

Abstract:

The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server's Disk I/O System. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations. We will cover the basics of computer systems, hard disks and disk controllers. Next, we will move to the fundamentals of RAID and how to configure your arrays for performance and reliability. Later, we will discuss the relationship between SQL Server and the file system, what is required for SQL Server and how to configure the file system for optimal performance. Finally, we will touch on how to monitor the performance and health of

SessionID: 28633

Introduction to MVC 3

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II

Speaker: Al Manint

Title: Introduction to MVC 3

Abstract:

Tired of Web Forms? Interested in why Microsoft is pushing MVC? Want to know what it stands for and why? The basics of the project type and each of the aspects are explored. Come explore a different way to write web applications in ASP.NET.

SessionID: 28870

Storage Optimization and Data Availability

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint

Speaker: Arnoldo Ruiz

Title: Storage Optimization and Data Availability

Abstract:

Optimizing storage and implementing comprehensive data protection strategies are essential for a highly performant, reliable SharePoint environment. SharePoint and SQL Server natively provide capabilities in this regard, but they prove inadequate for most organizations. In this session, we will discuss key components for a successful SharePoint backup and recovery plan, including extended and archived content. After analyzing SharePoint's native features, we will identify best practices and available solutions for ensuring a reliable, scalable SharePoint platform.

SessionID: 29099

Building a Maintainable Model w/ EF Code-First

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II

Speaker: Brian Sullivan

Title: Building a Maintainable Model w/ EF Code-First

Abstract:

The whiz-bang visual designer features of the Entity Framework demo well, and may even work for small projects, but anyone who's worked with EF knows that on larger projects, the design surface quickly becomes unusable and a bottleneck to your development process. Thankfully, the Entity Framework team has heard our anguished cries and introduced a new API for defining your EF models, dubbed "Code-First". In this presentation, Brian will guide you through building a true POCO model, basic mapping techniques, and leveraging conventions to keep your mappings DRY.

SessionID: 29285

Zen Coding

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I

Speaker: Brian Rigsby

Title: Zen Coding

Abstract:

Learn the philosophy, mindset, and attitude of a professional, principled, disciplined software developer.

SessionID: 29366

Get a Lever and Pick Any Turtle: Lifting with Meta

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin II

Speaker: Cade Roux

Title: Get a Lever and Pick Any Turtle: Lifting with Meta

Abstract:

Integrated metadata is a required element of all RDBMSs. In addition to ANSI INFORMATION_SCHEMA and metadata on implementation-specific features like indexes, SQL Server also offers a very powerful extended properties feature. In this talk, I cover using the basic metadata combined with extended properties and demonstrate practical usage to organize and document a system's design and monitor the health of a system's compliance with design rules.

SessionID: 29411

Business Intelligence for Managers/Decision Makers

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI

Speaker: Carlos Bossy

Title: Business Intelligence for Managers/Decision Makers

Abstract:

Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way your organization functions. In this non-technical session Carlos Bossy will show you what a BI project looks like and how it is different from other IT projects, how to determine the ROI of a BI project, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI Analytical Strategy and you should leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions.

SessionID: 29412

Tune a Star Schema for High Performance Reporting

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track

Speaker: Carlos Bossy

Title: Tune a Star Schema for High Performance Reporting

Abstract:

A data warehouse built using star schema dimensional models can be tuned to handle a demanding workload put on it by its users who require fast reports, dashboards, data extracts, and ad-hoc analysis. In this session Carlos Bossy will discuss the unique problems associated with star schema query performance and present strategies that will allow you to handle large query volumes in a dimensional environment. Topics covered will include clustering, indexing and partitioning, and how to treat fact tables different from dimension tables.

SessionID: 29430

PowerShell Cookbook for SharePoint 2010

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint

Speaker: Cody Gros

Title: PowerShell Cookbook for SharePoint 2010

Abstract:

This informative and demo filled session provides real world examples of using SharePoint Management Shell in SharePoint 2010. This session will demonstrate how to take full advantage of using the SharePoint Management Shell to solve common issues in SharePoint 2010. The session will be presented in a Problem/Solution/Discussion style. This is a must see session for anyone who wants to learn how to take the SharePoint Management Shell to the next level.

SessionID: 29459

Auditing and SQL Forensics in SQL Server 2008 (r2)

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS

Speaker: Cherie Sheriff

Title: Auditing and SQL Forensics in SQL Server 2008 (r2)

Abstract:

Have you ever wondered who made a change to your structures or data? Do you need to find out who has permissions to do what in your system? This session will take you on a tour of auditing for internal, SOX or HIPPA Compliance.

How much of a summary do you need? Or will this work? I will go into some data forensics as well, but to keep it within the time limit, I will structure it to structural changes, not so much the data itself, though the same techniques apply.

SessionID: 29476

Windows Phone Garage - Develop a Phone App

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Windows Phone Garage

Speaker: Chris Koenig

Title: Windows Phone Garage - Develop a Phone App

Abstract:

During this session Chris will be available to help you answer any questions that you have in developing your phone application. It is also a great time to bring in your laptop and start working on a sample phone application. Please come with the software pre-loaded to develop phone application. You can find more information at http://msdn.microsoft.com/en-us/library/ff402535(v=vs.92).aspx.

SessionID: 29611

Getting the most out of SharePoint Search

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint

Speaker: Cory Roth

Abstract:

The number one complaint about Enterprise Search is usually summed up by a statement like this: “I can’t find anything!”. Whether you are using SharePoint Foundation with Search Server Express, SharePoint Server 2010, or FAST Search for SharePoint, the quality of the results you receive from search is only as good as the input you give it. Out-of-the-box, SharePoint gives you a very functional search engine, but you need to do some work to really enable the full power it provides. This intro level talk will teach you the basics of Enterprise Search in SharePoint. Here you will learn about the basic building blocks such as content sources, crawled properties, managed properties, and scopes.

SessionID: 29659

MVc3 - Solid principles, IOC and ORM

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I

Speaker: Chander Dhall

Title: MVc3 - Solid principles, IOC and ORM

Abstract:

Come and see the important components of building an enterprise app with the current best practices on Mvc3 framework. It shows how to integrate Ioc containers, do some smart unit testing and integration testing. Use SOLID principles in practical every day development. Focus on techniques that increase productivity and reduces maintenance costs for the project down the line. And to use repository and unit of work patterns for ORMs like Nhibernate and Entity framework.

SessionID: 30093

BCS Best Practices in SharePoint 2010

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint

Speaker: Eric Trivette

Title: BCS Best Practices in SharePoint 2010

Abstract:

Business Connectivity Services (BCS), formerly Business Data Catalog, is a SharePoint 2010 service that allows developers to read and write data to and from external line-of-business (LOB) systems. In this session you will learn best practices in developing BCS solutions, including when to use BCS for your SharePoint projects, choosing the right type of BCS solution, securing your BCS solutions, and development techniques to use when creating your BCS solutions.

SessionID: 30389

Creating a Metadata Mart w/ SSIS - Data Governance

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS

Speaker: Ira Warren

Title: Creating a Metadata Mart w/ SSIS - Data Governance

Abstract:

Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture, via SSIS, that rely on a metadata mart. The end result a greatly reduced TCO(development effort) for generating the code required vs manual coding. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts.

SessionID: 30469

Looney Tuner? No, there IS a method to my madness

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin II

Speaker: Janis Griffin

Title: Looney Tuner? No, there IS a method to my madness

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

SessionID: 30631

Learning SSIS under 1 hour

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS

Speaker: Jose Chinchilla

Title: Learning SSIS under 1 hour

Abstract:

Need to know what is the corresponding SSIS transformation or task to a specific T-SQL statement? How do you accomplish Unions, Joins, and Merges in SSIS? How do you do CASE statements in SSIS? How do you group and aggregate data in SSIS? In this session I will cover the some of the most important SSIS control flow and data flow tasks to jump start DBAs and Developers into SSIS with SQL Server 2008-R2. At the end of this demo, you will be able to identify what control flow tasks and data flow transformations can be used in place of T-SQL statements and scripts. I will also cover how to accomplish in SISS: Basic SELECT, INSERT, DELETE, UPDATE statements, Inner and Outer joins, Union, Aggregates, Merge, CAST, CASE, Sorting, Grouping, etc

SessionID: 30633

Designing and Optimizing SSAS Hierarchies

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI

Speaker: Jose Chinchilla

Title: Designing and Optimizing SSAS Hierarchies

Abstract:

In this session Jose will do an overview of the different types of hierarchies and how to design user hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will learn how to implement natural unnatural hierarchies, balanced and ragged hierarchies, and Parent-Child hierarchies. Jose will show how to optimize SSAS hierarchies by specifying attribute and dimension types, member uniqueness, and aggregations. Jose will also do quick intro on querying hierarchies with MDX.

SessionID: 30705

TSQL Brush-up: The Best Things You Forgot You Knew

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin II

Speaker: Jennifer McCown

Title: TSQL Brush-up: The Best Things You Forgot You Knew

Abstract:

You’re a good SQL professional – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool, and that FOR XML isn’t as scary as it looks. And what’s more, we’ll look and BRAND-new features like SQL Server Denali’s new SEQUENCE object!

SessionID: 30706

Unraveling Tangled Code–Tale of Victory Over Chaos

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin I

Speaker: Jennifer McCown

Title: Unraveling Tangled Code–Tale of Victory Over Chaos

Abstract:

Once upon a time, you inherited an application or a database that was filled

with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible.

SessionID: 30968

Do More (ETL) with Less (Effort) - Automating SSIS

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS

Speaker: John Welch

Title: Do More (ETL) with Less (Effort) - Automating SSIS

Abstract:

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks or packages that adhere to a pattern, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.

SessionID: 30970

Handling Advanced Data Warehouse Scenarios in SSIS

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI

Speaker: John Welch

Title: Handling Advanced Data Warehouse Scenarios in SSIS

Abstract:

So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.

SessionID: 31074

Data in the Stream: Introducing StreamInsight

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track

Speaker: J Sawyer

Title: Data in the Stream: Introducing StreamInsight

Abstract:

Introduced as a part of the Sql Server 2008 R2 platform, StreamInsight is Microsoft's Complex Event Processing (CEP) engine. It allows you to analyze and process large volumes of data - think tens to hundreds of thousands of events per second - with sub-second response time. It's as close to real time as you can get without quantum entanglement! The Sql Server engine may be fast ... but it's just not that fast.

This presentation will introduce core CEP concepts and sample uses cases and then dive into kinkiness with real-time data, including hosting StreamInsight, getting data into (and out of) the engine, how time is handled, writing queries in Linq and how to extend the StreamInsight engine. It's a whole new paradigm of looking at data

SessionID: 31166

SSRS for .Net Developers

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS

Speaker: Justin Yesso

Title: SSRS for .Net Developers

Abstract:

At fist glance, SSRS can seem like an odd fit for .Net reporting. There is a little known side of SSRS that allows it to integrate seamlessly into an application's architecture. This session will introduce the concept of local mode reporting and how this feature allows direct binding to your Data Layer, Entity Model or any other type of object collection in your application.

SessionID: 31376

Back to Basics - Threading in .NET

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II

Speaker: Kyle Kelin

Title: Back to Basics - Threading in .NET

Abstract:

Multi-core processors are becoming pretty prevalent for most business user's workstations these days. This trend has increased the benefits for developer's to take advantage of multiple threads in applications. While not every application will benefit from being multi-threaded this programming tool should be in every .NET developers tool belt. Unfortunately in my experience the majority of .NET developers are not comfortable with this programming paradigm and are afraid to ask. This session dives into the basics behind threads, outlines all the different threading options in .NET, and then walks through programming examples using .NET 2.0 and 4.0.

SessionID: 31469

Fundamental OOP with C#

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II

Speaker: Chris Eargle

Title: Fundamental OOP with C#

Abstract:

Do you want to learn or have a refresher on the fundamentals of object-oriented programming and C#? This session is perfect for the DBA who must occasionally code and the developer who wants a deeper understanding of C# and OOP.

SessionID: 31782

Introduction to Windows Phone Development

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Windows Phone Garage

Speaker: Chris Koenig

Title: Introduction to Windows Phone Development

Abstract:

This session is an introduction to developing for Windows Phone 7.

SessionID: 31783

Windows Phone Demo Walk-through

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Windows Phone Garage

Speaker: Chris Koenig

Title: Windows Phone Demo Walk-through

Abstract:

During this session we will walk through some of the published sample Windows Phone 7 applications.

SessionID: 31909

Leveraging Open XML to Create More Dynamic Docs

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II

Speaker: Mike Huguet

Title: Leveraging Open XML to Create More Dynamic Docs

Abstract:

Take advantage of the Open XML format and the .NET SDK to construct and manipulate documents, allowing for simplified interactions with Office documents. This session covers the Open XML format, the Open XML SDK, and shows some examples of how to apply this in real world solutions. We’ll also discuss the role of some of the SharePoint Office Services.

SessionID: 31959

Introduction to Agile/Scrum

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track

Speaker: Michael Moles

Title: Introduction to Agile/Scrum

Abstract:

An introduction to Agile using the Scrum Process. In the past I’ve done an Agile presentation but soon learned that many people needed the basics, so I’ve created a introduction presentation. Even if you know Agile but don’t know scrum, I think you will find this presentation useful. You will learn about what a Scrum Master is vs. a Product Owner; you will understand the difference between the Team and the Stakeholders. Lots of good stuff.

SessionID: 32285

Developing Rich Reporting Services Visualizations

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin I

Speaker: Peter Myers

Title: Developing Rich Reporting Services Visualizations

Abstract:

This session explores the rich visualization capabilies of Reporting Services 2008 R2. Beyond the standard capabilities to deliver data using grid layouts (tables and matrices), Reporting Services includes Chart, Gauge, Map, Data Bars, Sparklines and Indicators visualizations.

Learn what each delivers and how to configure them to produce visually compelling reports. Furthermore, learn how the Chart is also available to developers to embed directly into .NET applications.

SessionID: 32289

Introduction to Analysis Services 2008 R2 Cubes

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI

Speaker: Peter Myers

Title: Introduction to Analysis Services 2008 R2 Cubes

Abstract:

Analysis Service’s OLAP component allows organizations to implement a cube that is designed for rapid ad hoc information retrieval of their data. The cube, as a single version of the truth, can be enriched to encapsulate business rules and calculations, and advanced Business Intelligence features including KPIs and actions.

For organizations that have a Standard or Enterprise SQL Server license, Analysis Services is a possible zero-cost opportunity for your organization today. In the session learn how to exploit the capabilities and features, and the basics of best practice design. Be prepared for numerous compelling demonstrations and to leave the session energized by the potential!

SessionID: 32471

Introduction to Windows Azure

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track

Speaker: Ryan Duclos

Title: Introduction to Windows Azure

Abstract:

During this session we'll explore an introduction to the Windows Azure platform. Covered will be basics of the developer tools, how development differs from traditional ASP.NET development. Also jump into some of the basics about the Azure Storage options (Tables, Blobs, and Queues), and briefly mention SQL Azure.

SessionID: 32472

Introduction to SQL Azure

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track

Speaker: Ryan Duclos

Title: Introduction to SQL Azure

Abstract:

SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the full relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer.

SessionID: 32598

Must-Know Design Patterns

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I

Speaker: Rob Vettor

Title: Must-Know Design Patterns

Abstract:

Design patterns are recurring solutions to software design problems you find again and again in application development. They also serve as a vocabulary for developers to communicate their ideas.

Come and walk-through 5 key patterns, with easy-to-follow examples, and a clear explanation of the how and why behind each:

• Factory • Strategy • Observer • Template Method • Decorator

You’ll walk away with an understanding of each pattern which you can take to the office the next day and implement

SessionID: 32599

EntityFramework 360: Getting Started

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I

Speaker: Rob Vettor

Title: EntityFramework 360: Getting Started

Abstract:

While most enterprise applications are object-oriented, the data upon which they depend is not. Unfortunately, binding these two platforms together can result in significant amounts of lost productivity and a less than optimal solution.

Come see how you can resolve this recurring theme with the Microsoft ADO.NET Entity Framework. In this session, we’ll…

• Explore the Entity Framework 4, its components and see how it all works • Generate a business object model with database mappings, demonstrating database-first, model-first and code-only approaches • Walk through a variety of code examples that show how to interact with the model • Show how the Entity Framework automatically tracks data changes and generates updates • Deep-dive

SessionID: 32724

Using the MVVM pattern in Silverlight and WPF

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I

Speaker: Ryan Richard

Title: Using the MVVM pattern in Silverlight and WPF

Abstract:

Silverlight and WPF are new technologies that break from the traditional Windows Forms style of programming. The MVVM (Model-View-ViewModel) pattern can be used to create a robust and testable framework for your new Windows or Web application.

SessionID: 32864

Understanding Backups

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin I

Speaker: Sean McCown

Title: Understanding Backups

Abstract:

One of the most important functions a DBA can perform is the backup. And far too many DBAs rely on the wizard to perform this task. Here I'll take you through everything you need to know about understanding command line backups, writing backup routines, and making the right decisions on how to do what kind of restore and when. I will take you through basic backup syntax and fully explain how things work the way they do and why. If you ever wanted to understand the ins and outs of SQL Server backups then this session will give you what you're after.

SessionID: 32865

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin II

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 32871

Extending Visual Studio Sql Server Mgmt. Studio

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track

Speaker: Latish Sehgal

Title: Extending Visual Studio Sql Server Mgmt. Studio

Abstract:

Are you a big fan of productivity plugins like ReSharper, CodeRush and SSMS Tools Pack? Ever wondered how you can write your own plug-ins for Visual Studio or Sql Server Management Studio? Come to this session to learn about the different ways to extend these editors. We'll see how one can create extensions, add-ins and packages and add new functionality to Visual Studio and Sql Server Management Studio.

SessionID: 32929

The Top Ten SQL Server Skills You Need

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin I

Speaker: Steve Jones

Title: The Top Ten SQL Server Skills You Need

Abstract:

Come learn the ten most important skills that every accidental DBA, developer, or even manager should be able to do in SQL server. If you want to know where to start working with SQL server or which 10 things will get you through most of your days, some see Steve Jones show you how to accomplish these ten important tasks and explain why they are important. These ten skills represent the 80/20 rule in action; if you can do these ten things, you can successfully get through most of your days at work.

SessionID: 33195

Introduction to Visual Studio LightSwitch

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II

Speaker: Stacy Vicknair

Title: Introduction to Visual Studio LightSwitch

Abstract:

Tired of access or excel "applications"? Ready to quickly replace those apps with a 3-tier solution based on best practices and the .NET platform? In this session we'll look at how Microsoft's latest Visual Studio SKU, Visual Studio LightSwitch, can help rapidly create data-driven rich Internet applications. Get rid of those legacy nightmares once and for all!

SessionID: 33255

Basic Guidelines for VLDB's

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin II

Speaker: Stuart Ainsworth

Title: Basic Guidelines for VLDB's

Abstract:

Most database professionals know (from firsthand experience) that there continues to be a "data explosion". Databases are getting larger, and working with Very Large DataBases (VLDB's) is becoming more commonplace. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of VLDB's.

Special attention will be paid to the following areas:

SessionID: 33471

SQL Server Partitioning from A to Z

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin I

Speaker: Kevin Boles

Title: SQL Server Partitioning from A to Z

Abstract:

We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.

SessionID: 33473

Advanced TSQL Solutions

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS

Speaker: Kevin Boles

Title: Advanced TSQL Solutions

Abstract:

The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.

SessionID: 33632

Visualizing SQL Saturday.

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI

Speaker: Tim Costello

Title: Visualizing SQL Saturday.

Abstract:

SessionID: 33831

You want [Me] to do what?

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint

Speaker: Victor Chataboon

Title: You want [Me] to do what?

Abstract:

Lessons for the accidental SharePoint administrator

In many environments, there's one lucky winner that becomes the SharePoint Administrator or keeper of the system. This session provides some good advice for beginning Administrators seeking to gain a better understanding on how to effectively implement SharePoint in their environment.

SessionID: 34258

An Overview of PowerPivot

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI

Speaker: William E Pearson III

Title: An Overview of PowerPivot

Abstract:

In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …”

SessionID: 34260

An Overview of PowerPivot in SharePoint

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint

Speaker: William E Pearson III

Title: An Overview of PowerPivot in SharePoint

Abstract:

Gain exposure to the Server side of PowerPivot with Microsoft BI Architect and SQL Server MVP Bill Pearson. The targeted audience of this session includes professionals who will be planning, deploying and maintaining the server side of PowerPivot. Among other BI architects and developers, this overview will be of particular interest to SharePoint Admins who are new to capabilities for sharing and managing PowerPivot applications created with PowerPivot for Excel.

SessionID: 34502

SQL Admin Best Practices with DMV's

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin II

Speaker: William Assaf

Title: SQL Admin Best Practices with DMV's

Abstract:

In this practical and script-focused session, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.

SessionID: 34524

Advanced Visual Studio Tips and Tricks

Back to calendar

Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I

Speaker: Zain Naboulsi

Title: Advanced Visual Studio Tips and Tricks

Abstract:

Created for the seasoned developer, this session explores the features that can, literally, save hours of work. Learn how to create your own templates all the way to special DevEnv switches you can use to quickly reconfigure your environment. These are the super tips that can turn a ten minute task into ten seconds.