06 - Save User Creation To SQL Database PS Script - Build Web Apps Using Powershell and PHP

Pubblicato il: 26 giugno 2021
sul canale di: the Sysadmin Channel

1,181

In our 6th video we're going to create a function to save user creation to SQL database. In our last video we created the new-usercreation which generates a username and email address from their first and last name.

Here we're going to save the info that was generated into our SQL database for processing. We want to send it to the database so it acts as a logging system as well as batch the creations at once. This is a great tutorial for beginner and intermediate Powershell and SQL users. We'll use the invoke-sql cmd to input data into a database as well as pull and confirm data that we've already written.

Series Playlist:
• 01 - Configure PHP and IIS on Windows Serv...

00:00 - Intro
00:30 - Start developing Powershell Script
00:49 - Create a function from scratch
01:15 - Powershell advanced function overview
02:47 - Create Powershell structure
03:16 - Starting the process block
04:14 - Writing 'insert into' SQL statement
07:40 - Validating data was inserted into the SQL database
09:05 - Testing script within Powershell

In questa pagina del sito puoi guardare il video online 06 - Save User Creation To SQL Database PS Script - Build Web Apps Using Powershell and PHP della durata di ore minuti seconda in buona qualità , che l'utente ha caricato the Sysadmin Channel 26 giugno 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,181 volte e gli è piaciuto 7 spettatori. Buona visione!