howto

SQL Server date time conversions to/from Unix bigint format UPDATED

Categories:

I am in the middle of a SQL data conversion project. Amazingly, our *new* SQL Server database requires dates to be stored in Unix format, which is a bigint field with the number of milliseconds since 01/01/1970. Amazing, I tell you.

Here are some queries that I have found useful in this project. I have updated this article to include an alternative that does not involve functions.

How to snap windows horizontally in Windows 7

Categories:

You may know the convenient feature in Windows 7 to snap windows to the right and left: drag a window all the way to one side of your screen and it will snap to the side of your screen, taking up exactly one half of it. The keyboard shortcut Win+Left (right) arrow does this as well. But how do you snap windows to the top and bottom of your screen? It's easy!

Enable Drupal's Clean URLs feature on Network Solutions hosting

Categories:

If you are running a Drupal site with Network Solutions hosting, please accept my condolences. And the lack of shell access? The pain of your loss is almost unbearable.

However, thanks to jomariworks on the Network Solutions forums, at least you can enable Clean URLs!

Converting FLAC files on Windows, or, "How I use ffmpeg to rule the world"

Categories:

I had some FLAC audio files on my computer that I wanted to convert to a lossy format (AAC, in my case). iTunes won't play FLAC, and VLC wasn't helping me. I ended up calling FFmpeg in a PowerShell script to quickly convert all of the files.

$target = 'J:\FLAC'
$target = $target + "\*.flac"
$files = Get-ChildItem $target

foreach ($file in $files) {
    .\ffmpeg.exe -i $file -acodec libvo_aacenc -b:a 256k -ar 44100 -threads 4 -n $($file.BaseName + ".m4a")
}

How to copy group membership between Active Directory users

Categories:

Let's say you need to add a new user to all the Active Directory groups of an existing user. It would be painstaking and error-prone to compare group memberships in the AD Users & Computers snap-in. But don't despair: There is an easier way!

First, install the free ActiveRoles Management Shell module for PowerShell from Quest if you don't already have it. Trust me, you'll wonder how you managed Active Directory without it!

Second, run a command like this in PowerShell:

Remove empty lines from a file with PowerShell

Categories:

Here's a quick way to remove blank lines from a file using PowerShell. This will also remove lines that only have spaces.

(gc file.txt) | ? {$_.trim() -ne "" } | set-content file.txt

PowerShell Get-WmiObject with a variable in filter

Categories:

Let's say you want to use PowerShell's Get-WmiObject commandlet to retrieve a list of files older than a certain amount of time. Here's one way to do it.

How to disable the Windows Firewall on Server 2008

Categories:

If you're wondering "Should I turn off the Windows Firewall service to disable the Windows Firewall?" The answer is NO!

How to Exclude Yourself from Emails you send to a Distribution List in Outlook

If you send a lot of emails to distribution lists that you also belong to, it can be annoying and unproductive to move those same emails from your inbox. However, with the Rules feature in Outlook, it is easy to have your computer do this for you.

Here's how:

List files and paths in a directory tree (including files in subdirectories)

Categories:

Recently I needed to list all of the files in a large directory tree. Each line needed to include the full path to the file, and I didn't want to include the directories themselves in the list, just the files. Here's how I did it:

dir /a:-d /s /b > files.txt

The dir command, as you probably know, lists files in the current directory, but the default settings are not useful here - it does not include file path, for one thing.

Pages

Subscribe to RSS - howto