Stuff I've picked up along the way

git Cheat Sheet

Command line tools Download git command line tools for Windows: http://msysgit.github.io/ Command line tips Create a branch and switch to it git checkout -b branchname  Switch branches git checkout branchname Push to remote repo git push origin branchname  Merging branches Be sure to commit and push branch to remote repo first for completeness git checkout master git merge branchname Delete local branch …

Read More

Accessing a Remote Git Repo from behind a Proxy Server

It is quite tricky accessing a remote Git Repo when you are stuck behind a corporate HTTP Proxy Firewall. The proxy requires authentication to access the outside world. Here is how to specify the proxy server settings for Git to negotiate its way out to the remote repo using Windows Authentication: Git Proxy Server Configuration git config –global http.proxy http://DOMAIN\\USERNAME:PASSWORD@PROXY_ADDRESS:PROXY_PORT

Read More

Mac OSX – Installing a password protected certificate from the command line

This was taken from a very helpful article over at skabber.com. I develop on a lot of machines and transferring Apple developer certificates is an absolute pain! — Thanks Jay! You saved me heaps of time! If you ever need to install a certificate into the OS X Keychain on a remote machine in such a way that Xcode can …

Read More

Handy .gitignore file for Visual Studio on GitHub

git doesn’t exactly play nicely with Visual Studio (or maybe it’s the other way around).  It probably doesn’t matter who’s fault it is. Fact is, if you add a Visual Studio solution to a git repo, you are bound to end up with a tonne of files you don’t really want in there. Cache files, build files, and all the …

Read More

Recover from a lost password on Mac OSX

This article has been copied from DailyOSX.com (http://osxdaily.com/2010/08/10/forgot-mac-password-how-to-reset-mac-password/) only to preserve it!   Thank you Paul Horowitz! This very article saved me after upgrading to Mac OSX Mavericks Preview 4.  The install went fine but then after the reboot, it wouldn’t let me login.  I didn’t forget my password – it just wouldn’t accept it.  After keying in my password, it …

Read More

Lazy unix command line script

I don’t know about you, but as a developer, I can’t count how many times a day I use the command on my Mac Terminal command-line: ls -al directoryname By definition, as a developer, I am lazy and I’m tired of typing that command. So I came up with an easy alternative:- l directoryname Back in the early 90’s, one …

Read More

SQL Server script to rebuild all indexes on all tables

You can use this script to generate SQL commands to rebuild all of the indexes on all of the tables in the currently selected database. SELECT ‘ALTER INDEX ALL ON ‘ + t.[TABLE_NAME] + ‘ REBUILD; ‘ FROM INFORMATION_SCHEMA.TABLES t WHERE t.[TABLE_TYPE] = ‘BASE TABLE’ ORDER BY t.[TABLE_NAME];

Read More

Check Upcoming Scheduled Jobs for SQL Server Agent

Here is a handy script for checking upcoming scheduled jobs for the Microsoft SQL Server Agent.  

Read More

Checking Sent Email Messages on SQL Server

Here are some handy scripts for checking the status of email messages sent via Database Mail on Microsoft SQL Server.    

Read More

How to Clear DNS Cache on Microsoft Windows

This procedure is for Microsoft Windows. For the Apple Mac OSX version of this procedure, click here. This procedure for flushing the DNS Cache has been tested and works on Windows XP and Windows 7. Open Command Prompt. Windows XP: Click Start –> Run –> Type: cmd and press the ENTER key. Windows 7: Click the start orb button –> …

Read More
Page 1 of 212»