Long names vs short names (or aliases)
I remember when I was first learning to code there was always the argument of how long a name should ... Continue reading
2021-06-30 (first published: 2021-06-15)
1,156 reads
Kenneth Fisher
Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz ... Continue reading
2021-06-22
144 reads
CROSS vs OUTER APPLY
I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER ... Continue reading
2021-06-21 (first published: 2021-06-10)
1,427 reads
My journey with hybrid technologies. Where it started, how it’s going, and where it ends. : T-SQL Tuesday #139
One of my favorite people is hosting TSQL Tuesday this month. Ben Weissman (blog|twitter). He wants us to talk about ... Continue reading
2021-06-18 (first published: 2021-06-08)
294 reads
#PowershellBasics: Finding a common AD group for a set of users.
A while back (almost 7 years ??) I wrote a post on finding the common AD groups of a set ... Continue reading
2021-06-17
134 reads
SQL Homework – June 2021 – SQL Audits
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading
2021-06-14 (first published: 2021-06-01)
306 reads
The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.
I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading
2021-06-11 (first published: 2021-05-27)
227 reads
#PowershellBasics: Writing to the screen
Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is ... Continue reading
2021-06-04 (first published: 2021-05-20)
642 reads
Use BCP to create a CSV (comma delimited) file from a table.
This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one ... Continue reading
2021-06-03
239 reads
Creating a configurable SSMS script
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from ... Continue reading
2021-05-28 (first published: 2021-05-18)
798 reads
Blogs
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
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...
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