My advanced SQL Server Performance Troubleshooting workshop goes to the international level!
I’m working my whole professional work life (around 11 years) with SQL Server, and
have see so many pitfalls in configuration...
2011-05-24
1,634 reads
I’m working my whole professional work life (around 11 years) with SQL Server, and
have see so many pitfalls in configuration...
2011-05-24
1,634 reads
Prayer Cat Prays
Well not THE Bible, but rather the SQL Server Bible! I’m incredibly excited and proud to say I’ll...
2011-05-24
572 reads
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,455 reads
Where do you see yourself in the future? Are you working at the same company, are you working in a...
2011-05-24
1,106 reads
I went to run this query recently:
select TOP 10 *
from users a
inner join Banned b
on a.username = b.usernameand...
2011-05-23
4,701 reads
If you’re already a MidnightDBA Groupie, then you’ve probably already heard about my fabulous inspiration: a new SQL community podcast! Now...
2011-05-23
1,636 reads
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I already posted some CTE examples and was bone dry...
2011-05-23
28 reads
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I...
2011-05-23
1,484 reads
A few weeks back I was on a short trip with my family and as some trips go, it had...
2011-05-23
679 reads
Paul Turley
Mentor, SolidQ
This article is based on my session at TechEd on May 18th, 2011
Report styles vary depending on the...
2011-05-23
3,621 reads
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
By James Serra
(This is the second post in a three-part series on how AI is changing...
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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