Rotating Header Image

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.

EDMPASS September Meeting w/Stacia Misner

Sep 6th, 2010
by admin.
No comments yet

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.

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

EDMPASS - August Meeting w/Aaron Nelson

Aug 6th, 2010
by admin.
No comments yet

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.

Posted in: Uncategorized.

EDMPASS - July Meeting w/Brent Ozar

May 31st, 2010
by admin.
3 comments

 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.

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

← Earlier Posts