Database default locations
One of the options you had when installing your instance was setting some default file locations.
Defaut data file locationDefault log...
2014-10-01 (first published: 2014-09-29)
8,143 reads
Blog Posts
Error while enabling NetFx3 feature || Alternate source path error
Hello Friends,
Life Is a struggle with Lot of If and buts. It’s being a many month I was out of...
2014-10-01
1,301 reads
I’m a SQL Server MVP!
I was just awarded as a Microsoft SQL Server MVP!
I can’t believe Microsoft has chosen me for this award and...
2014-10-01
510 reads
I’ve joined the SQL SERVER MVP community – Thank you!
TweetG’Day,
Today I awoke to find an email from Microsoft informing me that I’d been awarded an MVP. Wow.
I had to...
2014-10-01
1,113 reads
Intro to Auditing in SQL Server on SQL Shack
I had an article published yesterday on http://www.SQLShack.com.
Intro to Auditing in SQL Server.
It’s worth reading if I do say...
2014-10-01
1,231 reads
Notes On Our First Student to IT Pro Seminar
This past week we did our first try at the Student to IT Pro Seminar, run concurrently with SQLSaturday Orlando....
2014-10-01 (first published: 2014-09-29)
6,826 reads
Optimizing Power BI Q&A with Synonyms and Phrasing using Cloud Modeling
If you’ve have used or even just seen a demo of Power BI Q&A you’ve likely seen there’s great potential...
2014-10-01
880 reads
Renewed as MVP for 2015
Took a break to check email and saw the confirmation that I was renewed for another year. Pleasant news for...
2014-10-01
596 reads
SQL Server 2008 SP4 Released
On September 30th 2014 Microsoft released service pack 4 for SQL Server 2008. This service pack contains all cumulative updates...
2014-10-01
1,398 reads
A Bad Day with Backups
I learned a hard lesson when I first started as a DBA. Although to be honest, it’s not a lesson...
2014-09-30 (first published: 2014-09-25)
7,259 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