Featured Blog

Thanks to MVP Shay Levy from http://powershellmagazine.com fame, here's a quick way of dumping all ISE 3.0 keyboard shortcuts; a lot of them are...

If you think you understand PowerShell parameter binding, then have a look at this simple function which exposes a little-known PowerShell behavior:...

  If you need to know the object nature of command results, you probably know that you can pipe them to Get-Member like this: Get-Process |...

Here is another (and very solid) approach to remove leading zeroes from an IP address using a regular expression: '010.012.000.101' -replace...

There are two simple tricks to find out your current fully qualified domain name (FQDN). You can either resort to ping.exe: PS> ping -a localhost...

If you'd like to find out how long it is until next Sunday (or how many days have passed since last Sunday), simply use the property DayOfWeek. It...

If you must run an application with a different identity, Start-Process offers the parameter -Credential. This would launch the Notepad editor using...

SQL Server uses the port 1433 as its standard listening port.  Hackers know this and will use it to more easily hack into your SQL...

If you need to change and adjust settings in a registered scheduled task, there is a COM interface called 'Schedule.Service' that you can...

There is an underestimated option to make schtasks.exe dump scheduled tasks as CSV data. PowerShell can grab the CSV data and turn it into objects,...

A hash table can store any data type. If you want more control, you can create a typed dictionary (which behaves pretty much like a hash table): $ht...

I’ve heard people say many times that they don’t use full or bulk-logged recovery model or backup the transaction log of their database...

If you are like me, you hate having to type in the full path to a PowerShell script to run it.Wouldn’t it be nice if you could just execute...

One of my pet peeves is the use of RECONFIGURE WITH OVERRIDE in scripts to change server options. Am I being unreasonable or is this justified? All...

By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and the log file (or .ldf). It is, however, possible to...