Microsoft® SQL Server 2005 Unleashed

Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of t...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Rankins, Ray, Bertucci, Paul, Gallelli, Chris, Silverstein, Alex T
Format: Buch
Sprache:eng
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator Rankins, Ray
Bertucci, Paul
Gallelli, Chris
Silverstein, Alex T
description Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.Detailed information on…Installing, upgrading, and administering SQL Server 2005Database maintenance, backup, and recoveryCreating and managing tables, views, stored procedures, triggers, and user-defined functionsDatabase and index designSQL Server query optimization, and performance monitoring and tuningTransactions, transaction management, and distributed transactionsSQL Server Management Studio—NEW!SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!SQL Server Service Broker—NEW!SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!SQL Server high availability and SQL Server clustering and replicationDatabase Mirroring—NEW!Database Snapshots—NEW!Using XML in SQL Server 2005SQL Server tools and utilitiesCD-ROM includes8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text SearchCode samples, scripts, and sample databasesA PDF version of the entire bookIntroductionPart I Welcome to Microsoft SQL Server1 SQL Server 2005 Overview2 What’s New in SQL Server 2005Part II SQL Server Tools and Utilities3 SQL Server Management Studio4 SQL Server Command-Line Utilities5 SQL Server ProfilerPart III SQL Server Administration6 SQL Server System and Database Administration7 Installing SQL Server 20058 Upgrading to SQL Server 20059 Client Installation and Configuration10 Security and User Administration11 Database Backup and Restore12 Database Mail13 SQL Server Scheduling and Notification14 SQL Server High Availability.15 Replication16 Database Mirroring17 SQL Server ClusteringPart IV Database Administration18 Creating and Managing Databa
format Book
fullrecord <record><control><sourceid>safari_askew</sourceid><recordid>TN_cdi_askewsholts_vlebooks_9780768666861</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>0672328240</sourcerecordid><originalsourceid>FETCH-LOGICAL-a24273-6beaff811a2bc30a16a34388d5452efc48112a5069429252fe784a572388fffa3</originalsourceid><addsrcrecordid>eNpNj91Kw0AQhVdEUGvfIV544UVgM_uTzaUU_yAipdXbMElnaG1wIVPiW_kQPpkrEfTAMBzmYzjnSJ1rX4KBAFYf_zenai7ypn9Uemf9mbp62nVDlMiHr89stayzFQ0jDRlo7bKX955QtrS5UCeMvdD8d8_U693tevGQ18_3j4ubOkewUJrct4TMoSgQ2s5oLDwaa0LYOOuAuLPpBOi0ryxU4ICpDBZdihcCM6OZqevpMcqePmQb-4M0Y09tjHtpqjKk3MH7NEViLydWkHHYNRMzQvPX13wDCzVIQQ</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>book</recordtype></control><display><type>book</type><title>Microsoft® SQL Server 2005 Unleashed</title><source>O'Reilly Online Learning: Academic/Public Library Edition</source><creator>Rankins, Ray ; Bertucci, Paul ; Gallelli, Chris ; Silverstein, Alex T</creator><creatorcontrib>Rankins, Ray ; Bertucci, Paul ; Gallelli, Chris ; Silverstein, Alex T</creatorcontrib><description>Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.Detailed information on…Installing, upgrading, and administering SQL Server 2005Database maintenance, backup, and recoveryCreating and managing tables, views, stored procedures, triggers, and user-defined functionsDatabase and index designSQL Server query optimization, and performance monitoring and tuningTransactions, transaction management, and distributed transactionsSQL Server Management Studio—NEW!SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!SQL Server Service Broker—NEW!SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!SQL Server high availability and SQL Server clustering and replicationDatabase Mirroring—NEW!Database Snapshots—NEW!Using XML in SQL Server 2005SQL Server tools and utilitiesCD-ROM includes8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text SearchCode samples, scripts, and sample databasesA PDF version of the entire bookIntroductionPart I Welcome to Microsoft SQL Server1 SQL Server 2005 Overview2 What’s New in SQL Server 2005Part II SQL Server Tools and Utilities3 SQL Server Management Studio4 SQL Server Command-Line Utilities5 SQL Server ProfilerPart III SQL Server Administration6 SQL Server System and Database Administration7 Installing SQL Server 20058 Upgrading to SQL Server 20059 Client Installation and Configuration10 Security and User Administration11 Database Backup and Restore12 Database Mail13 SQL Server Scheduling and Notification14 SQL Server High Availability.15 Replication16 Database Mirroring17 SQL Server ClusteringPart IV Database Administration18 Creating and Managing Databases19 Creating and Managing Tables20 Creating and Managing Indexes21 Implementing Data Integrity22 Creating and Managing Views in SQL Server23 Creating and Managing Stored Procedures24 Creating and Managing User-Defined Functions25 Creating and Managing Triggers26 Transaction Management and the Transaction Log27 Database Snapshots28 Database MaintenancePart V SQL Server Performance and Optimization29 Indexes and Performance30 Understanding Query Optimization31 Query Analysis32 Locking and Performance33 Database Design and Performance34 Monitoring SQL Server PerformancePart VI SQL Server Application Development35 What’s New for Transact-SQL in SQL Server 200536 SQL Server and the .NET Framework37 Using XML in SQL Server 200538 SQL Server Web ServicesPart VII SQL Server Business Intelligence Features&lt;/</description><identifier>ISBN: 0672328240</identifier><identifier>ISBN: 9780672328244</identifier><identifier>EISBN: 0672328240</identifier><identifier>EISBN: 9780672328244</identifier><identifier>EISBN: 0768666864</identifier><identifier>EISBN: 9780768666861</identifier><language>eng</language><publisher>Sams</publisher><creationdate>2007</creationdate><tpages>1752</tpages><format>1752</format><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>306,780,784,786,24761</link.rule.ids></links><search><creatorcontrib>Rankins, Ray</creatorcontrib><creatorcontrib>Bertucci, Paul</creatorcontrib><creatorcontrib>Gallelli, Chris</creatorcontrib><creatorcontrib>Silverstein, Alex T</creatorcontrib><title>Microsoft® SQL Server 2005 Unleashed</title><description>Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.Detailed information on…Installing, upgrading, and administering SQL Server 2005Database maintenance, backup, and recoveryCreating and managing tables, views, stored procedures, triggers, and user-defined functionsDatabase and index designSQL Server query optimization, and performance monitoring and tuningTransactions, transaction management, and distributed transactionsSQL Server Management Studio—NEW!SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!SQL Server Service Broker—NEW!SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!SQL Server high availability and SQL Server clustering and replicationDatabase Mirroring—NEW!Database Snapshots—NEW!Using XML in SQL Server 2005SQL Server tools and utilitiesCD-ROM includes8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text SearchCode samples, scripts, and sample databasesA PDF version of the entire bookIntroductionPart I Welcome to Microsoft SQL Server1 SQL Server 2005 Overview2 What’s New in SQL Server 2005Part II SQL Server Tools and Utilities3 SQL Server Management Studio4 SQL Server Command-Line Utilities5 SQL Server ProfilerPart III SQL Server Administration6 SQL Server System and Database Administration7 Installing SQL Server 20058 Upgrading to SQL Server 20059 Client Installation and Configuration10 Security and User Administration11 Database Backup and Restore12 Database Mail13 SQL Server Scheduling and Notification14 SQL Server High Availability.15 Replication16 Database Mirroring17 SQL Server ClusteringPart IV Database Administration18 Creating and Managing Databases19 Creating and Managing Tables20 Creating and Managing Indexes21 Implementing Data Integrity22 Creating and Managing Views in SQL Server23 Creating and Managing Stored Procedures24 Creating and Managing User-Defined Functions25 Creating and Managing Triggers26 Transaction Management and the Transaction Log27 Database Snapshots28 Database MaintenancePart V SQL Server Performance and Optimization29 Indexes and Performance30 Understanding Query Optimization31 Query Analysis32 Locking and Performance33 Database Design and Performance34 Monitoring SQL Server PerformancePart VI SQL Server Application Development35 What’s New for Transact-SQL in SQL Server 200536 SQL Server and the .NET Framework37 Using XML in SQL Server 200538 SQL Server Web ServicesPart VII SQL Server Business Intelligence Features&lt;/</description><isbn>0672328240</isbn><isbn>9780672328244</isbn><isbn>0672328240</isbn><isbn>9780672328244</isbn><isbn>0768666864</isbn><isbn>9780768666861</isbn><fulltext>true</fulltext><rsrctype>book</rsrctype><creationdate>2007</creationdate><recordtype>book</recordtype><sourceid>OODEK</sourceid><recordid>eNpNj91Kw0AQhVdEUGvfIV544UVgM_uTzaUU_yAipdXbMElnaG1wIVPiW_kQPpkrEfTAMBzmYzjnSJ1rX4KBAFYf_zenai7ypn9Uemf9mbp62nVDlMiHr89stayzFQ0jDRlo7bKX955QtrS5UCeMvdD8d8_U693tevGQ18_3j4ubOkewUJrct4TMoSgQ2s5oLDwaa0LYOOuAuLPpBOi0ryxU4ICpDBZdihcCM6OZqevpMcqePmQb-4M0Y09tjHtpqjKk3MH7NEViLydWkHHYNRMzQvPX13wDCzVIQQ</recordid><startdate>20070419</startdate><enddate>20070419</enddate><creator>Rankins, Ray</creator><creator>Bertucci, Paul</creator><creator>Gallelli, Chris</creator><creator>Silverstein, Alex T</creator><general>Sams</general><general>Sams Publishing</general><scope>OHILO</scope><scope>OODEK</scope></search><sort><creationdate>20070419</creationdate><title>Microsoft® SQL Server 2005 Unleashed</title><author>Rankins, Ray ; Bertucci, Paul ; Gallelli, Chris ; Silverstein, Alex T</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-a24273-6beaff811a2bc30a16a34388d5452efc48112a5069429252fe784a572388fffa3</frbrgroupid><rsrctype>books</rsrctype><prefilter>books</prefilter><language>eng</language><creationdate>2007</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Rankins, Ray</creatorcontrib><creatorcontrib>Bertucci, Paul</creatorcontrib><creatorcontrib>Gallelli, Chris</creatorcontrib><creatorcontrib>Silverstein, Alex T</creatorcontrib><collection>O'Reilly Online Learning: Corporate Edition</collection><collection>O'Reilly Online Learning: Academic/Public Library Edition</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Rankins, Ray</au><au>Bertucci, Paul</au><au>Gallelli, Chris</au><au>Silverstein, Alex T</au><format>book</format><genre>book</genre><ristype>BOOK</ristype><btitle>Microsoft® SQL Server 2005 Unleashed</btitle><date>2007-04-19</date><risdate>2007</risdate><isbn>0672328240</isbn><isbn>9780672328244</isbn><eisbn>0672328240</eisbn><eisbn>9780672328244</eisbn><eisbn>0768666864</eisbn><eisbn>9780768666861</eisbn><abstract>Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.Detailed information on…Installing, upgrading, and administering SQL Server 2005Database maintenance, backup, and recoveryCreating and managing tables, views, stored procedures, triggers, and user-defined functionsDatabase and index designSQL Server query optimization, and performance monitoring and tuningTransactions, transaction management, and distributed transactionsSQL Server Management Studio—NEW!SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!SQL Server Service Broker—NEW!SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!SQL Server high availability and SQL Server clustering and replicationDatabase Mirroring—NEW!Database Snapshots—NEW!Using XML in SQL Server 2005SQL Server tools and utilitiesCD-ROM includes8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text SearchCode samples, scripts, and sample databasesA PDF version of the entire bookIntroductionPart I Welcome to Microsoft SQL Server1 SQL Server 2005 Overview2 What’s New in SQL Server 2005Part II SQL Server Tools and Utilities3 SQL Server Management Studio4 SQL Server Command-Line Utilities5 SQL Server ProfilerPart III SQL Server Administration6 SQL Server System and Database Administration7 Installing SQL Server 20058 Upgrading to SQL Server 20059 Client Installation and Configuration10 Security and User Administration11 Database Backup and Restore12 Database Mail13 SQL Server Scheduling and Notification14 SQL Server High Availability.15 Replication16 Database Mirroring17 SQL Server ClusteringPart IV Database Administration18 Creating and Managing Databases19 Creating and Managing Tables20 Creating and Managing Indexes21 Implementing Data Integrity22 Creating and Managing Views in SQL Server23 Creating and Managing Stored Procedures24 Creating and Managing User-Defined Functions25 Creating and Managing Triggers26 Transaction Management and the Transaction Log27 Database Snapshots28 Database MaintenancePart V SQL Server Performance and Optimization29 Indexes and Performance30 Understanding Query Optimization31 Query Analysis32 Locking and Performance33 Database Design and Performance34 Monitoring SQL Server PerformancePart VI SQL Server Application Development35 What’s New for Transact-SQL in SQL Server 200536 SQL Server and the .NET Framework37 Using XML in SQL Server 200538 SQL Server Web ServicesPart VII SQL Server Business Intelligence Features&lt;/</abstract><pub>Sams</pub><tpages>1752</tpages></addata></record>
fulltext fulltext
identifier ISBN: 0672328240
ispartof
issn
language eng
recordid cdi_askewsholts_vlebooks_9780768666861
source O'Reilly Online Learning: Academic/Public Library Edition
title Microsoft® SQL Server 2005 Unleashed
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-10T11%3A37%3A18IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-safari_askew&rft_val_fmt=info:ofi/fmt:kev:mtx:book&rft.genre=book&rft.btitle=Microsoft%C2%AE%20SQL%20Server%202005%20Unleashed&rft.au=Rankins,%20Ray&rft.date=2007-04-19&rft.isbn=0672328240&rft.isbn_list=9780672328244&rft_id=info:doi/&rft_dat=%3Csafari_askew%3E0672328240%3C/safari_askew%3E%3Curl%3E%3C/url%3E&rft.eisbn=0672328240&rft.eisbn_list=9780672328244&rft.eisbn_list=0768666864&rft.eisbn_list=9780768666861&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true