The Problem You have a table chock full of good business data. This data needs to be accessed by a host of potential search criteria and any combination of that search criteria. What’s the most elegant way to right a stored procedure which accepts multiple parameters as search criteria but only returns the records that [...]
Archive for the ‘SQL’ Category
The Stored Procedure for Searching Challenge
Posted in SQL on July 13, 2011 | 1 Comment »
Running SSMS Under Another Windows Authenticated User
Posted in SQL on April 20, 2011 | Leave a Comment »
Why do this? Recently, I’ve been using Ubuntu as a host operating system and running virtual machines for my various development and sandbox server environments. This has led me to not particular want to register all of my client VM’s with our work domain and just pass my credentials when needed. For most applications this [...]

