Failed to Create the Audit File
One day while checking things for clients, I happened across a fun little error message - "SQL Server Audit failed to create the audit file". It just so happens...
2017-12-31
70 reads
Jason Brimhall
An Introduction to Templates
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can...
2017-12-30
14 reads
An Introduction to Templates
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to...
2017-12-30
711 reads
An Introduction to Templates
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to...
2017-12-30
361 reads
Audit Domain Group and User Permissions
No matter how simple the task or how versed we are with doing a security audit, it seems like we...
2017-12-29
356 reads
Audit Domain Group and User Permissions
No matter how simple the task or how versed we are with doing a security audit, it seems like we...
2017-12-29
1,005 reads
Audit Domain Group and User Permissions
No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit...
2017-12-29
10 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful...
2017-12-28
12 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
558 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
243 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