서브메뉴
검색
SQL server 2012 with PowerShell V3 cookbook- [electronic resource]
SQL server 2012 with PowerShell V3 cookbook- [electronic resource]
상세정보
- 자료유형
- 단행본
- International Standard Book Number
- 9781849686471 (electronic bk.)
- International Standard Book Number
- 1849686475 (electronic bk.)
- International Standard Book Number
- 9781849686464
- International Standard Book Number
- 1849686467
- Library of Congress Call Number
- QA76.9.D3
- Dewey Decimal Classification Number
- 005.7585-22
- Main Entry-Personal Name
- Santos, Donabel.
- Publication, Distribution, etc. (Imprint
- Birmingham : Packt Pub, 2012
- Physical Description
- 1 online resource.
- Series Statement
- Quick answers to common problems.
- General Note
- Performing bulk export using Invoke-Sqlcmd.
- Formatted Contents Note
- 완전내용SQL Server 2012 with PowerShell V3 Cookbook; SQL Server 2012 with PowerShell V3 Cookbook; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Getting Started with SQL Server and PowerShell; Introduction; Notable PowerShell V3 features.
- Formatted Contents Note
- 완전내용Before you start: Working with SQL Server and PowerShellWorking with the sample code; How to do it ... ; See also; Exploring the SQL Server PowerShell hierarchy; Getting ready; How to do it ... ; How it works ... ; Installing SMO; Getting ready; How to do it ... ; There's more ... ; Loading SMO assemblies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Discovering SQL-related cmdlets and modules; Getting ready; How to do it ... ; How it works ... ; There's more ... ; More information on running PowerShell scripts; More information on mixed assembly error.
- Formatted Contents Note
- 완전내용Creating a SQL Server instance objectGetting ready; How to do it ... ; How it works ... ; See also; Exploring SMO server objects; Getting ready; How to do it ... ; How it works ... ; See also; 2. SQL Server and PowerShell Basic Tasks; Introduction; Development environment; Administrator; PowerShell ISE; Running scripts; Listing SQL Server instances; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Discovering SQL Server services; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Starting/stopping SQL Server services; Getting ready; How to do it ...
- Formatted Contents Note
- 완전내용How it works ... There's more ... ; See also; Listing SQL Server configuration settings; How to do it ... ; How it works ... ; See also; Changing SQL Server instance configurations; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Searching for database objects; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Creating a database; Getting ready; How to do it ... ; How it works ... ; Altering database properties; Getting ready; How to do it ... ; How it works ... ; See also; Dropping a database; Getting ready; How to do it ... ; How it works ...
- Formatted Contents Note
- 완전내용Changing a database ownerGetting ready; How to do it ... ; How it works ... ; See also; Creating a table; Getting ready; How to do it ... ; How it works ... ; See also; Creating a view; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating a stored procedure; Getting ready; How to do it ... ; How it works ... ; Creating a trigger; Getting ready; How to do it ... ; How it works ... ; Creating an index; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Executing a query / SQL script; Getting ready; How to do it ... ; How it works ...
- Summary, Etc.
- 요약SQL Server 2012 with PowerShell V3 Cookbook"" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away, This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants.
- Subject Added Entry-Uniform Title
- SQL server.
- Subject Added Entry-Topical Term
- Database management
- Subject Added Entry-Topical Term
- Windows PowerShell (Computer program language)
- Subject Added Entry-Topical Term
- Computer
- Subject Added Entry-Topical Term
- COMPUTERS Data Processing.
- Additional Physical Form Entry
- Print versionSantos, Donabel. SQL Server 2012 with PowerShell V3 Cookbook. Birmingham : Packt Publishing, 2012 9781849686464
- Series Added Entry-Uniform Title
- Quick answers to common problems.
- Electronic Location and Access
- 로그인을 한후 보실 수 있는 자료입니다.
- Control Number
- joongbu:423016
MARC
008140102s2012 enk o 000 0 eng d■001
■003OCoLC
■00520140127111324
■006m o d
■007cr cnu---unuuu
■019 ▼a824752438
■020 ▼a9781849686471 (electronic bk.)
■020 ▼a1849686475 (electronic bk.)
■020 ▼a9781849686464
■020 ▼a1849686467
■0291 ▼aAU@▼b000050492273
■0291 ▼aAU@▼b000050635553
■035 ▼a(OCoLC)818818960
■037 ▼aCL0500000184▼bSafari Books Online
■040 ▼aEBLCP▼beng▼cEBLCP▼dYDXCP▼dN$T▼dOCLCQ▼dE7B▼dUMI▼dCOO▼dOCLCQ
■050 4▼aQA76.9.D3
■072 7▼aCOM▼x018000▼2bisacsh
■08204▼a005.7585▼222
■1001 ▼aSantos, Donabel.
■24510▼aSQL server 2012 with PowerShell V3 cookbook▼h[electronic resource]▼dDonabel Santos
■260 ▼aBirmingham▼bPackt Pub▼c2012
■300 ▼a1 online resource.
■4901 ▼aQuick answers to common problems.
■500 ▼aPerforming bulk export using Invoke-Sqlcmd.
■5050 ▼aSQL Server 2012 with PowerShell V3 Cookbook; SQL Server 2012 with PowerShell V3 Cookbook; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Getting Started with SQL Server and PowerShell; Introduction; Notable PowerShell V3 features.
■5058 ▼aBefore you start: Working with SQL Server and PowerShellWorking with the sample code; How to do it ... ; See also; Exploring the SQL Server PowerShell hierarchy; Getting ready; How to do it ... ; How it works ... ; Installing SMO; Getting ready; How to do it ... ; There's more ... ; Loading SMO assemblies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Discovering SQL-related cmdlets and modules; Getting ready; How to do it ... ; How it works ... ; There's more ... ; More information on running PowerShell scripts; More information on mixed assembly error.
■5058 ▼aCreating a SQL Server instance objectGetting ready; How to do it ... ; How it works ... ; See also; Exploring SMO server objects; Getting ready; How to do it ... ; How it works ... ; See also; 2. SQL Server and PowerShell Basic Tasks; Introduction; Development environment; Administrator; PowerShell ISE; Running scripts; Listing SQL Server instances; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Discovering SQL Server services; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Starting/stopping SQL Server services; Getting ready; How to do it ...
■5058 ▼aHow it works ... There's more ... ; See also; Listing SQL Server configuration settings; How to do it ... ; How it works ... ; See also; Changing SQL Server instance configurations; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Searching for database objects; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Creating a database; Getting ready; How to do it ... ; How it works ... ; Altering database properties; Getting ready; How to do it ... ; How it works ... ; See also; Dropping a database; Getting ready; How to do it ... ; How it works ...
■5058 ▼aChanging a database ownerGetting ready; How to do it ... ; How it works ... ; See also; Creating a table; Getting ready; How to do it ... ; How it works ... ; See also; Creating a view; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating a stored procedure; Getting ready; How to do it ... ; How it works ... ; Creating a trigger; Getting ready; How to do it ... ; How it works ... ; Creating an index; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Executing a query / SQL script; Getting ready; How to do it ... ; How it works ...
■520 ▼aSQL Server 2012 with PowerShell V3 Cookbook"" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away, This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants.
■588 ▼aDescription based on print version record.
■63000▼aSQL server.
■650 0▼aDatabase management
■650 0▼aWindows PowerShell (Computer program language)
■650 4▼aComputer
■650 7▼aCOMPUTERS▼xData Processing.▼2bisacsh
■655 4▼aElectronic books.
■77608▼iPrint version▼aSantos, Donabel.▼tSQL Server 2012 with PowerShell V3 Cookbook.▼dBirmingham : Packt Publishing, 2012▼z9781849686464
■830 0▼aQuick answers to common problems.
■85640▼3EBSCOhost▼uhttp://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=499147
■938 ▼aEBL - Ebook Library▼bEBLB▼nEBL1057946
■938 ▼aYBP Library Services▼bYANK▼n9905049
■938 ▼aEBSCOhost▼bEBSC▼n499147
■938 ▼aebrary▼bEBRY▼nebr10623092
■994 ▼a92▼bK4R
■999 ▼z635217623907107158
