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

All authors

Getting a query plan

by Kenneth Fisher

SQLStudies

Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware...

2014-02-19

1,503 reads

T-SQL Tuesday #51: Doubledown disaster

by Kenneth Fisher

SQLStudies

Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...

2014-02-14 (first published: 2014-02-11)

1,583 reads

Transactions: What commands aren’t allowed?

by Kenneth Fisher

SQLStudies

Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put...

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

4,566 reads

Check your SQL Agent history settings before it’s too late!

by Kenneth Fisher

SQLStudies

A little while back I was doing some research into a failed job and ran into a slight problem. The...

2014-02-10

902 reads

Negative session_ids

by Kenneth Fisher

SQLStudies

I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...

2014-02-03 (first published: 2014-01-27)

2,179 reads

Transactions: Creating a single restore point across multiple databases.

by Kenneth Fisher

SQLStudies

This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple...

2014-02-02

1,386 reads

Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

by Kenneth Fisher

SQLStudies

I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I...

2014-01-29

1,258 reads

Transactions: Who, What and Where

by Kenneth Fisher

SQLStudies

Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I...

2014-01-23 (first published: 2014-01-20)

3,302 reads

The “most_recent_sql_handle” column

by Kenneth Fisher

SQLStudies

While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in...

2014-01-22

1,096 reads

Guid vs Identity columns (Ints)

by Kenneth Fisher

SQLStudies

I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary key?...

2014-01-20 (first published: 2014-01-13)

4,863 reads

All authors

Kenneth Fisher

Getting a query plan

T-SQL Tuesday #51: Doubledown disaster

Transactions: What commands aren’t allowed?

Check your SQL Agent history settings before it’s too late!

Negative session_ids

Transactions: Creating a single restore point across multiple databases.

Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

Transactions: Who, What and Where

The “most_recent_sql_handle” column

Guid vs Identity columns (Ints)

Blogs

A New Word: Dorgone

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

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

Forums

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

How Can Database Performance Improve the Overall Website Experience?

When And How to Automate?

Question of the Day

Hyperscale Replicas II