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

Database default locations

by Kenneth Fisher

SQLStudies

One of the options you had when installing your instance was setting some default file locations.
Defaut data file locationDefault log...

2014-10-01 (first published: 2014-09-29)

8,143 reads

Intro to Auditing in SQL Server on SQL Shack

by Kenneth Fisher

SQLStudies

I had an article published yesterday on http://www.SQLShack.com.
Intro to Auditing in SQL Server.
It’s worth reading if I do say...

2014-10-01

1,231 reads

Changing configuration settings with sp_configure

by Kenneth Fisher

SQLStudies

I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...

2014-09-24 (first published: 2014-09-22)

8,053 reads

What I know about batch files

by Kenneth Fisher

SQLStudies

For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how...

2014-09-24

633 reads

What are trace flags?

by Kenneth Fisher

SQLStudies

Trace flags are one of those things that I’ve heard about more and more over the last five or six...

2014-09-18 (first published: 2014-09-11)

7,982 reads

Triggers are not toys!

by Kenneth Fisher

SQLStudies

For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL...

2014-09-17

1,451 reads

I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

by Kenneth Fisher

SQLStudies

Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this...

2014-09-15

1,196 reads

T-SQL Tuesday #58: Passwords

by Kenneth Fisher

SQLStudies

It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host...

2014-09-12 (first published: 2014-09-09)

6,728 reads

Finding a job!

by Kenneth Fisher

SQLStudies

I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years...

2014-09-04 (first published: 2014-08-27)

7,710 reads

Pausing an MSSQL Instance

by Kenneth Fisher

SQLStudies

I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop...

2014-09-04

3,893 reads

Blogs

Wait… Could This Be the End of Index Maintenance?

By Monica Rathbun

While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...

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

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