Month: April 2013
-
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…
-
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…