Ben Miller (DBAduck)


Stairway to SQL PowerShell

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.

You rated this post out of 5. Change rating

2022-01-19 (first published: )

6,365 reads

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)

You rated this post out of 5. Change rating

2021-12-08 (first published: )

14,286 reads

Stairway to SQL PowerShell

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.

You rated this post out of 5. Change rating

2014-05-14

6,898 reads

Blogs

Visualising SQL Server in Kubernetes

By

The other day I came across an interesting repo on github, KubeDiagrams. What this...

Picking a Starting Table in Test Data Manager

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

SQL Server Migration Using a Distributed Availability Group

By

SQL Server migrations are a headache, ask anyone who’s been through the pain of...

Read the latest Blogs

Forums

Introduction to PostgreSQL for the data professional

By Site Owners

Comments posted to this topic are about the item Introduction to PostgreSQL for the...

what happens to ssis and ssrs whenb we migrate to sql saas

By stan

Hi we know (or believe)  ssas saas gets stood up separately when a company...

"External table is not in the expected format"

By Reh23

Good Afternoon. I have been manually running an SSIS package on an adhoc basis,...

Visit the forum

Question of the Day

CHOOSing an Alias

I have this code:

SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x
FROM ProductSales;
What is a good name for the column alias?

See possible answers