THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » PowerShell   (RSS)
  • SQL Saturday 6 - Cleveland August 9

    Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia). Then, my last week as a DBA at Advanstar, followed by my first week as a Trainer for ...
    Posted to Allen White (Weblog) by AllenMWhite on June 27, 2008
  • Evaluating Policies On Demand Through PowerShell

    In my previous blog I reviewed the different policy evaluation modes available in SQL Server 2008.  In this next installment I will detail how to initiate a policy on demand using PowerShell. PowerShell integration with SQL Server 2008 is getting more press lately.  In past blogs I noted a few resources to help learn PowerShell, and ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 19, 2008
  • Create Database from PowerShell

    Last week I presented a session on Using SMO to Manage SQL Server at SQL Connections in Orlando, Florida. This was the third major conference I've presented this session, and each time I do this session I change more demos from VB.Net to PowerShell. This time it was the demo to create a new database. The big thing about my demos is that I want ...
    Posted to Allen White (Weblog) by AllenMWhite on April 28, 2008
  • PowerShell Learning Resources Online

    PowerShell is all the rage!  It is deeply integrated in SQL Server 2008, where you can start a PowerShell session from Management Studio, and create job steps which execute PowerShell scripts.  SQL Server 2008 will also introduce some great new cmdlets.  This integration of PowerShell in SQL Server 2008 will introduce a number of ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on April 22, 2008
  • Start PowerShell in Management Studio

    In the February CTP of SQL Server 2008 a new feature has appeared in SQL Server Management Studio. You now have the ability to right-click on an object in the Object Explorer window and open up a PowerShell window. In this window you can navigate the database structures much like you can a disk file subsystem, or like you can navigate the ...
    Posted to Allen White (Weblog) by AllenMWhite on February 20, 2008
  • PowerShell, SQL Server and Large Resultsets

    Last week I posted about using PowerShell and SQL Server together, and I used a SQLDataAdapter and populated a DataTable with the results. This approach is fine if what you're doing returns a reasonably small resultset, but what if you're returning millions of rows. In this case a DataTable isn't too practical, and a forward-only DataReader is ...
    Posted to Allen White (Weblog) by AllenMWhite on February 1, 2008
  • Using PowerShell and SQL Server Together

    I've mentioned before my company manages trade shows, and we've got a series of web sites managed by an application which uses a different SQL Server database for each site, with a master database (I'll call it Global, to differentiate it from SQL Server's master database). Well, we have a number of shows which have multiple show locations, and ...
    Posted to Allen White (Weblog) by AllenMWhite on January 25, 2008
  • Create Agent Jobs to run PowerShell Scripts

    Actually, let's use PowerShell and SMO to create an Agent job which will run a PowerShell script. (Or is that a circular reference?) I've created a number of PowerShell scripts which automate database management processes, and I wanted to be able to run them from an Agent job. The trick, of course, is to be able to get to the PowerShell ...
    Posted to Allen White (Weblog) by AllenMWhite on January 9, 2008
  • Accessing WMI Information Using SMO

    While doing some research on SMO I found a couple of very handy features of the WMI accessibility features of SMO. I'm playing with PowerShell because it's easy to browse the SMO objects in that environment, but here are a couple of tips I found useful. We need to load the SMO assembly into PowerShell - here's the ...
    Posted to Allen White (Weblog) by AllenMWhite on December 28, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement