Slides & samples from my SQLdays 2010 sessions and workshop
As announced in my workshop and in my sessions at the SQLdays 2010 last week in Rosenheim/Germany,
you can download my...
2010-10-25
479 reads
Who You Learn From
Less than two weeks to go until the PASS Summit. I’m excited. I’ve managed to cram a ton of activities...
2010-10-25
682 reads
Bloggers, Quit Worrying About Spam
I don’t comment as often as I should on blog posts. I say should because as a blogger I know...
2010-10-25
618 reads
Return of Index Analysis Part 5
Let’s Anaylze An Index!Alright, up to the last of the changes I’ve made to the index analysis query that I...
2010-10-25
1,547 reads
SQLSaturday #59 Interview Speaker Series #10 - with Thomas LaRock
SQLSaturday #59 Interview Speaker Series #10 - with Thomas LaRock
Today, Monday, we pick up on our speaker interview series, with my...
2010-10-25
739 reads
T-SQL Tuesday Topics
I was asked to host a T-SQL Tuesday, and I accepted.
Once again, my fingers move a bit faster than...
2010-10-25
737 reads
Vote for Me for a PASS SQLRally Precon on SQL Server Security
Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...
2010-10-25
2,068 reads
SQLBIGeek's Function Friday - Return First Day of Quarter
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the first of my “SQLBIGeek’s Function Friday” blog series. I understand that I am posting...
2010-10-24
1,429 reads
Troubleshooting Connectivity with UDL files
I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and this was the first package being placed into production...
2010-10-24
33 reads
Troubleshooting Connectivity with UDL files
I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and...
2010-10-24
12,251 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