BI Thoughts and Theories

On May 15th I'll be presenting at the Triad SQL Server User Group , located in High Point, NC. The presentation will be focusing on new features in SQL Server 2008 for business intelligence and data warehousing. If you're in the area, please stop in and Read More...

The February CTP for SQL Server 2008 has been released, and is available to download at https://connect.microsoft.com/SQLServer/ . Microsoft is also sponsoring a bug bash contest, with prizes for the most bugs, most critical bug, etc. The rules are posted Read More...

The download link is here: http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en Evidently there have been some issues getting it on the Connect site, so they are hosting it in Microsoft's Download Read More...

And you can download it from here . It looks like there are a few new improvements in Reporting Services, and some new data types in SSIS (to complement the new data types in the relational engine), but nothing too major. Hopefully, I'll have time to Read More...

In my last post, I talked about using the new MERGE statement in SQL Server 2008. It allows you to merge the data in a result set with a table, based on a join condition that you specify. This is a common scenario in data warehousing, where you often Read More...

It's been a busy couple of weeks, but I've finally found some time to play around with the June CTP of SQL Server 2008. One of the items that caught my interest was the MERGE statement. This is a new addition to the T-SQL language that lets you perform Read More...