Archived Events

Next Meeting: Thu, Jan 15 2015

EDMPASS Jan-2015 Meeting with Glenn Berry

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=MN6B24&role=attend&pw=X%5E2Bxh2wg
RSVPURL: https://www.eventbrite.ca/e/edmonton-sql-server-user-group-jan-2015-meeting-with-glenn-berry-tickets-14945599691

Agenda:

5:30 pm - Food and socializing

5:45 pm - Group announcement - Brent Flesher

6:00 pm - Feature Presentation -  Glenn Berry

8:00 pm - Networking

 

When

iCal
UTC : Fri, Jan 16 2015 00:30 - 04:00
Event Time : Thu, Jan 15 2015 17:30 - 21:00 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Fri, Jan 16 2015 00:30 - 04:00

Where

10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room
Edmonton, Alberta
Direction: None

Featured Presentation

Analyzing I/O Subsystem Performance

Speaker: Glenn Berry, Principal Consultant SQLskills

Summary: SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

About Glenn: Glenn Berry works as a Principal Consultant at SQLskills in Parker, CO. He is a SQL Server MVP and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. Glenn is also an adjunct faculty member at University College - University of Denver, where has been teaching since 2000, and has completed the Master Teacher Program at Denver University - University College. He wrote the book "SQL Server Hardware," and blogs regularly at http://sqlserverperformance.wordpress.com.

Attachments

Older Meetings

 

 

EDMPASS - September 2012 Meeting w/Kevin Boles

 

 
Date: September 18 2012

Time: 5:00 pm - 7:00 pm

Location: 3rd floor - Standard Life Building, 10405 Jasper Avenue, Edmonton, AB T5J 4M8

Speaker: Kevin Boles

Topic: Common TSQL Mistakes

Session Abstract:

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over twenty times now and it is always very highly rated! 

Presenter Information: Kevin Boles (LinkedIn Twitter)

Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With almost 20 years of database experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 years. His passion is the relational engine, especially scalability, performance analysis and tuning.

Agenda:
 5:00 pm - Food and Socializing
 5:30 pm - Sponsor Presentation
 5:45 pm - Feature Presentation
 7:00 pm - Wrap Up

If you haven’t signed up already at edmpass.sqlpass.org please do so now to receive meeting notifications, news, and updates from EDMPASS.

See you all there.

PowerPoint and SQL Script

 

EDMPASS - April Meeting w/Adam Neiman

On April 19th 2012 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/3290649421

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: April 19th 2012
Time: 5:00 pm - 7:00 pm
Location: 3rd floor 10180-101 st. (Manulife Place - Windsor Room)
Speaker: Adam Neiman
Topic: Superstar SSIS

Session Abstract:

With the introduction of SQL Server Integration Services (SSIS) database developers have been offered a fantastic grab-bag of options to build solutions for their ETL and Data Migration problems. While every solution has its own unique requirements, there are some simple best practices that every developer can use to upgrade a normal package into an integration superstar. Topics covered will include:

· Strategies for simplifying your configuration
· Practical advice for avoiding common ETL mistakes
· Consolidating data from multiple sources
· Logging, tracking, and reporting strategies

Presenter Information: Adam Neiman

Adam Neiman is a senior technical analyst in the Edmonton Business Intelligence group at Ideaca. He has more than 10 years of experience in database development and business intelligence development using the Microsoft Business Intelligence technology stack and Oracle database systems. He has earned his MCTS and MCITP in Microsoft SQL Server 2008 BI technologies as well as his Oracle 9i CA.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

POWERPOINT PRESENTATION

SQL SCRIPTS

SSIS PACKAGES

EDMPASS - March Meeting w/Colin Stasiuk

On March 29th 2012 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/3046360747

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: March 29th 2012
Time: 5:00 pm - 7:00 pm
Location: 3rd floor 10180-101 st. (Manulife Place - King Edward Room)
Speaker: Colin Stasiuk
Topic: SQL 2012 - When Worlds Collide

Session Abstract:

This intro to SQL Server 2012 presentation is going to look at some of the new features and functionality for not only the DBAs (EDMPASS) but also the developers (EDMUG). For the developers in the audience we’re going to discuss and demo new features like paging, result sets, sequence numbers and throws and for the DBAs in the room we’ll discuss AlwaysOn, contained databases, and user defined server roles. Hopefully this will help get you prepared and excited for the upcoming release of SQL Server 2012.

Presenter Information: Colin Stasiuk ( blog | twitter )

Colin Stasiuk is an MCP, MCTS SQL 2005/2008, MCITP DBDEV, and MCITP DBA. Currently, he is an independent consultant contracted to Invidi Technologies Corporation and also provides remote database support and monitoring through his SQL Wingmen service offering. Colin is an accomplished Microsoft SQL Server DBA who has been working with SQL Server since 1996. He is the owner of Benchmark IT Consulting and is always willing to lend a hand with questions in many SQL Server community forums and via Twitter. His specialties include SQL Server Administration, Performance Tuning, Security, Best Practice / Standards, Upgrades, and Consolidation. Colin is the Regional Mentor for PASS Canada, President and founder of EDMPASS, and co-author of Pro SQL Server 2008 Policy-Based Management.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.
ATTENDEE LIVEMEETING LINK - (coming soon)

EDMPASS February Meeting w/Jason Strate

On February 16th 2012 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/2865521853

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: February 16th 2012
Time: 5:00 pm - 7:00 pm
Location: 3rd floor 10180-101 st. (Manulife Place - King Edward Room)
Speaker: Jason Strate
Topic: Extended Events, Work Smarter Not Harder

Session Abstract:

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

Presenter Information: Jason Strate ( blog | twitter )

Jason Strate, Digineer Inc, is a DBA with over fifteen years of experience. He is a recipient of the Microsoft Most Valuable Professional (MVP) for SQL Server since July, 2009. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Certification exams for SQL Server 2008.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.
ATTENDEE LIVEMEETING LINK - https://www.livemeeting.com/cc/usergroups/join?id=SP94SC&role=attend&pw=X%5E2Bxh2wg

EDMPASS - January Meeting w/Ryan Adams

On January 12th 2012 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/2653305107

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: January 12th 2012
Time: 5:00 pm - 7:00 pm
Location: 6th Floor Room 7 (Stanley A Milner Library)
Speaker: Ryan Adams
Topic: Mirroring: The Bare Necessities

Session Abstract:

Remember Baloo the bear from the Jungle Book? Well we are going to get down to the “bear” necessities of mirroring and more. Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.

Presenter Information: Ryan Adams ( blog | twitter )

Ryan is a highly skilled Microsoft oriented administrator and has worked for a Fortune 100 company for 14 years (2 of those as a contractor). In his time there he has supported everything from desktop to server. Most recently he has served as a senior Active Directory Architect and Identity Management (MIIS, ILM, FIM) Consultant. He is the sole SQL Server DBA for his group, supporting both vendor databases and custom databases. His primary focus is database design and performance, but also works with SSRS report development, and SSIS ETL. He enjoys being involved in the SQL community and serves on the Board of Directors for the North Texas SQL Server User Group as well as the PASS Performance Virtual Chapter. He also serves as a Regional Mentor for the Professional Association for SQL Server. He is well versed in many core Microsoft technologies, has implemented and supported them both nationally and internationally for a company of 250k+ users, and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

For those who are unable to attend in person here is the Live Meeting Attendee Link:

https://www.livemeeting.com/cc/usergroups/join?id=78DJ42&role=attend&pw=X%5E2Bxh2wg

Hope to see you there.

EDMPASS - December Meeting w/Jes Borland (Virtual)

On December 8th 2011 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/2447251796

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: December 8th 2011
Time: 5:45 pm - 7:00 pm
Location: Virtual (sorry the room was booked :(
Speaker: Jes Borland
Topic: Reporting Services 201: From Basic to WOW!

Attendee URL: https://www.livemeeting.com/cc/usergroups/join?id=R7D472&role=attend&pw=qW-%5CP%29%228Z

Meeting ID: R7D472
Attendee Entry Code: qW-\P)”8Z
Session Abstract:

You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from basic to “wow”, using features such as tablix, lists, images, and charts. At the end of this session, you will be familiar with:

- Report properties such as headers, footers and backgrounds
- Tablix properties such as ToolTip and NoRows
- How to build and customize a matrix
- How to effectively use lists, an often-overlooked feature
- Adding charts to make reports visually appealing and easy to understand

Presenter Information: Jes Borland ( blog | twitter )

Jes Schultz Borland is a Database Administrator at Kimberly Clark. She holds an AAS - Programmer/Analyst degree. She has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, the PASS WIT virtual chapter, and the MADPASS chapter. She is also an avid tweeter, blogger and runner.

Agenda:

5:45 pm - Feature Presentation

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there (Virtually :) ).

EDMPASS July 2011 - LiveMeeting Presentation Recording

On July 27th EDMPASS was lucky enough to have Jen McCown (@MidnightDBA) as a guest (virtual) speaker.

Here is the session abstract: Unraveling Tangled Code - A Spellbinding Tale of Victory Over Chaos

Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious!

If you were unable to attend the Live Meeting session here is a recording of the presentation.

 

Big thanks to Jen for doing this for us and if you are a SQL Server presenter and have interest in doing a Live Meeting session for EDMPASS please feel free to contact me.

EDMPASS - July Meeting w/Jen McCown

On July 27th 2011 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

Date: July 27th 2011
Time: 5:45 pm - 7:00 pm (MST)
Location: Virtual - Live Meeting
Speaker: Jen McCown
Topic: Unraveling Tangled Code – A Spellbinding Tale of Victory Over Chaos

You will need the Attendee URL: https://www.livemeeting.com/cc/usergroups/join?id=PW3NMB&role=attend&pw=J%3D%3Fb88*Ms

 

Meeting ID: PW3NMB

Attendee Entry Code: J=?b88*Ms

Session Abstract:

Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious!

Presenter Information: Jen McCown (@MidnightDBA)

http://www.midnightdba.com/Jen/

Jen McCown, MVP, is a SQL Server developer and DBA, currently serving as the lead DBA at a state trade association in Texas. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She also writes for Petri IT Knowledgebase and is a forum moderator. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She has presented at multiple SQL Saturday and 24 Hours of PASS events, PASS Summit 2010, and PASS SQLRally 2011.

Agenda:
5:45 pm - Feature Presentation
7:00 pm - Wrap Ups

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there (virtually).

EDMPASS - February Meeting w/Todd McDermid

On February 16th 2011 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/1268741841

Please be sure to not only click the “Add to my calendar” but also the “Register” button

Date: February 16th 2011
Time: 5:45 pm - 7:00 pm
Location: Virtual - Live Meeting
Speaker: Todd McDermid
Topic: Diagnosing and Addressing Performance in SSIS

You will need the Attendee URL: https://www.livemeeting.com/cc/usergroups/join?id=PZDJ5Z&role=attend&pw=9%5B%7DXG9%7Erp

Meeting ID: PZDJ5Z

Attendee Entry Code: 9[}XG9~rp

Session Abstract:

Integration Services is a complex system of parallelism and in-memory buffers. Determining what parts of your package are causing sub-par performance requires some specific techniques. Before you apply any “top ten” performance enhancements, you need to identify where the issue is - or you’ll be wasting your time. Learn what tools are available for monitoring and diagnosing poor performance in SSIS packages and how to apply them. Dive in to the only way to diagnose Data Flow bottlenecks - decomposition - and how to effectively address the most common causes.

Presenter Information: Todd McDermid (@Todd_McDermid)

http://toddmcdermid.blogspot.com/
Todd has a bachelor’s degree in Computer Science, and has earned the MCAD, MCSD and MCTS (SQL 2008 BI) Microsoft Certifications. In 2009, he earned a Microsoft Most Valuable Professional award for supporting the SQL Server community.

Agenda:
5:45 pm - Feature Presentation
7:00 pm - Wrap Ups

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there (virtually).

EDMPASS - January Meeting w/Jason Strate

On January 26th 2011 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/1156827101

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: January 26th 2011
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room - Basement
Speaker: Jason Strate
Topic: Solving Business Pains with SQL Server Integration Services

Session Abstract:

SQL Server Integration Services (SSIS) offers a wide range of features and functionality that can be used to solve business pains within Extract, Transform, and Load (ETL) processes. These pains can be caused by the performance of current ETL process, the maintainability of ETL processes or represent a new pain that SSIS features can resolve. This presentation will provide a demonstration of real world scenarios where features of SSIS were used to solve business pains through modification of existing SSIS packages or through the creation of new SSIS packages. The session will also discuss current best practices in SSIS package design.

Presenter Information: Jason Strate (@StrateSQL)

http://www.jasonstrate.com/
Jason Strate, Digineer Inc, is a database architect and administrator with over fifteen years of experience. He is a recipient of the Microsoft Most Valuable Professional (MVP) for SQL Server since July, 2009. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008.

Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings. Jason is also a contributing author for the Microsoft white paper “Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition.” Jason is an active blogger with a focus on SQL Server and related technologies.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS - No October Meeting Scheduled

After the response that we got for our last meeting we’re trying to get another great BI expert to speak in November.

EDMPASS.com will have all the details as they become available.

Thanks

EDMPASS September Meeting w/Stacia Misner

On September 29th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/842717591

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: September 29th 2010
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room - Basement
Speaker: Stacia Misner
Topic: Using SSAS To Develop Cubes

Session Abstract:

Using SQL Server Analysis Services (SSAS) to develop cubes gives users an easier way to explore and analyze data to make better decisions faster. In this session, we’ll start by discussing the architectural requirements for supporting SSAS and how to model data for SSAS. Then we’ll learn how to develop the key components of an SSAS database, and how to make a cube available to end users. By the end of this session, you should understand why SSAS should be part of your data infrastructure, how to get started, and where to learn more.

Presenter Information: Stacia Misner (@StaciaMisner)

http://blog.datainspirations.com/


Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solutions since 1999. With more than 25 years of experience in IT, she is the author or co-author of nine books about BI. Her most recent books include Building Integrated Business Solutions with SQL Server 2008 R2 & Office 2010 and Introducing SQL Server 2008 R2. Stacia provides consulting and custom education services through Data Inspirations, writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS - August Meeting w/Aaron Nelson

On August 25th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/792195478

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: August 25th 2010
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room - Basement
Speaker: Aaron Nelson
Topic: Powershell for Database Professionals

Session Abstract:

In this session we will begin exploring the amazing world of the PowerShell language. We will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell; then we will change these into multi-server scripts by adding only a single line of code. We will also take a look at some data visualization techniques that require only a small amount of code. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell and ready to practice it when they leave. Yes you will get a copy of the scripts I use.

Presenter Information: Aaron Nelson (@SQLvariant)

sqlvariant.com/wordpress/
Aaron Nelson is a Senior SQL Server Architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server.
He has experience managing enterprise-wide data needs in both transactional and data warehouse environments. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V).

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS - July Meeting w/Brent Ozar

On July 7th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/686883487

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: July 7th 2010
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room - Basement
Speaker: Brent Ozar
Topic: Virtualization and Magicians: Dealing with Virtual SQL Server

Session Abstract:

Virtualization and Magicians: Dealing with Virtual SQL Server

So the sysadmins told you they’ve learned a few tricks, and they’re going to virtualize your database servers. In this session, we’ll talk about our real-world experiences with virtual SQL Servers and how to help the sysadmins avoid implementation mistakes that will saw SQL Server’s performance in half.
  • How to configure CPU, memory and storage for virtual environments
  • How to benchmark your servers and make sure they’ll handle your loads
  • Common pitfalls like antivirus definition downloads that can cripple your servers
  • What to watch for after V-day

Presenter Information: Brent Ozar

Brent is a SQL Server Domain Expert with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor.

Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He’s currently writing SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, and Justin Langford. He’s Editor-in-Chief at SQLServerPedia.com, where he also records video podcasts.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS Meeting - May 26th w/Colin Stasiuk

On May 26th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/623637316

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: May 26th 2010
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room - BASEMENT
Speaker: Colin Stasiuk
Topic: Policy Based Management… not JUST for SQL Server 2008

Session Abstract:

Policy Based Management… not JUST for SQL Server 2008

In this live session we’re going to be getting a quick overview of Policy Based Management for the people who are not familar with it but then the “guts” of the presentation will be showing how to work with Policy Based Management in previous versions of SQL Server (2000 and 2005).
 
The biggest misconception I’ve heard time and time again is…. “Policy Based Management sounds great but I’m still on SQL 2000 or SQL 2005″. Out of the box Policy Based Management can evaluate previous versions of SQL Server but we’re going to take that knowledge and with the use of PowerShell we’re going to expand on it and created an automated solution of evaluating and tracking not only your SQL 2008 instances but also your SQL 2000 and SQL 2005 instances.
 
Please be advised that this presentation may go over time as there will be alot of content covered and live demos and Q&A.

Presenter Information: Colin Stasiuk
 

Colin Stasiuk is an MCP, MCTS SQL 2005/2008, MCITP DBDEV, and MCITP DBA. Currently, he is an independent consultant contracted to Vantix Systems and working for the Government of Alberta.

Colin is an accomplished Microsoft SQL Server DBA who has been working with SQL Server since 1996. He is the founder of Benchmark IT Consulting and is always willing to lend a hand with questions in many SQL Server community forums and via Twitter (http://twitter.com/BenchmarkIT) . His specialties include SQL Server Administration, Performance Tuning, Security, Best Practice / Standards, Upgrades, and Consolidation.

Colin is a proud PASS member, President of EDMPASS, and has recently co-authored a book on SQL Server 2008 Policy Based Management.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS Meeting Tomorrow April 28th 2010

SLIDE DECK NOW AVAILABLE: http://spkr8.com/t/3063/

On April 28th 2010 the Edmonton Chapter of PASS is having a BONUS meeting. Details below:

http://www.eventbrite.com/event/620818886

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: April 28th 2010
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: 6th Floor - Room 7
Speaker: Aaron Bertrand
Topic: SQL Server Management Studio Tips and Tricks

Session Abstract:

SQL Server Management Studio Tips and Tricks

A collection of little things you can do with Management Studio so you can start faster, work smarter, prevent mistakes, and present better.
Presenter Information: Aaron Bertrand

I’ve been blogging on this site since late 2006, after selling the FAQ site I started almost 10 years earlier (aspfaq.com). My focus here is mainly on keeping people up to speed with updates for SQL Server 2005 and SQL Server 2008, as well as deeper info on new features (such as Unicode compression in SQL Server 2008 R2), but I also post the occasional technical post. A recent series of entries I called “Bad Habits to Kick” tied for runner-up in the series category for the PASS Log Reader Awards (my “Stored Procedure Best Practices Checklist” post from last year took first place in the T-SQL category).

I’ve been a Microsoft MVP since 1997, have spoken at several user group meetings, SQL Saturdays and code camps, and this year was involved in a spectacular project with 52 other MVPs, where we each wrote one or two chapters for a unique compilation book called SQL Server MVP Deep Dives - with all author proceeds going to the charity War Child International.

In my day job I am a DBA for OTOLabs , a division of One to One Interactive. My official title is “Senior Data Architect,” but in addition to designing schema and writing data access code, I wear several other hats, including UI developer (C#), occasional blogger, and the target of many anti-Canadian jokes.

During my spare time, I tweet as @AaronBertrand and I try to help people out on StackOverflow. I also file a boatload of SQL Server issues on Microsoft Connect.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS Meeting on April 7th Cancelled

Message from Colin Stasiuk:

“I’d like to apologize to everyone for the missed EDMPASS meeting last night. I was in Calgary for Easter weekend and had some severe abdominal pain that took me to the hospital Sunday and it kept me there on IV with a chance of surgery. I was discharged on Wednesday (last) night. I came back to Edmonton last night and am taking a couple days to recover. This is the first meeting that needed to be cancelled and I feel horrible about it. I hope to see everyone at the next meeting on April 28th

Details: http://www.eventbrite.com/event/620818886

Our May meeting is already booked as well and to go with my book release I’ll be doing a session on Policy Based Management.

Details: http://www.eventbrite.com/event/623637316

I’ll update EDMPASS.com when I get back on my feet a little more and look forward to catching up with all of you.
Thanks
~ Colin”

EDMPASS Meeting April 7th 2010

On April 7th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/597067846

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: April 7th 2010
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: 6th Floor - Room 7
Speaker: Brent Ozar
Topic: Virtualization and Magicians: Dealing with Virtual SQL Server

Session Abstract:

Virtualization and Magicians: Dealing with Virtual SQL Server

So the sysadmins told you they’ve learned a few tricks, and they’re going to virtualize your database servers. In this session, we’ll talk about our real-world experiences with virtual SQL Servers and how to help the sysadmins avoid implementation mistakes that will saw SQL Server’s performance in half.
  • How to configure CPU, memory and storage for virtual environments
  • How to benchmark your servers and make sure they’ll handle your loads
  • Common pitfalls like antivirus definition downloads that can cripple your servers
  • What to watch for after V-day

Presenter Information: Brent Ozar

Brent is a SQL Server Domain Expert with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor.

Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He’s currently writing SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, and Justin Langford. He’s Editor-in-Chief at SQLServerPedia.com, where he also records video podcasts.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS Meeting - January 27th 2010

On January 27th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/503789849

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: Jan 27th 2010
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room - Basement Level
Speaker: Buck Woody
Topic: Improvements in SQL Server 2008 and SQL Server 2008R2

Live Meeting:

  https://www.livemeeting.com/cc/usergroups/join?id=55GG4M&role=attend&pw=q%5C%5C6%5B%23%22gD

 

 

Session Abstract:

“Come hear Buck Woody, Microsoft’s “Real World DBA”, explain the improvements in SQL Server 2008 and SQL Server 2008R2 over SQL Server 2000 and SQL Server 2005. He’ll show you what the new features are for developers and DBA’s and a quick overview of the new Business Intelligence features. He’ll show some practical examples of the new Transact-SQL statements, management features, and data types so that you can figure out where it fits in your organization.”
Presenter Information: Buck Woody (http://blogs.msdn.com/buckwoody/)

Buck Woody has been working with Information Technology since 1981. He has worked for the U.S. Air Force, at an IBM reseller as technical support, and for NASA as well as U.S. Space Command as an IT contractor. He has worked in most all IT positions from computer repair technician to system and database administrator, and from network technician to IT Manager and with multiple platforms as a Data Professional. He has been a DBA and Database Developer on Oracle systems running on a VAX to SQL Server and DB2 installations. Buck has a business degree and several industry certifications, including MCSE, MCDBA and Brainbench DBA. He is the author of over 400 SQL Server articles and five published SQL Server books; he is the site personality on InformIT.com’s SQL web, and was the President of the Tampa SQL User’s Group for 5 years. He was awarded the Microsoft MVP Award in 2006 for SQL Server, and started work in the SQL Server Team at Microsoft a year later. He has over twenty years extensive professional and practical experience in computer networks and database design. He also teaches a Database Design course at the University of Washington.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

December 16th SlideDeck and Notes

A big thanks once again to Trevor Barkhouse for delivering a great presentation via Live Meeting on Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting. Everyone in the room had great things to say about the presentation and didn’t mind at all that the meeting went longer then usual.

Here is the slidedeck from the presentation in pdf format. Download PDF

Also people were asking about a Twitter list for SQL Server Professionals…. this is the best list that I know of. SQLServerPedia Twitter List

Stay Tuned for our January 27th meeting announcement with the one and only Buck Woody!!

For those of you who are not in Edmonton and cannot attend this will be our first attempt at recording a LiveMeeting presentation and making it available to all… Live Meeting link to follow.

~ Colin

EDMPASS Meeting December 16th 2009

** PLEASE NOTE THE CHANGE IN ROOM LOCATION **

On December 16th 2009 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/493354637

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: Dec 16th 2009
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room - Basement Level
Speaker: Trevor Barkhouse
Topic: Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting

Session Abstract:

Over the years, Microsoft Customer Service and Support has developed a number of amazing tools for troubleshooting SQL Server. Thankfully many of these tools have been shared with the public. In this session I will demonstrate the configuration and usage of PSSDiag (for SQL Server 2000) and SQLDiag (for SQL Server 2005 and 2008), which collect valuable diagnostic data.

We will then analyze the data using PAL, SQL Nexus, and a few scripts of my own. Come and see how these tools can save you massive amounts of troubleshooting time!

Presenter Information: Trevor Barkhouse (http://sqlserversleuth.com/)

Trevor Barkhouse is a member of the Database Implementation and Escalations team at Terremark Worldwide, Inc., a leading global provider of IT infrastructure services. His team is responsible for the deployment, maintenance, and problem resolution for several hundred SQL Server instances belonging to Terremark’s customers. Trevor has a passion for automation, performance tuning, and troubleshooting. His years as a software developer (before realizing his love of database administration) led to being very comfortable with coding, T-SQL or otherwise, and his love for automating as much of his work as possible. Trevor is very active in the SQL Server community, presenting to the North Texas SQL Server Users Group (where he also serves on the board of directors) and the Greater Fort Worth SQL Server Users Group.

EDMPASS + Twitter = Hockey Tickets?

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

It’s Bring Your Boss to EDMPASS Day

For the next EDMPASS meeting on November 25th I was thinking that you (as a SQL Server professional) might already know the value of the PASS Summit but it’s their boss that really needs to see/hear the value in order to approve that training request for the Summit in 2010.

So what we’re doing is this… if you get your boss to register and attend the next EDMPASS meeting BOTH you and your boss will be entered in a draw for….

2pyustv

If DJ Hero is not for you… with Christmas coming around the corner I’m sure there is someone on your list that would love it!

So whether it’s the free food, drinks, prizes, or a general thirst for SQL Server knowledge… do what you can to get your boss to register and attend the next EDMPASS meeting on November 25th.

Even if you don’t win DJ Hero, having your boss listen and understand what it means to attend the PASS Summit has more value then you could imagine.

Q: What if I’m my own boss (ie Independent Consultant)

A: Then bring a SQL friend new to EDMPASS for a chance to win

EDMPASS Meeting November 25th 2009

On November 25th 2009 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/485596432

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: Nov 25th 2009
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: 6th Floor - Room 7
Speaker: Thomas LaRock and EDMPASS Summit Attendee Panel
Topic: PASS Summit Panel Discussion

Session Abstract:

Whether you have attended or have not attended a PASS Summit before this meeting is for you. EDMPASS is presenting a panel of EDMPASS Summit attendees as well as Thomas LaRock (SQL Server MVP and PASS Board of Directors Member).

  • Are you wondering what the Summit was like?
  • Do you have questions about specific sessions or speakers, events, etc?
  • Do you want details about the Summit in 2010?
  • Do you want to view an example session?
  • Do you want a chance to win more crazy awesome SWAG giveaways?

2pyustv

We will all be there to share our experiences, stories and to answer any questions you might have. This is going to be a very casual “round table” style of discussion so we hope everyone can attend and learn more about PASS and the Summit in general.

The Summit (for me) was one of those amazing “lightbulb on” type of weeks for me and I’d love to hear other peoples experiences and to also help get people excited about next years Summit.

Presenter Information: Thomas LaRock (http://ThomasLaRock.com)

sql_rockstar_v7

Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a database administration manager with ING Investment Management, Thomas has progressed through several roles at ING, including programmer, analyst, and DBA. Prior to ING, he worked at several software and consulting companies, working at customer sites in the United States and abroad. Thomas holds a MS degree in Mathematics from Washington State University and is a member of the Usability Professional’s Association. Thomas is also a member of Quest’s Association of SQL Server Experts, currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is a SQL Server MVP.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

SPECIAL RAFFLE DRAW: Bring a Friend to EDMPASS Day

OK Due to the overwhelming response for the upcoming EDMPASS meeting with Brent Ozar we are going to run a special contest…

If you get a “SQL Friend” (developer, DBA, Architect, Server Admin, etc) to Register and Attend the upcoming meeting YOUR name AND your SQL Friend’s name will be put in for a special raffle prize.

RULES:

Your “SQL Friend”
1) Must be a NEW EDMPASS attendee
2) Must work (directly/indirectly) with SQL Server
3) Must Register @ the EventBrite link on EDMPASS.com
4) Must Click on the “Contact the Host” button and identify which EDMPASS member they are friends with.

PRIZE:

A $250 Gift Card from BestBuy AND a Quest Software Prize Pack

We’re already going to be setting an attendance record with this upcoming meeting… but I don’t just want to set an EDMPASS record… I want to blow it out of the water.

Looking foward to seeing everyone on the 30th!

~ Colin

EDMPASS Meeting September 30 2009

On September 30th 2009 the Edmonton Chapter of PASS is having it’s next meeting. Details below:

http://www.eventbrite.com/event/421182769

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.

Date: Sept 30th 2009
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: 6th Floor - Room 7
Speaker: Brent Ozar
Topic: Hit The Ground Running with SQL Server 2008

Session Abstract: SQL 2008 has a lot of new features to help make database administration easier – but who has the time to learn ‘em all? Brent will get you started fast with the features that give you the most bang for the buck. Attendees will learn how to use these new 2008 features:

  • Central Management Server
  • Policy-Based Management
  • Group Query Execute
  • Resource Governor

Presenter Information: Brent Ozar

Brent is a SQL Server Domain Expert with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits, a Miami-based wine & spirits distributor.

Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He’s currently writing SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, and Justin Langford. He’s Editor-in-Chief at SQLServerPedia.com, where he also records video podcasts.

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
7:00 pm - Wrap Up and Draws

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS - July Meeting Review

Thanks to everyone who came out to the meeting last night. I was surprised at the turnout that we got last night just because it’s holiday season and it was such a nice evening that I thought for sure some would opt out of staying indoors after a long day at work. We’ve got some very dedicated SQL Server folks in Edmonton!! :)

I’d like to thanks Rafal Dyrda for volunteering to take over the “web” side of things which is one of the positions that I’m looking to fill on the EDMPASS Steering committee. Rafal is a good friend of mine so be sure to go and check out his website: http://www.Flame360.com. Rafal can’t wait to get his hands on EDMPASS.com and give it a much needed facelift.

On the attendance sheet quite a few people indicated that they would be interested in helping out which is great and a few people talked to me before and after the meeting as well. Here are the positions that we’re looking to fill and if you did let me know that you wanted to help out please drop me a line so we can start the conversation.

EDMPASS Steering Committee

President - Colin Stasiuk
Web Administrator - Rafal Dyrda
Event Planner - vacant
Information Officer - vacant
SWAG Coordinator - vacant

I’ve already received some great emails and comments on the event last night with some ideas as to what people would like to see presented on at future meetings.

Thanks everyone for their support and comments because at the end of the day EDMPASS is shaped by it’s members and we want to make sure that you find the meetings informative and educational but also a fun networking experience.

- Colin

EDMPASS - Meeting 2

In July the Edmonton Chapter of PASS is going to have it’s 2nd meeting. Details below:

http://www.eventbrite.com/event/378687665

Please be sure to not only click the “Add to my calendar” but also the “Register” button so that I can plan accordingly for food and drinks.

Date: July 29th 2009
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: 6th Floor - Room 7
Speaker: Colin Stasiuk
Topic: SQL Security Auditing Through The Ages

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
6:45 pm - Wrap Up and Draws

Presenter Information: Colin Stasiuk is an MCP, MCTS SQL 2005/2008, MCITP DBDEV, and MCITP DBA. Currently, he is an independent consultant contracted to Vantix Systems and working for the Government of Alberta. Colin is an accomplished Microsoft SQL Server DBA who has been working with SQL Server since 1996. He is the founder of Benchmark IT Consulting and is always willing to lend a hand with questions in many SQL Server community forums and via Twitter (http://twitter.com/BenchmarkIT) . His specialties include SQL Server Administration, Performance Tuning, Security, Best Practice / Standards, Upgrades, and Consolidation.

Colin is a proud PASS member, President of EDMPASS, and is on the DBA Abstract Selection Team for this years PASS Summit.

 

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

EDMPASS - Meeting 1 Review

Thanks to everyone who came out to our first meeting. It was great seeing some familar faces and also meeting a bunch of people that I hadn’t had a chance to meet yet. It’s good to know the SQL community in Edmonton is strong and that people understand the importance of networking (and also free food and training)

OK onto the meat of the update:

Survey Results

1) Expertise - 55% Admin, 35% Dev, 5% BI, and 5% Other

2) Level - 45% Advanced(300), 35% Intermediate (200), 20% Expert (400), 0% Intro (100)

3) Top 10 Topics - SQL 2008, Performance Tuning, Security, Resource Governor, Policy Based Management, TSQL Coding, High Availability, DMVs, Maintenance, and Monitoring

This is great information and also very helpful in ensuring that the speakers I bring in are not only speaking on the topics that you are interested in but also at the level you’re looking for.

I touched briefly upon requesting volunteers to join a steering commitee for EDMPASS. I’ll be sending out an email shortly explaining more about what that means but if you know you’re interested in helping out in some shape or form (thanks!!) please feel free to drop me a line.

I’m in the process of finalizing the next meeting date, speaker, and topic and as soon as I have an update I’ll send it along in a newsletter to the people who have signed up here on EDMPASS.

Thanks again for the support and I look forward to seeing all the familar faces (and some new ones) at our next meeting

- Colin

EDMPASS Inaugural Meeting

OK here we go… In May the Edmonton Chapter of PASS is going to have it’s 1st meeting. Details below:

Date: May 28th 2009
Time: 5:00 pm - 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: 6th Floor - Room 7
Speaker: Scott Gillespie
Topic: What’s New - SQL Server 2008 for Developers and DBAs

Agenda:
5:00 pm - Pizza and Socializing
5:30 pm - Sponsor Presentation
5:45 pm - Feature Presentation
6:45 pm - Wrap Up and Draws

Presenter Information: Scott Gillespie is one of the Principals in Winding River Solutions Inc. which was established in late 2001. Winding River is a Microsoft Gold Certified Partner whose consultants have extensive experience in the development of distributed applications and are highly skilled in infrastructure architecture and the deployment of Microsoft technologies. Winding River is also a Microsoft Gold Certified Partner for Learning Solutions and it is these same consultants who bring to the classroom a valuable combination of proven training abilities and real field experience. Scott is an experienced systems consultant, developer and trainer specializing in Windows Server, SQL Server database, Exchange Server, SharePoint Portal Server and Exchange collaboration applications. Scott has been involved in full enterprise deployment projects that use a wide range of Microsoft solutions.

If you haven’t signed up already at EDMPASS.com please do so now to receive meeting notifications, news, and updates from EDMPASS.

Hope to see you there.

Welcome to EDMPASS.com

Please visit the sign up page if you’d like to receive EDMPASS news and event notifications.

PASS

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit – the largest gathering of SQL Server professionals in the world – PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies.

PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration.

PASS Community Summit 2009
November 3-6, 2009, Seattle WA, USA

2009pass_signature_generic07

Since 1999, PASS has held an annual conference to bring together SQL Server professionals for deep-dive technical learning, hands-on labs, and the best networking in the community. Now, with events in both the US and in Europe, the annual PASS conferences are recognized as the must-attend SQL Server events of the year.