개발자를위한 sql server 2008 · 2015-01-22 · sql server의역사 version year release name...
TRANSCRIPT
![Page 1: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/1.jpg)
© 2004 Geac
개발자를 위한 SQL Server 2008
이 수 겸
올랩컨설팅 선임 컨설턴트
http://bybi.tistory.com
![Page 2: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/2.jpg)
Agenda
SQL Server의 역사
SQL Server의 현재
SQL Server 2008의 목표
SQL Server 2008의 새로운 기능
동적 개발 환경
관계형 데이터의 발전
![Page 3: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/3.jpg)
1987, Sybase와 MS의 DBMS 개발/판매 파트너쉽에서 시작(Sybase는 Unix, MS는 OS/2 및 MS의 OS에 대한 권리 가짐)
최초의 버전은 Ashton-Tate(dBase), Sybase와 공동개발
SQL Server의 역사
Version Year Release Name Codename
1.0(OS/2) 1989 SQL Server 1.0 -
1.1 1990 SQL Server 1.1 -
4.21(NT3.1) 1993 SQL Server 4.21 -
6.0 1995 SQL Server 6.0 SQL95
6.5 1996 SQL Server 6.5 Hydra
7.0 1999 SQL Server 7.0 Sphinx
- 1999SQL Server 7.0
OLAP ToolsPlato
8.0 2000 SQL Server 2000 Shiloh
8.0 2003SQL Server 2000
64-bit EditionLiberty
9.0 2005 SQL Server 2005 Yukon
10.0 2008 SQL Server 2008 Katmai
![Page 4: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/4.jpg)
SQL Server의 현재
Revenue: Fastest growing vendor
0%
20%
40%
60%
SQL Oracle IBM Other
RDBMS Revenue Share
2003
2004
2005
2006
Market :2003:12.1B2006: 16.4BCAGR: 8%CAGR 16.6%
Units: More than Oracle / IBM combined
0%
20%
40%
60%
SQL Oracle IBM Other
RDBMS Unit Share
2003
2004
2005
2006
Market :2003:987K2005: 1.3MCAGR: 17%
CAGR: 23%
2010 - 2011
SQL Server
“vNext++”
2007Q4/05
SQL Server 2005
2008
CTP3
TechEd07 Announcement
Q2 Q3
CTP4
CTP5
Q4 Q1
LAUNCH
SQL+VS+Windows
2/27
CTP6
RTM
H2
![Page 5: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/5.jpg)
SQL Server 2008의 목표
Microsoft’s
Data Platform vision
가치 Quality– Trusted
– Productive
– Intelligent
핵심 영역– Enterprise Data Platform
– Beyond Relational
– Dynamic Development
– Pervasive Insight
![Page 7: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/7.jpg)
SQL Server 2008의 새로운 기능
Transparent Data Encryption
External Key Management
Data Auditing
Pluggable CPU
Transparent Client Redirect for Database Mirroring
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
Visual Entity Designer
Entity Aware Adapters
SQL Server Change Tracking
Synchronized Programming Model
Visual Studio Support
SQL Server Conflict Detection
FILESTREAM data attribute
Integrated Full Text Search
Sparse Columns
Large User Defined Types
Date/Time Data Type
LOCATION data type
SPATIAL data type
Virtual Earth Integration
Partitioned Table Parallelism
Query Optimizations
Persistent Lookups
Change Data Capture
Backup Compression
MERGE SQL Statement
Data Profiling
Star Join
Enterprise Reporting Engine
Internet Report Deployment
Block Computations
Scale out Analysis
BI Platform Management
Export to Word and Excel
Author reports in Word and Excel
Report Builder Enhancements
TABLIX
Rich Formatted Data
Personalized Perspectives
… and many more
![Page 8: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/8.jpg)
동적 개발 환경
ADO.NET Entity Framework
LINQ(Language Integrated Query)
Data Synchronization
Integrated Visual Studio support
SQL Server change tracking
Integrated conflict detection
![Page 9: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/9.jpg)
관계형 데이터의 발전
New Data Types
– Date, Time, DateTime2, DateTimeOffset
– Hierarchyid
– User-Defined Table type, Large User-Defined Types
– Geography, Geometry
– FILESTREAM
Integrated Full-Text Search
T-SQL Enhancements
– MERGE, Sparse columns, filtered indexes
– Table-Value Parameters
![Page 10: 개발자를위한 SQL Server 2008 · 2015-01-22 · SQL Server의역사 Version Year Release Name Codename 1.0(OS/2) 1989 SQL Server 1.0 - 1.1 1990 SQL Server 1.1 - 4.21(NT3.1) 1993](https://reader033.vdocuments.co/reader033/viewer/2022060209/5f0440f47e708231d40d1118/html5/thumbnails/10.jpg)
참고자료
Euan Garden's BLOG
SQL MythBusters – "SQL Server is really a Sybase prod
uct not a Microsoft one." (http://blogs.msdn.com/euanga
/archive/2006/01/19/514479.aspx)
Mythbusters, SQL Server History follow up(http://blogs.
msdn.com/euanga/archive/2006/05/23/597677.aspx)
Techfest : A Whirlwind Tour of the Next Great Release of
SQL Server
SQL Server 2008 : Product Overview