FrankDolan77

I have been working with SQL Server for nearly 10 years as a database developer.

PowerShell Day By Day: The Pipeline

In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]

5 (5)

2020-12-31

3,483 reads

Creating SQL Agent Jobs to Run PowerShell

In one of my articles, Calling Procs from PowerShell with Parameters, there was a question in the discussion about calling PowerShell (PoSh) from SQL Agent Jobs. I haven't done much of that, as most of my PowerShell is interactive scripts to make work easier when managing lots of servers. However, it was an interesting challenge, […]

4 (1)

2020-11-30

2,739 reads

PowerShell Day by Day: Filtering Objects

In my last article, The Basics of PowerShell Day By Day, I covered some basics of getting started. These articles aren't intended to replace some of the getting started information in things like the Stairway to PowerShell. Instead, I am covering some of the tips, tricks, techniques, and bits of knowledge that I wish I'd […]

5 (6)

2020-10-08

2,197 reads

Blogs

Cleaning Up Stats Data for Volleyball

By

One of the things I’ve done the last few years is collect statistics as...

Day One, the Journaling App, Joins Automattic

By

We’re excited to welcome Day One to the Automattic team. Day One is a...

Find Queries Using a Key Lookup Operator

By

While teaching about Extended Events and Execution Plans last week, Jason, one of the...

Read the latest Blogs

Forums

Tracking, Privacy, and Lots of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking, Privacy, and Lots of...

Database File Growth

By lkennedy76

I have a question for the seasoned DBA's on here. I have come across...

Help query to select part of string

By imranazam

Hi Guys Hope everyone is well, i have a field called NAME with some...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers