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

PowerShell

Mike Robbins Presenting for the PowerShell VC of PASS today at noon

Jun 19th, 2013
by Aaron Nelson.
Comments are off for this post

Mike Robbins will be presenting PowerShell Fundamentals for Beginners today at noon EDT (GMT -4) for the PowerShell Virtual Chapter of PASS. You can sign up for it here: https://attendee.gotowebinar.com/register/8626194637601358080

PowerShell Fundamentals for Beginners

PowerShell IS where Microsoft is going for the administration of its products. If you’re not actively trying to learn PowerShell today, you’re soon going to be well behind the learning curve of the average IT pro. This session will start from zero and cover the basic fundamentals of PowerShell that will get you started on the right track to becoming a PowerShell Hero. During this session we’ll cover the three basic cmdlets; Get-Help, Get-Command, and Get-Member which are the building blocks to learning what PowerShell commands exist, how to use those commands, and what properties and methods are available | foreach command. We’ll also cover some of the common beginner related issues such as why you need to run PowerShell as an administrator and script execution policy.

Mike F Robbins

Mike F Robbins is a Senior Systems Engineer with almost 20 years of experience as an IT Pro. He’s a PowerShell Enthusiast who uses PowerShell on a daily basis to administer Windows Server, Hyper-V, SQL Server, Exchange, SharePoint, Active Directory, EqualLogic SANs, and AppAssure. Mike has written PowerShell guest blog articles for the Hey, Scripting Guy Blog!, PowerShell.org, PowerShell Magazine, and a chapter in the PowerShell Deep Dives book. Mike blogs at http://mikefrobbins.com and can be found on twitter @mikefrobbins. Mike is also a co-founder of the Mississippi PowerShell User Group.

 

TechEd Dirty Dozen Scripts – PowerShell for SQL Server 2012

Jun 12th, 2012
by Aaron Nelson.
Comments are off for this post

For those of you attending my presentation at TechEd North America today, here’s the scripts that we’ll be going through: http://SQLvariant.com/BlogSupport/PoShDirtyDozen/TechEdDozen.zip

I’m speaking at TechEd!

Jun 11th, 2012
by Aaron Nelson.
Comments are off for this post

imageI’ve been meaning to post this for months but I’ve been a bit busy.  Better the day before than never right?  I’m Speaking at TechEd!!!!  Smile

In addition to speaking Tuesday morning, I will be answering questions at the SQL Server booths (there’s 12 of them):

Monday from 12-2 and again from 5:30 – 7:30
Tuesday from 3 – 5
Wednesday 10:30 – 1
Thursday 10:30 – 1

If you’re at the conference and you have questions about SQL Server (especially if they involve PowerShell) I hope you’ll stop by!

P.S.  The easiest way to find where the SQL Server booths are is to head over to the Porsche the Visual Studio team is giving away.

PowerShell Scripts for Pragmatic Works Webcast

Apr 24th, 2012
by Aaron Nelson.
Comments are off for this post

I did a webcast for the folks over at Pragmatic Works for their Free Training series two weeks ago.  As promised, here are the scripts I covered in that webcast.

I want to thank everyone who joined the webcast and especially all the people that asked the great questions at the end!  I received some really awesome feedback from attendees about the webcast!!  Smile

When I get some time in a few weeks, I will go back and write a blog post showing code to answer the questions from the webcast.

PowerShell Presentation at SQLskills open-mic night

Dec 9th, 2011
by Aaron Nelson.
1 comment

Kimberly Tripp ( blog | twitter ) and Paul Randal ( blog | twitter ) SQLsklls are here in Atlanta this week.  Last night they held an ‘open mic’ night and allowed anyone who wanted to present a topic 15 minutes to show something to the rest of the class.  Surprise, surprise I decided to talk about PowerShell.

I received multiple requests to post the scripts I used before I even had a chance to sit down so here they are.

If you were in the class and would like to use these and don’t even know where to start with PowerShell have a look at my “Resources for my SQL Server PowerShell Extensions webcast” post.

If you ever get a chance to attend one of their classes and present in front of Paul and Kim TAKE IT! :-)   Even if it’s just about your SSMS tips or how to work around a problem you encountered.  The feedback you get is *more* than worth it!

Quick Blog: Grabbing basic machine info with PowerShell

Nov 29th, 2011
by Aaron Nelson.
2 comments

The other day I needed to track down how much RAM a couple of our servers had installed.  A few days later I needed to verify that a couple of them were in fact 64-bit and not 32-bit.  I decided I wanted to be able to get at this basic info any time that I wanted without having to remember all the syntax so I built it into a PowerShell function.

Building a PowerShell function is almost as easy easier than building a stored procedure around a select statement in SQL.  The reason PowerShell is easier than SQL is that when you have a parameter that you are passing in, you can give it a data type, but you don’t have to.

For the function below I gave it a default value of the local machine but you can pass in a machine name that you are trying to get to.

Just copy the code below into an ISE window and hit F5.

function Get-MachineInfo($ServerName="localhost")             
{            
get-wmiobject win32_computersystem -ComputerName $ServerName |            
select DNSHostName, Manufacturer, Model, SystemType ,             
        @{Name="TotalPhysicalMemoryInMB";Expression={"{0:n2}" -f($_.TotalPhysicalMemory/1mb)}},             
        NumberOfLogicalProcessors, NumberOfProcessors, CurrentTimeZone, DaylightInEffect            
}# End Get-MachineInfo

After you’ve done that, to call the stored proc function simply type in the name ( Get-MachineInfo ) to the prompt at the bottom and hit enter

image

My First MSSQLTip!

Nov 2nd, 2011
by Aaron Nelson.
2 comments

imageToday my first ever MSSQLTip was published.  Before you ask: Yes, it talked about PowerShell.

It came about because some of the SQL MVPs were trying to figure out the best way to download a VM that had been split up into 36 different equal-sized files.  I’m sure there’s a better way than this but at the same time it took me about 4 minutes to write.  Write is the wrong term, more like copy/paste/change a few things.

Give it a whirl and let me know what you think!  Smile

Whats in my PowerShell Profile

Oct 11th, 2011
by Aaron Nelson.
2 comments

Here are two zip files.  The first file is my profile and the second zip file is the scripts that my profiles references.  These are just some of the tools I find useful for enhancing PowerShell.

← Earlier Posts