Nr: 64
SQLSaturday #64 - Baton Rouge 2011
SessionID: 28479
Understanding Storage Systems and SQL Server
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:
SessionID: 28633
Introduction to MVC 3
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II
Speaker: Al Manint
Title: Introduction to MVC 3
Abstract:
SessionID: 28870
Storage Optimization and Data Availability
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
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
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin II
Speaker: Cade Roux
Abstract:
SessionID: 29411
Business Intelligence for Managers/Decision Makers
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Carlos Bossy
Abstract:
SessionID: 29430
PowerShell Cookbook for SharePoint 2010
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint
Speaker: Cody Gros
Title: PowerShell Cookbook for SharePoint 2010
Abstract:
SessionID: 29459
Auditing and SQL Forensics in SQL Server 2008 (r2)
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
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:
SessionID: 29611
Getting the most out of SharePoint Search
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint
Speaker: Cory Roth
Title: Getting the most out of SharePoint Search
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
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SharePoint
Speaker: Eric Trivette
Title: BCS Best Practices in SharePoint 2010
Abstract:
SessionID: 30389
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS
Speaker: Ira Warren
Abstract:
SessionID: 30469
Looney Tuner? No, there IS a method to my madness
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS
Speaker: Jose Chinchilla
Title: Learning SSIS under 1 hour
Abstract:
SessionID: 30633
Designing and Optimizing SSAS Hierarchies
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
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
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
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:
SessionID: 30970
Handling Advanced Data Warehouse Scenarios in SSIS
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track
Speaker: J Sawyer
Title: Data in the Stream: Introducing StreamInsight
Abstract:
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
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II
Speaker: Kyle Kelin
Title: Back to Basics - Threading in .NET
Abstract:
SessionID: 31469
Fundamental OOP with C#
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
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
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
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:
SessionID: 31959
Introduction to Agile/Scrum
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
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI
Speaker: Peter Myers
Title: Introduction to Analysis Services 2008 R2 Cubes
Abstract:
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Ryan Duclos
Title: Introduction to Windows Azure
Abstract:
SessionID: 32472
Introduction to SQL Azure
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: Bonus Track
Speaker: Ryan Duclos
Title: Introduction to SQL Azure
Abstract:
SessionID: 32598
Must-Know Design Patterns
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I
Speaker: Rob Vettor
Title: EntityFramework 360: Getting Started
Abstract:
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
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:
SessionID: 32864
Understanding Backups
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Sean McCown
Title: Understanding Backups
Abstract:
SessionID: 32865
Beginning Powershell for DBAs 1.0
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
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:
SessionID: 32929
The Top Ten SQL Server Skills You Need
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET II
Speaker: Stacy Vicknair
Title: Introduction to Visual Studio LightSwitch
Abstract:
SessionID: 33255
Basic Guidelines for VLDB's
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:
- query design
- logical and physical data structures
- maintenance backup strategies
SessionID: 33471
SQL Server Partitioning from A to Z
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: SSIS/SSRS
Speaker: Kevin Boles
Title: Advanced TSQL Solutions
Abstract:
SessionID: 33632
Visualizing SQL Saturday.
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: BI
Speaker: Tim Costello
Title: Visualizing SQL Saturday.
Abstract:
This session will cover the best practices of dashboard design and data analytics as we explore and create data visualizations from the history of SQL Saturday. This session will focus on analyzing trends over time, categorical trending and dashboard design.
SessionID: 33831
You want [Me] to do what?
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
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
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
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
Event Date: 06-08-2011 - Session time: 00:00:00 - Track: .NET I
Speaker: Zain Naboulsi
Title: Advanced Visual Studio Tips and Tricks
Abstract: