Office Zealot

SQL Server Data Services is Microsoft's exciting addition to their Software Plus Services strategy! It's an on-demand data storage and retrieval service that will offer customers data access from anywhere on the Web. A few good points about this new service (as of the time of this writing): Microsoft has placed no limits on the amount of data ...

Hey everyone, Happy 4th fo July! I ran across this nice article by Microsoft with detailed solutions to some of the more common T-SQL problems you may encounter. Check it out! http://code.msdn.microsoft.com/SQLExamples

There are times when creating a database backup is not convenient. For example, you may be connected remotely to a SQL Server and not have access to the backup files that may be created. For times like these, I love the SSMS Tools Pack. You can find this handy gem of a SQL Server addon at http://www.ssmstoolspack.com/Download.aspx. Once you ...

I ran across a very cool site today that is hosting virtual sessions of SQL Server 2008. You create an account there and then get a remote desktop connection to a machine with the latest beta copy of SQL Server 2008 already installed. Best of all, any work you do in the session will be persisted so you can setup a new database, test some of the ...

LEAD Technologies Inc. V1.01

  Last week, after safe landing from my trip to Redmond where I had a developer meeting, there was no time to waste. A couple of tools written in VBA (macros) and some shared add-ins written in VB6 didn't look that great in Office 2007/Vista environment and being the 'Office Dev Nerd' I was asked to do the big make-over and fix ...