Re-blog – April 29-May 5
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-06
571 reads
Blog Posts
SQL University: Precedence Constraints
Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables...
2011-05-06
2,115 reads
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented?...
2011-05-06
404 reads
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has...
2011-05-06
1,301 reads
Why you should ask your CTO to attend the User group meetings.
When we (Bill Wunder and me) started our user group, the first person we invited to sign up to our...
2011-05-06
1,864 reads
A row has no row number
It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s...
2011-05-05
3,976 reads
Certifications – and a survey.
G’day,
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them...
2011-05-05
735 reads
Correcting Image Distortion in PDF Reports
I’ve seen a few cases where reports exported or rendered to PDF have distorted charts and images. We’ve played with...
2011-05-05
1,707 reads
I Won't Be at SQL Rally
I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...
2011-05-05
875 reads
My Partitioning And Compression Quest! (Continued)
Thank you, David C, for your comment! Please see below to the answers to
your questions.
The table structure is:
CREATE TABLE...
2011-05-05
930 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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