1 / 9

Automating Tools with PowerShell is Liquid Awesome

Automating Tools with PowerShell is Liquid Awesome. Connecting things to your SQL Server environment. Aaron Nelson. Aaron@SQLvariant.com I blog at SQLvariant.com I’m kind of fond of PowerShell. Who are you and why are you here?. DBA, Dev , Sys Admin? Used PowerShell before?

carrington
Download Presentation

Automating Tools with PowerShell is Liquid Awesome

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automating Tools with PowerShell is Liquid Awesome Connecting things to your SQL Server environment

  2. Aaron Nelson • Aaron@SQLvariant.com • I blog at SQLvariant.com • I’m kind of fond of PowerShell

  3. Who are you and why are you here? • DBA, Dev, Sys Admin? • Used PowerShell before? • Love SQL Source Control or SQL Compare? • Just afraid of Denny?

  4. More Questions! • Did you Catch Rob’s session earlier today? • How many of you have had code magically show up in your Prod database without being checked into Source Control?

  5. Connecting the Dots • We’ve all heard the saying “When your only tool is a hammer, everything looks like a nail” • PowerShell isn’t just a hammer • PowerShell interfaces with other Hammers

  6. Here’s just a couple things I’ve used it with… http://bit.ly/dXIuxw • Excel • FTP • Email • Mount Points • SSAS • Charts • Querying multiple instances across multiple data centers

  7. SQL Source Control + PowerShell • A blog I did about SQL Source Control + PowerShell • http://bit.ly/SSCandPoSh • The link is case sensitive

  8. Just 34 things • Automating SQL Compare with PowerShell • Scripting out databases when SQL Compare or SQL Source Control can’t connect • Deploying a Migration script to multiple databases • Copying backup files to restore

  9. Thank you Red Gate • For letting me come here and share my passion for PowerShell

More Related