You Deserve to be an MVP
I have been sitting on this article for a while now. I have been tossing around some
thoughts and finally...
2016-07-25
565 reads
SQL RNNR
You Deserve to be an MVP
When you feel you deserve to be an MVP, are you prepared to do more work? Being an MVP is not just an award - it is a commitment...
2016-07-25
9 reads
Another Query to Help Find the Right Event
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many...
2016-07-26 (first published: 2016-07-21)
1,610 reads
Another Query to Help Find the Right Event
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with...
2016-07-21
10 reads
Extended Event Help Queries
Enjoy this article re-publication from my original work at SQL Solutions Group.
When working with Extended Events, there are times when...
2016-07-19
675 reads
Extended Event Help Queries
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor...
2016-07-19
13 reads
SQL Server CTE – Back to Basics
Quick Flashback
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-07-25 (first published: 2016-07-14)
3,350 reads
SQL Server CTE – Back to Basics
Of all the fundamental concepts within SQL Server, this one drives me a bit batty from time to time. Think about that statement for just a moment.
Related Posts:
T-SQL Tuesday...
2016-07-14
20 reads
SQL Server Desired Enhancements
Happy Belated Birthday
The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month...
2016-07-13
526 reads
SQL Server Desired Enhancements
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features...
2016-07-13
9 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
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
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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