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

Escaping from a runaway Logon trigger

by Kenneth Fisher

SQLStudies

Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...

2014-05-27 (first published: 2014-05-19)

1,758 reads

Microsoft’s free virtual labs

by Kenneth Fisher

SQLStudies

If you have spent any time looking around my site, you will notice that I love study materials and in...

2014-05-26

1,183 reads

DBA Myths: A table with a primary key is not a heap

by Kenneth Fisher

SQLStudies

Typically when you see a heading like this you know the answer is “No” or “False” but in this case...

2014-05-21

2,653 reads

Granting or denying permissions to all of the tables within a database

by Kenneth Fisher

SQLStudies

When granting or denying permissions to the tables within a database you have two options. You can either add the...

2014-05-20 (first published: 2014-05-15)

4,856 reads

T-SQL Tuesday #54: Interviews!

by Kenneth Fisher

SQLStudies

It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing....

2014-05-16 (first published: 2014-05-13)

1,624 reads

Does SQL Server do a CHECKDB during an instance restart?

by Kenneth Fisher

SQLStudies

When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server...

2014-05-13 (first published: 2014-05-07)

2,398 reads

Why is there a sysobjects when we already have sys.objects?

by Kenneth Fisher

SQLStudies

Once upon a time in a version of SQL far far away we had system tables that were easy to...

2014-05-05

722 reads

Collation: Confusion

by Kenneth Fisher

SQLStudies

I started reading about collations after I had a recent run in with them. As I read I started to...

2014-05-02 (first published: 2014-04-23)

2,398 reads

Collation: Temporary objects and variables: Demonstration

by Kenneth Fisher

SQLStudies

I had a recent run in with collation problems and it got me started reading about them. As I read...

2014-04-30 (first published: 2014-04-21)

2,085 reads

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

by Kenneth Fisher

SQLStudies

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However...

2014-04-30

2,727 reads

Blogs

A New Word: Dorgone

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

does anyone used https://github.com/ktaranov/sqlserver-kit

By ARUN KUMAR AGUNURU

Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...

How Can Database Performance Improve the Overall Website Experience?

By Brooks-Hayward

I’ve been looking into ways to improve the connection between a website and its...

When And How to Automate?

Comments posted to this topic are about the item When And How to Automate?

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers