SQL Lighthouse

Azure, Red Gate Software
Red Gate is constantly experimenting with technology. Because of a long history working within the Microsoft space, a lot of the new experimentation is in and around Azure. One new venture that could be online soon is SQL Lighthouse. It's a mechanism for dealing with changing structures in an unrestricted Windows Azure SQL Database where you have multiple developers making changes. Potentially, this is pretty interesting. Please follow the link, check it out, and sign up to be alerted when the program becomes available. Many people are just getting started with Azure, especially wrapping their heads around the concepts of using a Platform as a Service rather than having infrastructure, local, virtual, or on the cloud. If this is you, and you have an MSDN license, you can get that…
Read More

SQL Server Team-Based Development

The new book is available in a free download from Red Gate. I had a lot of fun working on the three chapters that I did for this book. The topics I received are near & dear to me because of all the time I've spent working on getting databases into source control and automating (as much as possible) the deployment of databases out of source control. Everything I go over in the book might not be 100% applicable to your situation, but I'm pretty sure almost anyone involved in database development and deployment can find some useful information there. For those who are interested, I don't just cover Red Gate tools in the book either. There's quite a bit of time spent describing how to automate deployments using Visual…
Read More