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,506 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
963 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,952 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers