자료유형 | E-Book |
---|---|
개인저자 | Santos, Donabel. |
서명/저자사항 | SQL server 2012 with PowerShell V3 cookbook[electronic resource] /Donabel Santos. |
발행사항 | Birmingham : Packt Pub., 2012. |
형태사항 | 1 online resource. |
총서사항 | Quick answers to common problems. |
ISBN | 9781849686471 (electronic bk.) 1849686475 (electronic bk.) 9781849686464 1849686467 |
일반주기 |
Performing bulk export using Invoke-Sqlcmd.
|
내용주기 | 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. 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. 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 ... 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 ... 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 ... |
요약 | 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. |
주제명(통일서명) | SQL server. |
일반주제명 | Database management. Windows PowerShell (Computer program language) Computer. COMPUTERS -- Data Processing. |
언어 | 영어 |
기타형태 저록 | Print version:Santos, Donabel.SQL Server 2012 with PowerShell V3 Cookbook.Birmingham : Packt Publishing, 20129781849686464 |
대출바로가기 | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=499147 |
인쇄
No. | 등록번호 | 청구기호 | 소장처 | 도서상태 | 반납예정일 | 예약 | 서비스 | 매체정보 |
---|---|---|---|---|---|---|---|---|
1 | WE00002477 | 005.7585 | 가야대학교/전자책서버(컴퓨터서버)/ | 대출가능 |