FrankDolan77

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

SQLServerCentral Article

T-SQL Language Changes in SQL Server 2022

SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes in the database platform, […]

4.92 (12)

2022-08-31

23,674 reads

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,977 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

4,337 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,598 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Coding Magic Values

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Coding Magic Values

How to Check previous data loaded records vs current day in a table

By Zond Sita

Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...

Permissions Changes Not Doing Anything

By EsquireDeveloper

Hi friends, So I have a Login to a server that is a windows...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers