Microsoft just came out with a SLEW of new bits to check out… it’s a good time to be looking at this stuff now as we prepare for the new 2010 track of tools on the horizon… Microsoft SharePoint Server 2010 Beta Microsoft SharePoint Server 2010 provides an extensible solution platform to rapidly build solutions [...]
07.07DBCC SHRINKFILE
Yeah, nothing new (yet again), but a common DB task in SQL. Quick way to shrink the size of a data file (mdb or log file). Came in handy the other day when I had a log file grow too large and needed to trim it up: backup log < DB Name > with truncate_only [...]
This came in really handy… if you don’t want to login to another machine to run your SQL session as a different user then the one you’re currently logged in, you can do thus: For SQL Server Express: runas /noprofile /netonly /user:domain\username “C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe” For the Full SQL Server (Standard or Enterprise): runas [...]
If you’re a wordpress user (like me), and like to manage your blog occasionally straight from MySQL (like me), here is a nice quick tip for changing the MD5 Password: UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here’ ) WHERE `wp_users`.`user_login` = “admin_username”; Bookmark on Delicious Digg this post Recommend on Facebook Buzz it up Buzz [...]
11.03PDC 2008 a Success!
It’s over, and what a week it was! Lot’s of cool things at this years PDC, and instead of talking about it, I thought it would be just as good to post the pics to the conference. I included lots of screen shots from various sessions, including the keynote (cloud computing and Azure), Team Foundation [...]