Using @@ROWCOUNT can be a bit tricky
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
738 reads
SQLStudies
What SQL Server components are installed on this machine?
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
635 reads
Finding the worst running query in a stored procedure
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,893 reads
Where you should start when managing an enterprise
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us...
2015-09-11 (first published: 2015-09-08)
1,867 reads
Learning Regular Expressions
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term...
2015-09-02
972 reads
The default instance has a name
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...
2015-09-07 (first published: 2015-08-31)
3,287 reads
The 30 minute rule
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule....
2015-08-26
683 reads
The tail of the log
The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...
2015-08-24
658 reads
SSMS’s Clipboard Manager
The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask...
2015-08-28 (first published: 2015-08-19)
2,826 reads
Pulling data from the error log
The other day I was asked to pull a list of errors from the SQL Server log into a table...
2015-08-25 (first published: 2015-08-17)
3,487 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