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

20,861 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,955 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,151 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,568 reads

Blogs

Automatically Take Missed Backups with Ola Hallengren’s Scripts

By

I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...

SQL Server 2022 is GA!

By

The big announcement at the PASS Data Community Summit 2022 was that SQL Server...

Tell My Story of Public Speaking

By

This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...

Read the latest Blogs

Forums

Backup progress

By ramana3327

We have started the full backup job that uses Veritas netbackup. The server has...

Join query with many tables

By pedroccamara

Hi guys, I hope everyone's ok I have a query in MySql (I'm using...

Mass update on Clustered Columnstore indexes

By SqlRon

Hi, we have a FACT table with 35 billion rows, partitioned on daily level....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers