Vacation

The hardest thing to do on vacation is stop reading email. At least in January I managed to leave the country and turn off my email redirection to avoid roaming charges. It's also not accurate to think that if you take time off and don't go anywhere, that you will get stuff done. At least I knocked out some Christmas shopping.

Useful Script

Here is a SQL script that grants execute access to all user stored procedures and functions. While I didn't write this particular script, it comes in handy after a restore!

IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'GrantExecOnStoredProc')
DROP PROCEDURE dbo.GrantExecOnStoredProc
GO
CREATE PROCEDURE dbo.GrantExecOnStoredProc @SQLUserName SYSNAME AS
SET NOCOUNT ON
DECLARE @cmd VARCHAR(200)
CREATE TABLE #tmp (cmd VARCHAR(100))
INSERT INTO #tmp
SELECT 'GRANT EXECUTE ON ' + NAME + ' TO ' + @SQLUserName
FROM sysobjects WHERE XTYPE = 'P' OR XTYPE = 'FN'
WHILE (EXISTS (SELECT * FROM #tmp))
BEGIN
SELECT TOP 1 @cmd = cmd FROM #tmp
EXEC (@cmd)
DELETE FROM #tmp WHERE cmd = @cmd
END
DROP TABLE #tmp
SET NOCOUNT OFF
GO

EXEC GrantExecOnStoredProc '[SQL\AD Account]'

Blogging is a habit..

So, I guess that if you don't blog often, you don't blog at all. I will now make an effort to blog, more often.

That being said, I'm going to get back on track.

Seriously, the writer's strike is killing me. First they end Heroes early, then they delay 24. Now we may not have Lost for a while and Family Guy might be done for good. I can't imagine how bad the movies are going to be that get released a year form now if this doesn't stop soon. Is there not enough money in Hollywood to go around? Perhaps George Clooney can live on $9mil instaed of $10mil? Can you imagine if all Windows Systems Engineers went on strike? How about just Exchange Administrators..

I guess I need to buy more DVDs or something. Maybe Netflix can follow the IRS's lead and say "Click here to donate $1 of you subscription to the Writer's Guild."

Hello?

Ok, so.. What's good to tell you guys about? Well, Guitar Hero II for xbox is an awesome game, but I think I am the last to notice that.. I really got interested when I saw the songs that would be used in GH III
http://en.wikipedia.org/wiki/Guitar_Hero_III

What else? I am starting some good projects at work. I will be implementing an AD Management tool (the ASP.Net tool I wrote still works, but they want something with even more functionality). I'm also trying to make us an early adopter of System Center Configuration Manager 2007. I guess going from less than a 100 desktops when I started to 400 or so now dictates some changes... It's insane to think we went from 20 servers to 150+ in just 2 years too!

Anyway, bring on the football season, baseball in Houston appears to be dead!

Chris

Wow

So this is my first blog. I guess I have to do this since I am a self proclaimed SuperGeek and don't have a blog. Be warned, this will be a random flow of babeling can will mostly cover technology but may on random days cover sports, politics, religion, or pop culture..

Thanks for reading.