Last week I spoke to the Atlanta PowerShell User Group about Remoting and Background Jobs. There are a couple different flavors of Remoting but the one I’m most excited to show people is called Implicit Remoting. What if you were on a machine that only had SSMS 2005 and you had to run something against a [...]
Posts under ‘Code’
PowerShell Week at SQL University – Post 3
Providers What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive. Why do you need them? Well you quite possibly may not ‘need’ them per-say but they sure do make things easier to work with from time [...]
PowerShell Week at SQL University – Post 2
Cmdlets, Functions and Snapins So far we’ve learned how to open up PowerShell and add on to it with some modules; then we learned how to create a variable and populate it with anything from some numbers to an entire table. Today we’re going to quickly look at another way of expanding PowerShell with something called [...]
PowerShell Week at SQL University – Post 1
Getting Started With PowerShell Variables Yesterday we laid the ground work for PowerShell Week. Today we will learn about Variables in PowerShell. You will notice that PowerShell variables work very differently from SQL Server variables. The evolution of variables in SQL Server is pretty straight forward. In SQL Server 2000 you had to DECLARE a variable as a [...]
PowerShell Week at SQL University – Post 0
Welcome to PowerShell Week at SQL University. For regulars at SQLvariant, SQL University is something Jorge Segarra organized to get industry experts together to create learning courses around SQL Server. These learning courses are in one week segments that focus on a specific area. When I began blogging about PowerShell there were some complications based on [...]
The Scripts
Last week I did a podcast for geekSpeak and a similar session at SQL Saturday #38 in Jacksonville. I’ve already blogged about most of the scripts in those sessions but here is a download of a bunch of those scripts. I have changed them a little from the way they were written in my session [...]
quick post checking mount points with PowerShell
Having problems with my blog feed so this is just a temporary post. I hope to get things fixed this weekend. Does anyone know how to fix a blog feed that is bigger than 512k? This code here will loop through a list of servers that you supply it in a text file and then [...]
Picking up a New Hammer
The other day I was answering a question in the forums on PowerGUI.org that I thought would be a quick answer. The only problem was that I had my T-SQL hammer in my hand and not my PowerShell hammer. When I read the question I thought of a way to solve the problem using T-SQL [...]
