SQL In The City: Seattle
If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...
2012-10-17
1,151 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
3,009 reads
RML Utilities and SQL Server 2012
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,484 reads
Interviewing a DBA
I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...
2012-09-26 (first published: 2012-09-24)
3,358 reads
PASS Elections 2012
Yeah, it’s that time again. And we have a magnificent slate of people running. I mean truly amazing and wonderful...
2012-09-21
716 reads
Conference in Florida: SQL Server Live
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
988 reads
SSC Clinic: Finding the rogue query
When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.
2012-09-13
6,276 reads
SQL Server vs. Oracle
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,026 reads
Please, Call Me Richard
I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good....
2012-08-28
1,289 reads
These People Are Exceptional
I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had...
2012-08-28
1,014 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
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...
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