Sometimes it happens. SQL Server Data Tools crashes and burns. (It’s also known as Visual Studio or SSDT but I don’t know how to pronounce that…) Was it something I said? I’m currently building a small data warehouse and building out a lot of packages in a fairly short period of time, so maybe I [...]

The upcoming release of SQL Server 2012 has a lot of new features for business intelligence developers to love. The free preview of Introducing Microsoft SQL Server 2012 (Microsoft Press, 2012) does not include the chapter on Analysis Services, but you’ll be able to read the details when the final version of the ebook is [...]

The upcoming release of SQL Server 2012 includes a major overhaul for Integration Services (SSIS). I write about the changes in SSIS, big and small, in Introducing Microsoft SQL Server 2012 (Microsoft Press, 2012) which will be available in March as a free download. Meanwhile, if you really can’t wait that long, you can get [...]