Rotating Header Image

EDMPASS - April Meeting w/Adam Neiman

Apr 9th, 2012
by admin.
No comments yet

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

Posted in: Uncategorized.
Tagged: · ·

EDMPASS - March Meeting w/Colin Stasiuk

Feb 28th, 2012
by admin.
No comments yet

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)

Posted in: Events, PASS.
Tagged: · · · · ·

EDMPASS February Meeting w/Jason Strate

Jan 30th, 2012
by admin.
No comments yet

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

Posted in: Events, PASS.
Tagged: · ·

EDMPASS - January Meeting w/Ryan Adams

Dec 15th, 2011
by admin.
No comments yet

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.

Posted in: Events, PASS, Uncategorized.
Tagged: ·

EDMPASS - December Meeting w/Jes Borland (Virtual)

Nov 7th, 2011
by admin.
No comments yet

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 :) ).

Posted in: Events, PASS, Uncategorized.
Tagged: ·

EDMPASS July 2011 - LiveMeeting Presentation Recording

Aug 18th, 2011
by admin.
No comments yet

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.

Posted in: Uncategorized.
Tagged: ·

EDMPASS - July Meeting w/Jen McCown

Jun 13th, 2011
by admin.
2 comments

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).

Posted in: Events, PASS, SQL Feed.
Tagged: · · · ·

EDMPASS - February Meeting w/Todd McDermid

Jan 31st, 2011
by admin.
No comments yet

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).

Posted in: Events, PASS.
Tagged: · ·

EDMPASS - January Meeting w/Jason Strate

Dec 29th, 2010
by admin.
No comments yet

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.

Posted in: Events, PASS, SQL Feed.
Tagged: · ·

EDMPASS - No October Meeting Scheduled

Oct 18th, 2010
by admin.
No comments yet

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

Posted in: Uncategorized.

← Earlier Posts