Next Meeting: Tue, Jan 31 2017
Jana Sattainathan Presents Practical Powershell for SQL Developers & DBAs
Event Type: In-Person
Online Meeting URL: None
UTC : Tue, Jan 31 2017 23:00 - 01:00
Event Time : Tue, Jan 31 2017 18:00 - 20:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Jan 31 2017 23:00 - 01:00
4821 Koger Blvd
Greensboro, North Carolina
Practical Powershell for the SQL Developer & DBA
Jana Sattainathan, Senior DBA SCOR
PowerShell is always something you heard about and wanted to use but never did! Starting with the resources available for a PowerShell newbie, we will advance to what pro's use to automate their database activities and beyond, for both DBA's and developers. The goal of this session is to get you immersed in PowerShell. Ask questions and learn how PowerShell can enable you and more importantly do your job for you (the way, future is heading). We will also look at free libraries and tools to help you advance your automation abilities. Common automation scenarios is the theme! Anything done with with clicks can be automated.
Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.
Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (>20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing.