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, […]
2020-11-30
1,511 reads
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 […]
2020-10-08
1,931 reads
Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.
2020-08-20
3,317 reads
A basic introduction to PowerShell for those DBAs familiar with T-SQL.
2020-08-13
5,339 reads
This article will explain how to use PowerShell to call a stored procedure and export results to the screen or a file.
2020-08-04
5,562 reads
I have held various certifications through my DBA career, from CompTIA A+ certification back...
I first starting presenting on mental health last December in Charlotte, NC on mental...
I first starting presenting on mental health last December in Charlotte, NC on mental...
I'm currently looking to design some auditing on my SQL application and am wondering...
Hi, How can I set the value of a variable from a Lookup activity...
Ahoi, im trying to deal with a user request to combine 2 values of...
Ask SSC