Busy is as Busy Does
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
566 reads
Watch out, Visual Studio 2010 does not support BI
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up...
2011-05-20
1,036 reads
SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)
I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL...
2011-05-20
1,134 reads
Re-blog – May 13-19
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-05-20
445 reads
Microsoft SQL Server 2008 R2 SP1
AdvertisementsMicrosoft SQL Server 2008 R2 SP1 CTP
SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409
2011-05-20
1,069 reads
Quickly Find Your DDL Triggers with PowerShell
As a consultant I spend much of the first day or two at a client site discovering everything I can...
2011-05-20
1,334 reads
Replicating XML Columns
One caveat that’s worth mentioning is replicating the XML data type in
SQL Server using Merge Replication. Sometimes, when replicating...
2011-05-20
1,432 reads
Presentation Deck For Hardware 201 at Denver SQL Server User’s Group on May 19, 2011
I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance...
2011-05-20
794 reads
IT and Innovation
This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a...
2011-05-19
750 reads
MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it last year with the exception that I at least...
2011-05-19
14 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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