31 Days of SSIS – Instant Excel Spreadsheet (14/31)
31 Days of SSIS
It’s day fourteen of the 31 Days of SSIS blog series. It’s also Friday, so I’m taking...
2011-01-14
624 reads
Last Call for Speakers 24 Hours of PASS
Calling for Presenters!Today is the day! If you were planning to submit a session for the next 24 Hours of...
2011-01-14
796 reads
Denver SQL Server User’s Group Meeting on January 20, 2011
My good friend, Kevin Cox, of Microsoft’s SQLCAT (SQL Customer Advisory Team) will be giving a presentation on what is...
2011-01-14
571 reads
Removing Time From A Datetime Value
How much time would a DateTime have if a DateTime had no time?
Ok, forgive the bad pun. But the point...
2011-01-14
904 reads
Introducing MagicPASS - Orlando's New PASS Chapter
After a year of planning I'm proud to announce that South Orlando has a new PASS chapter: MagicPASS! Our first...
2011-01-13
1,011 reads
SQL University: Spring 2011
The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...
2011-01-13
857 reads
31 Days of SSIS – Create XML Document (13/31)
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-13
1,971 reads
SQL People Events - TED for SQL Server
When I first saw Andy Leonard's post about a new SQL People event, I was intrigued. It's not a training...
2011-01-13
2,510 reads
Silly Billiseconds
You have to admire Microsoft for sticking to their guns, even when being palpably stupid. I refer, of course to...
2011-01-13
3,387 reads
January ’11 Meeting Reminder
If you saw my blog post the other day, you know that S3OLV has a meeting this Thursday (Jan 13, 2010) at 6:30 PM PST. If not, then you...
2011-01-13
21 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
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
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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