Said has over 30 year experience as an Information Technology Professional. He has a vast array of abilities in the field in the areas of Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. He has Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America. Current Said is a DBA at Kemper Insurance and the Vice-President of Philadelphia SQL Server Users Group (PSSUG).
We will be taking a look at SQL 2005+ enterprise feather of database snapshots and how they work. We will answer question like:
What is Database Snapshot?
Why use Database Snapshot?
How does a Database Snapshot work?
How does a Database Snapshot effect performance?
Learn about Encryption hierarchy, Symmetric Key, Asymmetric Key, Certificates. How to use encryption in SQL 2005 and up.
Intro to PowerShell basic commands. Why and how to use PowerShell with SQL 2005-2012. Tips on using PowerGUI a freeware tool for PowerShell. PowerShell script examples both basic and advanced.