Use -eq in Powershell
I was writing a quick script to work with files and I only wanted to process one file for each...
2014-11-27 (first published: 2014-11-17)
6,049 reads
Quickly Add Telnet
Have you found yourself on a server or workstation that doesn't have telnet (typical in new builds and new Azure...
2014-11-17
1,334 reads
Last Weeks Top “Reading” Links #109
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-17
689 reads
Exam Prep 70-463: Tables and Schemas
Well, the PASS Summit has come and gone and it was *awesome*. What a difference from my first Summit experience,...
2014-11-25 (first published: 2014-11-17)
8,790 reads
Using T-SQL to populate a Central Management Server
We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the...
2014-11-24 (first published: 2014-11-17)
7,007 reads
SQL Server Management Studio Reports
SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within...
2014-11-21 (first published: 2014-11-17)
7,626 reads
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint? Ans : 5022 2) Database Mirroring comes with which edition? Ans: SQL Server 2005 SP1. Or SQL Server 2005 RTM...
2014-11-17
15 reads
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1....
2014-11-17
20,539 reads
PASS Summit 2014 Recap
Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for...
2014-11-16
319 reads
T-SQL Tuesday #60 Roundup – Step Right Up
We had a great turnout for this months T-SQL Tuesday Block Party. Coming into this month and knowing that I...
2014-11-16
630 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