Category Archives: SQL

Useful code snippets in Sql.

Microsoft DreamSpark

Even thought I am a Windows user, I am no where near a Microsoft lackey but recently I learned that Microsoft is giving away a ton of professional grade software to students. Through the Microsoft DreamSpark program, students can get access to Visual Studio 2008 Professional, Windows Server 2003 Standard Edition, Microsoft Expression Studio, XNA [...]

Also posted in Design, DotNET, IDE, Programming, TechKnow, Tools, Visual Basic | 3 Comments

Perforce Report

I’m a really competitive developer and I like to see how many files I checked in a week compared to my fellow coworkers. I know that counting then number of changed files is no way near a correct accounting of my productivity but it is an easily quantifiable metric. Perforce has an optional P4Report download [...]

Also posted in Programming, Tools | 1 Comment

Repair A Crashed MySQL Table

I went through a bit of a scare with my blog today. All of a sudden I keep getting a barrage of emails informing me that my new WordPress blog had been successfully set up at Juixe TechKnow. I was like, WTF! I immediately emailed the technical support for my hosting provider but they did [...]

Also posted in TechKnow, Tools | 11 Comments

SQL Server Query Shortcuts

Sometime back I detailed the command to describe the details a database table for Microsoft SQL Server. To detail the a given database table you can use the sp_help command. If you don’t want to type sp_help every time you want to see the structure of a table you can use a query shortcut. Microsoft [...]

Also posted in TechKnow | 2 Comments

Top Programming Books on Google Book Search

Here is an extensive list of top programming books available for preview on Google Books. Google Books provides scans of thousands of textbooks. The scans are not the best, most books have visible scan defects in them. Even though the scans are not the best, there are some features that just work well. Just like [...]

Also posted in Books, DotNET, Java, JavaScript, PHP, Programming, Rant, Ruby, TechKnow, Visual Basic | 1 Comment

Java Persistence API – Best Practices and Tips

This JavaOne 2007 session was packed the rim but I soon discovered I should have gone elsewhere. Everything in Java has some type of context and JPA is no different, the speaker was talking about the Persistence Context, blah, blah, Entity Manager, something or other. I found this session a bit hard to follow, a [...]

Also posted in Conference, Java, TechKnow | Leave a comment