SQLMCM Training – Day 10
Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover
Clustering – all in all a very intensive day...
2011-08-18
624 reads
Blog Posts
Adding an Index to Save Space
Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that...
2011-08-17
1,054 reads
Afterthoughts: SQL Saturday #79 South Florida 2011
This past Saturday August 13th I presented two sessions at SQL Saturday #79 hosted by the South Florida SQL Server...
2011-08-17
1,237 reads
Another New Contributor–Christian Dadswell
This is just a short post to introduce you all to my good friend Christian Dadswell who has kindly agreed...
2011-08-17
867 reads
Applied SQL: sys.objects
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-17
1,387 reads
Applied SQL: You Have Homework
I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything. What do...
2011-08-17
590 reads
Microsoft SharePoint Online
Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365. For those of us...
2011-08-17
939 reads
PASSMN Presentation – The Creepy DBA
Last night I spoke at the PASSMN August user group meeting. The topic was The Creepy DBA and how you...
2011-08-17
673 reads
RAID server configuration and disk amounts
Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge.
Typical questions from...
2011-08-17
1,110 reads
SQL MCM Training – Day 9
Today Jonathan was talking the whole day about Consolidation and Virtualization. There
were again a lot of new concepts, and new...
2011-08-17
966 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