PASS Virtual Chapters

PASS Virtual Chapter Events: September & October 2014

PASS Virtual Chapter Events: September 2014

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.

Date Time Title Link
September 16th 11:00 CST The Roadmap to Better Performance: Reading Query Plans https://attendee.gotowebinar.com/register/3935830875052414466
September 17th 12:00 PST Learn JavaScript Properly Part 2 https://attendee.gotowebinar.com/register/4322399372235297538
September 17th 4:00 EST Absolute Beginners Presentation for Power BI for Office 365 https://attendee.gotowebinar.com/register/4757737807317828865
September 18th 12:00 EST Insider's Introduction to Microsoft Azure Machine Learning (AzureML) http://bit.ly/PASSBAVC091814
September 26th 11:00 EST Improving Query Efficiency with Data Access Layers http://oracle.sqlpass.org/
October 8th   12:00 CST Understanding your SQL Server IO Bottlenecks and how Flash can solve them https://attendee.gotowebinar.com/register/6093820357156042754
October 16th 10:00 EST MrExcel's Favorite Excel Tips & Tricks https://attendee.gotowebinar.com/register/8089449354432962050

 

By |September 11th, 2014|Categories: PASS, Virtual Chapters|Tags: |

PASS Virtual Chapter Events: August 2014

 

Date Time Title Link
August 15th 12:00 EST Manage Your Shop with CMS and Policy Based Management https://attendee.gotowebinar.com/register/4279519516082609665
August 19th 11:00 CST The Roadmap to Better Performance: Reading Query Plans https://attendee.gotowebinar.com/register/2124351382524970497
August 20th 12:00 PST Learn JavaScript Properly http://bookreaders.sqlpass.org/
August 21st 12:00 EST Looking Through the Windshield: Creating Forward-looking Dashboards and KPIs  https://attendee.gotowebinar.com/register/5282114692357849346
August 21st 1:00 EST SQL Server Security Easy Button https://attendee.gotowebinar.com/register/4752057729799585025
August 27th   12:00 EST The Curious Case of Isolation Levels http://dba.sqlpass.org/

 

By |August 15th, 2014|Categories: PASS, Virtual Chapters|Tags: |

PASS Virtual Chapter Events: June 2014

 

Date Time Title Link
June 11 12:00 MST PASS DBA Virtual Chapter: A Comedy of Errors sponsored by Dell Software https://attendee.gotowebinar.com/register/1711991640373835777
June 11 10:00 MST Whats New in Hyper-V 2012 R2 https://attendee.gotowebinar.com/register/308303418870126593
June 13 12:00 CST SQL 2014 Clustered Updatable Columnstore Indexes https://attendee.gotowebinar.com/register/7946480954532285698
June 17 11:00 UTC Rolling Upgrades, The Easy Way! https://attendee.gotowebinar.com/register/3511824004444615426
June 19 12:00 EST The Accidental Report Designer: Data Visualization Best Practices in SSRS https://attendee.gotowebinar.com/register/5392867398311459330
June 26  2:00 EST Workload Tuning with Distributed Replay https://attendee.gotowebinar.com/register/1254440871617041921
By |June 10th, 2014|Categories: Virtual Chapters|Tags: |

PASS Virtual Chapter Events : December 2013

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.

Application Development – Virtual Chapters

Date: Friday, December 6, 2013

Time: 2:00 PM – 3:00 PM (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Isn’t That Spatial: Spatial Data for the App Dev

Register

Virtualization – Virtual Chapters

Date: Wednesday, December 11, 2013

Time: 12:00 pm – 1:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Virtualization Question & Answers with Brent Ozar

The Virtualization Virtual Chapter (aka SIG) is dedicated to better management of SQL Servers in virtual environments like Microsoft Hyper-V and VMware vSphere. We: Help the community by producing things like monthly training webcasts, a centralized list of helpful virtualization-savvy administrators, and a periodic report of what works well under virtualization and what isn’t quite working yet. Help virtualization vendors by getting training and configuration information out to the people who need it, and helping the vendors build a better product with our feedback. Help PASS management by building assets that PASS can leverage (like a library of training content) and showing that PASS solves real DBA problems.

Speaker Info:

Brent Ozar is a Microsoft Certified Master of SQL Server 2008 and a Microsoft SQL Server MVP. He has over a decade of experience with SQL Server, systems administration, SAN storage, virtualization, and project management. Today, he’s a consultant for Brent Ozar Unlimited. Previously, Brent was a SQL Server expert at Quest Software and a DBA at Southern Wine & Spirits, a Miami-based wine and spirits distributor. Brent blogs at http://www.BrentOzar.com like it’s going out of style.

Event Details >> Attend

Database Administration – Virtual Chapters

Date: Wednesday, December 11, 2013

Time: 2:00 pm – 3:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Load Testing with SQL Server Tools sponsored by Dell Software

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels. Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.

Speaker Info:

Neil Hambly is a 14-year SQL Server veteran, with expertise in SQL Server from version 6.5 to the latest 2012 edition. He’s held database roles at major organizations, including the BBC, ABN AMRO, and Accenture, as well as at a number of market-leading companies. Currently CTO/Founder at SQLnextSteps, he’s worked as a DBA, developer, and architect. Leader of the PASS London Chapter, Neil can frequently be found speaking at UK and international events.

Attend

Big Data Virtual Chapter – Virtual Chapters

Date: Tuesday, December 17, 2013

Time: 4:00 pm – 5:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Building a Big Data Architecture

Big data solutions call for different architectural solutions than our traditional workloads. Here we examine several ideas related to the architecture”cloud versus on premises, picking toolsets and distribution, and how to plan for growth and change in the stack.

Speaker Info:

Joey D’Antoni is an Architect with over a decade of experience working in both Fortune 500 and smaller firms. He is currently solutions architect for SQL Server and Big Data for Anexinet in Blue Bell, PA. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University. He is a frequent speaker at events such as PASS Summit and TechEd.

Register

By |December 4th, 2013|Categories: Uncategorized|Tags: , |

PASS Virtual Chapter Events : November 2013

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.

DBA Fundamentals – Virtual Chapters

Date: Tuesday, November 5, 2013

Time: 10:00 am – 11:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Statistics Starters

Have you been updating statistics as part of your maintenance plan, even though you’re not really sure what they are? Have you been asking yourself where statistics exist, how to find them, and what people mean when they say check statistics? Do you look at the database options for statistics and wonder if they really matter? It’s time to end the guessing and start understanding the basics about statistics. In this session I’ll answer these questions using straight-forward demos and real-world examples. And if you haven’t been updating statistics as part of your maintenance plan don’t worry, I’ll get you started.

Speaker Info:

Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

There will be a drawing for a $100 Amazon gift card at the end of the meeting. A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address.

Register

Big Data Virtual Chapter – Virtual Chapters

Date: Tuesday, November 5, 2013

Time: 12:00 pm – 1:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Table Partitioning: Secret Weapon for Big Data Pro

Big Data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks. Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.

Speaker Info:

John Sterrett is a database administration senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServ