Nr: 28
SQLSaturday #28 - Baton Rouge 2010
SessionID: 28485
Understanding Storage Systems and SQL Server
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Wesley Brown
Title: Understanding Storage Systems and SQL Server
Abstract:
SessionID: 28570
Parallelism Options in .NET 4.0
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: DB Design App Dev
Speaker: Al Manint
Title: Parallelism Options in .NET 4.0
Abstract:
This session will cover examples of parallel options added in .NET 4.0 and VS 2010 including mainly parallel extensions, parallel debugger and concurrency viewer. There will be some review of the underpinning architecture needed to make this possible including parallel task library and the task scheduler. This session assumes that you have knowledge of Generics, LINQ and C#.
SessionID: 28658
Build Your First SSIS Package
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SSIS\BI
Speaker: Andy Leonard
Title: Build Your First SSIS Package
Abstract:
In this session, we'll take a top-down look at SQL Server Integration Services. We'll start with an overview of SSIS and how it fits in with the rest of the SQL Server BI stack, followed by a quick tour of the components and tasks available in SSIS. Finally, we'll wrap up by demonstrating how to build and deploy a simple SSIS package from scratch. This session is intended for those with little to no experience with SQL Server Integration Services.
SessionID: 28738
Building a Testable Data Access Layer
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: Apps\Cloud\Personal Development
Speaker: Todd Anglin
Title: Building a Testable Data Access Layer
Abstract:
All developers understand the theoretical value of unit testing, but with data driven applications, figuring out how to create tests can be hard. In this session, you will learn how to design and build a data layer that can be tested. We will introduce data layer architecture practices and methodologies that make testing possible, and cover the basics of unit test mocking. You will also be guided through various types of testing, including unit, integration, and functional testing. Leave this session with the basics needed to start creating tests for application data layers, including those powered by LinqToSQL and Entity Framework.
SessionID: 28761
Data Mining in Action: A case study
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SSIS\BI
Speaker: ANDREW MINKIN
Title: Data Mining in Action: A case study
Abstract:
This session will focus on using real world data ( no Adventureworks) taken through the life cycle of a data mining application. Topics will include the methodology an introduction to details of DMX, managing output and validating discoveries
SessionID: 28968
Breakfast Basics, SSAS Cube Creation
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: BI\SSRS
Speaker: Barry Ralston
Title: Breakfast Basics, SSAS Cube Creation
Abstract:
Bring your favorite caffeinated beverage and start SQL Saturday with this session on fthe basics of creating a SQL Server Analysis Services cube.
SessionID: 28969
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: BI\SSRS
Speaker: Barry Ralston
Abstract:
Toss Adventure Works and Project Real, this is SEC territory and football rules. This 'no holds barred session' will be a rapid fire creation of a Microsoft Business Intelligence solution from source data (NCAA Football statistics) to surfacing the data with Microsoft tools. The audience will get a first-hand overview of the dimensional modeling process, ETL, SQL Server Analysis Services and finally creating a UI for our data. All of the source code for the session will be made available for use after the session for anybody passionate enough about college football to maintain their own databaset.
SessionID: 29100
Introduction to NHibernate and Fluent NHibernate
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 2
Speaker: Brian Sullivan
Title: Introduction to NHibernate and Fluent NHibernate
Abstract:
Object-Relational Mappers (ORMs) have started to make their way into mainstream .NET development with the advent of LINQ-to-SQL and the Entity Framework from Microsoft. Before that, though, there was NHibernate. Based on the Java Hibernate project, NHibernate is one of the most mature .NET ORMs in the marketplace. The Fluent NHibernate project builds on this to make NHibernate a breeze to configure. In this presentation, Brian will discuss the pros and cons of ORMs in general, and demonstrate how NHibernate can take the pain out of writing your persistence layer.
SessionID: 29164
Best Practices Every SQL Server DBA Must Know
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin II
Speaker: Brad McGehee
Title: Best Practices Every SQL Server DBA Must Know
Abstract:
The focus on this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. As such, this session is targeted towards those who have less than one year’s experience. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
SessionID: 29171
Database Maintenance Essentials
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Brad McGehee
Title: Database Maintenance Essentials
Abstract:
Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance and reduce uptime. In this session you will learn the key things all DBAs need to know in order to help them maintain their databases at peak performance. As such, this session is targeted towards those who have less than one year’s experience as a SQL Server DBA. In this session, you will learn about: Physical File Fragmentation; Database and Log File Management; tempdb Maintenance, msdb Maintenance; Index Maintenance; Statistics Maintenance; Data Corruption Detection; Database and Log File Protection; and Database Maintenance Monitoring.
SessionID: 29282
Zen Coding
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 1
Speaker: Brian Rigsby
Title: Zen Coding
Abstract:
The philosophy, the mindset, the attitude of a professional, principled, disciplined software developer.
SessionID: 29283
Zen Testing
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 1
Speaker: Brian Rigsby
Title: Zen Testing
Abstract:
A introduction to unit testing and using "test first" coding concepts.
SessionID: 29305
MDX 101
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SSIS\BI
Speaker: Bryan Smith
Title: MDX 101
Abstract:
Join Bryan Smith, co-author of Microsoft SQL Server 2008 MDX Step by Step, in exploring the fundamental concepts of this powerful and elegant data access language.
SessionID: 29306
An Introduction to Power Pivot
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: BI\SSRS
Speaker: Bryan Smith
Title: An Introduction to Power Pivot
Abstract:
SessionID: 29378
Introduction to Windows Phone 7 Development
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: DB Design App Dev
Speaker: Carlos Femmer
Title: Introduction to Windows Phone 7 Development
Abstract:
SessionID: 29427
SharePoint 2010 Management with PowerShell
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: Apps\Cloud\Personal Development
Speaker: Cody Gros
Title: SharePoint 2010 Management with PowerShell
Abstract:
SharePoint 2010 includes hundreds of PowerShell cmdlets for managing your SharePoint 2010 environment. This session will first provide you with the basics of using PowerShell and then dive into using PowerShell to mange SharePoint 2010. You will learn everything from scripting out deployments to managing sites using PowerShell. This session will also show SharePoint administrators how to automate common SharePoint tasks.
SessionID: 29663
Azure - Best Practices
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: Apps\Cloud\Personal Development
Speaker: Chander Dhall
Title: Azure - Best Practices
Abstract:
SessionID: 29664
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 2
Speaker: Chander Dhall
Abstract:
SessionID: 30495
iPhone Development using .NET and Monotouch
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: DB Design App Dev
Speaker: Jason Awbrey
Title: iPhone Development using .NET and Monotouch
Abstract:
Want to learn how to leverage your existing .NET skills to develop for the iPhone? MonoTouch is a library that allows you to write C# code to control the iPhone native API. Learn how to get started with iPhone development without having to learn Objective-C.
SessionID: 30861
Running mixed workloads on SQL Server
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Jason Massie
Title: Running mixed workloads on SQL Server
Abstract:
In an ideal world, you can separate your OLTP traffic and reporting so the databases can be optimized for their respective workloads. In the real world, this is not always an option. Real time data means reporting off of the OLTP environment. We will first look at the shortcomings of different reporting solutions. We will then look at features that help a mixed work play nicely together. Some of these features include filtered indexes, indexes views, persisted computed columns, data compression, resource governor, partitioning and others. We will also touch on database design concepts that can help mixed workloads and leave you with topics to research further so you master the juggling act that is mixed workloads
SessionID: 31251
Microsoft .NET Framework from Scratch
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: Microsoft .NET Framework from Scratch
Speaker: Keith Elder
Title: Microsoft .NET Framework from Scratch
Abstract:
SessionID: 31377
Building Richer Web Applications with SP2010
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 2
Speaker: Kyle Kelin
Title: Building Richer Web Applications with SP2010
Abstract:
SessionID: 31454
C# Ninjitsu
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 1
Speaker: Chris Eargle
Title: C# Ninjitsu
Abstract:
C# has humble beginnings as an object oriented language of the purest kind. It was class-based, it was imperative, and it was component-oriented. For many years, the classic object-oriented design principles served class library designers well. But C# is no longer a purely object oriented language. It is no longer an imperative, class-based, component oriented discipline. It is also a generic, declarative, functional discipline. I will reexamine the object-oriented principles and introduce new principles. I will then introduce new refactorings as we move toward a more declarative, fluent world.
SessionID: 31455
RESTful Data
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 2
Speaker: Chris Eargle
Title: RESTful Data
Abstract:
REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With WCF Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE. This session will describe OData (the Open Data Protocol), the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.
SessionID: 31587
My first SQL Report
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: BI\SSRS
Speaker: Mark Verret
Title: My first SQL Report
Abstract:
SessionID: 31787
.NET 3.5 Fundamentals
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 1
Speaker: Mike Huguet
Title: .NET 3.5 Fundamentals
Abstract:
SessionID: 31957
ALM, Agile and TFS - The Keys to Successful Projec
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 1
Speaker: Mike Moles
Title: ALM, Agile and TFS - The Keys to Successful Projec
Abstract:
SessionID: 31974
Deciding if VMs are a good choice for your SQL Svr
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin II
Speaker: Denny Cherry
Title: Deciding if VMs are a good choice for your SQL Svr
Abstract:
SessionID: 31975
Getting SQL Service Broker Up and Running
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: Apps\Cloud\Personal Development
Speaker: Denny Cherry
Title: Getting SQL Service Broker Up and Running
Abstract:
Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature.
In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting (as time allows).
SessionID: 32279
CDC + SSIS = SCD
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SSIS\BI
Speaker: Patrick LeBlanc
Title: CDC + SSIS = SCD
Abstract:
SessionID: 32465
Intro to Windows Azure
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: Apps\Cloud\Personal Development
Speaker: Ryan Duclos
Title: Intro to Windows Azure
Abstract:
SessionID: 32466
Can you control your reports?
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: BI\SSRS
Speaker: Ryan Duclos
Title: Can you control your reports?
Abstract:
SSRS 2008
SessionID: 32594
Advance Your Debugging Skills with VS 2010
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 1
Speaker: Rob Vettor
Title: Advance Your Debugging Skills with VS 2010
Abstract:
In this session, we’ll …
• Dive deep into the new IntelliTrace feature, which enables you to step back in time within your debugging session and inspect or re-execute code, without having to restart your application.
• See how to manage large numbers of breakpoints with labeling, searching and filtering.
• Extend “data tips” by adding comments, notes and strategically “pinning” these resources to maintain their visibility throughout your session.
• Demonstrate “collaborative debugging,“ by debugging a portion of an application and then exporting breakpoints and labeled data tips, so that others can leverage your effort, without having to start over.
SessionID: 32595
Getting Started with the Entity Framework 4.0
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 1
Speaker: Rob Vettor
Title: Getting Started with the Entity Framework 4.0
Abstract:
In this session, we’ll…
• Explore the Entity Framework 4.0, its related components and show how it all works
• Demonstrate how to build a business object model (Entity Data Model) and database mappings, from a database, from a model or from code
• Walk through a variety of examples of how to interact with the model
• Take a close look at how and why EF 4.0 implements “Persistence Ignorance”
• Show how to implement Entity Framework in a multi-tiered application
You’ll walk-away with a clear understanding of how the Entity Framework 4.0 can greatly simplify your DAL and enable you to program against a conceptual model of your data, versus the actual data store itself
SessionID: 32843
Beginning Powershell
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Sean McCown
Title: Beginning Powershell
Abstract:
For those of you who have always wanted to get started with powershell but didn't know how, this session is for you. We'll go over the extreme basics of how PS is organized and show you everything you need to know to go out and continue your learning.
SessionID: 32844
SSIS and Powershell: A winning combination
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin II
Speaker: Sean McCown
Title: SSIS and Powershell: A winning combination
Abstract:
Managing SSIS packages in large environments can be a real challenge in large shops. This session will show you how to deploy, transfer, monitor, standardize, and automate your SSIS package environment using Powershell. You’ll learn how to keep many data marts in perfect synch, deploy packages to multiple servers, consolidate packages to a single server, enforce naming and security standards, and much more.
SessionID: 32941
Basic SQL Server
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Steve Jones
Title: Basic SQL Server
Abstract:
Learn the basics of SQL Server if you are new to working with the product. This high level technical session will introduce the basics of database design, objects in SQL Server, security, and queries as well as an overview of how the product is structured from an IT perspective.
SessionID: 32943
The Modern Resume: Building Your Brand
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: Apps\Cloud\Personal Development
Speaker: Steve Jones
Title: The Modern Resume: Building Your Brand
Abstract:
Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more.
SessionID: 33166
Data Mining.. Making $mart financial decisions
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: BI\SSRS
Speaker: Steve Simon
Title: Data Mining.. Making $mart financial decisions
Abstract:
SessionID: 33168
Get your Mining Model Predictions out to all
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: BI\SSRS
Speaker: Steve Simon
Title: Get your Mining Model Predictions out to all
Abstract:
Over the past 18 months many financial and portfolio management firms have been severely ‘hit’ by the depressed markets and poor economic conditions.This lead to risk exposure and considerable client liability.We like many firms have gone through the 'teething process'with regards to data mining model predictions and have now taken our systems from the prototype stage to our “shop floor” and are getting the 'good word' out to management via SQL Server Reporting Services 2008.
SessionID: 33271
Efficient Data Warehouse Design
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: DB Design App Dev
Speaker: Dr. Suresh Rajappa
Title: Efficient Data Warehouse Design
Abstract:
Key Design Decisions to avoid Enterprise Data Warehouse designs and delivering Business values.
When designing the enterprise data warehouse, what are the pitfalls an architect can face and how to avoid them. The session will also talk about when to use multiple dimensions and when to combine them for the performance. This topic also covers the new concepts of Rapidly changing dimensions etc with a real word example.
SessionID: 33315
Conceptual Data Modeling: Defining Our Data
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: DB Design App Dev
Speaker: Eli Weinstock-Herman
Title: Conceptual Data Modeling: Defining Our Data
Abstract:
SessionID: 33489
SQL Server Memory Deep Dive
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin II
Speaker: Kevin Boles
Title: SQL Server Memory Deep Dive
Abstract:
SessionID: 33493
Common TSQL Programming Mistakes
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Kevin Boles
Title: Common TSQL Programming Mistakes
Abstract:
We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.
SessionID: 33564
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: DB Design App Dev
Speaker: Thomas LeBlanc
Abstract:
SessionID: 33589
Dynamic SSIS with Expressions and Configurations
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SSIS\BI
Speaker: Tim Mitchell
Title: Dynamic SSIS with Expressions and Configurations
Abstract:
Never hard-code a connection string or file path again! In this session, we'll look at several ways to introduce dynamic logic into your packages by way of the SSIS expression language, package configurations, and variables. Learn how to reuse tasks, components, and containers by replacing static settings with dynamic and flexible properties.
SessionID: 33645
SQL Source Control: Poor man's data dude.
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SSIS\BI
Speaker: Tim Costello
Title: SQL Source Control: Poor man's data dude.
Abstract:
SessionID: 33646
ssis templates: the easy way to win.
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SSIS\BI
Speaker: Tim Costello
Title: ssis templates: the easy way to win.
Abstract:
SessionID: 33730
A PowerShell Cookbook for DBAs
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin II
Speaker: Trevor Barkhouse
Title: A PowerShell Cookbook for DBAs
Abstract:
This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of "recipes," stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.
SessionID: 33731
An Introduction to Profiler and SQL Trace
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin I
Speaker: Trevor Barkhouse
Title: An Introduction to Profiler and SQL Trace
Abstract:
SessionID: 33814
Exploratory Testing with Microsoft Test Manager
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 2
Speaker: Vaneshia Leachman
Title: Exploratory Testing with Microsoft Test Manager
Abstract:
SessionID: 34493
Introduction to DMVs in SQL 2005/2008
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: SQL Admin II
Speaker: William Assaf
Title: Introduction to DMVs in SQL 2005/2008
Abstract:
SessionID: 34525
The Best of Visual Studio 2010
Event Date: 14-08-2010 - Session time: 00:00:00 - Track: .Net 2
Speaker: Zain Naboulsi
Title: The Best of Visual Studio 2010
Abstract:
This session will combine the best parts of "What's new in VS2010", "What's new in the Framework 4.0", and "VS2010 Tips and Tricks". In this session you will see the best parts of three sessions in one uber session. We will look at Parallelism, changes to the CLR, cool features like the new Call Hierarchy, and much, much more!