PASS DBA Fundamentals Virtual Chapter
fundamentals.sqlpass.org / 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: http://www.SQLDiablo.com
PASS Data Warehousing and Business Intelligence Virtual Chapter
Web: http://BI.sqlpass.org / Twitter: @PASSBIVC / Email: PASSDWBIVC@sqlpass.org
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: http://www.jessicammoss.com.
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: www323.livemeeting.com/cc/usergroups/webJoin?id+G2JHM2&pw=W%5Dw5%22K45B&role=attend