Agenda:
6:00pm - 6:30pm: Networking & Pizza
6:30pm - 6:40pm: NJSQL Community Updates
6:40pm: Presentation
Refreshments: Pizza/Soda
Sponsor: Wrox
Give-A-Ways: TBD
Presenter/s: MAK and Yan
Topic: SQL Server Administration with Windows PowerShell
Topic Summary:
Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. Presentation includes Introduction to Windows PowerShell, SQL Server 2008 powershell providers, SQL Server administration etc.
Book(Released June, 2009): Microsoft SQL Server 2008 Administration with Windows PowerShell
Bios:
Muthusamy Anantha Kumar(a.k.a. MAK - http://www.mssqlengineering.com)
MAK is a Microsoft Certified IT Professional - Database Administrator ( MCITP SQL Server 2008, MCITP SQL Server 2005) . He has more than 11 years of experience in Information Technology including Database Engineering, Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2008/2005/2000/7.0/6.5/6.0/4.X for production/development/testing. He is experienced in MS SQL Server Engineering, installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery. He has handled VLDBs and been involved in SDLC of various data warehouse projects. Currently, MAK is Senior Database Engineer responsible for Engineering and standardizing Microsoft SQL Servers in one of the big finance companies on Wall Street. Previously, he was a Senior Database Administrator/Data Architect, responsible for development, test, DR and production servers for many finance , .com and B2B companies. He plays an active role in forums as a SQL Expert and moderator. He also teaches Database Administration at University of West Florida. He also teaches SQL Server part time in New Jersey. He published many online articles and he is a contributing columnist in DatabaseJournal.com. He is also publishing online articles in SQL-Server-Performance.com and SQLServercentral.com.
Yan Pan(http://www.yanpansql.com)
Yan (MCITP SQL Server 2008, MCITP SQL Server 2005, MCDBA SQL Server 2000, OCA Oracle 10g) is a Senior DBA for a leading global financial services firm, where her daily duties include administering hundreds of SQL Server and Oracle servers of every possible version, working with business units on software development, troubleshooting database issues, and tuning database performance. She is also a contributing columnist for DatabaseJournal.com. Her articles can be found at http://www.yanpansql.com/
Previously, Yan worked as a SQL Server DBA and a .NET developer at Data Based Ads, Inc., and developed two .NET Web applications. Before that, she worked at AT&T Research Labs. She designed OLAP cubes with SQL Server Analysis Services and developed PivotTable reports for regional managers. She has master’s degrees in Computer Science and Physics.
SQLDiva