Overview Dan Galvez Hedgehog Development dgalvez hhogdev com 631

Overview Dan Galvez Hedgehog Development dgalvez@hhogdev. com 631 -676 -2186 x 200

Outline SQL Server 2005 Momentum Data Platform Vision Delivering on Vision Enterprise Data Platform Dynamic Development Beyond Relational Pervasive Insight Predictable Customer Value

Company Overview “We provide resources to help companies create and communicate information to their internal teams and customers through the use of technology. ”

Main Technology/Service Offerings Application Lifecycle Management (ALM) Solutions using VSTS Share. Point Intranets and Extranets Sitecore Content Managed Web sites Custom. NET Development Solutions Database and BI SQL Server and PPS

Company Overview Microsoft Gold Partner Microsoft Partner of the Year 2008 - Excellence in Application Platform Optimization (APO) Microsoft Customer Satisfaction Awards - Three consecutive quarters Microsoft “Inner Circle Status” – Visual Studio Team System (VSTS) Certified Sitecore Partner

Sample Customers

SQL Server 2005 Enterprise Ready! ESG: Microsoft years ahead of Oracle for secure database OLTP and Data Warehouse Benchmark Leader IDC: More Units sold than Oracle and IBM Combined Gartner: Fastest growing DBMS and BI vendor 8 M SQL Server Express Downloads Over 600 K IT Pros & Devs trained Partners: >3000 ISVs “Microsoft’s ambition has been to grow SQL Server into the upper echelons of major enterprises, and with SQL Server 2005, this seems to be happening. ”

SQL Server 2005 Ongoing Enhancements Service Pack 1 Service Pack 2 Delivery of Database Mirroring SQL Server Express with Advanced Functions Management Tools Full Text Search Reporting Services support for Netweaver BI Performance updates: data compression Enhanced BI capabilities SSRS Integration with Share. Point Server 2007 Data Mining Plug-ins for Office 2007 Manageability enhancements Optimized for Windows Vista & Office 2007 Common Criteria Certification Designed for Portable enterprise applications Occasionally-connected & offline use Embedded in applications & devices

Your Data Any Place, Any Time Enterprise Data Platform Services Reporting Integration Analysis Beyond Relational Dynamic Development Pervasive Insight Query Mobile and Desktop FILE RDBMS OLAP XML Server Synch Search Cloud

Delivering On Our Vision Enterprise Data • Secure, Platformtrusted platform for your data • Optimized and predictable system performance • Productive policy-based management of your infrastructure Enterprise Data Platform Relational Beyond • Store and consume any type of data • Deliver Location Intelligence Beyond Relational within your applications Dynamic your development with entities • Accelerate Development data from anywhere • Synchronize your Pervasive Insight • • • Integrate all your data in the Enterprise Data Warehouse Reach all your users with scalable BI platform Empower every user with actionable insights

Dynamic Development Enterprise Data Platform Policy-Based Manage 1 ment Performance Data Collection Extended Events Table-Valued Parameters GROUPING SETS Beyond Relational FILESTREAM data type Pervasive Insight AS Scalable backup tools AS Dimension Design Large User-Defined Types Star Join Query Optimization MERGE command Large User-Defined Aggregates Database Mirroring Enhancements Enterprise Reporting Engine Conflict Detection DATE/TIME Data Types Data Compression Visual Studio Support Improved XML Support Query Optimization Modes Sync Services for ADO. NET Resource Governor Change Data Capture (CDC) Virtual Earth Integration Occasionally Connected Systems (OCS) AS Time Series VSTA Support for Script task GEOGRAPHY data type Support for 3 rd Party Certificates Enhanced Data Visualization Report Builder Enhancements Transparent Data Encryption Better rendering for Word & Excel Entity Data Model (EDM) External Key Management GEOMETRY data type Partitioned Table Parallelism ADO. NET Entity Framework Data Auditing Pluggable hot-add CPU Sparse Columns AS Query Optimizations LINQ Filtered Indexes Streamlined Installation Server Group Management Visual Entity Designer Enterprise System Management Entity Aware Adapters Data Mining Engine Improvements ADO. NET Data Services Performance System Analysis ORDPATH Persistent Lookups SSB Priorities & Diagnostics CLR Improvement Backup Compression IIS Agnostic Report Deployments Best Practice Design Alerts Upgrade Advisor Partition Aligned Indexed Views Integrated Full Text Search Scale-out AS Data Profiling AS Query & Writeback Perf

Secure, Trusted Platform For Your Data Enterprise Data Platform Protect your information Transparent Data Encryption External Key Management Data Auditing Pluggable CPU Enhanced Database Mirroring Encrypt your data without requiring an application re-write Consolidate security keys within the data center Answer common auditing questions like “what data was retrieved” Increase the reliability of your applications Add system resources without affecting your users Implement automatic failover transparent to your existing applications

Productive Policy-based Management of your infrastructure Declarative Management Framework Server Group Management Streamlined Installation Enterprise System Management Enterprise Data Platform Spend less time on ongoing operations Manage via policies instead of scripts Define Enterprise wide data management policies Automated monitoring and enforcement of policies Simplify your installation and configuration Integrated with your enterprise system management Define Policies that are compliant with System Definition Model Manage your data and system infrastructure with Microsoft System Center

Optimized And Predictable Performance Data Collection System Analysis Data Compression Query Optimization Modes Resource Governor Enterprise Data Platform Optimize your System Performance Monitor your system by collecting and storing system events Analyze and report on your system performance Reduce your storage costs and increase query performance Predictable performance Manage concurrent workloads on single system Prevent runaway queries Ensure consistent query performance

Accelerate Your Development With Entities Entity Data Model LINQ Visual Entity Designer Entity Aware Adapters Dynamic Development Develop with business entities Define your business not tables Model your complex business relationships Retrieve entities instead of rows and columns Connect to SQL Server with entity aware adapters Reliable application performance Store entities locally on your clients

Connect to your data From any device SQL Server Change Tracking Synchronized Programming Model Visual Studio Support SQL Server Conflict Detection Dynamic Development « Access your data from anywhere « Store your data locally while disconnected from server « Synchronize Incremental changes between client and server « Detect conflicts during synchronization including deletes « Add disconnected scenarios without re-writing existing applications

Store and Consume Any Type of Data FILESTREAM data type Integrated Full Text Search Sparse Columns Large User Defined Types Date/Time Data Type Beyond Relational Seamless transition between relational and non-relational Store your documents in cost effective storage platform Access documents as data Encode your complex hierarchies within XML Extend the database to meet your unique needs Find your data Query across relational and text data Build global applications Capture precise time from clients across the globe

Deliver Location Intelligence Within your applications GEOMETRY data type GEOGRAPHY data type Beyond Relational Build location-aware applications Capture location data from across your organization Integrate location intelligence to your existing applications Visualize your location information Standard Spatial applications Virtual Earth Integration Integrate with industry standard spatial applications Supported by 3 rd parties

Reach All your Users with Scalable BI platform Enterprise Reporting Engine Internet Report Deployment Pervasive Insight Deliver insights throughout your organization Deliver reports of any size and complexity Enhance analytical capabilities with more complex computations and aggregations Deploy and manage your BI infrastructure Subspace Computations Streamlined Analysis Tools Enhanced Analysis Design Scalable Backup Tool Streamline development of the analysis infrastructure Backup cubes with enhanced scalability Improve productivity with new cube design tools Optimize cube design with real time best practice alerts Deploy Reporting Services without IIS dependency

Empower Every User With Actionable Insight Render Reports in Word and Excel Flexible Report Layout Report Builder Enhancements TABLIX Rich Formatted Data Visualizations MOLAP Writeback Enhanced Data Mining Pervasive Insight Deliver information via Microsoft Office Render reports to Microsoft Word Enjoy improved rendering to Microsoft Excel Enable users to create powerful reports Build powerful ad-hoc reports Create reports with any structure using Tablix Add rich text regions your reports Embed powerful graphical data visualizations into reports Empower users with enhanced analysis Empower users with enhanced write back scenarios Enhanced predictive analysis

Enterprise Data Warehouse Enhanced Partitioning DW Query Optimizations Data Compression Resource Governor Persistent Lookups Change Data Capture MERGE SQL Statement Data Profiling Pervasive Insight Scale and Manage large number of users and data Improved Query performance on large tables Queries Optimized for data warehousing scenarios Increase I/O performance with efficient and cost effective data storage Manage concurrent workloads of ad-hoc queries, reporting and analysis Integrate growing volumes of data Optimize your ETL performance by identifying data in your largest tables Reduce the data load volumes by capturing operational changes in data Simplify your insert and update data processing Profile your information to identify dirty data

Next Steps Upgrade to SQL Server 2005 http: //www. microsoft. com/sql/solutions/upgrade/default. mspx Learn more about SQL Server 2008 http: //www. microsoft. com/sql/prodinfo/futureversion/default. mspx Download the latest CTP https: //connect. microsoft. com/SQLServer/content. aspx? Content. ID=5395

Q&A

Overview Dan Galvez Hedgehog Development dgalvez@hhogdev. com 631 -676 -2186 x 200