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,375 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,311 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,904 reads

Blogs

Monday Monitor Tips: VLF Alerts

By

A recent change made to Redgate Monitor to add a new alert for VLF...

Using T-SQL Snapshot Backup - Seeding Availability Groups

By

In this post, the fifth in our series, I want to illustrate an example...

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Read the latest Blogs

Forums

Backup taking too much time

By VastSQL

Hi Experts, One of my Large database having about 4TB in size is taking...

Keeping QUERIES for Using Again and Adding DB to Git/Github and VS Code

By Ahr Aitch

While I know that it will speed my learning to type queries as I...

Found a Tool Very Helpful for Beginner

By Ahr Aitch

I struggled with remembering the conventions I'd chosen when creating column names and data...

Visit the forum

Question of the Day

Partial Backups I

What is a partial backup for a read-only database?

See possible answers