We have a new contributor…
In order to keep the content fresh and the posts flowing here on my blog I have decided to publish...
2011-07-13
601 reads
Blog Posts
Automating Web App Deployments with SSIS
This is just a quick note to let everyone know I’ve uploaded the project files from my Pragmatic Works webinar...
2011-07-12
623 reads
Copying parent-child rows and SQL Dependency Tracker
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
2,145 reads
How to move the Model Database
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
6,634 reads
SQL Server “Denali”: CTP3 now available!
CTP3 of SQL Server Code Name “Denali” was made available for download this morning. You can download the 32-bit and...
2011-07-12
2,261 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has finally (after releasing the CTP version way back in April) released the final, gold build of SQL Server...
2011-07-12
2,659 reads
SQL Server 2011 (Denali) CTP3 Released!
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
960 reads
SQL Server 2011 CTP3 (Denali) Released
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
1,387 reads
SQL Server Denali CTP3: Policy Based Management
Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server “Denali”....
2011-07-12
1,398 reads
SQLDIY: Index Usage Statistics
There are several different aspects of indexes that can be monitored via DMV’s. One the neatest things is just how...
2011-07-12
2,475 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