2021-02-20
33 reads
Followup for the Kansas City SQL Server User Group
I had a great time speaking at the Kansas City SQL Server User Group on Thursday, February 18th. The more I present my Backup Basics with PowerShell and dbatools...
2021-02-20
16 reads
Daily Coping 19 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-19
29 reads
Daily Coping 18 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-18
37 reads
Azure SQL Database F and M series
Taking a screen shot from my Azure Portal, you will see the available hardware configurations available for Azure SQL Database. I wrote about Generation 4 and 5 in the...
2021-02-18
64 reads
Azure Data Factory Activity Failures and Pipeline Outcomes
Question: When an activity in a Data Factory pipeline fails, does the entire pipeline fail?Answer: It depends In Azure Data Factory, a pipeline is a logical grouping of activities...
2021-02-25 (first published: 2021-02-18)
736 reads
2020 Advent of Code–Day 2
This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 2. Part 1 This problem is...
2021-02-17
37 reads
Announcing the Azure Data Community from Microsoft
You can see an announcement from Buck Woody (b | t) of Microsoft on Data Exposed. Essentially, Microsoft is providing a number of free resources to help local user...
2021-02-24 (first published: 2021-02-17)
525 reads
How does the buffer pool handle low memory conditions?
(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you...
2021-04-20 (first published: 2021-02-17)
563 reads
Daily Coping 17 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-17
36 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