PowerShell SQL Tutorial Part 2 : Manipulating Data

Показать описание

Learn how to iterate through the data we get from the database and be able to execute if statements on them and display them, export them etc. In this video I go over how to take the data we got from the select statement and put it in a format where we can use foreach loops to iterate through the rows and perform actions on the data.

Tags:
Sql server, powershell, fetching data, powershell sql, powershell data science, automation, jacked programmer, scripting, coding, programming

Рекомендации по теме

Комментарии

High value content. Most underrated Programming coach on the interwebs imho, right now! Happy I found him that early. Here you go algorithm, a long comment!

fpost

Thanks for the video.
My understanding is that DataSet is useful for obtaining multiple tables from a database, for working with the relationships between those tables. Since in this case we want only one table, it's considered more efficient to use DataTable instead of DataSet. That should allow you to eliminate Line 14 from your script but the rest should otherwise remain very similar.
Secondly I believe there's no need to statically open or close the connection when using DataAdapter. DataAdapter will do that dynamically as needed.

tdoan

Thank you for the video and the scenario of how to use it.

create database Logging
use Logging
create table Log(
id bigint identity,
occuredAt datetime default CURRENT_TIMESTAMP,
appName nvarchar(100),
computerName nvarchar(255),
details text,
);

insert into Log (appName, computerName, details) values ('Test', 'TestComputer', 'TestDetails')
insert into Log (appName, computerName, details) values ('Test', 'TestComputer', 'TestDetails')
insert into Log (appName, computerName, details) values ('Prod', 'TestComputer2', 'TestDetails')
insert into Log (appName, computerName, details) values ('Prod', 'TestComputer', 'TestDetails')
insert into Log (appName, computerName, details) values ('Test', 'TestComputer2', 'TestDetails')

alexyou

you didn't provide the inserts in the description :/

TheDogtag

Why so complicated? What are you doing here? foreach($row in $data){
get-date -date $row.occuredAt -Format yyy-MM-dd
}
why the get-date. couldn't you just foreach $row.occuredAt ?

fpost

PowerShell SQL Tutorial Part 2 : Manipulating Data

PowerShell SQL Tutorial Part 2 : Manipulating Data

Managing SQL Server with PowerShell: Part 2 - The Tasks

PowerShell SQL - Making a SQL Module Part 2 : Select Statement

Microsoft SQL Server Powershell Classes: Part 2

PowerShell FOR DBA Part-2

🛢 Manage SQL Server with PowerShell 🤯 Step 2: Connect to SQLServer Database ✅

Using PowerShell SQL Server Database HTML Space Report - Part 2

PowerShell for the DBA, Part 2 Objects and Tools

PowerShell for Automation of SQL Server | Variables & Data-Types | Part-2

PowerShell SQL Tutorial Part 3 : Insert, Update, Delete

PowerShell Basics for SQL DBAs: Class 2

Create and manage Azure Sql server & database | Azure PowerShell

PowerShell SQL - Making a SQL Module Part 3 : Insert, Update, Delete

PowerShell SQL Tutorial Part 1 : Fetching Data

The HARDEST part about programming 🤦‍♂️ #code #programming #technology #tech #software #developer...

PowerShell DSC - Part 2- Local Configuration Manager

PowerShell: Advance cmdlet Group Object Part 2

PowerShell 7 Tutorials for Intermediates #2 : Methods (Part 2 of 2)

PowerShell For SQL Full Course

Powershell SQL Client SMO

Course Preview: Accessing SQL Server Databases from PowerShell

Set execution policy #currentaffair #programminglanguage #vocabulary #generalknowledge #powershell

PowerShell SQL Tutorial Part 4 : SQL Authentication

Powershell - Try and Catch - How many SQL Instance in running on my Host - Using PowerShell Part -2