Topic: Database Snapshots – Making Your Life Easier
Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier? If any of these appeal to you, then you should be familiar with database snapshots within SQL Server. Available since SQL Server 2005, use of this feature can make your life a lot easier. We’ll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot. Once we've covered the basics, we'll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.
Speaker: Paul Timmerman
Paul Timmerman is a Microsoft SQL Server MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has over thirteen years of experience in database administration and is a past Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQL Saturday conferences.
SponsorTEKsystems® is the nation’s leading technology staffing and services company. Combining a proven track record of superior performance, a quality-focused approach to service delivery, and the highest-caliber technical professionals in the market, TEKsystems helps our clients successfully plan, build, and run their critical technology initiatives.With more than 25 years of experience, we annually deploy 70,000 technical professionals from 90 locations throughout North America, Europe, and Asia. Our capabilities include IT and communications staff augmentation and direct placement services; managed, project-based, and outsourced applications and infrastructure services; education services; and comprehensive workforce management solutions.
Specialties:TEKsystems is the nation’s largest IT Services Organization. We focus our expertise in three main practice areas: Applications, Infrastructure and Telecommunications.
Below are some local services that TEKsystems can provide for you as a resource:
- Market Research/Analytics - We can keep you updated on the current market trends with technology, hiring, pay and local companies. You don’t have to be looking for a new job to have knowledge about the market.
- Career Path Information - This goes beyond just finding a job. We seek to understand your future goals and interests to identify the best opportunities that will put you in a position to succeed.
- Job Search Services -
a. Resume Writing b. Direct contact with hiring managers for resume submissions c. Interview Preparation (mock interviews, cultural information on company, etc..) d. Timely feedback on submissions and interviews
- Career Opportunities - we partner with over 70 companies here in the Omaha/Lincoln area to assist them with finding talented IT personnel to fill their Contract, Contract-to-Hire and Full Time Employee needs. We also have 105 offices nationally and can assist if you are looking to relocate as well.