Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » PowerShell » SQL Server 2008   (RSS)
Saturday, March 21, 2009 2:42 PM

Using PowerShell to Get Data & Log File Sizes

I was playing around with PowerShell today (yes I’m was geeking out on Saturday afternoon) to learn how to access Performance Counters using PowerShell. My mission was to write a script that would return the Data File and Log File sizes for each database
Posted by dtjones | 3 Comments
Friday, August 29, 2008 9:29 AM

PowerShell vs. T-SQL or Why Did We Add PowerShell Support in SQL2K8

The following write-up was originally an email I sent to Allan White (SQL Server MVP) in the context of a discussion on PowerShell and some of the PowerShell community postings questioning why SQL Server needed PowerShell support @ all given the strength
Posted by dtjones | 11 Comments
Thursday, July 31, 2008 8:00 AM

TechEd North America Session Videos

In shameless self promotion the video of the talk I did on PowerShell and SQL Server has been posted to the web. I haven't watched this as I just can't bring myself to sit and watch myself for an hour but the session evaluations were pretty good. Therefore
Posted by dtjones | 5 Comments
Tuesday, July 01, 2008 10:22 AM

Launching Vanilla PowerShell from SSMS

One of the criticisms of our PowerShell implementation is the integration with Management Studio launches our custom minishell. With just a few simple key strokes you can add a custom tool menu item and toolbar button. To do this select "External
Posted by dtjones | 0 Comments
Tuesday, June 24, 2008 5:45 PM

The SQLPS Firestorm Part Duex

On the PowerShell team's blog Architect Jeffrey Snover addresses the recent firestorm on SQLPS. BTW: he was a lot nicer about the engagement model than I would have been. I do want all feedback, positive and critical. Just make it constructive. Getting
Posted by dtjones | 1 Comments
Wednesday, June 18, 2008 11:15 PM

The SQLPS Firestorm

Within the PowerShell community there's a firestorm raging over SQLPS.exe our mini-shell that we're introducing in SQL2K8. In his blog Michiel does a good job explaining the mini-shell and provides a script you can use to register the SQL Server provider
Posted by dtjones | 11 Comments
Friday, June 13, 2008 1:44 PM

TechEd 2008 is Done!

I'm writing this on the plane from Orlando back to Seattle. I have lots of thoughts on TechEd that I'll try to get through before I run out of battery or the guy in front of me snaps my laptop display. I also want to answer a few of the questions that
Posted by dtjones | 0 Comments
Friday, June 06, 2008 2:50 PM

PowerShell Resources

  SQL Server Books Online PowerShell Overview SQL Server PowerShell Help SQL Server Learning PowerShell PowerShell Team MSDN PowerShell Site PowerShell Team Blog Cheat Sheet (This is Great!) Books Windows PowerShell in Action by Bruce Payette Windows
Posted by dtjones | 0 Comments
 
Page view tracker