Saturday, July 28, 2012

SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint

This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing and Bill Waters. Sharepoint sessions are great for those in the BI field using Microsoft BI stack managing PerformancePoint and PowerView/SSRS integration or SQL Server DBAs having a Sharepoint SQL instance.

8:20AM - Mapping Mashups with SharePoint Designer

Mapping Mashups with SharePoint Designer including an Overview of Current Map Service Providers, an Introduction to Customizing the Data View Web Part, and a Demonstration of Dynamic Mapping from List Data

Session Level: Intermediate

Tom Resing

Tom is a Microsoft Certified Master in SharePoint. He is passionate about online collaboration technologies and loves being active in the SharePoint Community. Tom has been blogging about SharePoint for the last 5 years after certifying on the 2007 platform. Tom has enjoyed 15 years in the internet industry developing products and web site functionality in Perl, C++, Java, VB.Net and C#. With SharePoint, Tom prefers an Out of the Box approach to deployment.

Contact URL:

9:35AM - SQL Server Best Practices for SharePoint 2010

Are you a SharePoint administrator and now have to maintain all your SharePoint databases? This session will provide you with the information you need to maintain your SharePoint databases including: - Backup/Recovery of databases - Determining your recovery model -Building maintenance plans - SQL Aliases

Session Level: Intermediate

Cody Gros

Cody Gros has been in the IT field for over 7 years working with SharePoint and Windows Server Technology. He is well versed in SharePoint 2010/2007 and is experienced in applying PowerShell scripting to SharePoint and Active Directory automation solutions.

Contact URL:

10:50AM - SharePoint Development for ASP.NET Developers

Getting started in the world of SharePoint development? Have ASP.NET development experience? In this session, you will learn how SharePoint 2010 is built off the ASP.NET platform. We will also bridge the gap between both platforms by covering the basics of the SharePoint platform and set you on the path to developing your own SharePoint solutions.

Session Level: Beginner

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.


1:10PM - Integrate with Business Connectivity Services

Business Connectivity Services with Microsoft SQL Server including an Overview of the Business Connectivity Services, an Introduction to Configuring BCS, and Demonstrations of using External Lists and External Data Columns.

Session Level: Advanced

Tom Resing

Tom is a Microsoft Certified Master in SharePoint. He is passionate about online collaboration technologies and loves being active in the SharePoint Community. Tom has been blogging about SharePoint for the last 5 years after certifying on the 2007 platform. Tom has enjoyed 15 years in the internet industry developing products and web site functionality in Perl, C++, Java, VB.Net and C#. With SharePoint, Tom prefers an Out of the Box approach to deployment.

Contact URL:


2:25PM - Adding Metro Style Navigation to a SharePoint Site

This is a walk through of how to create a Metro Sytle Navigation to a SharePoint Site, potentially including exposing high level Core Metrics in tiles to bubble that key information to users.

Session Level: Intermediate

Bill Watters 

Speaker photoI am a Nerd who loves soccer, hanging with my family and sharing what I learn. I have been in IT for over 15 years and focused on Portal Solutions for the last 10. I am currently highly focused on BI Integration with SharePoint and making data more accessable to users.

Contact URL:

Sunday, July 22, 2012

PASS Data Architecture presents Ami Levin: Where Are My (Primary) Keys?

I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my top 3 sessions last year at the Summit. He has an excellent way of using visuals to explain things. The session for the PASS Data Architecture VC on Thursday (July 26th) is great session on Primary Keys and relational databases and the rules surrounding them. All Developers need to watch the presentation.

Here is an article written by Ami recently and review by Dr. SQL Louis Davidson. Excellent step by step on how to normalization a many-to-many relationship into the proper table structure using Data Modeling.

Subject: Where are My (Primary) Keys?

Start Time:  Thursday, July 26th, 2012 12:00 PM US Central Time

End Time:  Thursday, July 26th, 2012 1:00 PM US Central Time

Presenter:  Ami Levin

Live Meeting Link:  Attendees LiveMeeting

Where Are My (Primary) Keys?

In this session, we revisit some of the fundamental design principals of relational databases—normalization rules, key selection, and the controversies associated with these issues—from a very hands-on, practical perspective. We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance.
Session takeaways:
• Understand the profound impact of key selection on the entire application lifecycle
• Learn to identify when it is best to use natural or artificial keys • Learn how to minimize performance, portability, and maintenance issues during the early database design phase

Ami Levin

  Ami Levin  CTO, DBSophic
Ami Levin is a Microsoft SQL Server MVP since 2006, with over 20 years of experience in development and IT. For the past 14 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide. Ami's areas of expertise are data modeling, database design, T-SQL, and performance tuning. He leads the Israeli SQL Server user group (ISUG), moderates the Hebrew MSDN SQL Server support forum, and is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences. Ami speaks often at user group meetings in Israel and Europe and writes articles about SQL Server.

Add to calendarAdd to calendar

Thursday, July 19, 2012

SQL Saturday #150 and TechDay Baton Rouge–BI 1 track

The SQL Saturday/TechDay in Baton Rouge will be the forth annual this year. The Business Intelligence sessions occupy 2 tracks this year. This blog will be about the speakers from first track.

The full schedule can be found here.

8:20AM - Introduction to SSIS with a Real-World Example

SSIS is a powerful and east to use data Extract, Transform, Load (ETL) tool SSIS providing a rich set of components to perform the most common ETL tasks with “drag-and-drop” ease. Packages can be constructed with rigorous error and exception handling as well as verbose logging allowing deployment of robust ETL processes.. This session will demonstrate a process for loading a comma-delimited data file into a staging table for further processing then validating the data and moving specific data into host tables using a a thorough example of a non-trivial ETL project with “real” data. The intended audience includes beginning SSIS developers, DBAs, and anyone with a desire to experience the magic of data management with this remarkable tool.

Session Level: Beginner

Ron Johnson

A 20 year veteran of the IT industry with over 10 years experience as a software engineer Ron is a seasoned SQL Server performance optimization professional.Ron is currently supporting various clients as a consulting DBA specializing in PTO,Replication,HA/DR,and Security with Xtivia, Inc. a full-service IT company with offices in Dallas,TX, Colorado Springs,CO,and Edison,NJ.Ron earned a M.Sc. in Computer Science and a B.Sc. in Physics.Ron has 10 years of experience as an adjunct faculty member.

Contact URL:


9:35AM Using SSIS 2012 for ETL in a Data Warehouse

This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demostration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints.

Session Level: Advanced

Thomas LeBlanc 

Thomas is a Senior DBA at Turner Industries in Baton Rouge, LA. Worked in the IT field for 21 years experience w/ COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 9 years ago. He has been blessed with speaking at SQLRally at SQLPass in 2011. Thomas’ free time is spent helping other & improving his relationship with family & God.

Contact URL:

10:50AM BI in the Cloud

In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.

Session Level: Beginner

David Liebman

Speaker photoI’m a developer specializing in .Net, SQL, and SSRS development for over five years of the eighteen years I have spent in the IT Industry. I have experience working for some big companies in Financial, Healthcare, and Insurance. I have written some custom reporting solutions and web applications for Large Companies in the Tampa Bay area using .Net, SSRS, and SQL. I’m currently a Sr. Developer at AgileThought that is leader in software development and system integration services in Tampa FL.

Contact URL:


1:10PM - Moving to a data warehouse

This presentation will walk through the key concepts and decisions necessary for moving from a transactional system to an analytical system based on a data warehouse. Concepts and demonstrations will be based on the process implemented at the LSU Highway Safety Research Group as the case study. The discussion will be based on a more business approach while also presenting technical details.

Session Level: Beginner

Cory Hutchinson 

Cory Hutchinson currently serves as the Associate Director for the Highway Safety Research Group (HSRG) at Louisiana State University and the Coordinator of the Louisiana Traffic Records Coordinator Committee (LA TRCC). Cory oversees all IT related projects within HSRG including business analytics, web site design, data quality analysis, electronic crash data collection, data reporting, disaster recovery, graphical information systems, business intelligence, and crash data integration.

Contact URL:


2:25pm - SSIS for ETL in the Enterprise Environment

Design walkthrough of an ETL solution developed using the Microsoft SSIS system for an enterprise level Data Warehouse. Managing the ETL process migration from a single data warehousing SQL Server to a multi-server environment can often be a complex task. This session will walk you through the design of a ETL system that has been created for such a scenario. The design takes into consideration several of the shortcomings inherent in the SSIS system and provides a structure for coordinated loading and processing of data from extraction to presentation.

Session Level: Intermediate

Paul Kennedy

Paul Kennedy is the Data Warehouse Manager for Pool Corporation out of Covington Louisiana. Developing aspects of BI solution at Pool Corporation for the past seven years and with additional companies for an additional three years, Paul has developed and maintains the current ETL, Data Warehouse, and BI systems for the company. Experienced with working the intergration of Microsoft SQL products such as SSIS, SSDE, SSRS, and SSAS with various transactional systems and E-Commerce Websites

Monday, July 16, 2012

PASS BI/DW presents Dimensional Modeling 101–by me…

With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach to Data Warehousing. The PASS DW/BI Virtual Chapter has graciously allowed me to present on Dimensional Modeling. I am not an expert, so this is an introduction to what I have learned over the years.

At Crown Vantage (a paper mill), I was tasked to move a data warehouse from the old (bankrupt) home office to the lone paper that was left. After reading A Diary to Data Warehousing, I found out that our office (Sales) just needed a Data Mart, and did not need a Data Warehouse for the nightly reports. Years later I was a DBA at Amedisys and started to help the BI team performance tune the SQL. This led me to the BI department of Amedisys.

Please join me tomorrow if interest in a level 101 intro to Dimensional Modeling!!!

Tues July 17th 11:30am - 12:30pm Central

Dimensional Modeling 101

Speaker: Thomas LeBlanc


This session is going to help create a dimensional Data Mart from the AdventureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to re-enforce the need for Requirements and Functional specifications. A brief review of ETL for Slowly Changing Dimension and population of the Fact will be demonstrated as well as a simple cube for reporting.

Thursday, July 12, 2012

I’m Speaking: PASS Summit 2012 and more…

Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of July and August 2012. My local brother from a different mother, Patrick LeBlanc, hosted a SQLLunch for me as I demonstrated the new CDC controls in SSIS 2012. Patrick’s slogan “No Fluff Just Stuff”, reflects the theme for as demo rich webcasts of SQL Server features. The recorded session is now available here.



The announcement a couple of weeks ago of the SQL PASS general session included me. A new talk I first did at SQLSaturday #132 in Pensacola about SSIS 2012 new features – concentrating on CDC controls, Data Quality feature and SSIS Catalogs. Part of the demonstration includes new display options and Undo/Redo plus some auto-correction when columns change in the data flows.


Next Tuesday, July 17th I will be presenting Dimensional Modeling 101 with the PASS BI/DW Virtual Chapter. I got great reviews from this presentation while at the SQL Saturday #104 in Colorado Springs, CO. This was a fun trip with my fiancé skiing on the Friday before the event at Monarch. Many great speaker were at this event, and you can read my review here.

SQLSaturday #150 and Tech Day in Baton Rouge in August 4th, and I will be presenting a preview to my PASS Summit session. You can read more about Baton Rouge’s largest tech event here and here and here.


The next session will be on the PASS BI/DW VC August 7th, but has not been posted on the site, yet.

God Bless,


Tuesday, July 10, 2012

Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track

August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered the new business building for out event.

This blog continues the series of blogs over the next few weeks to spotlight the tracks for this FREE event. Of course, nothing like this is possible without sponsors. This year we have Bronze sponsors CozyRoc and Turner Industries (my current employer).

The next track is the .Net 1 in the room 1100C. Returning speakers Latish Sehgal and Chris Eargle (MVP) are welcomed back. New local speakers, Steve Schaneville (Amedisys) and Forest Marie (Turner Industries) are my “enemies” because the use Entity Framework to generate SQL in .Net. They are still very respected individuals.Trey Cook is a former The Shaw Group employee that now works for Microsoft.

Oh, by the way, I heard today from the famous Patrick LeBlanc that he will be at SQLSaturday this year. It is recorded on today during a presentation I did for CDC control task in SSIS 2012.

8:20AM - The .Net Ninja's Toolbelt

As developers, we all have our favorite utilities, some used occasionally and then there are others that we refuse to work without. We might not use all of them everyday, but a good developer should know his options when the need arises. In this session, we'll go through the tools, utilities and hacks that can make you much more productive as a .Net developer.

Session Level: Beginner

Latish Sehgal

Speaker photoLatish is a .NET consultant with Improving Enterprises and very passionate about software development and solving customer problems. He also leads the Dallas C# SIG. He can be reached via his blog at or twitter (

Contact URL:


9:35 Windows Azure and Smooth Streaming

Learn how to leverage Windows Azure and the Content Delivery Network to host HD quality video, and Visual Studio to build and deploy a Smooth Streaming Media player to play the video.

Session Level: Intermediate

Trey Cook

Speaker photoI am currently a Technology Strategist for Microsoft for the Enterprise Partner Group customers in South Louisiana. Prior to joining Microsoft, I spent eight years with The Shaw Group as an IT Manager / Senior Systems Engineer for messaging and collaboration as well as an IT Security Manager. Prior to joining The Shaw Group Inc., I spent nearly five years as a PC/Network Technician, Help Desk Manager, Systems Administrator and DBA for Turner Industries, Ltd.


10:50AM - The Legend of Lambda

Lambda expressions are a powerful feature of C#, one that can be wielded for good or evil. Attend this session for an adventure through the evolution of the C# language, from the depths of the delegate keyword to the expressiveness of the lambda expression. I will show you how anyone can easily learn to wield and empower code with lambda expressions. It's dangerous to go alone! Take this: =>

Session Level: Intermediate

Chris Eargle

Speaker photoChris 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,, features content to guide you in becoming a .NET Ninja!

Contact URL:


1:10PM - Tools, Tips and Nuget for ASP.NET Developers

A high level discussion of the tools used in a large enterprise by a professional .NET team. On a budget? No worries, most of these tools are free courtesy of the open source .NET developer community that you need to know about. Discussion to include awesome debugging skills, catching performance issues before they go live (we learned the hard way), how to have a professional error logging system set up in minutes, working with other developers and productivity tools. We'll also spend some on some critical design tips to keep your applications running faster and avoiding the "clean slate syndrome."

Session Level: Beginner

Forest Marie

Forest Marie is a lead software developer working for Turner Industries in Baton Rouge, Louisiana and Microsoft Certified Professional. He's been developing a variety of software since graduating from Southeastern in 2003. As an advocate of the S.O.L.I.D. principles, Forest is passionate about writing applications that was easy to work on, easy to maintain and easy to extend.


2:25PM - Unit Testing - Solving some Tough Issues

Unit Tests are common place in our tools for creating quality code. However, we still run into several road blocks that often prevent us from writing a thorough suite of tests. This session will suggest ways of solving 2 specific problems that I have personally experienced when trying to write suites of unit tests. Specifically, I'll attempt to address: * how to write test for older code libraries that do not currently have unit tests so that the code can be changed with confidence (a look at the new Fakes framework in VS 2012). * how to write tests for logic/data access code that uses Entity Framework without hiding the flexiblilty of Entity Framework (note, I actually don't prefer the repository pattern).

Session Level: Advanced

Steve Schaneville

Maintenance Engineer at the Paper Mill a didn't make my (or any other) list of most satisifying jobs, so I left that life and moved to Germany, where I discovered programming. After 2 1/2 years writing code to control robots (well kinda), I moved back to Baton Rouge and, surrounded by some incredibly smart people, learned something or other about writing enterprise software. I now serve as the Senior Applications Architect at Amedisys, Inc., and learn new things daily from my genius coworkers

Sunday, July 8, 2012

Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track

August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got the ball rolling 4 years ago and now a team of IT professionals from Baton Rouge have continued the effort.

This blog starts a series of blogs over the next few weeks to spotlight the tracks for this FREE event. Of course, nothing like this is possible without sponsors. This year we have Platinum sponsors Sparkhound and USGS Technical Community. So far, Gold Sponsors are Confio and Amedisys (a previous employer).

The first track is the DBA 1 in the main auditorium. MVPs Sean McCown (Dallas) and Wesley Brown (Austin) are 2 of the speakers. It is good to see the Texas crew coming to Louisiana. Jim Murphy (Austin) and Ryan Adams (Dallas) are scheduled in this track as well as Mike Byrd.

8:20AM AlwaysOn - Finally, A usable 'mirror'!

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.

Session Level: Beginner

Jim Murphy

Speaker photoJim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90's. He is the President/CEO of SQLWatchmen, LLC., a managed DBA service provider for smaller companies who do not need a full-time DBA. He runs the Austin SQL Server User Group: CACTUSS Central and sits on the board of He has been a professional DBA and developer for over 20 years and has run a consulting company full-time for over a decade.

Contact URL:

9:35AM - Nuts and Bolts of Table Compression

Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results -- they were surprising to me!

Session Level: IntermediateMike Byrd

Speaker photoFormer rocket scientist, retired USAF fighter test pilot; now a database geek. Former CTO for Texas Windstorm Insurance Association (9 years) and now SQL Server guru for Newgistics, Inc. (a direct competitor with FedEx and UPS for ground transportation for small packages) and part-time consultant. Expertise is performance tuning.

10:50AM - Benchmarking, Baselines and Monitoring Storage

Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come!

Session Level: Beginner

Wesley Brown

Speaker photoWes Brown is a PASS chapter leader and SQL Server MVP. He writes for SQL Server Central and maintains his blog at Wes is Currently serving as a Database Administrator Consultant for Dell. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays.

Contact URL:

1:10PM - How Active Directory affects SQL Server

There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers. Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent. We'll discuss how the location of your server in AD is important, how security can be compromised, and even AD DNS configuration. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work. This includes the biggest perpetrator, Group Policies Objects.

Session Level: Intermediate

Ryan Adams

Speaker photoRyan has worked for a Fortune 100 company for 14 years. He is the sole SQL Server DBA for his group. His primary focus is database design and performance, but also works with SSRS and SSIS. He enjoys being involved in the SQL community and serves on the Board of Directors for the North Texas SQL Server User Group and the PASS Performance Virtual Chapter. He also serves as a Regional Mentor for PASS and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP

Contact URL:

2:25PM - The Backup Tune-up

Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success.

Session Level: Intermediate

Sean McCown

Speaker photoSean McCown is a Certified Master in SQL Server 2008. He is also a SQL Server MVP with 17yrs experience in databases. Sean is also founder and co-owner of the renowned website where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight.

Contact URL: