FrankDolan77

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

SQLServerCentral Article

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,687 reads

SQLServerCentral Article

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

3,057 reads

SQLServerCentral Article

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,355 reads

Blogs

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Group By Starting Characters

By

I was chatting with Jeff (b|t) on my team yesterday and the context escapes...

Daily Coping 22 Oct 2021

By

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

Read the latest Blogs

Forums

Maybe It Is DNS

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Maybe It Is DNS

Finding all logins that can alter DDL

By webrunner

Hello experts, Is there a ready-made query out there that I could run on...

Insert records with a where

By saintor1

I want to insert record job allocations only for selected jobs I know the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers