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,602 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,112 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
504 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,541 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
1,509 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,335 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
826 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
705 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
495 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)
9,787 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers