Things I could have done for you this week.

I was thinking about finding a job and about a new post and I thought this might be interesting! 
Click here to view or download my resume!

1. I could have written you 3 to 20 SSRS reports or setup some rss deployment scripts and report execution monitoring. I could have helped you get your dynamic drop down lists working or worked on your report template and setup a report footer page to include display the selected filters,  etc.
2. Worked with a few of your clients and built them small 5 to 10 table applications exactly as the wanted, not just what they would have asked for.  I would build the application in front of their eyes as they were explaining what they wanted so there would be no possibility that they didn't get what they asked for. I would even determine the real data unique record constraints and make sure they were implemented!  MS Access 2010 rocks! Especially with Sharepoint and ADO!  I'm working on getting a few MS Access apps setup for download. The web interface still isn't great so they run much better opened in Office 2010. I'm still a bit leary of giving out links to my SharePoint site but will have some setup soon.  My DBATools on SQL Azure is going to take a few weeks. 
3. Setup a job to email you a report of every table in every database on every server  that has missing clustered indexes: These table will not be de-fragmented by the DBCC defrag but more importantly clustered indexes determine your read and write performance.
4. Setup a job to email you a report of every table in every database on every server that has missing primary keys.
5. Setup a job to email you a report of every table in every database on every server that has missing real data unique record constraints.
6. Setup a job to email you a report of every table in every database on every server that has missing referential integrity constraints. 
7. Setup a lot of jobs for your servers like ones to use VBS and WMI to defragment the hard disks, update your fragmentation report data or use DOS calls to run the cleanup utility. It's not just the jobs. It's the code too! Do you have a library of functions and procedures? If not I just gave you a ton of code.
8. Setup audit logging on every table in every database on every server with primary keys consisting of 5 or less concatenated columns.  With a little more work I could modified the code to work on larger concatenated keys or to use my preference a single unique surrogate key. Also setup the jobs to update, enable and disable the audit log triggers. They will need to be updated after every deployment involving table modifications. The audit log data will be moved to an audit log database.
9. Setup a data import routine.  If you would rather spend weeks on every new data set / file you want to import feel free!  Evidently money grows on trees! BCP works pretty good though!
10. Scanned your existing code and documented existing data issues that could save (or cost) you billions of dollars. Laugh if you want but the truth is scary!
11. Configure my trace jobs to collect data for the database tuning advisor and configure the jobs to run the tuning advisor.
12. Setup a job to collect population and selectivity data for every column in every table in every database on every server and to send you an excel spreadsheet of the data. The data your reporting on means anything it will be fully populated.
13. Setup an anomaly detection database to start analyzing your database for bad data such as disposition dates without acquisition dates or disposition dates earlier then the acquisition date.
14. Setup routines to use WinZip or 7Zip to zip all the files in a directory, delete the originals and move the zip to the SQL Server backups location or wherever you wanted.

Now how how do you find talented people when ...