SQL Azure Databases - Active Secondary - How to connect? - Part 2
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to...
2017-05-27
637 reads
SQL and SQL Only
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
59 reads
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
13 reads
Find the number of rows for a value, without querying the table
Dear all,
Being a DBA, developers approach me with questions like can you run this query for me in production?
Select*FROM[dbo].[FactInternetSales]
WHERE UnitPrice...
2017-05-24 (first published: 2017-05-11)
2,458 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft cloud platform service, offering lots of services for...
2017-05-07
75 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft cloud platform service, offering lots of services for...
2017-05-07
14 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,
I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft...
2017-05-22 (first published: 2017-05-07)
1,265 reads
Data Channel Interview - 07 - Steve Knutson on Managing Sharepoint Databases
7th Interview of #DataChannel is out 🙂 Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge on "Managing SharePoint Databases" on #DataChannel. Steve, demystifies...
2017-05-05
20 reads
Data Channel Interview - 07 - Steve Knutson on Managing Sharepoint Databases
7th Interview of #DataChannel is out 🙂 Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge on "Managing SharePoint Databases" on #DataChannel. Steve, demystifies...
2017-05-05
20 reads
Data Channel Interview - 07 - Steve Knutson on Managing Sharepoint Databases
7th Interview of #DataChannel is out 🙂
Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge...
2017-05-04
425 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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