T-SQL Language Changes in SQL Server 2022 Part 2
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
3,817 reads
FrankDolan77
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, […]
2022-08-31
18,376 reads
Powershell Day by Day: Adding Help to Scripts
This next article in the PowerShell Day by Day Series will cover adding help to your scripts.
2021-09-29
4,893 reads
Powershell Day by Day: Customizing Scripts with Parameters
Learn how you can add parameters to your PowerShell scripts to make them more flexible and useful.
2021-07-21
5,076 reads
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 […]
2020-12-31
3,933 reads
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, […]
2020-11-30
3,976 reads
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 […]
2020-10-08
2,545 reads
Calling Procs from PowerShell with Parameters
Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.
2020-08-20
11,662 reads
The Basics of PowerShell Day By Day
A basic introduction to PowerShell for those DBAs familiar with T-SQL.
2020-08-13
6,207 reads
Calling a Stored Procedure from PowerShell
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
11,071 reads
Blogs
Daily Coping 30 Sep 2022
By Steve Jones
Today’s coping tip is to find a new way to use one of your...
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP....
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
Forums
Save Query Results to Excel and Automatically run it
Hello, I have a very simple query Select * from Employees where company...
TCP Provider: A connection attempt failed for target server
Hi. In source SQL Instance target linked server has been created and connection tested...
Get Part number and display in Header
Hello, so I have a part number, and I want to display it in...
Ask SSC