SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Feb 8 2014 at Hyland Software - Building 1, 28500 Clemens Rd., Westlake, OH 44145. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleages know about the event.
A Day of SQL Server Internals and Data Recovery
Take your recovery game to an all new level. Take a deep dive into SQL Server internals and data recovery and learn how to handle a wide variety of data loss and corruption scenarios. The session will cover how to be prepared for, prevent, and recover data lost due to deletion or corruption.
Learn the following skills in this session:
- Built-in functionality in SQL Server for preventing and detecting corruption that you may not even know about.
- How to identify a specific transaction in the transaction log and recover data lost from that transaction.
- Categories of corruption and how to manage recovery differently for each one.
Don't come empty handed. Bring your laptop and we'll practice recovering corrupt databases together.
Speaker Bio: Argenis Fernandez
Argenis Fernandez is a Senior Database Engineer for SurveyMonkey based in Redmond, WA. He has worked with SQL Server for over 15 years and enjoys large SQL Server farms, high-end OLTP databases, managing Windows environments, performance troubleshooting, high availability, disaster recovery, best practices, and PowerShell scripting. Prior to SurveyMonkey, Argenis worked as a Senior Database Administrator for Coinstar/redbox and as a Senior Consultant on SQL Server Core for Microsoft Consulting Services. In 2013 he founded the Security Virtual Chapter for the Professional Association for SQL Server (PASS) (http://security.sqlpass.org).
Automate and Manage SQL Server with PowerShell
This soup-to-nuts all day workshop will first introduce you to PowerShell, after which you’ll learn the basic SMO object model, how to manipulate data with PowerShell and how to use SMO to manage objects. We'll also cover how to manage data using the Invoke-SQLCmd cmdlet as well as ADO.NET. We’ll then move on to creating Policy-Based Management policies, work with the Central Management Server, manage your system inventory and gather performance data with PowerShell. We’ll wrap up with a look at PowerShell Remoting and how you can use PowerShell to manage SQL Server 2012 in server environments including Windows Server Core. After this one day, you’ll be ready to go to work and able to use PowerShell to make you truly effective.
Speaker Bio: Allen White
Allen White is a Microsoft SQL Server MVP and Practice Leader at UpSearch. Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. He currently serves the SQL Server community as President of the Ohio North SQL Server User Group, the Cleveland, OH based chapter of the Professional Association for SQL Server (PASS). Contact Allen at upsearch.com. Follow Allen on Twitter: @SQLRunr