#SqlBits and SSIS custom components
If you are in anyway interested in SQL Server and live in the UK, you cant of failed to of...
2011-04-11
722 reads
If you are in anyway interested in SQL Server and live in the UK, you cant of failed to of...
2011-04-11
722 reads
If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you.
Every day in March...
2011-03-12
551 reads
I am not a lawyer. Let me say that again, I am not a lawyer.
Todays Dilbert has prompted me...
2011-02-24
811 reads
In my previous post “Denali Paging – is it win.win ?” I demonstrated the use of using the Paging functionality within Denali. ...
2010-11-19
699 reads
I'm not one for automatically poo-pooing new ideas, new practices and new technology. Rather I like to take a measured...
2010-11-10
808 reads
Greg Gonzalez (blog | twitter) of SqlSentry, last night released a very cool new and free product. Plan explorer is a...
2010-10-21
2,956 reads
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
565 reads
I am now in the process of arranging the 2nd meeting of the kent sqlserver user group. This will be...
2010-08-27
440 reads
Well , that was an experience.
It was my first time arranging anything like that and it seemed to me that...
2010-08-19
692 reads
NullIf can be a very handy function sometimes. For those who have not used it, if the result of the...
2010-08-06
687 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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