SQL Saturday New England: The New Date
The real world can get in the way of important things like SQL Saturday. In the case of SQL Saturday...
2010-10-12
574 reads
A Trio of Table Variables
So, it’s the second Tuesday of the month again, and it’s time for T-SQL Tuesday again. This month it’s hosted...
2010-10-12
1,286 reads
SQL Server Recovery Models
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you...
2010-10-12
1,978 reads
Speaking at South Florida SQL Server User Group
I will be speaking at the South Florida SQL Server User Group on October 13 via Live Meeting. My topic...
2010-10-12
448 reads
SQLSaturday#59 - Interview with Robert Pearl (1st in series)
SQLSaturday#59 - Interview with Robert Pearl (1st in series) - Say what?
As we get the countdown under way, I caught up...
2010-10-12
1,230 reads
Google Wind
I’m not sure Google is a better company than Microsoft or some of the other extremely large companies that get...
2010-10-12
824 reads
Press Release: SQLSaturday#59 Speaker Session Schedule Announced...
Source Event Home Page: http://www.sqlsaturday.com/59/eventhome.aspx
Written & Distributed by: Robert Pearl
You may have heard that we’re planning an event in NYC, called...
2010-10-12
951 reads
Review: NPR Baseball Driveway Moments
NPR Baseball Driveway Moments ($15 @ Amazon) is an audio book I got from the local library to listen to on...
2010-10-12
393 reads
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a...
2010-10-12
12 reads
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-12
1,438 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