SQL Server 2012 AlwaysOn Presentation Given at Vermont PASS SQL Server User Group Last Week
This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...
2013-12-16
1,349 reads
This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...
2013-12-16
1,349 reads
The other morning I was commenting during our regular meetings amongst fellow DBAs on where to read up on installation...
2013-12-11
5,338 reads
LinkedIn has matured over the past decade and I can
sincerely say it is well worth the time setting up your...
2013-10-09
1,275 reads
This will not be a typical post, just a dive right away into Data Access Language Code, which provides a...
2013-09-10
3,753 reads
Since I changed organisations in January this year, I asked one of my colleagues to export his SQL Server Management...
2013-08-01
1,846 reads
For those Database Administrators seeking to lock-down security related to a Service Account(s), there is an option starting with Windows...
2013-06-21
2,257 reads
Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which...
2013-02-25
2,648 reads
One of the great features available since SQL 2008 is Row and/or Page Compression. However, even for those of you on SQL...
2013-02-08
2,792 reads
Since the last guide was quite popular (over 4k distinct views for SQL Server 2008 R2), I've uploaded to SkyDrive...
2013-01-11
19,294 reads
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for...
2012-12-26
1,517 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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