2007-08-07
1,693 reads
Administration
2007-08-06
1,707 reads
Server Farm Reporting - Part 2
Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.
2007-08-06
2,829 reads
Using Non-Standard Port for SQL Server
Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.
2007-08-03
3,002 reads
2007-08-02
1,712 reads
2007-08-01
1,674 reads
Get And Set SQL Server 2005 Instance Registry Values
Most SQL Server DBAs will never need to read the registry for their instances, however in case you do find yourself needing to read or write something in SQL Server 2005, Vince Iacoboni brings us a technique for performing both of these actions.
2007-07-31
8,924 reads
2007-07-25
2,052 reads
2007-07-17
1,792 reads
2007-07-16
1,504 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