PASS Virtual Chapter Late February Presentations

PASS AppDev Presents: PowerShell for Data Professionals

For this session we have partnered with SQL User Groups on the other side of the planet to do multiple live sessions in time slots that are convenient for them.  If you would like your User Group to partner with us on a time slot for a future session please contact us here:  appdev_DL@sqlpass.org

Event Description:
In this session we will learn to perform several everyday data tasks including user database backups, scripting table objects and evaluating disk space usage with PowerShell. For each task we will explore the benefits of using PowerShell over the standard method. 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 help everyone get their feet wet using PowerShell.

Aaron Nelson:
 
Aaron 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.  He also holds certifications for  MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V). Aaron blogs at SQLvariations

How do I view the presentation?
Attendee URL:�
Live Meeting Link (Auckland, NZ)
Live Meeting link (Australia)
Live Meeting link (Eastern US Time Zone)

____________________________________________________________________________________________________

PASS DBA VC Presents: SQL Server Locking & Blocking Made Simple

Event Description:
A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

Joe Webb:
 
Joe Webb, a Microsoft SQL Server MVP, serves as Chief Operating Manager for WebbTech Solutions, a Nashville-based consulting company. He has over 14 years of industry experience and has consulted extensively with companies in the areas of software development, database design, and technical training.

Live Meeting Information:
Attendee URL: Live Meeting Link