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,481 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,576 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,551 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

892 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,167 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,360 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,170 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,291 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,077 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,702 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

The Benefits of Teaching

Power BI, Excel, OneLake – Dreams Do Come True!

The Book of Redgate: What Our Staff Says

Forums

Deny Connect problem

Website Stability 2025/12/05

403 Forbidden

Question of the Day

Fabric Mirroring