Microsoft SQL Server 2005 포켓 컨설턴트 관리자용

Microsoft SQL Server 2005 SQL Server 2005. SQL Server,. SQL Server. SQL Server,,, ( ). 1000 100,,,, SQL Server.? Microsoft SQL Server 2005 SQL Server (Workgroup, Standard, Enterprise, Developer).. SQL Server 2005 SQL Server SQL Server 2005 SQL Server 2005, SQL Server. SQL Server SQL. SQL Server,,,,,., Microsoft Windows

23 SQL,. SQL, Microsoft Press. Microsoft SQL Server 2005 SQL Server.,.,.,. 1, Microsoft SQL Server 2005 SQL Server. 1 SQL Server,,. 2 SQL Server. 3 SQL Server,,. 4 SQL Server., SQL Server 2005. 2, Microsoft SQL Server 2005 SQL Server. 5. 6 SQL Server Management Studio SQL Server.,,,,. 7. 8 SQL Server. SQL Server,,.,. 3, Microsoft SQL Server 2005 SQL Server. 9,,,,,. 10

24 BCP. 11 SQL Server., Microsoft Transaction Coordinator(MSDTC),. 12.,. 4, Microsoft SQL Server 2005 SQL Server,. 13, SQL Server,. 14.,. 15,,,.,.,.,....

25. Microsoft SQL Server 2005 SQL Server.. Microsoft Press (http://mspress.microsoft.com/support/).,. Microsoft (http://support.microsoft.com/directory/). / http://mssql.feelanet.com.

1 Micros oft SQL Serve r 2005 1 Microsoft SQL Server 2005. 1 SQL Server,. 2 SQL Server 2005,. 3 SQL Server,. 4 SQL Server.

Mic roso ft SQL Se rve r 2005 2 SQL Server SQL Server, SQL Server Registry SQL Server,., SQL Server 2005. SQL Server 2005, SQL Server. SQL Server SQL Server 2005,. (Extraction), (Transformation), (Loading) (ETL) SQL Server 2005 Analysis Services S QL S e rve r Int e g rat io n S e rvice s SQL Server 2005 DTS( )SQL Server Integration Services(SSIS), ETL.

2 Microsoft SQL Server 2005 47 SSIS. SQL Server Management Studio SSIS, ETL Business Intelligence Developer Studio.,.. DTS 2000 SSIS SQL Server 2000 DTS SQL Server 2005 SSIS. DTS 2000 SQL Server 2000 DTS SQL Server 2005 SSIS. DTS 2000 DTS 2000. 10,, SSIS. S QL S e rve r 20 05 SQL Server 2005 SQL Server 2000. SQL Server 2005. Transaction-SQL(T-SQL).., T-SQL. T-SQL. T-SQL SQL Server...

48 1 Microsoft SQL Server 2005 S QL S e rve r 2 005 SQL Server 2005Analysis Services. Analysis Services OLAP. Analysis Services,. SQL Server 2005 Analysis Services (UDM). UDM OLAP, OLAP. SQL Server 2005 UDM.. SQL Server 2005 Analysis Services DDL(Data Definition Language) XML. SQL Server 2005 Analysis Services, XML. SQL Server 2005 Analysis Services SQL Server 2000 Analysis Services.,..,,,.. S QL S e rve r 2 005 SQL Server 2005 Reporting Services,,. Reporting Services,, IT., Reporting Services (SPS) SQL Server 2005 (SPS). Reporting Server.

2 Microsoft SQL Server 2005 49. (SPS),, Reporting Services. HTML, PDF, Tiff, Excel, XML CSV,. HTML, Adobe PDF TIFF. XML CSV,. SQL Server 2005 SQL Server 2005.. SQL Server SQL Server. S QL S e rve r 2 005 SQL Server 2000 SQL Server 2005. SQL Server SQL Server Windows.. 1 Microsoft SQL Server 2005. I/O. I/O... SQL Server SATA II Ultra SCSI(Ultra 320SCSI ).., I/O. SATA II Ultra320 SCSI ( ), ( ).,

50 1 Microsoft SQL Server 2005 15,000RPM 10,000RPM I/O 45%50%. 3.5ms 4.7ms 25%30%. (Meantime To Failure; MTTF). MTTF., 15,000RPM Ultra320 SCSI MTTF. Maxtor Atlas 15K II 98MBps. Seagate Cheetah 15K.4 96MBps, 1,400,000 MTTF. (GBps). 1.5GBps 187MBps, 3.0GBps 374MBps. ( ).. Seagate Barracuda 7200 SATA II 7,200RPM 58MBps. 8.5ms 1,000,000 MTTF 7,200 RPM SATA II..,.. 15,000RPM. Maxtor Atlas 15K II Seagate Cheetah 15K.4 70 ( ). I/ O I/O, RAID RAID.. RAID RAID RAID. RAID. RAID RAID CPU,. RAID RAID RAID.

2 Microsoft SQL Server 2005 51 RAID. Windows Server 2003 RAID 0( ), 1( ), RAID 5( ), RAID RAID 0 + 1(RAID 10, ). SQL Server RAID 1, SQL Server. RAID 1 ( ),..... RAID. RAID. RAID. ( ).. RAID 1 RAID,. RAID 1 OS. RAID 1.. SQL Server RAID 5 RAID 0 + 1. RAID 5..,... RAID 5,. RAID 1 150GB 150GB. 50%. RAID 5 31(33%). RAID 5

52 1 Microsoft SQL Server 2005. RAID 5 RAID 1., 5 5. 4I/O (2 2 ) RAID 5 RAID 1.,.. RAID 0 + 1. RAID 0 + 1, (RAID 0). RAID 1 RAID 0 + 1 I/O ( 1 ). (RAID 0 RAID 5 ). RAID 0 + 1. RAID 1 RAID 5,.,.,. RAID 0 + 1.., 450GB 450GB. 450GB. RAID 5 RAID 0 + 1. RAID 5. RAID 0 + 1 RAID 5. 90% 10% RAID 5. RAID 0 + 1.

2 Microsoft SQL Server 2005 53 RAID 15 RAID 0 + 1.. RAID 1 RAID 0 + 1.,.., SAN(Storage area network). (log shipping). Microsoft Cluster Service (Failover). (Distributed Partition View)... SQL Server 2005 (Database Mirroring) (Log Shipping).,.. 2... SQL Server 2005. (Principal Server),. (Mirror Server),,.

54 1 Microsoft SQL Server 2005 (Witness Server) (Witness Server) (Principal Server), (Mirror Server), (Failover).. (Principal Server), (Mirror Server) ( ) (, )..,., (Principal Server) (Mirror Server) (Failover),. (Offline) (Mirror Server)... SQL Server.. SQL Server,,. 12,,. SQL Server 2005. SQL Server. SQL Server. SQL Server SQL Server SQL Server 2005,..

2 Microsoft SQL Server 2005 55 sysadmin -A SQLCMD.. Sql cmd - U mummya - P mo r e FunPl e a s e - S Fe el anet DB01 - A mummya sysadmin FeelanetDB01 SQL Server.,. Sql cmd - U mummya - P mo r e FunPl e a s e - S Fe el anet DB01\ Wal ke r hi l l -A Walkerhill SQL Server. (Multiple Active Result Set; MARS) SQL Server. SQL Server 2000.. MARS. ODBC. SQL_HANDLE_DBC. SQL_HANDLE_STMT. SQL Server 2005 SQL Native Client SQLODBC SQLOLEDB MARS. Microsoft.NET Framework Version 2.0 SqlClient.NET MARS. MARS. T-SQL, T-SQL. SQL Server...

56 1 Microsoft SQL Server 2005 SQL Server 2000 MARS. MARS. MARS,,. SELECT, FETCH, READTEXT, RECEIVE BULK INSERT.. OLEDB ODBC SQL Server 2000 SQL Server 2005.,. (Autocommit). SqlClient.NET SqlConnection, SqlCommand SqlTransaction. SqlConnection, SqlCommand (), SqlTransaction. (Context) SqlTransaction. SQL Server SQL Server SQL Server. SQL Server SQL Server. SQL Server.. SQL Server SQL Server Registry SQL Server S QL S e rve r SQL Server 2005..

2 Microsoft SQL Server 2005 57 SQL Server 2005, SQL Server 2005. SQL Server 2005. SQL Server SQL Server Agent, Analysis Services Report Server Services.. SQL Se rv e r SQL Server 2005 SQL Server 2005 SQL Server 2005., SQL Server.. SQL Server 2005..., SQL Server. SQL Server. computer_name\instance_name,. SQL Server 2000 SQL Server 2005, SQL Server. SQL Server Enterprise (Multinode). SQL Server. virtual_server _name\ instance_name.

58 1 Microsoft SQL Server 2005 SQL Se rv e r SQL Server 2005 SQL Server 2000. Windows Server 2003 1 XP Professional 2 Windows Installer 3.0. SQL Server 2005 Microsoft (http://www.microsoft.com/ download) Windows Installer 3.0. Windows Installer,. / / SQL Server 2005. 1.. SQL Server 2005 CD-ROM CD-ROM.,. 2. (Autorun), SQL Server 2005. CD-ROM Servers Splash.hta. 3. (Server Components), (Tools), (Books Online)... 4., SQL Server. [2-1]..

2 Microsoft SQL Server 2005 59 [2-1] Microsoft SQL Server 2005 SQL Server WMI, MSXML, IIS, Internet Explorer COM+.,. 5. SQL Server...... 1.

60 1 Microsoft SQL Server 2005 [2-2] 6. 25CD,. 7... SQL Server SQL Server. SQL Server 2005.. Anlaysis Services Anlaysis Services. Analysis Services.. Reporting Services. IIS.NET 2.0. SMTP(Simple Mail Transfer Protocol) Exchange. Notification Services Notification. Integration Services ETL SSIS., SQL Native Client.

2 Microsoft SQL Server 2005 61. SQL Server -. SQL Server. 8. [2-3],. SQL Server.. [2-3 ].. 16.. 9. SQL Server SQL Server Agent (, Analysis Services ). [2-4].

62 1 Microsoft SQL Server 2005.. SQL Server.,.. SQL Server, SQL Server Agent SQL Browser. [2-4 ] SQL Server SQL Server,... SQL Server, SQL Server Agent. CmdExec ActiveScript SQL Server, SQL Server Agent. Reporting Services.

2 Microsoft SQL Server 2005 63 10.. SQL Server Microsoft Windows. Windows SQL Server. SQL Server SQL Server. SA... 11. ([2-5] ). SQL Server SQL Server Agent. SQL Server SQL Server Agent. Microsoft Windows, Korean_Wansung. /.. SQL SQL Server Analysis Services., master SQL Server. master. 6 (Collation) master.

64 1 Microsoft SQL Server 2005 [2-5] 12.,.. SQL Server http:// ServerName/ DirectoryName. DNS(Domain Name System), http:// feelanet7/ reports. SQL Server http:// ServerName/ DirectoryName$InstanceName., http:// feelanet7/ reports$walkerhill SQL Server. 13.,., SSL. SQL Server. KorDB12 Namhansansung SQL Server, ReportServer$ Namhansansung, http://kordb12/reportserver $Namhansansung http://kordb12/reports$namhansansung. Reporting Services..

2 Microsoft SQL Server 2005 65 14.. HTTPS Active Directory.... 15..... Notification Services Microsoft.net Framework. Notification Services Notification Services. Notification Services, Notification services.,.net Framework CD. Notification Services (Microsoft.SqlServer.NotificationServices.dll) (Regasm.exe).. r ega sm / code ba se / t l b SQLDi r\ Mi c r osof t. sql s e r ve r. not i f i cat i onse rvi c e s. dl l SQLDir SQL Server. r ega sm / codeba s e / t l b %Pr og r amfi l e s%\ Mi c r osof t SQL s e r ve r\ 90\ Not i f i c at i onse r vi ce s\ 9. 0. 242\ bi n\ mi c r osof t. sql s e r ve r. not i f i cat i onse rvi c e s. dl l SQL Server.,. 1.. SQL Server 2005 CD CD-ROM.

66 1 Microsoft SQL Server 2005 2. SQL Server 2005. CD-ROM Splash.hta. 3.,,.,. 4. SQL Server...,. 5.. 25 CD. 6... SQL Server SQL Server. SQL Server, Analysis Services Reporting Services.,..,... /. [2-6] / SQL Server 2005.. SQL Server 2005....

2 Microsoft SQL Server 2005 67 [2-6 ] / SQL Server. 1. / Microsoft SQL Server 2005,. SQL Server 2005 SQL Server. 2., Analysis Services.. 3. SQL Server.. 4.. /. 5.... 6.,. S QL S e rve r SQL Server /. SQL Server. SQL Server.

68 1 Microsoft SQL Server 2005 1. / SQL Server. SQL Server 2005. 2. /. 3.. SQL Server 2005. SQL Server CD-ROM CD-ROM CD. SQL Server 2005 /SQL Server.,. 1. Microsoft SQL Native Client 2. Microsoft SQL Server