Tag Archives: Training

Learn High Availability and Disaster Recovery with SQL Server in a Day!

If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00 PM (EDT) 

Do you need to build a High Availability (HA) and/or Disaster Recovery (DR) strategy for SQL Server Databases? If so, you will no doubt have questions like:

•    What does a good High Availability or Disaster Recovery strategy look like?
•    What options are available to help implement a proper HA/DR strategy?
•    What do I do if my database server goes down?
•    How do I mitigate downtime for planned outages?
•    How much time do I have to recover, and which native SQL Server features helps me reach my goal?
•    How does this work with my company’s existing HA/DR strategy?

Linchpin People & SIOS are offering this seminar to answer those questions and more!
In this all-day training, we will help teach you the fundamentals and best practices of building and implementing a full HA/DR Strategy for your company.  You will learn how to build a recovery plan by mastering the basics of backups and restores. You will also learn how to implement and monitor log shipping, database mirroring, replication, Windows clustering, SQL Server Failover Clustering Instances, and the new Availability Group features. After this training session, you will have the knowledge to design, implement and manage your very own high availability and disaster recovery (HA/DR) plan.

Meet The Presenters!

High Availability and Disaster Recovery Cheap TrainingJohn Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, is a PASS Regional Mentor, and one of the founders of the WVPASS user group and the PASS HA/DR Virtual Chapter. Tim RadneyTim Radney is the Lead System DBA for a top 40 US held bank. He is also a chapter leader for the Columbus GA SQL Users Group, PASS Regional Mentor for Greater South East US. Tim is a Microsoft Systems Admin turned DBA. Prior to becoming a full time DBA, he spent 10 years supporting Citrix, Novell, Windows, IIS, and MSSQL.

 Event Details:

Thursday May 22nd, 2014 – 8:30am-4:30pm (EDT)
Cost:  $79.00 before April 30th, $99.00 after April 30th
Location:
Microsoft Office
30 Isabella St., Second Floor
Alcoa Business Services Center
Pittsburgh, PA 15212
Phone: (412) 323-6700
Food:  Lunch, and drinks will be provided at the event location.  Please contact the organizer if you require a vegetarian option.

24 Hours of FREE SQL Server Training

On May 19th there will be 24 live back-to-back presentations including ones highlighting new features provided in SQL Server 2008 R2 and more.  I attended parts of the 24 hours of PASS last year and was blown away by the content.  If you work with SQL Server I highly recommend you attend.   You can register online now at http://www.sqlpass.org/24hours/2010/

The following speakers are lined up for this great event.  Adam Machanic, Andy Leonard, Brad McGehee, Brent Ozar, Brian Knight, Chuck Heinzelman, Dean Richards, Don Kiely, Don Vilen, Donald Farmer, Glenn Berry, Greg Low, Jacob Sebastian, Jessica Moss, Kevin Cox, Kevin Kline, Louis Davidson, Maciej Pilecki, Peter Myers, Peter Ward, Rushabh Mehta, Sean McCown, Simon Sabin, Thomas Grosher

Watching Paint Dry
Watching Paint Dry

“But John I have to do xyz watch the paint dry on May 19th and the 20th.”

That’s fine, it looks like these sessions will be recored and made available through PASS within two months.  If you access the event this way you can watch 24hrs of PASS and the paint at the same time 🙂

A good friend of mine Thomas LaRock(blog | twitter) is organizing this bad boy.  For more information check out his post or the 24 hrs of PASS site.  I know it will be a big hit!

Free SQL Server 2008 Training Kit

Are you looking for some free SQL Server training?  Are you looking to upgrade your SQL Skills to SQL Server 2008? If so, Microsoft has a download just for you.

Download SQL Server 2008 Developer Training Kit

The SQL Server 2008 Developer Training Kit includes presentations, sample code and labs that cover the following topics:

  • Spatial Support
  • FILESTREAM
  • CLR
  • Reporting Services
  • Date and Time
  • T-SQL enhancements including  Table Value Parameters, Merge, Row Constructors, Grouping Sets and more..