Nathan's profileNates StuffPhotosBlogListsMore  |  Tools Help |
|
May 22 Truncating SQL Server 2005 Transaction LogI have to look this up all of the time, but if you want to email a database backup to your buddy, you can truncate all of your tables and still have a very large database! This is because the transaction log comes along with the database backup. Here is a script to truncate your transaction log (for development databases only!)
dump tran [dbname] with truncate_only
--nz May 07 Job Well DoneIt's not often I get such high compliments! So when I do I like to brag! --nz
Hi Tim,
I’d like to convey our satisfaction with the development work Nate Zaugg completed on the Hotel Online Reservation site for the Jackson Rancheria. As you are aware of the previous issues/delays surrounding the delivery of the Online Reservation site through your conversations with us, we were a bit skeptical it would only take the estimated two days to complete the work that was needed to complete the deliverable to our satisfaction given the previous months in which there was very little progress.
Though it is unknown to us whether Nate was hired in or put under contract, we do know it is individuals like him that get things done. He was able to skim the Opera Web Service manual and our previous in-house development code, and then code from scratch to integrate the Online Reservations to our new Internet site. It was impressive.
We appreciate the expertise you have granted us by bring Nate on-site and hope he is kept aboard your company in some capacity whether for us or for any of your other clients. Thank you, Steven 3-Way SwitchI have to re-think how a three way switch works every time I go to wire one! I created a Visio of the circuit to help me remember and thought it might be handy to someone else. We will be building our house in the coming months and unfortunately, it doesn’t look like they are going to let me wire it! Here comes the 14 gauge wire and “stab-in” connections on outlets and switches! In my opinion 14 gauge wire and the stab-in connections are overused! 14 gauge wires are not recommended for runs longer than 100 feet. Also, its capacity is roughly 15 amps which could easily be overloaded up with a vacuum cleaner, TV and light! There is an outlet in my house in which if my wife uses her hair dryer the lights dim (a lot!). There must be at least a 10 volt drop! This is a circuit in which it’s more than 100 foot run, and overloaded (the entire upper story is feed by a single 14-2 wire!).
Maybe I am being too pedantic but I think that using 14-2 in conjunction with stab-in connections is a bad practice, in spite of its current safety record! Residential wiring is still in its infancy; 40 years ago aluminum wires seemed like a great idea and the stab-in connections have already been banned with 12 gauge wire, and aluminum wire because of safety concerns! If I had my way, there would be very little 14 gauge wire in my new home; unfortunately, I doubt I have a choice! |
|
|
