Running Powershell scripts remotely.
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of...
2015-04-29
1,599 reads
SQLStudies
What SQL version is my SSIS package?
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how...
2015-04-27
1,102 reads
Backup before you restore
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
A while back...
2015-04-22
498 reads
The hidden security of msdb
To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...
2015-04-20
1,502 reads
Adding, altering or removing multiple columns from a table
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing...
2015-04-16
954 reads
Remotely shutting down an instance
This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t)...
2015-04-23 (first published: 2015-04-14)
5,325 reads
Make sure you back up the Service Master Key
I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master...
2015-04-08
817 reads
What is a CTE
CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade....
2015-04-06
695 reads
Microsoft buys the dictionary
It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as...
2015-04-01
485 reads
Port numbers and SQL Server
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...
2015-04-03 (first published: 2015-03-30)
8,882 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers