Ganesh Kaliaperumal created a script to export schema to files for us to easily compare with WinMerge. Check out the options and modify as needed.
Call from powershell command line like so:
.\GenerateScript.ps1 "Servername" "Adventureworks" "c:\scripts\powershell\"
Kevin Kline (Twitter|@KeKline) wrote up an article on SQLPASS.org about learning opportunities and opensource education couseware. This was news to me that it even existed and I know a lot about free software! There is a consortium http://www.ocwconsortium.org that has a list of the major Universities that participate, including MIT. Very cool.
My experience at upgrading my HP Pavilion 9500 from Vista Ultimate x64 to Windows 7 Ultimate x64 was the worst I have read about so far. To help anyone who had my issues I documented all my fixes and posted some comments on the net for those who had same issues.
Paul Randal gives an excellent explanation of why not to shrink data files if you don't have to. http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx You can turn a <1% fragmented index to 99% fragmented index with one shrink operation.
His recommendation, if you have the extra space, is to shrink by moving data to new filegroups:
Since the Red-Gate software sponsored award website doesn't post much information about us, I thought I would post my application letter so you get a better feel for what I do at work. Thanks for voting - click Vote Now image on this site: http://www.exceptionaldba.com/vote.htm
My company uses SCOM 2007 and recently upgraded to R2, which provides a whole host of new features like linux support and Service Level Dashboards. Walter Eikenboom has some great SCOM related posts and one on this feature.
If you read the release notes, SharePoint MUST be a local install, can't do remote yet.
The terminal services team blog has a great post on upcoming Windows 7 and Windows 2008 R2 multi-monitor remote RDP sessions, including comparison to the Vista span mode. Cool things to come in next version!
The SQLCAT team blog has a great tip on deleting rows efficiently to help preventing blocking and minimize log file growth http://sqlcat.com/msdnmirror/archive/2009/05/20/fast-ordered-delete.aspx.