Microsoft have released a raft of SQL Server 2008 White papers. These can be found here: http://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx. Although fairly high level the first business intelligence white paper outlines some of the significant changes made to 2008, in order for it to better compete in the Data Warehousing space.
There are 6 separate white papers dedicated to Business Intelligence alone. The introduction to new Data Warehousing features has a great deal of information on new features that will further enhance the BI offerings from Microsoft. This document includes details on the following enhancements:
SQL Server Relational DBMS DW Improvements:
- Star Join
- Partitioned Table Parallelism.
- Partition-Aligned Indexed Views
- GROUPING SETS
- MERGE
- Change Data Capture
- Minimally Logged INSERT
- Data Compression
- Backup Compression
- Resource Governor
Integration Services Improvements:
- Lookup Performance
- Pipeline Performance
Analysis Services Improvements:
- MDX Query Performance: Block Computation
- Query and Write back Performance
- Analysis Services Enhanced Backup
- Scalable Shared Database for AS
Reporting Services Improvements:
- Reporting Scalability
- Server Scalability
Meet the Team – Zach Stagers, Senior Consultant
Up next in our series of Meet the Team blogs is Zach Stagers, Senior Consultant.
Nov
A Cost Comparison between PaaS and IaaS Cloud Architectures
Introduction This aim of this blog is to do a cost comparison between two cloud
Nov
Providing Careers at Adatis
At Adatis, we believe in developing and training our employees which aligns with 2 of
Nov
Meet the Team – Donna Bavin, People Operations Lead
We couldn’t achieve all the great work we do without our amazing team, so in
Nov
Deep Dive into the Common Data Model Video Presentation
At SQLBits last month some of our team gave fantastic sessions on a variety of
Oct
The Adatis Values – No is OK and Listen & Challenge
Our nine company values are super important to us and are at the heart of
Oct
Optical Character Recognition (OCR) using Tesseract and Databricks
The topic of Optical Character Recognition (OCR) is not an unexplored field to the Adatis
Oct
An experiment with Azure Custom Vision
An experiment with Azure Custom Vision Azure Cognitive Services is a comprehensive family of APIs,
Oct