1 / 24

SQL Server 2005: Beyond Relational, Pervasive Insight, Dynamic Development

Learn about our enterprise data platform that offers secure and trusted storage, optimized performance, and dynamic development capabilities. Gain pervasive insight through beyond relational data integration and empower users with actionable insights.

phillipsk
Download Presentation

SQL Server 2005: Beyond Relational, Pervasive Insight, Dynamic Development

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview Dan Galvez Hedgehog Development dgalvez@hhogdev.com 631-676-2186 x200

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

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

  4. Main Technology/Service Offerings • Application Lifecycle Management (ALM) Solutions using VSTS • SharePoint Intranets and Extranets • SitecoreContent Managed Web sites • Custom .NET Development Solutions • Database and BI SQL Server and PPS

  5. 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

  6. Sample Customers

  7. SQL Server 2005Enterprise 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 8M SQL Server Express Downloads Over 600K IT Pros & Devs trained “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.” Partners: >3000 ISVs ESG considers Microsoft to be years ahead of Oracle and MySQL in producing secure and reliable database products.

  8. 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 • Reporting Services support for Netweaver BI • Performance updates: data compression • Enhanced BI capabilities • SSRS Integration with SharePoint 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

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

  10. Delivering On Our Vision Enterprise Data Platform • Secure, trusted platform for your data • Optimized and predictable system performance • Productive policy-based management of your infrastructure Enterprise Data Platform • Store and consume any type of data • Deliver Location Intelligence within your applications Beyond Relational Dynamic Development • Accelerate your development with entities • Synchronize your data from anywhere Beyond Relational Dynamic Development 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 Pervasive Insight

  11. Beyond Relational Enterprise Data Platform Dynamic Development Pervasive Insight

  12. Secure, Trusted PlatformFor Your Data Enterprise Data Platform • Protect your information • 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

  13. Productive Policy-based Management of your infrastructure 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

  14. Optimized And Predictable Performance 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

  15. Accelerate YourDevelopment With Entities 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

  16. Connect to your data From any device 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

  17. Store and Consume Any Type of Data 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

  18. Deliver Location Intelligence Within your applications 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 • Integrate with industry standard spatial applications • Supported by 3rd parties

  19. Reach All your Users withScalable BI platform 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 • 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

  20. Empower Every UserWith Actionable Insight 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

  21. Enterprise Data Warehouse 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

  22. 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/content.aspx?ContentID=5395

  23. Q&A

  24. Overview Dan Galvez Hedgehog Development dgalvez@hhogdev.com 631-676-2186 x200

More Related