Monthly Archives: May 2016

Improving the performance of functions

By | May 15, 2016

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 »

Hello world!

By | May 10, 2016

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

An Overview of the tools SQL Server database professionals use

By | May 1, 2016

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 »