Ben Miller (DBAduck)

Stairway to SQL PowerShell

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.

2018-04-25 (first published: )

8,787 reads

Blogs

Fun Fact: AWS RDS and system_health

By

Did you know that the system_health Extended Event session was running in your RDS...

Daily Coping 2 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

TSQL Tuesday #127 Invite – Non SQL Tips and tricks

By

How about for this months TSQL Tuesday let’s do another month of tips and...

Read the latest Blogs

Forums

buy Adalat West Virginia, Adalat acalasia

By stanley

buy Adalat West Virginia, Adalat acalasia Shop from home in our secure online store!...

Buy Symbicort safely, When is symbicort going generic

By stanley

Buy Symbicort safely, When is symbicort going generic Shopping for medications could be a...

Order Ofloxacin pay by cod online, Ofloxacin 200 preis

By stanley

Order Ofloxacin pay by cod online, Ofloxacin 200 preis Our online pharmacy is well...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers