Writers: Microsoft Corporation
Contributors: Amir Jafri, Jim Toland, Peter Scharlock
Technical Reviewers: Srini Acharya, Sunil Agarwal, Peter Carlin, Roger Gilchrist
Published: January 2009
Applies To: SQL Server 2008, MS CRM 4.0
Summary: Microsoft SQL Server 2008 contains many new features that can enhance the performance and security of a MS CRM 4.0 deployment. This paper describes a project, including findings and specific implementation guidence, which the MS CRM Engineering for Enterprise team in conjunction with SQLCAT recently completed.
This project evaluated how to maximize the performance and security of MS CRM 4.0 utilizing the following SQL Server 2008 features: Compression, Filtered Indexes, Sparse Columns, Transparent Data Encryption, and Data Encryptions.
For more information, please refer to the Improving Microsoft CRM Performance and Securing Data with SQL Server 2008 Whitepaper.
About Peter
Peter has over 25 years of career database experience. He joined the SQL Server development team in 1996 when SQL 6.0 was the shipping product. As a member of the SQLCAT ISV team Peter is currently responsible for the SQL development team's technical interaction with the Microsoft Dynamics development organizations. Prior to this role he had similar roles working with Strategic Healthcare ISVs and other Global Microsoft ISV Partners. He regularly presents at Microsoft and ISV Conferences.
Prior to joining Microsoft, Peter was a Mainframe (IBM / Tandem NonStop) embedded SQL programmer, analyst, and consultant primarily in the Healthcare, Telecommunications, and Logistics industries. He has lived and worked extensively in Europe and the Middle East.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
