SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all...
2010-12-28
66 reads
Jason Brimhall
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give...
2010-12-20
836 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give a little follow-up on how my foray into Powershell...
2010-12-20
13 reads
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification...
2010-12-16
888 reads
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification more accessible to the masses. You can read more...
2010-12-16
13 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not...
2010-12-15
549 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not end with the birth of our baby girl two...
2010-12-15
20 reads
T-SQL Tuesday #13 – Business Requirements
Business Requirements
We have made it yet another month and to yet another episode in the continuing saga known as TSQL...
2010-12-14
664 reads
T-SQL Tuesday #13 – Business Requirements
I think a common area that is easily overlooked when it comes to requirements and interpretation of requirements is report creation. A common problem is that there are no...
2010-12-14
12 reads
SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago...
2010-12-13
518 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
Alamat Telp BCA KCP Poris Indah (+62) 838-4945-0961
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
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