How to remove additional (unwanted) log files
Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a...
2014-11-05
1,356 reads
Kenneth Fisher
Force only certain values to be unique
I thought of something rather interesting the other day while answering a question asking for help with some table structures....
2014-11-03 (first published: 2014-10-22)
6,585 reads
My DTS Package won’t load with the error “here were errors loading package”
You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
Error...
2014-11-03
793 reads
Playing with the log – Before the first full backup
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the...
2014-10-29
1,827 reads
Update to “The clustered index columns are in all of the non clustered indexes.”
I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments...
2014-10-29 (first published: 2014-10-20)
6,083 reads
A script to list the DTS connection information for every package on the instance.
For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...
2014-10-27
679 reads
UNION vs UNION ALL
You might be wondering why I’m going into such a simple subject. Well the way I see it there are...
2014-10-16
2,772 reads
TSQL Tuesday #59: My Hero, My Inspiration, My Wife
TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t)...
2014-10-14
1,171 reads
You can’t use aggregate/windowing functions with CROSS APPLY
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well...
2014-10-13 (first published: 2014-10-06)
9,202 reads
Required reading before upgrading SQL Server.
I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q...
2014-10-08
1,306 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