ituaigaAoaoga a le potuaoga
Tusi Resitala

Faʻatonuina o le PowerShell SQL Server

faʻamatalaga

Tagata o loʻo faʻalogo ma faʻamuamua

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

Faʻatonuina o le PowerShell SQL Server

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

Prerequisites

O tagata auai e tatau ona galulue faatasi ma le Mana ma le malamalama i malosiaga o le malosi. Get, Set, foreach, if, array, hash, Variables, pipeline, where etc. Malosiaga o polokalame e le o ufiufiina, naʻo le Powershell e fesoʻotaʻi ma le SQL Server

Course Outline Duration: 2-3 Days

Day XCHARX 1

  • Puleaina o Auaunaga Tūmau SQL
  • Puleaina o Maliega Fesoʻotai Tagata Matutua
  • Le puleaina o Alias ​​Client Alias
  • Puleaina o Maliega Fesootaiga Tūmau
  • Suia o Mea Faʻatonu Autu o Fesoʻotaʻiga SQL
  • Tausi siaki mai le SQL
  • Error Log Error Log
  • Mataʻituina o Faʻalavelave
  • Mataʻituina o Noataga
  • Mataʻituina o Faʻamaumauga
  • Mataituina o meafaitino o le komepiuta
  • sqlps Lelei
  • SQLSERVER: Drive ma InvokeSqlcmd
  • Mauaina Faamatalaga Faʻamatalaga
  • Faamatalaga SPID SP Server SQL

Aso - 2

  • Fesoʻotaʻiga Fesoʻotaʻi Fesoʻotaʻiga SQL Server
  • Fesoʻotaʻiga Faʻamatalaga Faʻamaumauga o SQL Server
  • Fesuiaiga o le Faʻasalaga Faʻasaga
  • Faʻamaumauga o Faʻamaumauga - Faʻasalalau, Eseese & Faʻasalalauga Faʻatasi
  • Toe faʻafoʻiina o le Backup - Toe Faʻalagolago ma le Faʻasalalauga Toe Faʻasoa
  • Le Faʻamatalaga Faʻamatalaga
  • Faʻasalalauga Faʻasalalau Tutotonu
  • File Database Filema ma
  • Fausiaina o Initaneti Tūmau SQL
  • Faʻataʻitaʻiga o le Faʻasinomaga o SQL
  • Aoina o le Tūmau SQL Server ma le Faʻatonuga o le Aufaigaluega
  • Mataituina o le SQL Server:
    • Pinging SQL Server Hosts
    • Siakiina o Auaunaga Fesoʻotai SQL i luga o Host Server Host
    • Iloilo le Uptime o le SQL Server
  • Mataʻituina le faʻaaogaina o avanoa faʻavaomalo, Database
  • Mataʻituina o le Faʻaaogaina o avanoa faʻavalea
  • Mataʻituina o Faʻamatalaga Faʻamaumauga

Aso - 3

  • Mataʻituina Suʻega
  • Toe fausia Atinaʻe
  • DBCC CHECKDB
  • Tuuina atu le Polokalama Faʻatonu SQL
  • Faaaogaina SMOs
    • Faʻapipiʻi SMO
    • Avanoa i Mea Faʻailoga SQL
    • Avanoa SMO Mea faʻatupu
  • Maua o faʻamaumauga i totonu ma fafo o le SQL Server
    • Faʻaofi Faʻamaumauga i Lisi
    • Faitau mai le Laulau
  • Puleaina o galuega a le WMI ma sikuea
    • Get-CimInstanceCimInstance
    • Get-CimAssociatedInstance
    • Get-CimClass
    • Win32_Service
    • Win32_Process
    • Win32_LogicalDisk
    • Win32_DiskPartition
  • Eseese auala o sauniga AF mulimuli peʻa maeʻa
    • fasioti
    • Taofi-Faʻasaga

Faamolemole tusi mai ia i matou i info@itstechschool.com & faʻafesoʻotaʻi i matou i le 91-9870480053 mo le tau aʻoaʻoga & tusi faamaonia o tau, faʻasologa ma le nofoaga

Tuʻu mai ia i matou se Fesili

Mo nisi faʻamatalaga agalelei faafesootai matou.


iloiloga