Jana Sattainathan Sr. DBA, SCOR
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 13 billion rows (7 TB, within 20 hours) from hundreds of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing.In his free time, he dabbles in .Net. He has an MCITP in SQL Server Administration as well as Development and is an Oracle Certified Professional DBA. Outside work, he enjoys nature, movies, playing tennis, poker, biking and hiking (not to mention wine).Visit Jana’s Blog at hhttp://www.sqljana.wordpress.com
Follow Jana on Twitter: www.twitter.com/SQLJana |
Small Scale Data Collection Using PowerShell
– Going NSA Style! While we are not the NSA, certain vital data needs to be collected (for example audit data, trace data, session information, performance data etc.) all to a central SQL Server repository, for analysis and safekeeping. In this session, we will see how freely-available PowerShell code can be used to collect data from multiple SQL Server instances/databases/OS. At the end of this session, you will have the knowledge and ability to collect pretty much any data in a central repository in a scheduled manner or online with just a couple of lines of code, all in a manner that works specifically for you!If time permits, we will dive into advanced techniques in data collection like parallelizing the data collection to collect millions of rows of data in a matter of minutes. |
