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,486 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,579 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,555 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

895 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,172 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,366 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,193 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,297 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,081 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,783 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

Overcoming Imposter Syndrome: A Plan

Advice I Like: Celebrate Success

Programmatically Retrieving MLV Lineage and Refresh Times

Forums

Cara buka blokir BWS Mobile banking

BCA KCP Morowali Telp:Cs.08216977726

BCA KCP Kertopaten Telpon. 083135766741

Question of the Day

Increase Deadlock Detection