Www.facebook.com/crystalspidersinstitute/ +91 733 845 7517 ...
[Pages:5]SQL Training By Chreddy crystalspidersinstitute/
SQL Server PowerShell Course Content
chreddy@ +91 733 845 7517 +91 955 313 7753
What Is Windows PowerShell: Command-Line Interfaces versus Graphical User Interfaces Prerequisites for Installing Windows PowerShell 2.0 2 o Installing the Microsoft .NET Framework o Installing Windows Remote Management Installing Windows PowerShell Launching Windows PowerShell Using the Command console Using All Programs Using Start Run
Windows PowerShell Command Types, Snap-ins, and cmdlets:
PowerShell Command Types o Native Commands o PowerShell cmdlets o Shell Function Commands o Script Commands o Calling PowerShell cmdlets or Scripts from the Command Shell
PowerShell Snap-ins o Core o Host o PowerShell.Management o Security o Utility o Diagnostics o WsMan.Management
PowerShell cmdlet Syntax o Named Parameter
o Positional Parameter o Command Chaining
Filtering Sorting Formatting
Windows PowerShell Programming, Scripting, Error Handling and Debugging:
PowerShell Scripts PowerShell Variables Arrays Expressions
o Operators Conditional Expressions
o IF Statement Loop Construct
o For Loop o While Loop o Do-While Loop o Do-Until Loop o Foreach Statement Input PowerShell Scripting Text File as Input Output o Writing to the Console o Writing to a File Error Handling Debugging
Windows PowerShell Functions, Parameters, Sourcing Scopes and User Profiles:
1
SQL Training By Chreddy crystalspidersinstitute/
SQL Server PowerShell Course Content
chreddy@ +91 733 845 7517 +91 955 313 7753
Functions o Arguments in Functions o Returning Values
Script Parameters Sourcing Variable Scope
o Function Scope o User Profiles Transcripts
Working with the File System, Registry and Variables:
Using Get-PSDrive and GetPSProvider
Working with File System o Navigating the File System o Managing Files and Directories o Managing File Contents
Working with the Registry Working with Variables
o Automatic Variables o Preference Variables o User-Created Variables Working with Environment Variables
Working with Event Logs: Event Log Service Event Viewer Event Logs Log Entry Types Exporting the event logs o PowerShell cmdlets Related to event log
Working with Windows Services and Processes:
What is a Windows Service? Windows PowerShell and Windows
Services o Get-Service o Stop-Service o Start-Service o Set-Service
Working with Windows Processes Get-Process Stop-Process
Working with WMI: Permission Issues and WMI The WMI Model Working with Event Log Working with Services Working with Processes Working with Environment Variables Working with the Registry
WMI Provider for Configuration Management:
Managing SQL Server Services Managing Client Network Protocols Managing SQL Server Client Aliases Managing Server Network Protocols Changing FILESTREAM Settings Changing SQL Server Advanced
Properties
2
SQL Training By Chreddy crystalspidersinstitute/
SQL Server PowerShell Course Content
chreddy@ +91 733 845 7517 +91 955 313 7753
WMI Provider for Server Events: WMI Provider for Server Events WMI Query Language (WQL) Event handling with Windows PowerShell 2.0 Monitoring Errors from the SQL Server Error Log Monitoring Deadlocks Monitoring Blockings Monitoring Login Changes and Failed Login Attempts Monitoring Databases Monitoring Database Objects
Windows PowerShell in SQL Server 2008 Environment and SQL Server PowerShell Provider:
sqlps Utility SQLSERVER: Drive and Invoke-
Sqlcmd cmdlet SQL Snap-ins Encoding and Decoding Uniform
Resource Name (URN)
Managing Policies through SQLSERVER: \SQLPolicy:
SQLSERVER:\SQLPolicy Folder Conditions Policies
Windows PowerShell and SMO: PowerShell and the SQLConnection .NET Class Working with SQL Server using SMO
o Methods and Properties o Getting Version Information o SQL Server SPID Information o SQL Server Server-Related
Information o SQL Server Database-Related
Information o Changing the Login Mode o Host Information o Performance Counters Working with Databases using SMO Working with Tables using SMO o Creating Tables o Listing Columns o Removing Columns o Adding Columns o Dropping a Table Backup and Restore with SMO o Database Backup o Transaction Log Backup o Differential Backup o Restoring Full Backup o Restoring a Full Backup and
Transaction Log Backup
Building SQL Server Standards and PowerShell Coding Standards:
SQL Server Standards SQL Server Development Standards
o Naming Conventions o General Rules Stored Procedure Standards o Keep Them Small o ``DBO'' As Object Owner
3
SQL Training By Chreddy crystalspidersinstitute/
SQL Server PowerShell Course Content
chreddy@ +91 733 845 7517 +91 955 313 7753
o Use Comments Generously o Select * o Cursors o Temporary Tables o Things to Avoid o Things to Use o Check @@ERROR o Use SQL Server Date Data
Types o DML Statements o ANSI-Standard Join Clauses o Deprecated Features Database Design Standard and Best Practices o User-Defined Tables o Logs o Split tempdb o Databases o Security and Roles o Auto Create and Auto
Update o Size o Auto Shrink and Auto Close o Design and Performance o Store Unstructured Data o More Performance
Guidelines Data Protection Standards and Best
Practices o Backup Policy
SQL Server Production Standards o High Availability and Disaster Recovery
o The Administration Database o The Scratch Database o Centralized Inventory Server o Database File Location and
RAID o Segregation o Features PowerShell Coding Standard o Default Parameters o Log File o Log Format o Comments o Display o Variable Naming Convention o Exception Handling
Building SQL Server Inventory: SQL Server Inventory Hosts Clusters Cluster Nodes Servers Databases Supplementary Tables
SQL Server Installation: Installation Procedure and Template o SQL Server Installation Template Standalone Installation Example Cluster Installation Example
4
SQL Training By Chreddy crystalspidersinstitute/
SQL Server PowerShell Course Content
chreddy@ +91 733 845 7517 +91 955 313 7753
Collecting SQL Server Performance and Host Performance Data:
SQL Server Performance Data Collection
SQL Server Host Performance Data Collection
Monitoring SQL Server: Pinging SQL Server Hosts Checking SQL Server?related Services on SQL Server Hosts Checking Uptime of SQL Server Hosts Monitoring Windows Event Logs Monitoring SQL Server Error Log Monitoring Blockings Monitoring Deadlocks
Monitoring Disk Space Usage, Database Files, and Backups:
Monitoring Disk Space Usage Monitoring Database Files Monitoring Backups
Defining Policies: Stored Procedure Naming Convention Policy Auto_Close and Auto_Shrink off Policy
Generating Database Scripts: Scripting Databases Scripting Schemas Scripting User-Defined Data Types
Scripting Tables Scripting User Views Scripting Stored Procedures Scripting Functions Scripting XML Schemas Scripting Users
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- execute multiple sql statements in batch file
- crystalspidersinstitute 91 733 845 7517
- automating azure sql database maintenance tasks
- ms 55039 windows powershell scripting and toolmaking
- achieve more in less time by using the new sql powershell
- practical sql queries for microsoft sql server 2008 r2
- bi alm tfs
Related searches
- 1 or 2 733 733 1 0 0 0 1
- 1 or 3 733 733 1 0 0 0 1
- facebook iframe src 9322 com iframe
- toyota highlander 5 or 91 select 91 from pg sleep 15 used
- 198 5 or 845 select 845 from pg sleep 15 1 1 change wifi password
- facebook facebook facebook facebook facebook facebook
- facebook facebook facebook facebook facebook twitter
- twitter facebook facebook facebook facebook facebook twitter
- twitter facebook facebook facebook facebook facebook facebook
- facebook twitter facebook facebook facebook facebook twitter
- facebook twitter facebook facebook facebook facebook facebook
- facebook facebook twitter facebook facebook facebook twitter