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/.

Thank you!

by Kenneth Fisher

SQLStudies

I won’t be able to make it to the PASS Summit this year but I still consider myself part of...

2014-03-19

675 reads

Start with stupid

by Kenneth Fisher

SQLStudies

True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked...

2014-03-17

573 reads

:CONNECT in SSMS

by Kenneth Fisher

SQLStudies

Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...

2014-03-13

1,435 reads

T-SQL Tuesday #52: Keep your head down!

by Kenneth Fisher

SQLStudies

It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...

2014-03-11

1,289 reads

Impersonating a server level permission

by Kenneth Fisher

SQLStudies

Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...

2014-03-07 (first published: 2014-02-26)

2,528 reads

Characters you should never ever use in an object or schema name!

by Kenneth Fisher

SQLStudies

You can put pretty much any character you want into an object or schema name by enclosing the name in...

2014-03-05

723 reads

Using SQLFiddle

by Kenneth Fisher

SQLStudies

SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...

2014-03-03

3,009 reads

What’s the difference between a temp table and a table variable?

by Kenneth Fisher

SQLStudies

I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...

2014-02-24

1,096 reads

Finally added a (t) to my (b)

by Kenneth Fisher

SQLStudies

I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....

2014-02-20

504 reads

DBA Myths: An index on a bit column will never be used.

by Kenneth Fisher

SQLStudies

Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...

2014-02-19 (first published: 2014-02-17)

2,618 reads

Blogs

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers