SQL Server 2008 R2 Parallel Data Warehouse

Tonight's Tampa Bay SQL Server BI Users Group meeting was about:

SQL Server 2008 R2 Parallel Data Warehouse

Interesting topic. Deals with buying pre-assembled hardware/software which you plug in and load your data warehouse. It's designed to handled "a-lot" of data in the terabytes on up. The processor dynamically load balances the data into 8-10 servers all running "vanilla" SQL-Server. Each server is then split up into 8 file structures so you can split a 10 terabyte database into 10 server of 1 terabyte into 8 file structures of about 120 gigs. It's quite powerful, but it works for just data warehouses (no OLTP at this time). The warehouse can be accessed directly through JDBC, ODBC, ADO.net as well as SSRS, SSAS through native code.

The presenter, Brian Mitchell, did a wonderful job keeping us entertained for 2+ hours. And the free pizza was delicious (Pizza Hut).

I think it was worth taking the night off from work (Part Time) to attend the meeting. Can't wait for next months meeting.

And that's about it.