It’s a brand new year, so start it off right. Cleveland is hosting its third SQLSaturday on February 8, 2014 at Hyland Software in Westlake, OH. (Because where else would you rather be in February than Cleveland, Ohio?) This is one SQLSaturday you won’t want to miss. We’ve got some fantastic speakers lined up. SQL Server experts like Tim Ford, Grant Fritchey, Steve Jones, Tom LaRock, Erin Stellato, and Kendal Van Dyke. BI bad-asses like Stacia Misner and Julie Smith. I suppose I should be plugging my own session, but seriously did you see that list of speakers??
But wait, there’s more!
And if the regular sessions weren’t enough, there will also be 2 fantastic pre-con sessions, by Argenis Fernandez and Allen White.
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.
Argenis Fernandez is a Database Monkey for SurveyMonkey. 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. Argenis is also a Microsoft Certified Master on SQL Server 2008, an avid Twitter user (you can follow him at @DBArgenis), and occasional blogger on SQL Server topics at SQLBlog.com.
Register for Argenis’ pre-con.
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.
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
What more could you possibly ask for?
So go register for SQLSaturday #241 in Cleveland. And then go register for a pre-con. I’ll see you there!