1 / 47

Introduction to SQL Server 2008

Managing Director and Mentor

Ava
Download Presentation

Introduction to SQL Server 2008

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

    3. Travel Warning

    4. Evaluations

    5. Acknowledgements Materials have been gleaned from: TechEd 2007 Sessions (in particular DAT304 Don Vilen) SQL Server 2008 CTP LiveMeetings PASS 2007 Sessions (in particular AD313 Michael Rys)

    6. Session Agenda SQL Server 2008 Messaging Enterprise Data Platform Beyond Relational Dynamic Development Pervasive Insight SQL Server Release Scheduling Session Summary <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION> <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    7. The Data Explosion

    8. Your Data Any Place, Any Time

    9. Transparent Data Encryption External Key Management Data Auditing Pluggable CPU Transparent Client Redirect for Database Mirroring Database Mirroring Enhancements DBM: Auto Page Repair Declarative Management Framework Server Group Management Streamlined Installation Enterprise System Management Performance Data Collection System Analysis Data Compression Query Optimization Modes Resource Governor Entity Data Model LINQ

    10. Session Agenda SQL Server 2008 Messaging Enterprise Data Platform Beyond Relational Dynamic Development Pervasive Insight SQL Server Release Scheduling Session Summary <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION> <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    11. Secure Trusted Platform Transparent Data Encryption External Key Management Data Auditing Hot pluggable CPUs Backup compression Failover Transparency Mirroring Enhancements including Automatic Page Recovery

    12. Policy Based Management Declarative Management Framework Server Group Management Streamlined Installation Enterprise System Management

    13. Optimised & Predictable Performance Performance Data Collection System Analysis Data Compression Query Optimisation Modes Resource Governor

    14. SQL Server 2005 Resource Management Single resource pool Database engine doesn’t differentiate workloads Best effort resource sharing

    15. Resource Governor – Workloads Ability to differentiate workloads based on connection property e.g. app_name, login, user, db name Per-request limits Max memory % Max CPU time Grant timeout Max Requests Resource monitoring

    16. Resource Governor – Importance A workload can have an importance label Low Medium High Gives resource allocation preference to workloads based on importance

    17. Resource Governor – Pools Resource pool: A virtual subset of physical database engine resources Provides controls to specify Min Memory % Max Memory % Min CPU % Max CPU % Max DOP Resource monitoring Up to 20 resource pools

    18. Resource Governor Putting it all together Workloads are mapped to Resource Pools (n : 1) Online changes of groups/pools SQL Server 2005, others ‘default’ group ‘default’ pool Main Benefit Prevent run-away queries

    19. <SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION><SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    20. Session Agenda SQL Server 2008 Messaging Enterprise Data Platform Beyond Relational Dynamic Development Pervasive Insight SQL Server Release Scheduling Session Summary <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION> <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    21. Data Types Filestream Integrated Full-Text Search Sparse Columns Filtered Indexes Large UDTs and UDAs ORDPATH (Hierarchical Data) DATE and TIME data types

    22. Spatial Data Geometry Geography Virtual Earth Integration Planar vs Geodesic Algorithms Separate MSI for Spatial Assemblies

    23. Economist Example

    24. Economist Example (Amended)

    25. Economist Example (Geodesic)

    26. <SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION><SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    27. Session Agenda SQL Server 2008 Messaging Enterprise Data Platform Beyond Relational Dynamic Development Pervasive Insight SQL Server Release Scheduling Session Summary <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION> <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    28. Entity-Based Development LINQ – Language Integrated Query Entity Data Model Visual Entity Designer Entity Aware Adapters

    29. Partially-Connected Devices Change Tracking Synchronization Services Visual Studio Support Conflict Detection

    30. Language Enhancements += MERGE Table-valued Parameters Table-valued Constructors Grouping Sets Object Dependencies Extended Event Notifications

    31. <SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION><SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    32. Session Agenda SQL Server 2008 Messaging Enterprise Data Platform Beyond Relational Dynamic Development Pervasive Insight SQL Server Release Scheduling Session Summary <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION> <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    33. Data Warehousing Partitioned Table Parallelism enhancements Enhanced star join query performance Resource Governor Change Data Capture Persistent Lookups MERGE Data Profiling Minimal Logging

    34. Analysis Services Enhancements Subspace Calculations Streamlined Analysis Services Tools Scalable Backup Options New Cube Design Tools MOLAP Enabled Writeback Best Practice Design Alerts (Squigglies) Query Tracing (like Showplan) Resource Monitoring (think DMVs)

    35. Reporting Enhancements IIS-Agnostic Reporting Engine WORD Rendering Enhanced Excel Rendering TABLIX Control Scalable Report Engine

    36. Integration Services VSTA (Visual Studio Tools For Applications) C# Scripting Support

    37. <SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION><SLIDETITLE>Demonstration</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>See demo script. </SLIDESCRIPT> <SLIDETRANSITION>What other features are present in Management Studio?</SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    38. Session Agenda SQL Server 2008 Messaging Enterprise Data Platform Beyond Relational Dynamic Development Pervasive Insight SQL Server Release Scheduling Session Summary <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION> <SLIDETITLE>Agenda</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE>Start with the introduction to the new architecture and productivity enhancements designed into SQL Server 2005.</KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT>This presentation is going to narrowly focus on some of the enhancements and productivity improvements in SQL Server 2005. It will not cover the developer improvements, including XML enhancements, and the ability to program using Common Language Runtime (CLR), nor will it present in any detail the Business Intelligence or DTS improvements. It will focus on some of the key changes that will improve productivity and control in the areas of manageability, security, and availability. The time available today is too short to present all the improvements, but you will see new tools and new features in old tools. </SLIDESCRIPT> <SLIDETRANSITION>Before you are introduced to some of the changes, you should understand the new architecture and the intent behind the changes. </SLIDETRANSITION> <ADDITIONALINFORMATION><ITEM></ITEM></ADDITIONALINFORMATION>

    39. Deprecation Getting more serious about deprecation policy Deprecation stages – over 3 major releases Announcement – typically only once an alternative exists Final support – will be removed in next major version SQL Server 2008 implements the deprecation policy Perf counters for all deprecated features Trace events to track deprecated feature usage DEPRECATION_ANNOUNCEMENT DEPRECATION_FINALSUPPORT Books Online, Upgrade Advisor

    40. So What’s Deprecated? sp_addalias Backup and restore DUMP statement LOAD statement BACKUP LOG WITH NO_LOG BACKUP LOG WITH TRUNCATE_ONLY BACKUP TRANSACTION sp_helpdevice 60, 65, and 70 compatibility levels DBCC CONCURRENCYVIOLATION sp_addgroup, sp_changegroup sp_dropgroup, sp_helpgroup Northwind and pubs sample databases

    41. New SQL Server Development Process Predictability Regular release cycles Completeness End-to-end scenarios and improvements Including performance, documentation, etc Quality High quality CTPs – Community Technology Previews

    42. SQL Server Engineering Lifecycle

    43. SQL Server 2008 Schedule CTP6 – Now CTP6 Refresh - Soon Launch – 27 February 2008 ? Note: Launch <> RTM RTM – Q3 2008

    44. Session Summary Great new capabilities High degree of backwards compatibility Predictable release cycle SQL Server 2005 -> the best upgrade path Download the CTPs and get involved

    45. SQL Down Under Mailing List (now over 800 members) Podcast (free audio shows on SQL Server topics) SQL Code Camp in October at CSU Wagga Wagga www.sqldownunder.com

    46. Solid Q Australia Services Public Training 5 Day MicrosoftBI Bootcamp – Sydney 12th May, Brisbane 19th May 5 Day End to End Practical SQL Server Performance Tuning – Melbourne 30th June Performance Tuning Don’t’ throw hardware at the problem ! Mentoring and Private Training

    47. Thanks! greg@greglow.com www.sqldownunder.com http://msmvps.com/greglow

More Related