Author: John
3D Photos from my Loreo Lens in a Cap
After my earlier post about the Loreo Lens in a Cap, I decided I’d post a few of my results so you can decide what the lens is like. Here are a couple of photos I took that…
Read More »A Mac OS X Dashboard Widget I can't live without – iStat Pro
iStat Pro is one of the most useful “task monitors” for an apple. I don’t even know where to start describing how useful it is. It even tells me the charge level on my wireless bluetooth mouse. Here…
Read More »Force Quitting Applications in Mac OS X
Yes, Mac applications hang. Normally you can click on the in the top left corner of the screen and select “Force Quit”. But what about keyboard shortcuts? As shown in the image above, ⌘ + ⌥ + ESC…
Read More »SQL Joins and Applies – Understanding APPLY
This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…
Read More »SQL Joins and Applies – Understanding OUTER JOIN
This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…
Read More »SQL Joins and Applies – Understanding CROSS JOIN
This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…
Read More »SQL Joins and Applies – Understanding INNER JOIN
Understanding INNER JOIN. The other posts in this series are: SQL Joins and Applies – Understanding CROSS JOIN SQL Joins and Applies – Understanding OUTER JOIN SQL Joins and Applies – Understanding APPLY This is part of a…
Read More »Creating ISOs in Mac OS X
Here are step by step instructions on how to create an ISO from a CD or DVD in Mac OS X. First, insert the CD/DVD and open terminal. Type in: drutil status Your results may vary, here is…
Read More »SQL Joins and Applies – Test Data
I’m writing a four part series on Joins and Applies in SQL. Below is the T-SQL to create the two tables and a function used to explain SQL Joins and Applies. –CREATE A TABLE VALUED FUNCTION –FUNCTION IS…
Read More »High Performance Bulk Inserts into SQL – Considerations
Did you know that simply setting the Database Recovery Model to BULK_LOGGED does not guarantee minimal logging when inserting? At the very least, for performance: Recovery Model should be set to BULK_LOGGED. Destination table should not be replicated….
Read More »