PASS Virtual Chapter Events : July 2013

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.

Creating HTML reports with PowerShell – June 17, 2013
Online Event

Language: English

Date: Tuesday, June 11, 2013

Time: 10:00 am – 11:00 am (Mountain Time)

Cost: Free

Featured Presentation

Creating HTML reports with PowerShell

Speaker: Jeff Hicks, PowerShell MVP, author and trainer JDH IT Solutions

Summary: Creating HTML reports on one hand is almost brain-dead easy in PowerShell. But using it with style takes a little more work. Wouldn’t you like to add a little pizzazz to your HTML reports that you create in PowerShell. In this session I’ll offer some tips and tricks for creating great looking, or at least better looking, HTML reports including stylized alternate rows and embedded graphics.

About Jeff: Jeffery Hicks is a Microsoft MVP in Windows PowerShell, Microsoft Certified Trainer and an IT veteran with over 20 years of experience, much of it spent as an IT consultant specializing in Microsoft server technologies with an emphasis in automation and efficiency. He works today as an independent author, trainer and consultant. Jeff writes the popular Prof. PowerShell column for, is a regular contributor to the Petri IT Knowledgebase, 4SysOps and the Altaro Hyper-V blog, as well as frequent speaker at technology conferences and user groups. If he isn’t writing, Jeff is most likely recording training videos for companies like TrainSignal or hanging out in the forums at Jeff’s latest books are Learn PowerShell 3 in a Month of Lunches, Learn PowerShell Toolmaking in a Month of Lunches and PowerShell in Depth: An Administrators Guide. You can keep up with Jeff at his blog , on Twitter at @jeffhicks and on Google Plus (http:/

Event details >> Join Meeting

BAVC Virtual Chapter Meeting – “Introduction to Mahout for HDInsight”
Professional Development – Online Event

Language: English

Date: Wednesday, June 12, 2013

Time: 9:00 am – 10:00 am (Mountain Time)

Cost: Free

Speakers: Christopher Price, Senior BI Consultant Pragmatic Works

Summary: In this session, we will introduce a Mahout, a machine learning library that has multiple algorithms implemented on top of Hadoop and HDInsight. We will start by introducing the foundational concepts needed to understand clustering, classification and collaborative filtering before demonstrating what it takes to get started with Mahout. In addition to learning how you get Mahout set-up, you will learn what it takes to process and prepare data, how to execute an embarrassing parallel batch recommendation job and subsequently how to integrate the result back into your existing ecosystem.

About Christopher: Christopher Price is a senior business intelligence consultant with Pragmatic Works, based in Tampa, FL. He has a bachelor’s degree in MIS and an MBA, both from the University of South Florida, and previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and data integration, data quality and MDM, SSAS, SharePoint, and Big Data. Chris regularly speaks at SQLSaturday, Code Camp, and other community events. He has authored multiple whitepapers and books and served as technical editor for others.

Event details >> Register

The BI Guy’s Little Guide to Big Data
PASS Big Data Virtual Chapter – Online Event

Language: English

Date: Tuesday, July 23, 2013

Time: 1:00 pm – 2:00 pm (Mountain Time)

Overview: You know Pig is more than a farm animal and that Hive is not some ultra-hip bar. You’ve beyond the buzz words and the word count demos. Now¦you’re ready to figure out how it all fits in. In this session we will review common integration scenarios, proven patterns and best practices for integration Big Data solutions into your existing data warehouse and BI architecture. Learn how you too can ride the Big Data wave without reinventing the wheel to both enhance the information you currently deliver while solving problems that were previously unapproachable.

Speaker: Christopher Price

About Chris: Chris Price is a Sr. BI Consultant with Pragmatic Works based out of Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He began his career as a developer working his way into a software architect role before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQL Saturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor for a range of BI topics. You can follow Chris on his blog at or on Twitter at @BluewaterSQL.

Cost: Free

Event details

SSIS – Effective Control Flow Execution

Language: English

Date: Wednesday, July 24, 2013

Time: 2:00 pm – 3:00 pm (Mountain Time)

Cost: Free

Summary: Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting help of Foreach Loop container. Foreach loop container provides ability to loop through items of a list. There are 7 types of enumerators for using in this Foreach loop, which provides wide range of lists to be used in loop structure. For example looping through array of items in a variable, or nodes and elements of an XML data, or looping through excel sheets, looping through SQL Server data objects…. In this session audience will learn about all 7 types of enumerators, and real world scenarios of using them in SSIS packages. One of the main benefits of loop structures are helping in creating dynamic task execution, for example dynamic data flow. In this session, there will be samples of creating dynamic data flows with help of Foreach Loop enumerators.

Speaker: Reza Rad: Author, Trainer, Speaker and Senior DW/BI Consultant

About Reza Rad: He has a BSc in Computer engineering; he has more than 10 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for three continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: . He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCTS and MCITP of BI. He is the leader of New Zealand Business Intelligence users group. He is a Technical Speaker in TechEd, SQL Saturdays, SQL users groups, and Conferences. And He is a Microsoft Certified Trainer.

Event details >> Register

By |July 14th, 2013|Categories: Uncategorized|Tags: , |

PASS Summit 2013

PASS Summit is the world’s largest and most intensive technical training conference for Microsoft SQL Server and BI professionals. But more than that, it’s your conference planned and presented by the SQL Server community, for the SQL Server community.

Join the conference in Charlotte and get the top-notch training, technical tips and tricks, and networking and connections you need to take your SQL Server skills to the next level.

WhatPASS Summit 2013

Dates: October 15-18, 2013

Location: Charlotte, NC

VenueCharlotte Convention Center


Rates and Schedule

Application & Database Development

The primary audience for this track is developers and database administrators focused on building and supporting successful applications using SQL Server and related technologies. This track provides in-depth knowledge from industry experts who have successfully used the technologies to solve complex tasks and build real solutions. The track is designed to cover all aspects of SQL Server and related application development, including architectural design, coding, testing, troubleshooting, data access methods, and optimization.

BI Information Delivery

Designed for BI architects, application developers, and BI analysts, this track addresses the implementation and use of front-end technologies that deliver BI to business users and enable self-service BI. It will cover concepts and implementation, best practices, and lessons learned. Specific technologies include SQL Server Reporting Services, SharePoint Server, Performance Point Services, PowerPivot for Excel and SharePoint, Power View, Report Builder, Excel and Excel Services, Visio, and .NET. Topics will include scorecards, dashboards, and self-service BI.

PASS Summit offers the following 6 tracks to choose from;

BI Platform Architecture, Development & Adminstration

Designed for BI architects, developers, and administrators, this track focuses on BI infrastructure, administration, architecture, and development on the Microsoft BI Platform. Technical content will cover SQL Server Analysis Services, SQL Server Integration Services, SQL Server Master Data Services, SQL Server Reporting Services, and troubleshooting and administration of SharePoint Server. Focus will be on best practices and lessons learned, upgrading and migration, scale-up and scale-out strategies, and new capabilities to consider for rollout and deployment.

Cloud Application Development & Deployment

This track is for developers and IT professionals interested in leveraging their existing SQL Server skills to take advantage of the benefits of Windows Azure Data Services. It focuses on concepts and application design, best practices, and lessons learned – whether attendees are looking to develop directly in the cloud, utilize a private cloud solution, or extend their existing environment for a hybrid solution.

Enterprise Database Administration & Deployment

This track is designed to equip IT professionals for the challenges inherent in the ever-changing database environment and to prepare them to work efficiently with other professionals involved in enterprise database systems. It addresses the diverse range of topics that DBAs face when working in a production database environment, including consolidation and virtualization, application integration, web integration, capacity planning, data warehousing, and security.

Professional Development

This track offers something for every data professional, whether they are a SQL Server administrator or developer or a BI specialist. It includes sessions to help attendees further their career, with focus on technical writing, speaking, project management, career planning, interviewing for a new job, making the move into management, and more.

Click here for more event details

By |June 9th, 2013|Categories: Uncategorized|Tags: |

PASS SQL Saturday Events : June 2013


PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.  Please note that in order to attend one of these event, you must register (registration links are provided for each event).  Please register soon as seating is limited, and let friends and colleagues know about the event.  Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza).


#229 / Dublin, Ireland

Date: Saturday, June 21-22, 2013

Time: Friday 9:00 am – 5:00 pm
Saturday 9:00 am – 5:00 pm

Cost: Saturday Free + $22.00 (11Euro) For lunch

Venue: Hilton Dublin, Charlemont Place, Dublin 2

This year they are hosting a two-day, training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development.

Friday Preconference Training Day (21st of June) will contain 3 fantastic full day training sessions:
– Productivity and Leadership Skills for the IT Professional by Kevin Kline
– Self-Service BI and Office 2013 by Chris Webb
– SSIS, MDS and DQS by Matt Masson
These full-day sessions can be booked for ‚¬249.

SQLSaturday – the GATHERING (22nd of June) will be free one-day training community event with a range of well-known Microsoft speakers, MVP speakers and new community speakers.

Register Now!
Admittance to this event is free, however we do have an optional charge ‚¬11 to offset the costs of providing lunch for everyone on the day.

Hotel Accommodation
22nd of June will be a busy night for Dublin hotels. The Hilton Hotel have given us a special rate for our delegates of ‚¬159 for a single room B&B / ‚¬169 for a double room B&B. These rooms will be allocated on a first-come, first served basis…. so don’t hesitate, book now to avoid disappointment!

Event details >> Register

#226 / South Florida – Davie, FL

Location: 3301 College Ave, Davie, FL, 33314

Date: Saturday, June 29, 2013

Time: 8:00 am – 5:00 pm ?

Cost: Free, Includes lunch

Event details >> Register

Submitted Sessions

Here is the list of sessions submitted so far. The goal is to feature as many different speakers and topics as possible, but space limitations prevent from accepting every session. Details on each session can be found by clicking the links below.

Title Speaker Level
(Way Too Much) Fun with Reporting Services Stacia Misner Beginner
A Balanced BI Approach (Self-Service & Corporate) Anthony Sammartino Intermediate
A Big Data Primer Stacia Misner Beginner
Agile BI with SQL Server 2012 and TFS 2012 Mohamed Kabiruddin Intermediate
AlwaysOn – Finally, A usable ‘mirror’! Jim Murphy Beginner
Applied Enterprise Semantic Mining Mark Tabladillo Intermediate
Bad, less Bad, not Bad; rewriting bad SQL Code Jeffrey Garbus Beginner
Best Practice Data Visualization Jen Underwood Intermediate
Building a SQL Server for Optimal Performance Gareth Swanepoel Beginner
Building a Windows 8 app from scratch (English) Russell Fustino Beginner
Building Your Own SQL Server Virtual Playground Kendal Van Dyke Intermediate
Changing Data Is Easy, Managing Data Change is Hard! James McAuliffe Intermediate
Code Paradigms in BIDS Frank Quintana Intermediate
Column Level Encryption David Dye Beginner
Dashboard Do’s and Don’ts Stacia Misner Beginner
Data Mining Innovation with SQL Server 2012 Mark Tabladillo Advanced
Data Partitioning in VLDB Dmitri Korotkevitch Advanced
Data Profiling, Cleansing, Enrichment & Matching with SSIS Christopher Price Beginner
Database Design Disasters: Common Mistakes Found in the Wild Richie Rump Intermediate
Dealing With Errors in SSIS 2012 David Dye Advanced
Discover, Document, & Diagnose Your Servers on Your Coffee Break Kendal Van Dyke Beginner
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers Richie Rump Intermediate
ETL Automation Using SSIS Jorge Novo Intermediate
Exploring The Microsoft Reporting Technologies David Ortiz Beginner
From 0 to big data in 60 minutes Luis Figueroa Intermediate
Getting started with Master Data Services 2012 Luis Figueroa Beginner
HDInsight: What’s all the Hadoopla about Big Data? Rafael Salas Intermediate
Help! I’ve Got XML In My Database! Kendal Van Dyke Intermediate
How to be a GREAT DBA Jeffrey Garbus Beginner
Implementing a HIPAA Compliance Strategy with SQL Server Brandon Leach Beginner
Implementing Auditing in SQL Server 2012 David Dye Beginner
Indexing for Join Optimization Jeffrey Garbus Advanced
Indexing for performance Jeffrey Garbus Intermediate
Into the Wild,Taming Unstructured Data Christopher Price Intermediate
Introducing Cube World To Users From Flat Table Land Michael Antonovich Intermediate
Introduction to SQL Server Replication Chad Churchwell Beginner
MDS in Practice: An Integrated Approach Christopher Price Beginner
Moving Big Data – SSIS, Pig, and Sqoop John Welch Beginner
PowerShell Working with XML and SMO Max Trinidad Intermediate
Present This, Not That! Kendal Van Dyke Beginner
Putting Quality Back Into Your Data Analysis Michael Antonovich Intermediate
Report Builder: Reports made Easy. Yelena Pavlyuk Beginner
Secrets of Enterprise Data Mining Mark Tabladillo Intermediate
Self-Service ETL and Data Explorer: Are we there yet? Rafael Salas Intermediate
Self-Service Visualization with Power View Anthony Sammartino Beginner
Social Marketing 2013 for Microsoft Professionals Mark Tabladillo Beginner
SQL Server – Practical Troubleshooting Dmitri Korotkevitch Intermediate
SQL Server 2012 AlwaysOn for HA and DR Chad Churchwell Intermediate
SQL Server 2012 AlwaysOn Step-by-Step David Bermingham Intermediate
SQL Server 2012 ColumnStore Indexes Gareth Swanepoel Intermediate
SQL Server 2012 IaaS and SQL Database In Depth Herve Roggero Intermediate
SRS Report Builder for Business Intelligence David Eichner Beginner
SSAS Tabular and PowerPivot – Choose Your Own Adve Anthony Sammartino Intermediate
SSIS – Integrating PowerShell in a ScriptTask component Max Trinidad Intermediate
SSIS Programming using .Net Jorge Novo Advanced
SSIS Programming Using .NET Jorge Novo Advanced
Stay ahead with Change Data Capture Jose L. Rivera Intermediate
Taking BI to the Next Level: Collaboration Stacia Misner Intermediate
TempDB under the hood Sam Mesel Advanced
The T-SQL Features in SQL Server 2012 You Can’t Ignore Richie Rump Intermediate
Tips on how to get your next GREAT job! Hanneh Bandi Non-Technical
Tuning Analysis Services Processing Performance John Welch Advanced
Unit Testing SSIS Packages John Welch Intermediate
Upgrade your TSQL to the NEXT level Jose L. Rivera Intermediate
Visualizing Data with Reporting Services Christopher Price Beginner
Whats New in T-SQL With SQL Server 2012 David Dye Beginner
Wrangling performance with Resource Governor Brandon Leach Beginner
Zero To Cube in 60 Minutes Dustin Ryan Beginner


By |June 9th, 2013|Categories: Uncategorized|Tags: , |

PASS Virtual Chapter Events : June 2013

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.


HASSUG & H-BI Monthly Meeting – June 11, 2013
In-Person & Online Event

Language: English

Date: Tuesday, June 11, 2013

Time: 12:30 pm – 3:30 pm (Mountain Time)

Cost: Free

Featured Presentation

Extend Your Knowledge with Extended Events!

Speaker: Janis Griffin, Senior DBA Confio Software, Inc.

Summary: SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data alongside of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies in 2012.

About Janis: Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database instances. Her primary focus has always been database performance. Before coming to Confio, she held many DBA posi