Finding active DTS packages
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS...
2013-12-09 (first published: 2013-11-27)
3,193 reads
Kenneth Fisher
Undocumented functionality in FORMATMESSAGE
I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which is...
2013-12-09
1,565 reads
Insert into a table using only default values
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value...
2013-12-04
1,206 reads
Why do DBAs like to say “It Depends” so much?
Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice...
2013-12-02
654 reads
Finding the metadata for a query
You know I occasionally find it interesting how I learn new things. I was running through a practice test for...
2013-11-25
2,586 reads
A pattern to do beginning of period calculations.
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning...
2013-11-20
783 reads
Connection options in SSMS
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...
2013-11-18
1,745 reads
Who’s on call
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of...
2013-11-13
599 reads
A better way to find missing indexes
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a...
2013-11-11
1,010 reads
sp_SrvPermissions & sp_DBPermissions V3.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2013-11-11 (first published: 2013-11-04)
1,868 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
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