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
2,938 reads
This article shows how to import and export a list of registered servers from SSMS.
2024-04-29
2,987 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
12,519 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)
26,367 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
15,702 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
26,690 reads
This next article in the PowerShell Day by Day Series will cover adding help to your scripts.
2021-09-29
6,490 reads
Learn how you can add parameters to your PowerShell scripts to make them more flexible and useful.
2021-07-21
6,644 reads
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
4,120 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
6,789 reads
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
Code that can be used in order to create dashboard or SSRS report on...
So, I have an interesting situation that I need a double-check on. One of...
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers