Why Is The Server Slow?
This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...
2016-02-24 (first published: 2016-02-22)
2,856 reads
The Scary DBA
Azure SQL Database Error
I was on SQL Cruise where I was scheduled to present a session on Azure SQL Database. I recorded all...
2016-02-18
457 reads
Loading Data into Azure SQL Data Warehouse
Ouch.
Let’s start with the level set. I’m not an ETL expert. In fact, I haven’t done any professional ETL work...
2016-02-15
1,549 reads
Speaker of the Month: February 2016
I’ve been a little remiss on this. I just haven’t been getting out to see people speak for a while...
2016-02-12
464 reads
Positivity
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
563 reads
Learning R: Happy With My Book Choice
This is just a quick update. I wrote about the two books I’m using to learn R. Well, I’m extremely...
2016-02-01
509 reads
PASS Board 2016: Update #1
Hello everyone. Just because I’ve moved on to the executive committee doesn’t mean I’m walking away from these reports. I...
2016-01-29
905 reads
The Importance of a Full Backup in SQL Server
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
511 reads
Finding Your Query in Query Store
Query Store is pretty amazing. I’m loving working with it. I think it’s likely to change how query tuning will...
2016-02-01 (first published: 2016-01-25)
2,377 reads
Removing All SQL Server Query Store Data
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
545 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