Ben Miller

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: )

7,677 reads

Blogs

Cursor Dynamic SQL

By

Today was working on SQL Server cursor standard cursor deification would be like this:...

How to get the Active Directory user password policy values

By

Recently I have had to troubleshoot quite a bit of SQL login issues and...

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

XP_send mail fail

By ramyours2003

We migrated from sql 2005 to sql 2016  recently in one of the job...

How does DBCC CHECKDB use tempdb?

By RaufDBA

I would like to know the working principle of DBCC regarding the tempdb. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers