[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools
Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand...
2014-09-17
1,135 reads
TheSqlPro.com - Ayman El-Ghazali
Dear IT Guy, Customer Service is part of your job
It may be true that you are one of a kind, a true techie with specialized skills that are hard...
2014-09-04
567 reads
Dear IT Guy, Why do you hesitate to attend my meetings?
I was attending Microsoft’s on-boarding training last week and one of the managers there mentioned that a lot of IT...
2014-08-28
881 reads
The Good the Bad and the Ugly of my extended job search
Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my...
2014-08-25
394 reads
SQL Saturday 294 Philadelphia Lessons Learned
Being in Philadelphia this past weekend was fantastic! I got to meet a lot of old friends, spend time with...
2014-06-09
616 reads
SQL Saturday 294 Philadelphia, Nostalgic!
Less than a week left and I’m extremely excited about SQL Saturday in Philly on June 7th, 2014 and the...
2014-06-02
656 reads
[SQL Snacks Video] SQL Server Table Partitioning 103
Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two...
2014-04-28
943 reads
SQL Server Internals Presentation Double Time!
I’ll be doing double time over the next two weeks with Two Presentations on SQL Server Internals. It is essentially...
2014-04-22
671 reads
[SQL Snacks Video] SQL Server Table Partitioning 102
Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first...
2014-04-15
633 reads
[SQL Snacks Video] SQL Server Table Partitioning 101
I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare...
2014-04-08
649 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