Recently I had to employ functions to perform a kind of name resolution on a column within the database. The database had a user table with usr_name and usr_id and then all other FK tables used usr_id . Within the procedures we could naturally do joins to fetch the username but there were many other… Read More »
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
Recently I was asked what tools database professionals use and I wanted to clarify a little bit on the topic so here goes. Previously we used to have a number of different tools when working with the database. If you look at just SQL 2000 we had Query Analyzer and Enterprise manager one for the… Read More »