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,607 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,119 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
508 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,555 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,719 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,340 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
835 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
711 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
500 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)
10,198 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Alamat Telp BCA KCP Sulawesi (+62) 838-4945-0961
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers