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

Add them to ALL the roles!

by Kenneth Fisher

SQLStudies

I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...

2014-07-28 (first published: 2014-07-21)

8,651 reads

Why am I getting a primary/unique key violation?

by Kenneth Fisher

SQLStudies

This may seem like a question with a simple answer but there is a bit more to it than you...

2014-07-23

1,437 reads

Yes, Virginia, you can have too much white space.

by Kenneth Fisher

SQLStudies

When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch...

2014-07-22 (first published: 2014-07-16)

9,125 reads

What does it mean that a value is NULL?

by Kenneth Fisher

SQLStudies

Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be...

2014-07-15 (first published: 2014-07-14)

10,889 reads

Single Quotation Marks in SQL

by Kenneth Fisher

SQLServerCentral.com

T-SQL

One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.