erlösung

going dark part one

noreply@blogger.com (Anonymous) — Thu, 18 Feb 2016 12:38:00 +0000

my mom and my stepdad live in a retirement community in the tampa, florida area. one of their neighbors is a married couple, both the husband and wife of whom made their careers in the federal intelligence community. the husband is still an active CIA agent who spends long periods of time in the middle east. the wife worked for the FBI but is now retired. at some point, she and my mom were discussing social media and my mom brought up having to use her friends' accounts to snoop around since my brother and i forbade her from joining facebook. her friend laughed and said we had done her a favor. when my mom asked what she meant, she replied "if you are on facebook or twitter, get off. that's all i can say."

i have been anti-facebook for a long time but not always for the same reasons. facebook appeals to the narcissist in you. if you can't admit to that, you should know that they are in the intelligence business but more in the google sense of collecting every bit of information on as many people as possible rather than only spying on 'bad guys' like the my mom's neighbors. i always considered myself the paranoid brother between matty and i but something triggered a change in him and he started making me aware of all of the different ways sites collect your information (i'll write about this in a different post). i stopped using google as a search engine in favor of duckduckgo but there was far more work to be done

back to facebook - i had quit previously but always came back, usually while drunk and powerless against my impulses to spy on someone or post something inappropriate but hilarious. since i quit drinking, this was no longer a factor and so i quit facebook and instagram months ago and haven't returned. this left twitter (which i couldn't tell you the last time that i used - probably humanafest last year), foursquare, swarm and linkedin. unlike facebook which retains your data seemingly indefinitely, twitter deletes your handle, history and all information after 30 days. i don't know why this made me hesitant but it did. i love swarm but not for any good reasons. i like being the mayor of places, especially where i work where it has always been an active competition between my coworkers. yesterday i decided that neither the public availability of my twitter history nor the prestige of mayorship were really adding anything beneficial to my life so i left facebook, swarm and twitter. linkedin is a colossal annoyance except for when you are looking for a new job or entertaining job offerings to get a feel for the market when you are negotiating your salary. if anyone from dynamit is reading this, meet me at the current median going rate of a software developer in the columbus area with thirteen years of experience and i will leave linkedin immediately and complete the circle

that's the history that led me to write this. next will be why going dark was important to me and why i take pride in having done it (with the one exception already stated)

be wary of the results of sys.dm_db_index_physical_stats

noreply@blogger.com (Anonymous) — Fri, 14 Dec 2012 20:21:00 +0000

my coworker (@developingjim) and his team was troubleshooting a client database production down issue this past weekend and discovered something that neither he nor i were aware of - the sys.dm_db_index_physical_stats function only scans index parent-level pages (leaf-level +1). the results of this versus running the function in DETAILED mode (which scans all pages and returns all statistics) can be drastically different. The image below shows two queries and the results for each:

The first query lead the team to believe that index fragmentation was not an issue; the second revealed that this was far from the truth and the crisis was resolved after the massive fragmentation was addressed

windbg - issues loading sos for .net framework v4

noreply@blogger.com (Anonymous) — Thu, 26 Jul 2012 21:31:00 +0000

from stack overflow:
"The CLR runtime dll was renamed to clr.dll with .NET 4. So in order to load the correct version of SOS you need to adjust your .loadby command. I.e.

.loadby sos clr"

sql server best practices: disk configuration

noreply@blogger.com (Anonymous) — Thu, 05 Apr 2012 18:01:00 +0000

store the data and the log on different physical drives
use the appropriate RAID level depending on the importance of performance and redundancy

performance only - RAID 0
redundancy only - RAID 1
performance and redundancy - RAID 5 or RAID 10

place files on subsystem connected to different controllers
mirror the transaction log
mirror the master and model system databases
stripe the tempdb database
store the user database files on a different physical drive from the master , model and tempdb system databases
monitor the default filegroup or allow for automatic growth
RAID, SAN and NAS appear as driver letters
use direct-connected hard drivers or SAN instead of NAS or network file shares
use NTFS

humana fest 2012 review: the veri**on play

noreply@blogger.com (Anonymous) — Wed, 04 Apr 2012 19:34:00 +0000

writer: lisa kron
director: nicholas martin
summary: jenni made a minor mistake three months ago on the payment of her cell phone bill and cannot get it resolved no matter how many times she speaks with customer service and is assured that it is taken care of. she eventually reaches the breaking point and joins a support group for others dealing with similar life-altering experiences with evil, incompetent customer service departments
grade: B
comments: basically a one hour and twenty minute bashing of the pathetic quality of modern customer service. verizon wireless is the main focus of the insults and rants but shots are also fired at other companies and industries (anthem blue cross/blue shield, greyhound, credit agencies, mortgage brokers, etc.). the actors that played jenni and her sister did a very good job but i would not say the same about the rest of the crew. if you take it for what it is - a comedy dealing with modern day frustrations that mixes intelligent and funny dialog with over-the-top, intentionally dumb humor - you will probably enjoy it

humana fest 2012 review: the hour of feeling

noreply@blogger.com (Anonymous) — Wed, 04 Apr 2012 19:07:00 +0000

writer: mona mansour
director: mark wing-davey
summary: a young palestinian man (adham) who recently received his doctorate in english romantic poetry meets some bumpkin broad (abir), quickly marries her and then the couple moves to london where a prestigious university has asked him to give a lecture. the lecture is a success but abir speaks no english and doesn't fit in well in the company of academia so their marriage struggles almost immediately. war breaks out in the middle east and adham must choose whether to stay and pursue his career or return home with his wife
grade: a-
comments: i thought the play was engaging, very well written and did a good job of mixing in comedy with the drama. i was very impressed with how the way the writer tied events from the beginning of the play and discussions of poetry between adham and his colleagues with the final scene

humana festival of new america plays 2012 reviews

noreply@blogger.com (Anonymous) — Wed, 04 Apr 2012 19:04:00 +0000

i saw six plays this year: the hour of feeling, death tax, michael von siebenburg melts through the floorboards, oh, gastronomy!, the veri**on play and how we got on. overall i would consider this collection of plays the second best i've seen in the four years that i've attended the festival. i was also happy to see such a wide variety topics in the plays as opposed to the last two years where the overriding theme was male homosexuality and each year it seemed like the directors and/or writers competed to see who could edgier starting with the abundance of live dude dick i saw two years ago and escalating to full-fledged cock-in-ass last year. rather than reviewing every play in a single post, im going to write about each individually since i don't know how long it will take me to get through them all and i want to publish my thoughts on the ones that really stick out in my mind while the memory is fresh

how to fix screen shrinking problem on jailbroken iphone

noreply@blogger.com (Anonymous) — Fri, 16 Mar 2012 18:13:00 +0000

there seems to be a bug in the absinthe jailbreak for iphone os 5.0.1. occasionally when you open an app it will shrink into the upper-left corner of the screen. i know of no permanent fix for this, but since it doesn't seem to happen very often, i figured out a way to temporarily fix this when it occurs:

download sbsettings from cydia if you haven't already (note: if you can't get cydia to appear in a normal window, try rebooting until it does). reboot/respring if necessary
swipe from left-to-right or right-to-left across the top of the screen to get the sbsettings menu to drop-down.
click the power button
click 'safe mode'
when you reboot in safe mode, open an app. it will either immediately open in a normal sized screen or appear shrunken again and then restore to normal size.
click 'exit safe mode' at the top of the screen
click to restart to return to normal mode and the problem should be fixed

you're welcome, alyssa

untethered jailbreak for iPhone 4s

noreply@blogger.com (Anonymous) — Thu, 02 Feb 2012 20:13:00 +0000

the wait is finally over - the chronic dev team released absinthe for Linux, Mac and Windows operating systems. For Windows 7 users the process is very simple - download the application from the absinthe link, log in as the local administrator account (required - absinthe won't run if you are logged in as any other account, even if they belong to the local administrators group), plug in your phone and run the application. make sure to disable the passcode lock on the phone if one is set and it is highly recommended to back up the device before you jailbreak it. i have 15 GB of data on my phone and the whole process took ~5 mins

sql server best practices: database creation

noreply@blogger.com (Anonymous) — Wed, 20 Jul 2011 14:15:00 +0000

when you create a new database in with the default options, sql server creates two files, the data file and the log file, in a single filegroup called PRIMARY. the files are created in the DATA sub-folder of the directory where you installed sql server unless you override the defaults (as you should). the state of the PRIMARY filegroup determines the state of the database

why this is bad: by only having one data file, user databases are stored in the same location as system databases. the majority of data changes occur in the the user databases. if the drive fails in the middle of a write operation, your data file becomes corrupt and all databases within become unusable. while having separate data files for your system and user databases avoids the previous situation, corruption to any file in the PRIMARY filegroup makes the database unusable.

what to do instead: minimally, all new databases should be created with two filegroups, two data files and a log file. the filegroups and the log file should all ideally be located on separate drives (which are hopefully RAID drives but more on best practices for RAID configurations for data log files in a future post). place one data file in the PRIMARY filegroup. this data file will contain the system databases and has a file extension of .mdf by convention. place the other data file in the second file group. this data file will contain user databases and has a file extension of .ndf by convention. change the default filegroup from PRIMARY to the second filegroup so new objects are created in the .ndf data file.

how to make soap

noreply@blogger.com (Anonymous) — Fri, 29 Apr 2011 13:36:00 +0000

disclaimer/warning - this soap is for clothing. i have no idea what would happen if you put it on your person but i know what the individual ingredients do so i don't recommend it

granny's homemade soap

1 3/4 quart lard

1 quart water

1 can lye

1 cup ammonia

3 tablespoons borax

cooking pan (2 inch sides)

dissolve borax in 1 cup boiling water

put lye in granite kettle and cover with water

allow to cool, then add the dissolved borax, lard and ammonia. stir for five minutes

pour mixture into pan with two inch sides and set in cool, dark place to harden

cut into bars and let sit for at least three weeks before using

sql server best practices: tempdb

noreply@blogger.com (Anonymous) — Fri, 11 Mar 2011 20:28:00 +0000

despite all of my lovely certifications and ten years of experience as the company dba, i am constantly faced with sql server performance issues (deadlocking more than anything else) that challenge or completely go against what i thought i knew about best practices. today, i learned that the default settings for the tembdb system database are far from adequate; the settings need to be changed based on the server environment. this is something that i've known and preached about with user databases (optimal hard disk RAID configurations, separation of physical and log files, etc. - i will cover this in another post), but i only really knew that the tempdb is recreated whenever the server is started and that the default size of the database files should be set large enough such that auto-growth never occurs. the following are some things i didn't know:

the number of tempdb physical files should be equal to the number of processors or cores on the server. as the name implies, the tempdb stores temporary information required by sql server to complete some operation such as intermediate result sets and temporary tables created in queries. if there is only one tempdb data file, only one processor will be used to read and write information. to make use of all of the available processors, create one physical file per processor and set them all to be the same size.
since the tempdb is recreated every time the server starts, redundancy is pointless. put the tempdb files on the fastest drives available
auto-growth of the tempdb is bad for the same reasons that auto-growth is bad for user databases (file fragmentation, processing halts while the file grows, etc.) but, since the tempdb is constantly used for operations, the heinousness of auto-growth of the files grows exponentially with server load. don't be stingy with the default size - allocate enough disk space to ensure that there will always be enough available without depending on growth

edit: divide the maximum amount of memory allocated to sql server (server properties -> memory) by the number of logical processors to get the recommended size of each tempdb physical file

edit: great reference

understanding physics 01: derivation of fundamental linear motion equations (cont'd)

noreply@blogger.com (Anonymous) — Thu, 12 Aug 2010 15:14:00 +0000

i finally got around to doing some of the work this morning (note: since i don't know how to insert the integral symbol, i'll use an ampersand instead):

v = dx/dt, vdt = dx, &vdt = &dx -> vt = x (assuming x0 is zero, v is avg velocity)
a = dv/dt, adt = dv, &adt = &dv -> at + v0 = v
distance (w/o vf): x2 - x1 = v2t - v1t, v2t = (1/2)at^2 -> x2 = x1 -v1t + (1/2)at^2
velocity (w/o t): x = vt, v = [(v + v1)/2], t = (v - v0)/a -> x = [(v + v0)/2][(v - v0)/a] = [v^2 - (v)(v0) + (v)(v0) - v0^2]/2a = (v^2 - v0^2)/2a, 2ax = v^2 - v0^2, v^2 = v0^2 + 2ax

understanding physics 01: derivation of fundamental linear motion equations

noreply@blogger.com (Anonymous) — Wed, 04 Aug 2010 16:54:00 +0000

i'm tutoring someone in physics again and i was thinking about how to explain why conservation of energy is so fundamental in physics but specifically in classical mechanics while driving to work this morning. one of the reasons i love physics more than other sciences is that it conceptual understanding doesn't require excessive blind memorization of symbols, constants, tables, taxonomic ranks, etc. If you can remember Newton's laws, understand that energy is conserved, know how work relates to force, distance and direction, you pretty much just need two equations and basic calculus to solve any problem through intermediate mechanics: F=ma and v=dx/dt. there are numerous equations you could memorize to solve problems involving linear and angular motion, but all of them are derived from v=dx/dt (i guess you also need to know that there are 2pi radians in a circle for angular motion problems). i remember that at the start of every exam, i would derive the equations for distance, velocity, acceleration and time and, for whatever reason, this would always calm me down. i've decided to see if i can still do it and will post my notes when i finish or give up

jailbreak the iphone 3GS OS 4.01

noreply@blogger.com (Anonymous) — Mon, 02 Aug 2010 14:11:00 +0000

if you made the terrible, terrible mistake of upgrading your iphone 3GS to OS 4.0 before a jailbreak was released, the day of salvation has arrived. an ingenious 17 year old has released the first OTA (over the air) jailbreak for the iphone which will finally give freedom back to the poor souls on OS 4.0. backup your iphone and then open safari and navigate to http://jailbreakme.com. note that it took me three tries before the download started so don't give up if it doesn't appear to work the first time. a progress bar and status message will inform you when the download is complete and then once the jailbreak is complete and cydia is installed. if you have not already done so, allow cydia to store your ECID

jailbreak the ipad or iphone 3G/S OS 3.1.3

noreply@blogger.com (Anonymous) — Fri, 14 May 2010 19:32:00 +0000

it is again possible to jailbreak your iphone if you made the mistake of upgrading the OS to 3.1.3 (or broke your phone and had to buy a new one that already had the damn thing on there). spirit is a small (4,464 KB), free application that jailbreaks your iphone with the click of one button in ~30 seconds including the reboot. it will also jailbreak your ipad but i won't know the amount of time that it takes until mine arrives next week :) (edit: ipad jailbreak ~15 seconds)

recommended applications once your device is free from the controlling, icy grips of apple:

infinidock - dock as many applications as you please (well worth the $.99 cents)
five column springboard - five columns of apps on every screen instead of four (free) (edit: note - do not install this on an ipad. it will add a fifth column but all of your icons will squish together)
sbsettings - bossprefs 2.0. slide your finger across the top of the screen to access all of your phone information and change configure any setting you can imagine (free)
backgrounder - run applications in the background. from experience, this is much more useful if you have a 3GS that can handle it (free)
mxtube - save youtube videos to your phone (free)
yourtube - like mxtube but integrated with existing youtube app ($2.00)
lockdock - launch applications from your lock screen ($2.00)
installous -don't feel like paying for that appstore application? get it for free using installous (free)
appsync -include cracked applications when you backup/restore your iphone (free)

the latter two apps require you to first add the hackulo repository (from cydia: manage -> sources -> edit -> add, enter cydia.hackulo.us and click 'add source')

all thanks to @Lavarsicious for this information

jailbreak the iphone 3G OS 3.0

noreply@blogger.com (Anonymous) — Wed, 01 Jul 2009 16:10:00 +0000

jailbreaking an iphone is a process that allows you to install applications without having apple approve them first - it's your phone, you should be able to put whatever you want on it. having said that, the freedom you gain by jailbreaking comes at the cost of being kicked out of the nest and out from under the protective wing of apple. i don't know but doubt there are possible legal ramifications for jailbreaking but i can guarantee that shiny icare protection plan you bought isn't worth the cardboard it came in if you send in a hacked phone and ask apple to please fix the booboo. get the facts, weigh the pros and cons and know why you are doing this before you start.

...or you could be reckless and cavalier like me and just do it because it sounds cool

i used the information found here as a guide and highly recommend it; however, if you understand what you're about to do and/or you've been reading about the experiences of others, you should realize that jailbreaking doesn't always go as planned. i you didn't realize that, you should and you do now, but you should also realize that as long as you don't freak out or at least refrain from physically stopping the process (e.g. disconnecting the pc power cord or turning off your laptop, disconnecting the phone from the pc, formatting your hard drive during the jailbreak, etc.), at worst you should have your phone back to where it was before you started toying with it in an hour or two. here is my interpretation of the information presented in the link above and how i'd walk someone through the jailbreak (draft one since work is calling):

connect your iphone to your pc and allow it to fully synchronize. this gives you a point-in-time backup of your phone and later allows you to automatically recover all of your apps/contacts/settings/etc. and keep the jailbreak.
download the 3.0 installation package manually. you will have one locally if you upgraded to 3.0 through iTunes, but i was unable to get through the first reboot of the jailbreak using this file.
download and extract redsn0w (i'd do as they say and use the torrent they certify). it doesn't matter where you place or what you name the folder that will contain the extracted files.
run redsn0w and browse to and select the .ipsw file you downloaded. i don't know if your phone has to be on and attached to your pc at this point but i would assume so since the application appears to verify that the OS version on your phone matches the one from the file.
(edit: i seem to have issues with redsn0w completing if my phone is password protected. to be on the safe side, i would disable this feature before continuing) do as redsn0w says but don't freak out if you don't time something perfectly. your phone will visibly react to both the initial two second hold of the power button and the following ten second hold of both the power button and the home button; however, it never took more than 13 seconds on the final step of holding just the power button for redsn0w to take over (the screen will flash and display an image and a message stating that installation started). once you see this you can let go of the home button and let redsn0w do the work from there.
occupy yourself with something else for the next twenty or thirty minutes because the install takes time. if you sit there and stare at it, you run the risk of worrying that it is taking too long and freaking out and doing something stupid and possibly dangerous to your phone.

b. if the phone never comes back from rebooting (i.e. stays powered off), just cancel the jailbreak, detach the phone from the pc (probably optional) and turn it back on - you will see it is perfectly fine and looks exactly like it did before you initiated the jailbreak.

once you can get back to your home screen, detach and then reattach your phone to the pc. this will confuse itunes and it will ask you if it should treat the phone as new or if it should restore the phone from a backup. select the backup you created in step 1. and continue. this will likely take longer than the actual jailbreak but you are in the clear at this point.
after itunes finishes restoring the backup and synchronizing, you will have a phone that does everything you loved before but is no longer under the all-seeing eye of the apple gestapo.

post any questions and i'll do my best to help as soon as i can

CONDG Presentation

noreply@blogger.com (Anonymous) — Fri, 25 Apr 2008 14:41:00 +0000

I'm very grateful to all those who attended the presentation Scott and I gave last night. I will be doing a screencast next week of the demo that I was unable to get to due to technical difficulties. I guess I need to clear up something that I said last night because I was asked about this more than anything else:

Johnny Cash was an immensely influential American singer and song writer and is probably the most recognized country musician of all time. His 'calling card' and what most people associate with him was the dark clothing he wore, usually all black, hence the crack on myself before I gave my presentation

.NET Garbage Collection PopQuiz Quick Answers

noreply@blogger.com (Anonymous) — Tue, 15 Apr 2008 11:58:00 +0000

all credit to Tess for this.

the original quiz can be found here

Tess's answers and further explanation can be found here

1. How many GC threads do we have in a .NET process running the Server version of the GC on a dual-core machine?

A: server version = one thread per logical processor = two threads (four if hyper threaded)

2. What GC mode is used in the web development server (cassini) on a quad proc machine? Why? (you can choose from server, workstation or concurrent-workstation)

A: cassini = windows forms app = user interaction = use concurrent-workstation

3. How many finalizer threads do we have in a .NET process running the Server version of the GC on a quad proc machine?

A: Tess states that the answer is one per process. further investigation only lead to more confusion - server version of GC on a quad proc machine means four GC threads (eight if hyper threaded). i believe the answer is either one or four/eight. i'll keep reading and update this when i find an explanation that makes sense to me

UPDATE: the gentleman walker looked into this and found that, at a given time, there is one per .NET process with a maximum equal to the sum of the number of worker process allocated to each application pool. the process will only show up in taskman if the associated app pool/web site is in use

4. When is an object garbage collected?

A: when the object is no longer referenced and a GC occurs for the generation your object is in

5. What causes an object to move from Generation 0 to Generation 1 or to Generation 2?

A: the object is still referenced when a GC occurs for the generation the object is in

6. If you look at the GC sizes for Generation 0, 1 and 2 in perfmon, why is most of the memory in the process in Gen 2?

A: gen 0 and gen 1 have small sizes (though these sizes are not fixed); gen 2 does not. since GC occurs when gen 0 and gen 1 are nearly 'full', referenced objects will eventually end up in gen 2 where they will remain for the remainder of their life (i.e. until they are no longer referenced and eventually cleaned up)

7. How many heaps will you have at startup on a 4 proc machine running the server GC? How many would you have if the same machine was running the workstation GC? Will the memory used for these show up in private bytes or virtual bytes in perfmon or both?

A: one small object heap and one large object heap per logical processor for server GC; one small object heap and one large object heap in workstation GC. as far as the memory part of the question, this is how i understand it - virtual bytes corresponds to memory reserved by a process, whereas private bytes is the memory actually being used by the process. if all goes smoothly, the graphs for these will follow each other which means the process is allocating memory correctly. at startup, virtual bytes may be a lot larger than private because the reserved memory hasn't been used it, but private bytes should eventually catch up to an extent and both should smooth out in perfmon

8. (Leading question:)) Is the fact that you have mscorwks.dll loaded in the process in 2.0 an indication of that you are running the workstation version of the GC?

A: no; in 2.0, both the server and workstation versions of the GC reside in mscorwks.dll

9. Can you manually switch GC modes for a process? If so, how and under what circumstances?

A: the answer is "yes, but...". i'll leave Tess to explain the restrictions:

a) you can not run the server version on a single proc box, it will default to workstation

b) you can not run concurrent while also running server

c) if the runtime is hosted, the hosts GC mode will override the configuration

10. Name at least 2 ways to make objects survive GC collections unnecessarily.

A: create an unnecessary finalize method. create a objects within a method and then have the method perform some action for a long time, preferably one that causes memory pressure which will trigger a GC and the referenced objects will not be collected

11. Can a .NET application have a *real* memory leak? In the C++ sense where we allocate a chunk of memory and throw away the handle/pointer to it?

A: not in the C++ sense, but leaking memory is quite possible. see Tess lab 6 (which was also covered in my presentation)

12. Why is it important to close database connections and dispose of objects? Doesn't the GC take care of that for me?

A: disposing the objects releases their resources and makes them available for GC immediately (note: calling dispose on an object does not trigger a GC)

iTunes and QTFairUse

noreply@blogger.com (Anonymous) — Wed, 12 Mar 2008 18:43:00 +0000

if you're like me and simply prefer the .m4a file extension to the .m4p file extension that hangs from the end of files newly purchased from iTunes, you probably use either QTFairUse (QT) or myFairTunes. to continue to purchase music from the iTunes store, i was forced to upgrade to at least version 7.4. i also noticed earlier that QT was no longer functioning correctly - it would just spit out the name of all the songs on my list preceded by the test 'could not play track'. i figured an upgrade/reinstall wouldn't hurt and may actually solve both problems. the download page for the iTunes installer only allows you to download version 7.6; however, the latest version that QT 2.5 supports (despite the readme file saying that the max is 7.0.2) is 7.5. luckily, i always keep a local copy of the iTunes installer for the latest version supported by QT.

<tangent>
am i the only one to notice a strange correlation between the timing of QT supporting the most current version of iTunes and iTunes prompting me to upgrade to a newer version that contains just fuckloads of new features. ever wonder why iTunes seems to be the only product that doesn't come with a 'what's new' document, or why you can't find any reference to this on their website? that's because, as far as i can tell, nothing new has been added since 6.0 - maybe even somewhere in the 5.x realm. why can't the assholes just admit that the only new feature is a new encryption key to keep the crackers (the computing type, not white people in general) off their tails for a few months?
</tangent>

that was the background, here is the problem: i upgraded to 7.5 and was able to download my music, but QT kept saying it couldn't find my music library. i navigated to my music folder and found an assload of .itl and .xml files with ' - copy (n)' and even some ' - copy (n) copy' appended to the filename, where n went as high as five or six. i assumed these were created by QT since there is an option to backup the current library and this option is selected by default. what i couldn't find was the non-copied version of my library, which is what QT was looking for. i moved all of these .itl and .xml files to a backup folder thinking that iTunes would prompt me for the location of my library and i could just rename my latest copy to the default name and put it back in the original location and everyone would be happy. this didn't happen. iTunes instead created a new .itl and .xml file with ' - copy (x)' (can't remember which it was) in the default location and the application came up with nothing in my music library.

solution: close iTunes, then hold down shift and launch it again. it will prompt you to use an existing library or create a new one. at this point, you can copy one of the backups to the default location, give it the default library name, and you will have all your music back in your library and the ability to strip your songs of evil, evil copyright protection once again

p.s if anyone needs either the installer for iTunes or QT, feel free to contact me.

classical mechanics problem: box on an incline

noreply@blogger.com (Anonymous) — Wed, 13 Feb 2008 15:26:00 +0000

for some reason i'm in a physics mood so i thought i'd share a classic problem that anyone that took elementary mechanics would come across at some point and how to solve it .

Q: a box of mass m sits motionless on an incline. what is the maximum angle Θ of the incline before the box begins to slide down?

A: all good little physics students know the first step is to draw a diagram and then add forces:

where Θ is the angle of the incline, μ is the coefficient of friction and N is the normal force

now lets disect the horizontal and vertical forces on the box:

ΣFx = horizontal component of gravity - friction = mgsin(Θ) - μN = 0 (box is stationary)

-> mgsin(Θ) = μN

ΣFy = vertical component of gravity - normal force = mgcos(Θ) - N = 0 (box is stationary)

-> mgcos(Θ) = N

we have two equations and three unknowns (Θ, μ, and N). the second equation gives us a N in terms of Θ, so let's plug it into the first equation and then solve for Θ:

mgsin(Θ) = μ(mgcos(Θ))

cancel out mg on both sides and get μ by itself:

μ = sin(Θ)/cos(Θ) = tan(Θ)

bring tan to the other side and we are done:

Θ = arctan(μ)

the solution tells us that the largest angle of incline before the box moves is dependent on the coefficient of friction of the incline.

mercy i loves me some classic mechanics :)

bubu made the rock band hall of fame

noreply@blogger.com (Anonymous) — Wed, 13 Feb 2008 13:51:00 +0000

on a personal note, i would like to congratulate bubu on their induction into the rock band hall of fame. most of the credit goes to my singer, YEAHYEAH (who also happens to be the computing services/IT/network guy where i work) and, or course, me, who is most proficient with the axe (both lead and bass) but is also more than competent with the sticks (drums) and has had to take that role when friends with no rhythm whatsoever come over and want to play. a special thanks goes to maneet and good sir thomas playing bass and lead guitar respectively for assisting YEAHYEAH and i on that fateful night. i'd also like to thank diiiiiiiiiidddtttyy, good sir thomas, lonlon and YEAHYEAH for helping the band regain several hundred thousand fans that we lost when i had too much to drink and repeatedly played and failed the song 'gimme shelter' by the stones (alcohol gives me sausage fingers). i'd also like to thank alex (who is a phenom with the sticks), tha dream (who really isn't that good with the sticks), superman, and winnie (who recently became tha dream's wife), for their help along the way.

come to think of it, all the above mentioned people with the exception of good sir and winnie work with YEAHYEAH and i. i think this is one of the reasons that i love where i work - i like to hang out with my coworkers, be it going out boating, going out to a bar, hanging out late at work late and discussing business over a beer or just having everyone come over for some rock band jam'ins. at least half of tha dream's wedding last week was composed of coworkers. i genuinely consider these people friends and am eternally grateful that i work for a company that encourages this kind of environment.

the effects of changing a machine's name on sql server

noreply@blogger.com (Anonymous) — Wed, 13 Feb 2008 13:29:00 +0000

i decided to post about this because, i shit you not, every single member of our solution delivery department (aka our consultants) and a good number of our developers have approached me with issues after renaming their machine. one may be wondering why so many people are renaming their computer in the first place. simple - in my neck of the woods, we have several baseline virtual machine images built up for anyone to use. when someone begins using it, they typically give the 'computer' a new name (especially if they want to join it to the domain). the problem is that sql server doesn't pick up on this and programs that try to connect to the server by referencing it by the new name (or new name\instance name) will get errors along the lines of 'the server could not be found in the sysservers list. try adding the server using sp_addlinkedserver'. don't do that; it won't work. try running this command against the master database instead:

SELECT @@servername

it will probably return the name of the machine (\instance name) before you renamed it. the fix is this:

sp_dropserver '{oldname}'

where {oldname} is whatever was returned by your first query. after that, run this:

sp_addserver '{newname}(\instancename)', 'LOCAL'

obviously only include (\instancename) if it is a named instance of sql server. restart the sql server service, then re-run your original query and it should return the correct name (you will have to either open a new query editor or re-connect the query editor screen you originally used as restarting the service will cause a disconnect).

damned system named constraints

noreply@blogger.com (Anonymous) — Tue, 12 Feb 2008 16:42:00 +0000

problem: you need to write a script to alter or drop a column as part of a hotfix for your clients. this column was created with a default constraint, but this default constraint was not explicitly named, thus a system-generated name was given (which looks something like 'DF__(partialtablename)__(partialcolumnname)__(random numbers and letters)' in SQL Server 2005). since the name of the constraint will be different on every client, you can't write a straight forward 'ALTER TABLE DROP CONSTRAINT ' statement.

solution: system tables aaaaaaaand ...

dynamic sql!!! weeeeeeeeeeeeeeeee

(i don't know why i got excited about something i genearlly preach against, but, as i've said before, dynamic sql is a necessary evil and can be very useful)

/*1. i think it is good practice to validate that something exists before dropping it (or does not exist before adding it). that way if a sql query that is part of a hotfix is accidentally run more than once, no errors should occur. this script simply checks to see if there is a constraint on a column named 'col_a' in table_a:*/

IF EXISTS (SELECT OBJECT_NAME(constid) FROM sysconstraints CN
INNER JOIN syscolumns CO
ON CN.id = OBJECT_ID('table_a') AND CO.id = CN.id AND
CO.name = 'col_a' AND CN.colid = CO.colorder)
BEGIN

/*2. the following sample then removes the constraint from the column:*/

DECLARE @Sql AS NVARCHAR(2000)

SELECT @Sql = 'ALTER TABLE table_a DROP CONSTRAINT ' + OBJECT_NAME(constid)
FROM sysconstraints CN
INNER JOIN syscolumns CO
ON CN.id = OBJECT_ID('table_a') AND CO.id = CN.id AND
CO.name = 'col_a' AND CN.coldid = CO.colorder

EXEC(@Sql)

END

/* to be extra safe, you may want to include the type of constraint you are dropping as part of the join. the type of constraint is contained in the pseudo-bit-mask value of the sysconstraints 'status' column. as an example, a default constraint will have a status value of '133141' */

preserving the stack trace when handling exceptions

noreply@blogger.com (Anonymous) — Tue, 29 Jan 2008 18:19:00 +0000

i just now stumbled across something that i didn't realize (though it makes sense) about the difference between throw and throw ex within a try...catch...finally block and i thought i'd share the wealth. i have the feeling this may be one of the "holes" in my coding knowledge/fundamentals that everyone else knows except for me since i was a physics major and only took 16 hours worth of computer science back in college. if so, you can politely skip this post and be happy for me that i learned something valuable. if you think i'm dumb for not knowing this, just know that i think you're dumb for not knowing that an operator that commutes with the Hamiltonian does not evolve with time. yeah, what now??

here's the gist:
case i) if a method call within a try...catch block results in an exception, calling throw(with or without an exception instance) causes any code in the ...finally block to immediately execute and then execution continues on its jolly way up the call stack. if you want to log anything about the error, do so before calling throw. furthermore, calling throw by itself preserves the call stack, whereas calling throw with an exception instance causes the stack trace to restart from the method that re-throws the exception and you lose whatever precious debugging information you had about what was going on before the call.

case ii) if procedural code within a try...catch block results in an exception, you lose the stack trace whether you throw with an exception instance or without. you should log what you need to know about the error before you throw as suggested in case i) and additionally log the stack trace.

if you are truly masochistic/sadistic (not sure which but i'd lean towards the former), you can follow what some bloke by the name of Chris Taylor outlines here