How the Resource Governor Helped Our Report Server
Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.
2010-06-28
5,741 reads
Roy Ernest
Ask for something and when you get it no one uses it
There was a time when almost every Chapter leader were asking PASS to find a place where the leaders can...
2010-05-21
407 reads
My experience while writing for SQL Server Standard magazine
It all started with Grant Fritchey (Twitter @GFritchey) posting on THE THREAD asking everyone if they are interested in writing...
2010-05-07
846 reads
Powershell- Is it easy as everyone claims?
Where ever you read, people claim that power shell is so easy that even a dummy can do it. Really?...
2010-03-08
638 reads
First International speaker for our User Group
I am a nervous wreck today. Tomorrow we will have the first International speaker for our user group. Jimmy may...
2010-02-17
750 reads
Jimmy May coming to our Local Chapter meeting
This is wonderful news to our new chapter. Jimmy May has agreed to come to give a presentation at our...
2010-01-26
700 reads
My first presentation for User Group
Yesterday was the first time I gave a presentation to a group of professional who knows SQL Server. I was...
2009-12-04
813 reads
A good way to learn
I have noticed that one of the best way to learn about a certain topic is to write an article...
2009-11-25
708 reads
To Grant or Not to grant
It is said that you should not give direct table access (even select permission) to a user or group. But...
2009-11-25
555 reads
Starting up a Pass Chapter
I am on my way in setting up a Pass chapter on our tiny Caribbean island. I had no clue...
2009-06-17
613 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
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
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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