mhandoChikoro Kudzidzisa
nyoresa

SQL Server PowerShell

tsananguro

Vateereri & Prerequisites

Course Outline

Purogiramu nemitengo

kutaura kuti ichokwadi

SQL Server PowerShell

PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language. Initially a Windows component only, known as Windows PowerShell

Zvinotarisirwa

Vadzidzi vanofanira kunge vakashanda naPowershell uye vanoziva simbahell cmdlets Get, Set, foreach, kana, array, hash, Variables, pipeline, uye nezvimwe. Powershell basic programming haina kuvharwa, chete SQL Server inowanikwa Powershell ichafukidzwa

Course Outline Duration: 2-3 Days

Day XCHARX 1

  • Kutarisira SQL Server Services
  • Kutarisira Mutevedzeri Wemitambo Mitemo
  • Kutungamira SQL Server Mutevedzeri Wekuteerera
  • Kutarisira Server Server Mitemo
  • Kuchinja SQL Server Yakazara Zvimwe Zvayo
  • Kuongorora Zvikanganiso zvakabva kuSQL
  • Server Error Log
  • Monitoring Deadlocks
  • Kuongorora Kuvhara
  • Kutarisa Databases
  • Kuongorora Dhiyabhorosi Zvinhu
  • sqlps Utility
  • SQLSERVER: Drive uye InvokeSqlcmd
  • Kuwana Rudzi rweZvirevo
  • SQL Server SPID Information

Zuva- 2

  • SQL Server Server-Related Information
  • SQL Server Data-Related Information
  • Kuchinja Login Login
  • Backup Database - Full, Differential & Transactional Log
  • Kudzorera Backup - Backup Yakakwana & Transaction Log Backup
  • The Database Database
  • Centralized Inventory Server
  • Database File Location uye
  • Kuvaka SQL Server Inventory
  • SQL Server Installation Template
  • Kuunganidza SQL Server Performance uye Host Performance
  • Kuongorora SQL Server:
    • Pinging SQL Server Hosts
    • Kuongorora SQL Server-Related Services paSQL Server Hosts
    • Checking Uptime Uptime yeSQL Server
  • Kuchengeta Disk Space Usage, Database
  • Kuchengeta Disk Space Usage
  • Kuongorora Dheyoti Files

Zuva- 3

  • Kuongorora Mazvidzidzo
  • Ongororo dzekuvakazve
  • DBCC CHECKDB
  • SQL Server Command regai
  • Kushandisa SMOs
    • Kuisa SMO
    • Kuwana zvinhu zveSQL Server
    • SMO Zvinhu Hierarchy
  • Kuwana deta mukati uye kunze kweSQL Server
    • Isa Data muTedheni
    • Verenga kubva kuTebvu
  • Kutarisira mabasa eWMI uye cmdlets
    • Get-CimInstanceCimInstance
    • Get-CimAssociatedInstance
    • Get-CimClass
    • Win32_Service
    • Win32_Process
    • Win32_LogicalDisk
    • Win32_DiskPartition
  • Nzira dzakasiyana dzekuvhara masangano ePPS mushure mekupedzwa
    • Uraya
    • Stop-Process

Ndapota nyorera kwatiri info@itstechschool.com & taura nesu pa + 91-9870480053 pamutengo wematengo & chikwata chemari, purogiramu & nzvimbo

Dhidzai Mhinduro

Kuti uwane mamwe mashoko nemutsa taura nesu.


Reviews