PowerShell Development: Querying SQL Server

preview_player
Показать описание
A quick code walk through of a custom function that executes queries against a SQL Server database. Includes coverage of key concepts.

Code available at:
  1. Bryan Cafferky
  2. SQL
  3. SQL Server
  4. -T-SQL
  5. database
  6. relationalal
Рекомендации по теме
PowerShell Development: Querying 0:16:15

PowerShell Development: Querying SQL Server

How to use 0:49:11

How to use PowerShell in SQL Server

PowerShell For SQL 2:56:36

PowerShell For SQL Full Course

Powershell reading data 0:13:05

Powershell reading data from SQL Server via cmdlet or SMO

SQL Database Queries 0:11:02

SQL Database Queries using Powershell

Query Database using 0:07:00

Query Database using powershell

Exploring the SQL 1:30:21

Exploring the SQL Server Powershell Module

Powershell SQL Connection 0:04:58

Powershell SQL Connection | Execute Queries

How To Run 0:05:54

How To Run a SQL Query On Multiple SQL Servers Using Powershell

Painting with PowerShell: 0:54:23

Painting with PowerShell: SQL Server Administration

Powershell Working with 0:02:50

Powershell Working with SQL and Hash Tables

Install & Configure 0:45:01

Install & Configure SQL Server with PowerShell DSC

Powershell For SQL 0:35:46

Powershell For SQL DBA Day-1, 27/07/2022

How to Run 1:16:04

How to Run a SQL Query on Multiple SQL Servers using PowerShell - Serial Manner

Loading SQL Data 1:01:34

Loading SQL Data From Powershell

Powershell SQL Client 0:05:59

Powershell SQL Client SMO

Working with PowerShell 0:38:19

Working with PowerShell to perform SQL tasks

Deploy & Manage 0:53:13

Deploy & Manage Ola Hallengren's Scripts in SQL Server with PowerShell

Automate Operational Readiness 0:46:28

Automate Operational Readiness and Validation Testing of SQL Server with PowerShell and Pester

🛢 Manage SQL 0:09:04

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

When you first 0:00:32

When you first time install Kali linux for hacking 😄😄 #hacker #shorts

Powershell Scripting For 0:36:39

Powershell Scripting For SQL DBA - Demo + Day1.1 , 06/11/2022

Powershell For SQL 0:38:37

Powershell For SQL DBA Day -1.7 , 11/03/2023

Automating SQL Server 0:08:59

Automating SQL Server Availability Groups with Powershell

Комментарии
Автор

Very useful demonstration. Can you also demonstrante an ODBC select?

michaeldobala
Автор

Curious to know the benefits or draw backs of using the SQLPS module vs SQL Native client,


Also if you schedule a powershell job using SQL agent, what version of powershell is sql agent using? Can you change it? Am i left to invoking powershell and passing the .ps1 file on the job step if I want to use certain cmdlets?

If I loaded a function in memory would I be able to use that function in the job step and have sql agent call it given it as permission to perform said task?

alextexas
Автор

Could please come up with a course on using azure api using powershell.

sumitshanker
Автор

That was fantastic... How can you run multiple sql statements in multiple script files using invoke sql command in powershell?

TarekFaham
Автор

Can you provide the link for the code please?

tanmaysathaye