SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

Posts Tagged ‘PSSnapin’

Basic SQL Querying From PowerShell

I promise to make this worth your time.  (Oops, I better make this quick.) Alright so with PowerShell if you open it up and just run this code you’ll be able to query your database right from the start.  Anyone who has worked with data systems for a while will notice right away the first [...]

SQLServer:\SQL\Databases\Tables> Dir

Getting started talking to your SQL Servers in the PowerShell 2.0 ISE By now hopefully you’ve noticed that SQL Server 2008 comes with PowerShell all over the place.  Just about anything you click on in Object Explorer has “Start PowerShell” and you can even execute PowerShell steps in SQL Agent Jobs.  You may be wondering [...]

Get Adobe Flash playerPlugin by wpburn.com wordpress themes