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

Blog Post

ORDER BY the numbers

Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...

2013-06-19 (first published: )

2,779 reads

All authors

Blogs

A New Word: Dolorblindness

By

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Read the latest Blogs

Forums

Optimism Without Illusion or Why AI Needs Blunt Technologists

By dbakevlar

Comments posted to this topic are about the item Optimism Without Illusion or Why...

SSIS with VS2022 64/32 issue with Excel files

By mario17

Hi all, I'm trying to do classic scenario for loading multiple Excel files into...

Case part is sloooooow

By krypto69

Hi So the case statement is slowing this down - but for the life...

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code: 

SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled.

See possible answers