Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
747 reads
Creating Icons Files
While working on a PowerPack for PowerGUI I needed to create a bunch of icon files from bitmaps files so...
2011-07-03
690 reads
Non-Convergence of Replicated Data
Brad McGehee over at SQL Aloha posted his July Question: What Do You Think are the Most Common DBA Pain...
2011-07-02
876 reads
Bloopers
An early peak at the bloopers going out on Monday. Feel free to enjoy today. I’ve included the editorial and...
2011-07-01
1,372 reads
July Question: What Do You Think are the Most Common DBA Pain Points?
While being a DBA is challenging and often rewarding, we often experience a lot of pain points that we wish...
2011-07-01
696 reads
MVP Award
Today on July 1st 2011, I was pleasantly surprised to be recoginzed as a Microsoft Most Valuable Professional for contributions to the PowerShell technical...
2011-07-01
595 reads
SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for the entire database. While reading the blog, I was...
2011-07-01
36 reads
SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for...
2011-07-01
678 reads
SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”
Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next...
2011-07-01
1,273 reads
SQLDIY: Gathering A Data Dictionary
In this installment we are looking at assembling a basic data dictionary from the column level meta data stored in...
2011-07-01
1,001 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