Gonzo TechNet
Microsoft SQL Server tips, tricks, configurations, & How-To's

Welcome to the Gonzo TechNet pages for Microsoft SQL Server versions 2000 & 2005. Due to the Microsoft policy of providing minimal instruction with maximum confusion, I've developed my own set of cheat sheets to enable me (and you!) to complete the daily duties of a Database Administrator. Hopefully, the will shed some light on what you need to accomplish and how to actually do it.

Below are links to answers for some of the problems I've run into over time. Feel free to use, plagerize, copy, and mangle at your discretion.

WARNING:Use at YOUR own risk!

I might be wrong, Microsoft is constantly changing things, objects are closer than they appear, results may vary depeding on mileage, my dog told me to do it that way, someone else has a better way, Jesus was a spaceman, the book I stole it from is out of print, etc., etc...

Errors, Fixes, & General Stuff...

Retrieving information

Maintenance procedures and functions

Setup and Configuration

Home | TechNet | ADO.Net | DOS | ASP.NET | IIS | VB.NET | VIM (vi) | Windows | XHtml
MS-SQL | T-SQL | SSIS | Oracle