The Unconventional Guide to How to Implement Lookup Transformations TIP #124
This is one the articles in the series of step by step SSIS tutorial. In this post, we are going...
2015-12-20
851 reads
Advent of Code Contest
I saw the post from Steve Jones about the Advent of Code contest and decided to take a look. The first...
2015-12-18
670 reads
Monday Morning SQL Break – December 28, 2015
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-18
322 reads
A Few Days Off in Space Country
The new Star Wars film opens today, and while I won’t see it then, perhaps I’ll get to it early...
2015-12-18
634 reads
Speaker of the Month: December 2015
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
460 reads
How to do Step by Step Merge Join Transformations - #123
In last post tip #122, We discussed Merge transformation. Now in this tip, we are going to discuss Merge Join....
2015-12-31 (first published: 2015-12-18)
2,573 reads
New Whitepaper – SQL Server Licensing Reduction
Poor storage performance continues to be the largest pain point with enterprise Database Administrators in today’s virtual world. However, it...
2015-12-17
1,090 reads
What Permissions Does This Login Have?
I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer. Grant the login the same permissions...
2015-12-17
2,196 reads
Could not Register Service Principal Name
Have you ever seen the error below in your SQL Server log shortly after startup? You’ll actually see two of...
2015-12-29 (first published: 2015-12-17)
1,580 reads
SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.
Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we...
2015-12-17
49 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
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