Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,229 reads
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,229 reads
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,707 reads
DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of database software, such as Microsoft SQL Server. They are concerned with gathering, storing and presenting data to data consumers, which includes virtually anyone in the modern world.
2011-12-08
1,076 reads
In keeping with the past, I’m going to go ahead and post my evals for the two sessions I did...
2011-12-06
1,587 reads
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked...
2011-12-05
1,607 reads
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,334 reads
Very short informational post.
If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server...
2011-11-21
2,023 reads
I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the...
2011-11-18
1,486 reads
As part of my commitment to read and review 12 books in an effort to be active in my own...
2011-11-07
1,778 reads
Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me?
Wow…
Geez Tom, couldn’t you ask a hard question for...
2011-11-07
1,802 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