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.

4 (1)

2021-12-08 (first published: )

12,056 reads

Blogs

Checking if a database has a master key–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Join me in Germany in June

By

I have been selected to speak at the DataGrillen conference later this year. I will be...

Daily Coping 26 Jan 2022

By

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

Read the latest Blogs

Forums

Restore autmomation

By ramyours2003

i need to  create sql job  which perform automate restore of the databases  with...

Stored Procedure error log integration with APM tools

By stevetb

Hi all, We typically consolidate our logging in an APM tool (eg: like Datadog)....

Cohort Cumulative Rates in SQL

By eugeniexxx

I have a question regarding a problem for cohort analysis in SQL (any dialect)....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers