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 […]
2026-01-07 (first published: 2020-12-31)
6,222 reads
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection dialog. This post looks at this feature and how […]
2024-07-31
6,915 reads
This article shows how to import and export a list of registered servers from SSMS.
2024-04-29
5,892 reads
Learn about more of the T-SQL language changes in SQL Server 2022. This article is the third in a series and will cover the changes to the JSON functions.
2022-12-30
13,062 reads
Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.
2022-12-23 (first published: 2020-08-20)
29,596 reads
Learn about more of the T-SQL language changes in SQL Server 2022 to LTRIM, RTRIM, TRIM, GET_BIT, SET_BIT, LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT and more.
2022-09-30
16,422 reads
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, […]
2022-08-31
27,828 reads
This next article in the PowerShell Day by Day Series will cover adding help to your scripts.
2021-09-29
7,612 reads
Learn how you can add parameters to your PowerShell scripts to make them more flexible and useful.
2021-07-21
12,474 reads
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
8,378 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers