PASS Virtual Chapters Archives - Page 2 of 2 - DawaBI

PASS Virtual Chapters

PASS Virtual Chapter Events : May 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.


Adam Belebczuk – Introduction to SQL Server 2012 A
DBA Fundamentals – Canada/US Online Event

Language: English

Date: Tuesday, May 7, 2013

Time: 11:00 am – 12:00 pm (Central Time)

Cost: Free

Event details >> Register

TBA – “Details of our upcoming event are still being ironed out…”
Professional Development – Online Event

Language: English

Date: Wednesday, May 8, 2013

Time: 11:00 am – 12:00 pm (Mountain Time)

Cost: Free

Event details >> Register

HASSUG & H-BI Monthly Meeting
Professional Development – Online Event

Language: English

Date: Tuesday, May 14, 2013

Tentative Schedule:

10:30-10:40 Announcements
10:40-11:45 General presentation (Topic 1)
11:45-12:15 Lunch\Networking Raffle #1
12:15-1:20 BI themed presentation (Topic 2)
1:20-1:30 Recap Announcements Raffle #2

Time: 10:30 am – 1:30 pm (Mountain Time)

Cost: Free

Event details >> Register

Robert Davis – Case Study: Designing a Global Scaled-out Architecture Level

Summary: How do you deliver a public-facing website on a global scale? To be truly competitive in a global market, you need to deliver a high performing website no matter what part of the world the user is in. Scaling out websites to multiple locations is easy, but it doesn’t really provide the performance required if the website has to get data from halfway around the world. This session will look at the challenges to scaling out the entire application to meet global performance requirements and how we addressed these challenges for an existing web application.

About Robert: Robert is a SQL Server 2008 Certified Master and an experienced Database Administrator, SQL Server evangelist, speaker, writer, and trainer. He has worked with SQL Server for 13+ years, most recently as Chief SQL Server Evangelist for Idera Software. Previously he served as PM for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft. Robert helped found the PASS Data Architecture Virtual Chapter and was co-author of Pro SQL Server 2008 Mirroring

Language: English

Date: Thursday, May 16, 2013

Time: 11:00 am – 12:00 pm (Mountain Time)

Cost: Free

Event details >> Register

SQL Server Disk I/O
WVPASS – Canada/US

Language: English

Date: Thursday, May 16, 2013

Time: 4:00 pm – 6:00 pm (Mountain Time)

Cost: Free

Event details >> No registration link provided

HBase and HDInsight Java Script Console
PASS Big Data Virtual Chapter

This session continues on building an understanding on HadoopmEcosystem Components, with a focus on HDinsight Javascript shell and NOSQL DB HBase.

Language: English

Date: Tuesday, May 21, 2013

Time: 11:00 am – 12:00 pm (Mountain Time)

Cost: Free

Event details >> Register

PASS Virtual Chapter Events – September 2012

PASS DBA Fundamentals Virtual Chapter / Twitter:  @DBAFundVC

September 4, 2012 – 11:00 a.m. CST

Introduction to SQL Server Service Broker

Speaker:  Adam Belebczuk

In this session, we’ll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos.  We’ll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases.  If you’ve ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won’t want to miss this session.

Speaker Bio:  Adam Belebczuk is a Developer turned Accidental DBA that works for a small SaaS provider in Cleveland, Ohio.  Adam is an MCITP DBA 2005/2008 and belongs to the Ohio North SQL Server User Group & Professional Association for SQL Server (PASS).  In addition to all things technological, he also loves to make electronic music, cook, go skiing, read, and help educate his fellow geeks whenever the opportunity presents itself.

Contact URL:


PASS Data Warehousing and Business Intelligence Virtual Chapter

Web: / Twitter:  @PASSBIVC / Email:

September 6, 2012 – 12:00 p.m. EDT

Exploring Your Data with Power View

Speaker:  Jessica Moss


Exploring your data has never been easier with Power View included in SQL Server 2012.  Learn how to analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool.  This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one.

Speaker Bio:  Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence.  Jessica’s expertise includes data warehouse modeling, Integration Services ETL’s Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their business intelligence solutions.  Jessica enjoys sharing her knowledge with the central Virginia community, speaks regularly at user groups, code camps, and conferences, and has co-authored technical books.  You can read more on her website:


PASS SQL Professional Development Virtual Chapter

September 12, 2012 – 10:00 a.m. PST

The Art of the Question – How can IT Pros be more successful?

Speaker:  Brian Moran


PASS SQL Performance Virtual Chapter


September 27, 2012 – 6:00 p.m. GMT

I feel the need . . . the need for speed

Speaker:  Jeff Renz

Every project that I worked on I’ve always felt that users want everything to be fast . . . really fast.  Since we tend to be constrained by time and money we want to best leverage the tools and techniques that make the project successful . . . “fast.”  With the introduction of SQL 2012 we need to understand what we get by implementing a SQL Server 2012 solution.  That led me to these questons:

Is SQL Server 2012 really faster and more efficient than SQL Server 2008 R2 when I load data and query data?  Does a SQL Server 2002 Tabular model perform the same as a SQL 2012 Dimensional Model?  Are there really any performance differences when loading data using SSIS 2012 compared to other data loading approaches?  Does SQL Server 2012 offer me anything specific that would cause me to change how I would design my database to take advantage of new performance features?  Find out the answer to these questions and more in my session.

Speaker Bio:  Jeff Renz has developed databases using SQL Server for over 13 years, primarily focused on global manufacturing and supply chain data collection and reporting.  In the past two years he has implemented two large data warehouses using data vault architecture for Abound Solar.  Jeff has a Bachelors degree in computer sciences and a Masters degree in operations research from the Colorado School of Mines.  Jeff is a Certified Data Vault Data Modeler by the Genessee Academy.

View the Live Meeting:



By |September 4th, 2012|Uncategorized|

PASS Virtual Chapter Events – July 2012


Date:  Thursday, July 10

Time:  11:00 a.m. – 12:00 p.m. Central Time

Virtual Chapter:  DBA Fundamentals

Event URL: (Meeting ID TW8M35, Entry Code Prxcw2F-H)


Subject:  ‹DBA

Now that you’re a DBA where do you start?  You have backups, don’t you?  Are you really sure?  Tools for the DBA really help you do your job, so we will talk about some tools to use.  I’ll talk about how you can get help when you need it.  I’ll point you to some really good scripts to use for monitoring or for using for your whole maintenance cycle on your SQL Servers.

‹Presenter:  David Smithey has 31 years of IT experience.  He has 9 years of experience as an SQL Server DBA and before that he was a developer.  He has worked/consulted for companies such as Acustar, Computer Services Corporation, the Pentagon, Boeing and NASA.  He is currently employed by Curves International.  ‹Email: ‹ Twitter:  @DavidKSmithey


Date:  Thursday, July 26

Time:  12:00 p.m. – 1:00 p.m. Central Time

Virtual Chapter:  Data Architecture Virtual Chapter

Event URL:

Subject:  ‹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 lifestyle
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
‹Presenter:  ‹Ami Levi, 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.
By |June 21st, 2012|Uncategorized|