Two Profiler Tips
I’ve had occasion to watch a lot of people try Profiler, and to hear a lot more about their previous...
2011-01-27
581 reads
Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
19,198 reads
My Most Popular Posts From 2010
I was recently looking through my blogging statistics and discovered that I can see the most viewed posts during that...
2011-01-27
739 reads
31 Days of SSIS – Small Package, Big Win (26/31)
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
917 reads
SSAS Dimension Attribute Discretization Methods
Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is...
2011-01-27
3,827 reads
A Half-Price Seat at the Masters’ Table
Well, it looks like I half-won the SQLskills competition for a free seat at a SQLskills Master Immersion Event on...
2011-01-27
532 reads
A SQL Azure Customer
Not me, though I’m not necessarily against Azure in principle. I had a friend ask me for a SQL Server...
2011-01-26
745 reads
SQLSaturday 57 In Houston, Here I Come!
Another year and staring it off right! I’ll be speaking at SQLSaturday in Houston, TX on the fundamentals of storage...
2011-01-26
950 reads
User Group Giveaway: My Latest Book
As I annouced earlier, Oracle and database expert, Bert Scalzo and I collaborated on an introductory text appropriately titled Introduction to SQL...
2011-01-26
711 reads
Shameless Plug: My First SSC Article Published Today
Please forgive the shameless plug. My first article was published today on sqlservercentral.com. It’s titled “Backup and Housekeeping with Maintenance...
2011-01-26
561 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