Coming soon...
Using PowerShell for SQL Database Management
by Ram Iyer, Prashanth Jayaram
PowerShell 6.0 Linux Administration Cookbook
- Preface
- Installation, Reference and Help
- Introduction
- Installing PowerShell
- Fetching Help Information in PowerShell
- Fetching Help Information for a Specific Cmdlet
- Updating Help
- Searching Help for Keywords
- Looking for help information specific to a parameter
- Exploring the About_ Topics
- Discovering Cmdlets
- Finding Modules
- Installing Modules from the Repository
- Listing the Various Providers in PowerShell
- Introducing the Core and its Capabilities
- Introduction
- Dissecting a .NET Core Object
- Breaking down an output into different objects
- Parsing input from text to object
- Comparing the outputs of Bash and PowerShell
- Comparing Windows PowerShell and PowerShell
- Listing out the aliases and using them in place of cmdlets
- Creating a Custom Alias
- Export/Import Custom Aliases for Future Use
- Listing out the execution policies and setting a suitable one
- Preparing for Administration using PowerShell
- Introduction
- Installing Visual Studio Code
- Configuring automatic variables
- Changing the shell behaviour using a variable
- Enabling automated execution of commands for each load
- Customising the terminal prompt
- Understanding standard redirection in PowerShell
- Calling native Linux commands from PowerShell
- Understanding cmdlets and parameters
- Running cmdlets with minimal keystrokes
- Finding parameter aliases
- Calling a PowerShell script
- Dot-sourcing a PowerShell script
- Calling a PowerShell cmdlet from outside of PowerShell
- Recording the cmdlets run on the PowerShell console
- First Steps in Administration using PowerShell
- Introduction
- Working with date properties
- Working with date and time functions
- Working with currently-running processes to measure resource consumption
- Launching and stopping a process
- Finding the owner of a process
- Invoking an application based on the file type
- Installing the Crontab PowerShell module 
- Scheduling jobs in PowerShell
- Removing the jobs in PowerShell
- Passing Data through the Pipeline
- Introduction
- Selecting columns from the output
- Limiting the number of output objects
- Expanding the properties within properties
- Filtering objects
- Grouping the output
- Sorting the output
- Taking actions on the returned objects
- Understanding pipeline-enabled parameters
- Importing content into PowerShell
- Using Variables and Objects
- Flow Control using Branches and Loops
- Introduction
- Using If–ElseIf–Else conditions to control script flow
- Using Switch–Case conditions to control script flow
- Learning to use delays
- Writing a basic looping construct
- Writing a more complex loop on a predefined array
- Using the For loop construct
- Using the While loop construct
- Cleaning empty directories using the Do–While construct
- Cleaning empty directories using the Do–Until construct
- Working with Strings
- Performing Calculations
- Using Arrays and Hash Tables
- Handling Files and Directories
- Building Scripts and Functions
- Advanced Concepts of Functions
- Getting Under the Hood: Debugging and Error Handling
- Working with the Environment
- Security in PowerShell
- Enterprise Administration using PowerShell
- Best Practices Round-up
- PowerShell and Cloud Operations
- Using PowerShell for SQL Database Management
Using PowerShell for SQL Database Management
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.