SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure...
2011-06-28
569 reads
Attention Speakers–Sign Up for SQLSaturday #85 in Orlando!
Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into...
2011-06-28
621 reads
Let’s Get Registered! Registered!
The PASS Summit is only a few short months away. But before that happens there is an important deadline fast...
2011-06-28
684 reads
HASHBYTES – A T-SQL Function
Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.....
2011-06-28
15,136 reads
Instead Of Trigger and OUTPUT clause headache
It is known that you cannot get inserted identity values using OUTPUT clause when inserting to view which has instead...
2011-06-28
1,868 reads
Which database is using all my CPU
We all know how easy it is to see how much CPU power is consumed by the SQL Server process,...
2011-06-28
1,684 reads
My Favourite SQL Server Myths and Realities
It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management...
2011-06-28
3,825 reads
Counting Licenses for VMs
This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought...
2011-06-28
3,162 reads
Why Two Devices
I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and...
2011-06-27
929 reads
MCITP: 3 Down 1 To Go
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in SQL 2008, other things came up that have slowed...
2011-06-27
9 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