This is another one of the code examples that I did in my PowerShell for Data Professionals session last week. If you give it your computer name and then run it you will get back a stream or properties like I mentioned during the session. get-wmiobject -query ` “Select DeviceID,Size,Freespace from Win32_logicaldisk where drivetype=3″ ` [...]
Posts from ‘February, 2010’
Speaking at SQLSaturday #33 in Charlotte, NC
I will be speaking at SQLSaturday #33 in Charlotte, NC on March 6. I’m bringing two new sessions with me, “Virtualize This!” and “PowerShell Awesomesauce”. Virtualize This! is going to be sort-of an overview of what options are available with virtualization. I say sort-of because I’m not big on PowerPoint, in fact I’ve only used [...]
Get More Done with SQLPSX
In my LiveMeeting session for the AppDev Virtual Chapter of PASS yesterday I talked about building on top of tools that others had already built for you to use. A great one for any DBA to use is the SQL PowerShell Extensions known as SQLPSX. Even if you’ve never used PowerShell before you should take [...]
How Big Were Last Nights Backups?
Last week one of the Sys Admin’s asked me “How big were last night’s backups?” I was like “Why are you asking me? We drop all of the backup files onto one of your arrays so why don’t you tell me.” Background: We’re doing a Data Center move and they wanted to move a copy of all [...]
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 [...]
Bite Sized Blog Posts
For the next several weeks (about 9) I will be really busy with a data center move and doing some presentations on PowerShell. During that time I’m sure I’ll find all kinds of cool uses for PowerShell and SQL Server and I’ll post them as quick as I can in a small bite-sized format. This [...]
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 [...]
PASS Virtual Chapter Late February Presentations
PASS AppDev Presents: PowerShell for Data Professionals For this session we have partnered with SQL User Groups on the other side of the planet to do multiple live sessions in time slots that are convenient for them. If you would like your User Group to partner with us on a time slot for a future [...]
SQL Saturday #41 – Atlanta
SQL Saturday is coming to Atlanta on April 24th. Well be doing this at the Microsoft building again so capacity is limited to just 250 people. Right now we’ve got the call for speakers open so if you have a session that you’d like to submit we’d love to have you. If any out [...]
Filtered Indexes: The Conversation
A few months back as one of my very first blog posts I showed off some functionality that I had learned in Bruce Payette’s book “PowerShell In Action” (Coincidentally a new update to the MEAP for the Second Edition was released tonight). I showed how it was not too difficult to Archive the wisdom of [...]
