Year: 2013

  • How to pour Guinness from a can

    How to pour Guinness from a can

    Here’s the secret to pouring Guinness from a can into a pint glass.  Open the can, quickly jam it in the pint upside down, and slowly it pull out.  That’s it. And if that isn’t clear enough, I made a little video for you. It even “stands up” to the pencil test.

  • My Subversion Backup Script

    In the name of all that’s good – backup your Subversion repository! Your repo is the history of the code that runs your business.  Make sure you back that beast up.  You can safely back it up while developers are using it by running the dump command. Take a dump I like to script my…

  • Rangle Up Variables with JavaScript Closures

    Using global variables in JavaScript is bad and can tick off other developers.  Use Closures to group your variables with proper scope and stop watching your back in JavaScript User Group meetings. Here’s what I mean: When you make a variable or function in JavaScript by default it’s defined on the global object and it…

  • Notifying DBAs of New SharePoint Databases

    In our production environment, the Database Administrators like to know when a new database is created or dropped. As well they should.  They normally use a DDL trigger to send out an email when one of these events occurs.  The problem we ran into was that in Windows SharePoint Services 3 (WSS3/SharePoint 2007), the trigger…

  • How to Run SQL Server Management Studio as a Different Windows User

    If you’re using Windows Authentication for your SQL Server database you’ll need to run SQL Server Management Studio (SSMS) as that Windows account to test queries.  SSMS normally runs as the user logged in to Windows, but there is a simple way to run it as the database access account. Just shift-right-click on a shortcut…