PASS SQL Saturday Events: November 2014
DateEventNovember 1 SQLSaturday #339 – Shanghai 2014November 1 SQLSaturday #337 – Oregon 2014November 22 SQLSaturday #355 – Parma, Italy 2014November 22 SQLSaturday #353...
2014-10-15
561 reads
Blog Posts
SSIS Pivot makes you stronger
At the recent Toronto SQL Server User group meeting Michal J Swart (@MJSwart) gave a good presentation based on 10...
2014-10-15
911 reads
Thank You: #passvotes
The results are in and it seems that I’ve been elected to a place on the PASS Board.
Thank you.
I will...
2014-10-15
497 reads
The full text error and why I was happy to see it.
The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to...
2014-10-15 (first published: 2014-10-07)
6,164 reads
Upcoming conferences end of 2014: Microsoft Technical Server Summit, MVP Summit, PASS Summit, Microsoft Technical Summit
(DE)
Das Jahresende nähert sich in raschen Schritten. In den nächsten 3 Monaten stehen wieder mehrere Konferenzauftritte an.
(EN)
The end...
2014-10-15
1,090 reads
Webinar Q&A: SSRS Subscriptions and Data Alerts
Updated 10-16-2014 at 11:20 AM Eastern
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the...
2014-10-15
1,537 reads
#TSQL2sday #59 – My Heroes
Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....
2014-10-14
555 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The contents of the mirror database are lagging behind the contents of...
2014-10-14
38 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :-
Mirroring stateDescriptionSYNCHRONIZINGThe contents of the mirror database are...
2014-10-14
2,010 reads
Murder In Utah
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-10-14
10 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