Articles

PowerShell articles, tutorials, and guides from community experts.

Don Jones
Scripting Games

State of the Games

As of Monday at 5pm Pacific time (which is Tuesday morning, 00:00 hours GMT), the 2013 Scripting Games’ first event will conclude. That means the first event is open for community voting - so get on it! Remember, some of the best prizes - including a free pass to the 2014 PowerShell Summit - are reserved for folks who offer their votes and comments. Incoming new registrations for the Games will not be able to compete in Event 1 at this point, but they can jump in with Event 2 (and subsequent events) if desired.

Enrique Puig
PowerShell for Admins

Comparing SQL Server table schemas with PowerShell

As a SQL Server DBA or SQL Server developer sometimes is necessary to know whether two tables have equal schemas or not. For example, a few months ago I had to consolidate two SQL Server instances in just one. One of the main problems were the collisions between Databases and Tables. I found out that both instances had Databases with equal name and the same thing happened with tables inside those databases.

Richard Siddaway

CIM cmdlets vs WMI cmdlets"“speed of execution

One question that came up at the summit was the comparative speed of execution of the new CIM cmdlets vs the old WMI cmdlets. No of us knew the answer because we"™d never tried measuring the speed. I decided to perform some tests. This first test is accessing the local machine. In both cases the cmdlets are using COM. WMI uses COM and CIM will use COM if a ““ComputerName parameter isn"™t used.

Richard Siddaway

Time for D-CRUD?

I was thinking on the plane back from the PowerShell summit about the CRUD activities. They are a concept we have inherited from the database world: C = Create R = Read U = Update D= Delete Create, Update and Delete correspond directly to the PowerShell verbs ““ New,Set and Remove respectively. The Read action corresponds to the Get verb. Well sort of. Get-* is used in two distinct scenarios. Firstly we know of an object and we we want to read its properties ““ for example:

Richard Siddaway

Scripting Games 2013 have started

The 2013 Scripting Games kicked off during the PowerShell summit. Event 1 is open and you can submit entries up until 23:59:59 GMT on 29 April 2013. Voting on the entries starts at at midnight on 30 April. You can enter and you can vote on the entries. This is a community games run by powershell.org ““ all are welcome. If you haven"™t entered yet there is still plenty of time to get you entry in for event 1.

Richard Siddaway

PowerShell Summit"“thank you

I"™d like to extend a huge thank you to everyone who attended the PowerShell Summit this last week. The Summit was a success ““ in no small part due to you. Your questions, and discussions, are what this is all about. It was a pleasure meeting you all and I hope to return next year ““ I hope to see many of you there as well.

Don Jones
Announcements

Forums Migration Schedule

Here’s the schedule for our Forums migration: From Now until May 4th, the old forums will remain online and in-use. However, you should consider creating an account here on the “new” site (distinguishable by the different visual theme). Your new account will have no connection to the old one, and may be a Twitter, Facebook, Live, or other login. To create an account, just click “Login” at the top-left of any site page (in the dark gray toolbar).

Don Jones
PowerShell Summit

Recording the PowerShell Summit

So, we did have one enterprising fella use his Webcam to record the Summit sessions he attended. Once he gets with me, we’ll get those online so you can see. We are trying to think really hard about formal recordings for next time. It depends a lot on what folks want. For example: Pointing a camera at the front of the room is easy and cheap. We worry that the audio might suck and that you might not be able to read on-screen code - although many presenters make their code/slides available for download.

Don Jones
Scripting Games

Meet the Scripting Games Judges: "Scripting Guy" Ed Wilson

Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the twice daily Hey Scripting Guy! blog (the number 1 blog on TechNet). He has also spoken at TechEd and at the Microsoft internal TechReady conferences. He is a Microsoft-certified trainer who has delivered a popular Windows PowerShell workshop to Microsoft Premier Customers worldwide. He has written 11 books including 8 on Windows scripting that were published by Microsoft Press.