Thursday, July 28, 2011

Business Intelligence Track–SQLSaturday #64 Baton Rouge

Just in case you did not know, the annual Baton Rouge SQLSaturday #64 and Tech Day will be August 6th in Baton Rouge, LA at the LSU campus. Patrick LeBlanc started it all in 2009 and there is wonder group of Technology Geeks keeping the trend going.

If I were not volunteering for #SqlSat64, this is where my but would be all day, except during lunch eating jambalaya and watching with Steve Jones represent RedGate

Business Intelligence for Managers/Decision Makers (1111) - Beginner

BI Track – 8:30-9:30AM

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.

Carlos Bossy (MCTS SQL Server 2008 BI, CBIP) is a Consultant with 25 years of experience in software and database development. Carlos is an independent consultant and focuses on developing Business Intelligence solutions including data warehouses, predictive analytics, data integration and reporting. He has worked with SQL Server for 10 years and is very enthusiastic about its powerful features. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies.

Handling Advanced Data Warehouse Scenarios in SSIS (1111) - Intermediate

BI Track – 9:45-10:45AM

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

John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server BI topics.

Introduction to Analysis Services 2008 R2 Cubes (1111) - Intermediate

BI Track – 11:00-12:00PM

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

Peter Myers has 14 years of solid experience working in OLTP database design and Business Intelligence with SQL Server and SharePoint. In April 2010, Peter was re-awarded Microsoft MVP (Most Valuable Professional) for the fourth 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

Designing and Optimizing SSAS Hierarchies (1111) - Advanced

BI Track – 1:30-2:30PM

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

Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Developer working as a Sr. BI Consultant and trainer for Pragmatic Works. Jose has12+ years of experience in IT and has focused his career in OLTP and OLAP database design, development and administration and specializes in ETL/ELT using SSIS, Data Warehousing and Multidimensional Analysis using SQL Server 2008 BI tools. He is also the current president of the Tampa Bay Business Intelligence User Group

Visualizing SQL Saturday (1111) - Intermediate

BI Track – 2:45-3:45PM

This session will cover the best practices of dashboard design and data analytics as we explore and create data visualizations from the history of SQL Saturday. This session will focus on analyzing trends over time, categorical trending and dashboard design

Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker with 25 presentations in the US and Canada since January of 2010. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area. Tim Started working with data in Access 95 and has worked in every version of SQL from SQL 7 forward

An Overview of PowerPivot (1111) - Beginner

BI Track – 4:00-5:00PM

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

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable 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 solution

Saturday, July 16, 2011

SQLSaturday #64 Baton Rouge Edition

AAAAYYYEEE!!! as they say down on the Bayou.

Time to get some free SQL Server, .Net and Sharepoint training in Baton Rouge. This is annual Tech Day in Baton Rouge for the third year. MVPs from all over the south and beyond are gathering to train people through 8 Tracks with 6 sessions each, that is 48 hours of free training plus a Window 7 Phone garage (not sure about this one).

Please register her:

See the session lineup here:

There are too many presenters to mention, so will not name them because I do not want to miss anyone, but this year the will be 46 different speakers and I will not be one of them. I am concentrating on helping the volunteers put on the show.

Also, I have been accepted as a speaker (and alternate) at the PASS Summit in Seattle October 10-15 2011. Still have to get approval from my new job to attend.

Oh yeah, I forgot to mention that I have a new Job. I now work at Blue Cross-Blue Shield of Louisiana in Baton Rouge in the Enterprise Architecture team, probably to change to Enterprise Architect Data Performance title. I am in New York right now training on Informatica which is an enterprise ETL tool that sorry to say, blows SSIS out of the water.

Maybe Denali will catch up with Informatica, but right now it does not look close.

Well, good night and back to work Smile

God Bless,


Tuesday, July 12, 2011

July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”

July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”

Microsoft – Readying on “Hadoop”

Start Time:
Thursday, July 21, 2011 9:00 PM US Eastern Time (July 22, 2011 2:00 AM GMT)

End Time:
Thursday, July 21, 2011 10:00 PM US Eastern Time ( July 22, 2011 3:00 AM GMT)

Gaurav Aggarwal (blog)

Live Meeting Link:

Microsoft – Readying on “Hadoop”
This session will provide overview of different options on Microsoft platform for Hadoop. Session will cover pro and cons of different options and architecture level coverage of HPC, PDW and Dyrad.

Gaurav Aggarwal
Gaurav Aggarwal is a Senior Architect with 16+ years of experience. He has been working with Microsoft for the past 7+ years. He helps senior management in aligning their IT capabilities to innovate and achieve momentum for their business goals. He has been architecting and delivering solutions using various technologies for nearly 17 years. He has delivered solutions in the areas of Investment Banking, Insurance, HR, Manufacturing, Retail Banking and ITES. These solutions were based on a wide range of technologies including Microsoft and Java platform based solutions.

He is a Microsoft Certified Master (SQL Server), Microsoft Certified Architect (SQL Server), and Microsoft Certified Architect (Solutions), IASA Certified Architect Professional and a practicing Six Sigma and PMP (Project Management Professional) professional.

Gaurav’s blog:

Add to calendarAdd to your calendar