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,484 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,553 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,171 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,362 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,181 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,294 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,080 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,746 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: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Question of the Day

String Similarity I