Kenneth Fisher

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at https://sqlstudies.com/.

Thank you!

by Kenneth Fisher

SQLStudies

I won’t be able to make it to the PASS Summit this year but I still consider myself part of...

2014-03-19

688 reads

Start with stupid

by Kenneth Fisher

SQLStudies

True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked...

2014-03-17

582 reads

:CONNECT in SSMS

by Kenneth Fisher

SQLStudies

Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...

2014-03-13

1,468 reads

T-SQL Tuesday #52: Keep your head down!

by Kenneth Fisher

SQLStudies

It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...

2014-03-11

1,300 reads

Impersonating a server level permission

by Kenneth Fisher

SQLStudies

Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...

2014-03-07 (first published: 2014-02-26)

2,665 reads

Characters you should never ever use in an object or schema name!

by Kenneth Fisher

SQLStudies

You can put pretty much any character you want into an object or schema name by enclosing the name in...

2014-03-05

750 reads

Using SQLFiddle

by Kenneth Fisher

SQLStudies

SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...

2014-03-03

3,117 reads

What’s the difference between a temp table and a table variable?

by Kenneth Fisher

SQLStudies

I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...

2014-02-24

1,113 reads

Finally added a (t) to my (b)

by Kenneth Fisher

SQLStudies

I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....

2014-02-20

518 reads

DBA Myths: An index on a bit column will never be used.

by Kenneth Fisher

SQLStudies

Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...

2014-02-19 (first published: 2014-02-17)

2,632 reads

Blogs

Copilot on the Power BI Report Canvas vs. Modern Report Builder

(This is the second post in a three-part series on how AI is changing...

The #MS_DatabaseConnector## Role: #SQLNewBlogger

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...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

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

By Bruno De Grauwe

Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...

The ##MS_DatabaseConnector## User

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The ##MS_DatabaseConnector## User

Visit the forum

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
GO

I then login as Demo and run this:

USE sandbox
go
SELECT CURRENT_USER

What is returned?

See possible answers