I’m A Friend Of Red Gate For 2015
I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...
2015-01-23
568 reads
Blog Posts
Technology Advances – mSATA external case
I had an SSD die last year. It was one of my traveling SSDs, where I keep spare copies of...
2015-01-23 (first published: 2015-01-16)
6,624 reads
Video: A Better Way to Reindex
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,946 reads
Excel Apps – Not Quite Ready for Primetime
While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I...
2015-01-22
1,106 reads
How to install standalone SQL Server 2012 instance ?
Steps to install standalone SQL Server 2012 instance 1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition...
2015-01-22
22 reads
How to install standalone SQL Server 2012 instance ?
Steps to install standalone SQL Server 2012 instance
1) Start the setup > Go to Installation from Left > Click on 1st option...
2015-01-22
1,084 reads
Looking Out for Others Helps You Lead
I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go...
2015-01-22
805 reads
Pagination in SQL Server
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL...
2015-01-22 (first published: 2015-01-15)
8,995 reads
SQL #57–A one-liner query with PARTITION BY
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,471 reads
SQLPort’s new image
After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image...
2015-01-22
539 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