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

A T-SQL query to get current job activity

by Kenneth Fisher

SQLStudies

I recently had the task of collecting job activity for the purposes of turning it into a report for some...

2013-09-05

15,568 reads

When I run “Script as” it isn’t (or is) … How do I fix it?

by Kenneth Fisher

SQLStudies

When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix...

2013-09-03

766 reads

The effect of VLF size on shrinking the log.

by Kenneth Fisher

SQLStudies

I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided...

2013-08-29 (first published: 2013-08-26)

2,631 reads

The most important skill to practice when preparing for any certification exam!

by Kenneth Fisher

SQLStudies

I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an...

2013-08-28

1,023 reads

Lots of ways to UNPIVOT a table

by Kenneth Fisher

SQLStudies

I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated...

2013-08-21

1,314 reads

sp_SrvPermissions

by Kenneth Fisher

SQLStudies

Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...

2013-08-19

1,390 reads

How are COALESCE and ISNULL different?

by Kenneth Fisher

SQLStudies

At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...

2013-08-16 (first published: 2013-08-07)

8,880 reads