©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
ISA Server 2006
ISA Server 2006
Leeven Chang
Leeven Chang
GJUN CTEK
GJUN CTEK
leevenchang@msn. com
leevenchang@msn. com
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Agenda
Agenda
Introduction to SQL Server 2005
Introduction to SQL Server 2005
SQL Server 2005
SQL Server 2005 New Features
Enterprise Performance
Manageability
Security
Security
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
What is SQL Server 2005?
SQL Server 2005
SQL Server 2005
Relational Database
Engine
.NET CLR
Integration Services
Reporting Services
Notification Services
Analysis Services
Native HTTP Support
Service Broker
Replication
Full-Text Search
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
SQL 2005 Data Platform
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Sql2005 Architecture
Relational Database Engine
CLR Runtime support
Analysis Services
Notification Services (Available now)
System Integration Services
Reporting Services (Available now)
Replication
Service Broker
Native HTTP Support
Full-Text search
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
SQL 2005 -New Features
How many organisations depend upon
SQL now?
Upgrade will reap immediate benefits
You will gain further benefits once you
start developing your applications to take
advantage of the new features
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Administrative Tools
SqlServer Management Studio
Replacement of Enterprise Manager and
Query Analyzer
SQL Computer Manager
Replacement of Service Manager
sqlcmdutility
Replacement of ISQL and OSQL
SMO
Replacement of DMO
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
SqlServer Management
Studio
Based on Visual Studio .NET
Manages RDBMS, Cubes, Reporting Services
and CE Databases
Project Centered View
Different editors for T-SQL, XMLA and MDX
Nice things
Multithreaded
Scheduling
Scripting
Filtering
Disconnected editing
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
SqlComputer Manager
MMC snap-in to manage all the SQL
Services and connectivity settings
Replaces Server Network Utility, Client
Network Utility and SQL Service Manager
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
HA 、 Reliable 、 Expandable
Management Integration
Performance & Security
Improvement
Visual Studio & .NET Integration
Native XML, CLR, Web Services
Customize Data Type
On-time OLAP, Data Mining, KPI,
UDM
Multi-Languages support
Reporting Services, Report Builder
DTS (SSIS) 600% faster
Enterprise Data Management
Enterprise Data Management
Palteform
Palteform
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Enterprise Performance
SSIS (SQL Server 2005 Integration
Services)
Moves millions of rows per second
In memory transformations and delivery to
multiple destinations
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Enterprise Performance
Analysis Services
Sub second query times
Advanced caching
Data mining with
predictions for very
large data sets
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Enterprise Performance
Notification Services
100,000's subscription based users
Numerous business rules for polling
Reporting Services
Scale up/scale out
Advanced Caching
Snapshot strategies to support high user
concurrency
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Enterprise Performance
Inserting data
Bulk load -always fast
Now faster -Bulk Copy Program (bcp.exe)
BULK INSERT (T-SQL)
Better performance and more options for
OPENROWSET () function
Highly scalable way to load XML documents
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Business Continuity
SQL 2005 delivers 24x7 data availability
Failover clustering
Database mirroring
Online indexing
Piecemeal backup and restore
Partitioning
Dynamic configuration
Hot memory swapping
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Business Continuity
SSIS offers distributed deployment and
restart-ability
Resilient ETL (Extraction, Transformation &
Loading)
Notification Services & Reporting Services
integrated with IIS
Allows NLB
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Business Continuity
More disaster recovery options
More affordable
Peer-to-peer replication
Log shipping
Analysis Services, Server Sync
Multiple servers support primary servers
Dedicated administrator connection
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Manageability
SQL Server Management Studio
One interface -entire platform
Boosts DBA productivity
Easier identification, troubleshooting and
resolution of performance issues
SQL Server Profiler
Improved trace capabilities for all products
(DB, IS, AS)
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Manageability
Extensible XML based definition
Capture and effectively analyse more details
Use aggregated views
Perform correlation with Windows Event Logs
New expanded performance counters
Graphical Deadlock and Showplan
enhancements
DMVs (Dynamic Management Views)
Ongoing server activity
Dynamically changing state
Diagnostic information
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Manageability
Automation of repetitive or common SQL
admin tasks
E.g. retrieving configsettings, db creation,
applying T-SQL scripts, backups, creating
SQL Server Agent jobs
SMO (SQL Management Objects)
API.SMO -partners & ISV
Better performance and scalability than SQL
DMO (Distributed Management Objects)
SQL 2005 supports SQL DMO9
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Manageability
Build proactive performance monitoring
with SQL Server Agent
DTA (Database Tuning Advisor)
Replaces ITW (Index Tuning Wizard)
Helps resolve performance issues
New security contexts
Non SAscan create database traces
Can use DTA to tune database
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Security
SQL 2005 built on premise of Microsoft's
Trustworthy Computing initiative
Secure by design
Secure by default
Secure in deployment
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Security
Dedicated security configuration interface
SAC (Surface Area Configuration)
Consolidates access to configurable services
and settings -helpful descriptions
Fine grain admin rights
Admin rights separated from data access
rights in each platform subcomponent
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Security
Password policy enforcement
Increased levels of data encryption for storage
and transmission
Secure development environment
Sign, verify and manage code
CLR (Common Language Runtime) assemblies that
run in the database
Managed code uses CAS (Code Access Security)
preventing assemblies from performing certain
operations
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Operational Cost Savings
Server Consolidation
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Consolidate on SQL 2005
How many data-storage & management
platforms, suites and tools do you use in the
following categories?
Relational databases
Multidimensional (OLAP) databases
Data replication
Extraction, Transformation and Loading (ETL)
Enterprise reporting
Data mining
Notification engines
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Consolidate on SQL 2005
For the previous software investments,
how many of the following do you require?
Licensing & support agreements
Dedicated servers
Different development skill sets
Different operational skill sets, policies and
practices
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Consolidate on SQL 2005
Hardware and software savings
Save on DBA time
Easier to manage
Better performance
Move to a high availability cluster
Consolidate 20+ servers easily.
©2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
Thank You. Q & A