In my progression from novice programmer to seasoned DBA, I have had cause to touch just about every part of the SQL Server arsenal.
I haven't generally worked for large multi-national corporations with IT budgets to match, so I've had to meet most database challenges with the out-of-the-box SQL Server tools provided by Microsoft. This has often meant getting down and dirty in the system tables to find creative(and free) ways of meeting business and IT requirements.
I've had a lot of help from 'the community' along the way, and it's good to know that some of the DB (and infrastructure) systems I've helped build are still operational 10 years later.
I owe part of my ongoing success to the early realisation that I have a personal characteristic that is both a strength and a weakness - I hate doing things twice. This leads me to ask a large number of detailed questions when presented with a challenge (this is where the weakness part comes in - sometimes I can ask too many questions) so that I can produce a solution that not only delivers what is required, but which is both scalable and modular enough to deliver to next weeks and next months revised requirements.
This characteristic, combined with a DBAs natural reluctance to throw anything away, has led me to keep an extensive library of code samples. Some are self-contained and generic enough to use as-is, but some may require some re-engineering to be of use, or may just serve as an indicator of what can be achieved.
Up to this point, this code library has been usable only by those with whom I have direct contact. I've now decided it is long past time to publish for the use of everyone.
As stated in my initial blog post 'Hello World', my diligence in recording the source of each idea has not always been good, but then when I started the collection, blogs didn't exist, and personal web sites were few and far between. Therefore, most of the code included has no author attribution (aside from those parts that originated with me). Apologies to the original authors - no plagiarism was intended.
While the Google Blogger offering is excellent, I'm sure there are limits to how many additional pages of information I can add, and the page layout functions are more limited than I would like too (although initially the content will be fairly straightforward). I have therefore invested in a more mainstream web site, again hosted by Google. The Code Library tab will contain the master list of all code samples, but the links all redirect to the web site. Alternatively, you can go direct to www.chilledsql.com