Year: 2013

  • Turn Yeast into a Mosquito Killing Army!

    Mosquitoes are drawn to CO2.  Yeast create CO2.  So, use yeast to draw mosquitoes into a trap. I heard about this tip somewhere and thought I’d share it with you.  It cleverly uses yeast’s carbon-dioxide bi-product to trick mosquitoes into going into a bottle.  Since mosquitoes are also drawn to heat, you can paint the…

  • Quickly See a Table’s Columns in SSMS

    When looking at long queries you’ll typically need to remember what data is in one of the tables.  SSMS allows the creation of shortcut keys that can be used to quickly look at the first row in a table.  You’ll then be able to see the column names and some example data. In SQL Server…

  • Open a CMD Window From Anywhere!

    Open a CMD Window From Anywhere!

    In Windows 7, hold down shift and right click a folder to see some additional menu items.  You’ll notice a few extra options like “Open command window here” and “Copy as path”. Open command window here Often when browsing folders in Windows Explorer you will want to open a command shell, using the directory being…