SQLSaturday #64 - Baton Rouge 2011

Event Date: 08/06/2011 00:00:00

Event Location:

Louisiana State University - Taylor Hall
3304 Patrick F Taylor hall
Baton Rouge, Louisiana

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

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

Speaker(s):

Wesley Brown

Track and Room: SQL Admin I - N/A

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

Speaker(s):

Jose Chinchilla

Track and Room: SSIS/SSRS - N/A

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.

Speaker(s):

Jennifer McCown

Track and Room: SQL Admin I - N/A

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.

Speaker(s):

Cory Roth

Track and Room: SharePoint - N/A

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.

Speaker(s):

Ira Warren

Track and Room: SSIS/SSRS - N/A

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

Speaker(s):

J Sawyer

Track and Room: Bonus Track - N/A

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!

Speaker(s):

Jennifer McCown

Track and Room: SQL Admin II - N/A

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.

Speaker(s):

Cade Roux

Track and Room: SQL Admin II - N/A

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

Speaker(s):

Rob Vettor

Track and Room: .NET I - N/A

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.

Speaker(s):

Brian Sullivan

Track and Room: .NET II - N/A

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.

Speaker(s):

Ryan Duclos

Track and Room: Bonus Track - N/A

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!

Speaker(s):

Peter Myers

Track and Room: BI - N/A

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.

Speaker(s):

Eric Trivette

Track and Room: SharePoint - N/A

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.

Speaker(s):

Sean McCown

Track and Room: SQL Admin II - N/A

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.

Speaker(s):

Kevin Boles

Track and Room: SQL Admin I - N/A

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.

Speaker(s):

Zain Naboulsi

Track and Room: .NET I - N/A

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.

Speaker(s):

William E Pearson III

Track and Room: SharePoint - N/A

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.

Speaker(s):

Kyle Kelin

Track and Room: .NET II - N/A

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.

Speaker(s):

Steve Jones

Track and Room: SQL Admin I - N/A

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.

Speaker(s):

Carlos Bossy

Track and Room: BI - N/A

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.

Speaker(s):

Latish Sehgal

Track and Room: Bonus Track - N/A

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.

Speaker(s):

William Assaf

Track and Room: SQL Admin II - N/A

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 …”

Speaker(s):

William E Pearson III

Track and Room: BI - N/A

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.

Speaker(s):

Chris Eargle

Track and Room: .NET II - N/A

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.

Speaker(s):

Chris Koenig

Track and Room: Windows Phone Garage - N/A

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.

Speaker(s):

Cody Gros

Track and Room: SharePoint - N/A

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.

Speaker(s):

John Welch

Track and Room: BI - N/A

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.

Speaker(s):

Victor Chataboon

Track and Room: SharePoint - N/A

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.

Speaker(s):

Justin Yesso

Track and Room: SSIS/SSRS - N/A

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.

Speaker(s):

John Welch

Track and Room: SSIS/SSRS - N/A

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.

Speaker(s):

Janis Griffin

Track and Room: SQL Admin II - N/A

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.

Speaker(s):

Chander Dhall

Track and Room: .NET I - N/A

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.

Speaker(s):

Sean McCown

Track and Room: SQL Admin I - N/A

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.

Speaker(s):

Jose Chinchilla

Track and Room: BI - N/A

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

Speaker(s):

Stuart Ainsworth

Track and Room: SQL Admin II - N/A

Title: Zen Coding

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

Speaker(s):

Brian Rigsby

Track and Room: .NET I - N/A

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

Speaker(s):

Rob Vettor

Track and Room: .NET I - N/A

Title: Visualizing SQLSaturday.

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 SQLSaturday. This session will focus on analyzing trends over time, categorical trending and dashboard design.

Speaker(s):

Tim Costello

Track and Room: BI - N/A

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.

Speaker(s):

Kevin Boles

Track and Room: SSIS/SSRS - N/A

Title: Introduction to Windows Phone Development

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

Speaker(s):

Chris Koenig

Track and Room: Windows Phone Garage - N/A

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.

Speaker(s):

Cherie Sheriff

Track and Room: SSIS/SSRS - N/A

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.

Speaker(s):

Peter Myers

Track and Room: SQL Admin I - N/A

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.

Speaker(s):

Ryan Richard

Track and Room: .NET I - N/A

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!

Speaker(s):

Stacy Vicknair

Track and Room: .NET II - N/A

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.

Speaker(s):

Ryan Duclos

Track and Room: Bonus Track - N/A

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.

Speaker(s):

Carlos Bossy

Track and Room: Bonus Track - N/A

Title: Windows Phone Demo Walk-through

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

Speaker(s):

Chris Koenig

Track and Room: Windows Phone Garage - N/A

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.

Speaker(s):

Arnoldo Ruiz

Track and Room: SharePoint - N/A

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.

Speaker(s):

Mike Huguet

Track and Room: .NET II - N/A

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.

Speaker(s):

Michael Moles

Track and Room: Bonus Track - N/A

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.

Speaker(s):

Al Manint

Track and Room: .NET II - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Al Manint

Contact: http://www.linkedin.com/profile/view?id=35458402

IT Director for BRGMC and IT Nerd.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

Chris Koenig

Chris Koenig is a Senior Developer Evangelist with Microsoft, based in Dallas, TX. Prior to joining Microsoft in March of 2007, Chris worked as a Senior Architect for The Capital Group in San Antonio, and as an Architect for the global solution provider Avanade. As an Architect and consultant, Chris worked with a variety of clients from many vertical markets, ISVs and other solution providers on enterprise-class Windows and web-based applications.

Jose Chinchilla

Twitter: - SQLJoe

LinkedIn: Jose Chinchilla

Contact: http://www.sqljoe.com

Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.

Michael Moles

In May 2011 Mike Moles joined Perficient as the Director of the Louisiana Business Unit. Prior to joining Perficient Mike served as the Executive Vice President of Systems and Development and CTO Bizzuka. Before either of these two positions Mike helped build a company, Antares Technology Solutions, from the ground up where he served as the President and CEO for almost 21 years.

Cherie Sheriff

Cherie Sheriff is an MCDBA with 20 years of professional experience in Information Technology. Her education is in Philosophy and Physics, but her love for technology steered her career. She has focused on database technologies and business intelligence since 1992. Career challenges include modeling virtual training environments, financial analytics, geospatial data, data security and compliance.

Mike Huguet

Contact: http://blogs.msdn.com/b/pfedev

Mike Huguet is a Developer Premier Field Engineer for Microsoft. He is an active member of the IT community as the President of the Baton Rouge .NET User Group, a founding member of the Baton Rouge SQLSaturday event, and an avid speaker at all day conferences and user groups. He has a software development background and has been delivering solutions with .NET since Beta 1 and SharePoint since 2006.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Wesley Brown

Twitter: - @sqlserverio

LinkedIn: Wesley Brown

Contact: http://www.sqlserverio.com

Wesley Brown is a former SQL Server MVP and PASS Chapter Leader who loves to teach others about SQL Server.He maintains his technical blog at http://www.sqlserverio.com. Wes specializes in high availability, disaster recovery, and large-scale database performance tuning.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Peter Myers

Peter has 14 years of solid experience working in OLTP database design and Business Intelligence with SQL Server and SharePoint. In April 2012, Peter was awarded Microsoft MVP (Most Valuable Professional) for a sixth time. Peter enjoys sharing his enthusiasm for Microsoft technologies by presenting at SQL Server user group meetings and technical events, including TechEd in North America, Europe and Australia.

Brian Sullivan

Contact: http://www.sullivansoftdev.com

Brian Sullivan is a developer analyst for Falcon Applications, LLC in Shreveport, LA. He has been working with Microsoft technologies for about 7 years, and is interested in increasing the exposure of agile techniques and methodologies in the Microsoft developer community. He currently runs the Shreveport .NET User Group and speaks frequently at local user groups and conferences. He received the Microsoft MVP award for Data Platform Development in 2011. Brian is a graduate of Harding University.

Ryan Duclos

Contact: http://about.me/rduclos

Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.

Peter Myers

Ryan Duclos

Contact: http://about.me/rduclos

Tim Costello

Twitter: - timcost

LinkedIn: Tim Costello

Contact: http://www.timcost.com

Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.

Cade Roux

Twitter: - caderoux

LinkedIn: Cade Roux

Contact: http://www.caderoux.com/

Cade Roux, is the founder of Rose Crescent, a software and systems consultancy in New Orleans. He has been a professional programmer since 1992, and a user of SQL Server since 1997, managing IT operations at all levels of organizations. He has broad experience in several lines of business, including Route Accounting, Medical and Banking and technical exposure ranging from C/C++ to T-SQL, from the Windows API to Data Warehousing. He loves building great systems and great teams.

Rob Vettor

Rob Vettor is a C# MVP, INETA Regional Speaker and senior .NET Technologist for OZ Software, a leading provider of Education Healthcare software. Rob has built systems for a number of corporations, including Avanade, Raytheon, American Express and Jack Henry and Associates. Rob lives in Dallas, TX, with his wife, twin sons and three dogs, and is the founder of Hands-On-Coding (http://www.hands-on-coding.net/). You can contact Rob at robvettor@hotmail.com

Ira Warren

Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.

Cory Roth

Contact: http://www.dotnetmafia.com

Corey Roth is a solutions architect at Stonebridge specializing in SharePoint solutions in the Oil Gas Industry. Corey has always focused on rapid adoption of new Microsoft technologies including SharePoint 2010, Visual Studio 2010, .NET Framework 4.0, LINQ, and SilverLight. When it comes to SharePoint, he specializes in ECM, Enterprise Search, and Business Connectivity Services. Corey is a SharePoint MVP.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Justin Yesso

Justin is a Senior Development Consultant at Sparkhound Baton Rouge. He has helped develop web applications for a variety of different government and private industries including tax collection, banking and health care. His main focus is in C# web development but if you pin him down, he’ll admit to knowing VB as well.

Victor Chataboon

Contact: http://goodguytx.com/blog

Over 15 years of IT Enterprise experience with backgrounds in support, training, administration and architecture. Currently working as the Community Manager at Idera providing community support and resources to the PowerShell, SharePoint and SQL user communities. Also serves as the Board Chair for the Houston SharePoint User Group providing guidance to the current officers. Also advising and mentoring other user groups.

Chris Eargle

Contact: http://www.kodefuguru.com

Chris Eargle is a Telerik Developer Evangelist, INETA Director, and Microsoft Most Valuable Professional – C# from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, features content to guide you in becoming a .NET Ninja!

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.

Brian Rigsby

Twitter: - @ZenDeveloper

Contact: http://zendeveloper.blogspot.com

Brian#39;s formal education is in music, but he is an eighteen year software development veteran. His unorthodox presentation style is both inspirational and entertaining.

Rob Vettor

William Assaf

Twitter: - william_a_dba

LinkedIn: William Assaf

Contact: http://www.sqltact.com

William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kyle Kelin

Contact: http://www.dotnetmafia.com/blogs/kylekelin/default.aspx

Kyle Kelin has seven years of experience using Microsoft technologies to develop software. Kyle has built applications across multiple industries that include consumer electronics, travel, energy, government, pharmaceuticals, and investment banking. Kyle has worked with technologies like ASP.NET, SharePoint, WPF, Silverlight, and Surface. He is currently an Account Manager for Infusion in Houston. Kyle is a graduate of Oklahoma State University.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Chris Koenig

Contact: http://chriskoenig.net

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

Zain Naboulsi

Contact: http://blogs.msdn.com/zainnab

For over 15 years Zain has been working with the latest Microsoft technologies. He’s been a consultant and trainer since 1995. He currently runs the Visual Studio Tips and Tricks blog. Also, he created Online Community Evangelism; which is an effort to build communities in virtual places like LinkedIn, Facebook, and elsewhere. He is not only a proponent of the community aspect of online environments but also is a supporter of the myriad business applications that these new mediums offer.

J Sawyer

Contact: http://www.devbiker.net

J is a Senior Architect for Hitachi Consulting based in Houston, TX who absolutely loves to write code and build cool, innovative solutions to hard problems. He#39;s also the President of the Houston .NET User#39;s Group

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Chander Dhall

Contact: http://www.chanderdhall.com

Chander Dhall is the founder of Dallas day of dot net. Chander Dhall is an Independent Consultant, an INETA speaker( and Technology Advisor - Ria Consulting, LLC. He has a Master’s Degree in computer science with specialization in algorithms, principles and patterns and is focused on building high performing modular software. Chander leads the UT Dallas .NET user group and co-leads the Dallas dot net user group. Email: csdhall@chanderdhall.com Twitter @csdhall

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Stacy Vicknair

Contact: http://www.d68tm.org

Stacy Vicknair is the Lieutenant Governor Marketing for Toastmasters District 68. As LGM, Stacy oversees the club growth and success for over 900 members across 50+ clubs spread throughout Louisiana and Jefferson County in Texas. He gladly volunteers his time to Toastmasters and will tell you himself that he’s gained way more professionally with the help of Toastmasters than he would have without.

This meeting will feature several members of Toastmasters District 68.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Ryan Richard

Ryan Richard is a development consultant with Sparkhound in Baton Rouge. Ryan has worked in the IT industry since 2000, primarily as a SQL Server dba, and as a .Net developer.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Latish Sehgal

Twitter: - latish

Contact: http://www.dotnetsurfers.com

Latish is a .NET Principal Consultant with Improving Enterprises and very passionate about software development and solving customer problems. He also created SqlSmash, a productivity plugin for SSMS. He can be reached via his blog at http://www.dotnetsurfers.com/ or twitter (http://twitter.com/latish).

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Arnoldo Ruiz

Contact: http://avepoint.com

Arnoldo has extensive knowledge of Business Service Management strategies, data protection technologies, forensic e-discovery applications. Arnoldo works directly w/ Fortune 500 other enterprise customers to develop implement cost-effective SharePoint management, protection, and optimization strategies. His contributions to the SharePoint community have garnered him speaking opportunities at technology conferences, seminars, and user groups throughout North and Latin America.

Cody Gros

Cody Gros has been in the IT field for 5 years working with Windows Server technology, SharePoint, and PowerShell. Recently, he is working extensively with SharePoint and providing solutions to clients on the SharePoint platform. Cody works for Antares Technology Solutions as a SharePoint consultant designing and implementing Microsoft SharePoint 2010 solutions.

Chris Koenig

Jose Chinchilla

Twitter: - SQLJoe

LinkedIn: Jose Chinchilla

Contact: http://www.sqljoe.com

Stuart Ainsworth

Twitter: - @codegumbo

LinkedIn: Stuart Ainsworth

Contact: http://codegumbo.com

Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.

Eric Trivette

Eric Trivette, MCPD, has been working with Microsoft ASP.NET since December 2006. Eric began SharePoint development with SharePoint 2010 and works with Antares Technology Solutions as a consultant where he designs and implements custom solutions in SharePoint 2010 and all versions of ASP.NET.

SQLSaturday #64 - Baton Rouge 2011

Sessions

Title: Understanding Storage Systems and SQL Server

Title: Learning SSIS under 1 hour

Title: Unraveling Tangled Code–Tale of Victory Over Chaos

Title: Getting the most out of SharePoint Search

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

Title: Data in the Stream: Introducing StreamInsight

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

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

Title: EntityFramework 360: Getting Started

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

Title: Introduction to SQL Azure

Title: Introduction to Analysis Services 2008 R2 Cubes

Title: BCS Best Practices in SharePoint 2010

Title: Beginning Powershell for DBAs 1.0

Title: SQL Server Partitioning from A to Z

Title: Advanced Visual Studio Tips and Tricks

Title: An Overview of PowerPivot in SharePoint

Title: Back to Basics - Threading in .NET

Title: The Top Ten SQL Server Skills You Need

Title: Business Intelligence for Managers/Decision Makers

Title: Extending Visual Studio Sql Server Mgmt. Studio

Title: SQL Admin Best Practices with DMV’s

Title: An Overview of PowerPivot

Title: Fundamental OOP with C#

Title: Windows Phone Garage - Develop a Phone App

Title: PowerShell Cookbook for SharePoint 2010

Title: Handling Advanced Data Warehouse Scenarios in SSIS

Title: You want [Me] to do what?

Title: SSRS for .Net Developers

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

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

Title: MVc3 - Solid principles, IOC and ORM

Title: Understanding Backups

Title: Designing and Optimizing SSAS Hierarchies

Title: Basic Guidelines for VLDB’s

Title: Zen Coding

Title: Must-Know Design Patterns

Title: Visualizing SQLSaturday.

Title: Advanced TSQL Solutions

Title: Introduction to Windows Phone Development

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

Title: Developing Rich Reporting Services Visualizations

Title: Using the MVVM pattern in Silverlight and WPF

Title: Introduction to Visual Studio LightSwitch

Title: Introduction to Windows Azure

Title: Tune a Star Schema for High Performance Reporting

Title: Windows Phone Demo Walk-through

Title: Storage Optimization and Data Availability

Title: Leveraging Open XML to Create More Dynamic Docs

Title: Introduction to Agile/Scrum

Title: Introduction to MVC 3

Speakers

Sponsors