16th September, 2010 – Microsoft Canada Ottawa Office
5:45pm
Session 1: Windows PowerShell for the SQL Server DBA (6:00PM – 7:00PM)
Presenter: Edwin Sarmiento
Windows PowerShell is becoming the scripting language of choice for managing Microsoft servers and workstations. And while T-SQL is still the scripting language for DBAs to administer and manage SQL Server, there are tons of stuff that can be easily done with Windows PowerShell.
In this session, learn Windows PowerShell from the ground up and how you can use it with SQL Server Management Objects (SMO) to administer and manage a SQL Server instance
Session 2: Your SQL Server DBA PowerShell Scriptbox (7:15PM to 8:15PM)
Presenter: Edwin Sarmiento
Do your day-to-day tasks with Windows PowerShell. And while Windows PowerShell is not intended to replace T-SQL, see how a multi-line T-SQL script can be translated in a one-liner code in Windows PowerShell. In this session, you will see how to use Windows PowerShell to perform tasks such as run SQL Server audits, check for SQL Server Agent job and backup status, generate backups and many more.
Edwin Sarmiento works as a Senior SQL Server DBA/Windows Engineer for Pythian in Ottawa, ON in Canada. Prior to joining Pythian, he was a senior systems engineer/DBA for Fujitsu Asia Pte Ltd in Singapore and is responsible for maintaining 200+ servers and databases for a global client in 10 countries. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – "To help people grow and develop their full potential as God has planned for them"
He wants the whole world to know that the FILIPINO is a world-class citizen and brings JESUS CHRIST to the world.