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,496 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,581 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,564 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

901 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,178 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,383 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,247 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,299 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,095 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,837 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

Take Time to Gain Perspective

The Fringe Festival

Demo for Parameter Sniffing and Memory Grant Feedback

Forums

Fulltext filter daemon host (FDHost) process has stopped abnormally

Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer

Database Mail Configuration

Question of the Day

Database Mail Configuration