ALTER TABLE - Adding Column - Column Order Impact
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
997 reads
Who Am I
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
701 reads
Five Lines of Code
An interesting story on how a database speeds up by changing some application code. Worth the read for sure.
I caught...
2011-06-24
789 reads
Full Time Employees Per Number of Database Users? FTE/DB users? How Many Servers are too much to Handle?
After several days research, I have been trying to get a rough estimate on how many Full Time Employees are...
2011-06-24
3,257 reads
Configuration Manager for Sqldiag
SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor...
2011-06-24
1,128 reads
Growing Leaders
Here’s a two part story(Part 1, Part 2 from Information Week by Larry Tieman you should read. There’s a great...
2011-06-24
902 reads
SSRS 2005 Data Driven Subscription and Temporary table
Few days back I was setting up data driven subscription for a SSRS 2005 report. The command / query which populates...
2011-06-24
1,520 reads
Re-blog – June 17-June 23
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-24
569 reads
Good stuff for the DBA from SQL Server Magazine...
I literally changed the topic of my blog today, (as I had my blogger open), since I had read some pretty...
2011-06-24
1,155 reads
Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
6,143 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