Change Data Capture and Lookup Cache will be popular with DBAs who want to speed up ETL (Extract, Transformation, and Load) processes, as will the pipeline improvements in Integration Services, ...

Just keep in mind that the benefits you get from Data Compression (which works at the page level, replacing repeating data with lookup pointers) will depend on the nature of the data in your table and ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...

Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? The wait is over. Microsoft has finally released SQL Server 2008, the ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...