Tech Blog

Jay's Technical blog

Some house cleaning...

31 January 2005
Jay Kimble

[WARNING! This is an archived post and as such there may be things broken/missing here.. you have been warned.]

Ok, I decided this morning to post all the people whose blogs I currently read on the side (for those you looking at my site in HTML).  This way when I have a few extra minutes here or there I can easily click a link and read...

You may also be interested in knowing who I read (if you are you need to find some other hobby).  If you think I should be reading your blog too then drop me a line and tell me why.  I might just start reading your blog.

If you think I'm nuts for not reading someone else' blog then tell me that as well...

[BTW, my list is still not 100% complete... I've stopped reading a few folks because of some data loss via transferring my blog rolls, and intend to add those soon].

 


Tim Blogs...

30 January 2005
Jay Kimble

[WARNING! This is an archived post and as such there may be things broken/missing here.. you have been warned.]

My good friend Tim blogs (and he notes that I haven't done much with my spaces blog which is true).

John K., you're next...

(sorry for the short entry.. I'm juggling a bunch of stuff)


REVIEW: Unicus SQL Table Utility

22 January 2005
Jay Kimble

[WARNING! This is an archived post and as such there may be things broken/missing here.. you have been warned.]

Yesterday I mentioned that I played with the 2 Xtras.Net XDN giveaways this month.  I reviewed the first of those products here.  Now, I want to talk about the other product: Unicus SQL Table Utility.


Honestly, I'm struggling with this review.  I found this utility less useful than the last one.  So, here's the scoop.  This utility let's you browse your objects in your SQL server.  It also generates code for a coupl scenarios.  It will build SQL for selecting, inserting, and updating a table.  It will also generate QA code against a stored proc.  Finally, it generates VB6 code that can used to manipulate a table or execute a stored proc (it will build simple functions/subs or a complete class module).

I guess because I'm use code generation utilities like CodeSmith or MyGeneration I'm less than impressed with this utility.  I like code generating my own code instead of generating someone else' code (I know what my code does, and am confident in what it will do). 

Beyond that fact that I don't use VB6 anymore... I'm actually ramping up to put the latest VS 2005 on my main machine.  I also only use stored procs.  I guess the generation of the SQL statements could save a lot of works on tables that have lot's of fields, but considering that CodeSmith and MyGeneration are free and I can generate complete stored procs for a table with my own custom comments (this all becomes a lot less useful)

While the QA code generation is kind of cool, it's the only real feature I find useful (for me).

Barring all this if you don't want to write your own templates and you're still using VB6 this might be a fairly useful utility for you (I'm not so arrogant to think that I represent the only true programming user in the universe).

Xtras.Net has it for $108 right here.


REVIEW: First look at xSQL

21 January 2005
Jay Kimble

[WARNING! This is an archived post and as such there may be things broken/missing here.. you have been warned.]

Ok, I just used my Xtras.Net XDN membership to get the latest free stuff for members: xSQL Object, and Unicus' SQL Table Utility.  I'm going to share with the world my initial thoughts on these products (first up is xSQL).


I picked this one first because it seems a little more useful to me.  xSQL is more of a DBA's tool.  One of the things it can replace is the Script this object functionality in Enterprise Manager.  It appears to script things a little faster and you can toggle things in a live manner; for instance you can toggle on/off whether it generates SQL script for permissions and with will dynamically add this to the script (it does throw up a progress dialog while it does this..).

It can also check an object and tell you what other things that object depends on; this is great if you are trying to determine what needs to be deployed to you production database.  To make this even easier it has a database compare tool.  It will even generate change scripts for you (and I believe you can select the objects that it generates change scripts for, so you can generate scripts for just those things that need updating and not your bleeding edge changes).

I'm totally impressed.  My normal review question "does it have a manual test has been ignored at this point" (it does have a help file) because it was fairly easy to setup and use.  My current employer needs this tool for our Development DBAS.

Xtras.Net Price - $188 - right here

[BTW, thank you Mr. Schinkel for providing a way for me to get this excellent tool]


It's always darkest before everything goes pitch black

17 January 2005
Jay Kimble

[WARNING! This is an archived post and as such there may be things broken/missing here.. you have been warned.]

So a few minutes ago I posted this.  I forgot 1 little detail in telling my fears for our industry.  Lately I've taken to saying that the next company I work for will not be publicly trading (getting me away from Sox -- Sarbanes-Oxley).  Unfortunately I spoke with my friend Tim this weekend and he told me that his privately held company must nowdo Sox because they mainly work on government contracts... <sigh>

I'm worried.  Someone help me see that all creativity isn't gone!  Please, please, please... [Maybe I'm overreacting]