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

How do I use a variable in an IN clause?

by Kenneth Fisher

SQLStudies

I see this question in one form or another a lot. I’ve seen this or something like it probably half...

2013-04-08

752 reads

How do I move a SQL login from one server to another without the password?

by Kenneth Fisher

SQLStudies

This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...

2013-04-03 (first published: 2013-03-25)

9,252 reads

Using Templates

by Kenneth Fisher

SQLStudies

Templates are one of those really handy tools that most DBAs I know of have either never heard of or...

2013-03-18

1,152 reads

The STUFF function

by Kenneth Fisher

SQLStudies

While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...

2013-03-14

879 reads

Script to clean up “Windows” logins no longer in AD

by Kenneth Fisher

SQLStudies

I was scanning http://dba.stackexchange.com and ran across the following question:
http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory
Basically the OP wanted to know how to get rid of...

2013-03-12 (first published: 2013-03-01)

4,152 reads