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

Publicado el: 26 junio 2021
en el canal de: 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

En esta página del sitio puede ver el video en línea 06 - Save User Creation To SQL Database PS Script - Build Web Apps Using Powershell and PHP de Duración hora minuto segunda en buena calidad , que subió el usuario the Sysadmin Channel 26 junio 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,181 veces y le gustó 7 a los espectadores. Disfruta viendo!

3,223

127