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

677 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

575 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,438 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,290 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,548 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

727 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,045 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,099 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

506 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

Git forked

By Randolph West

Forgive me for the title. Mentally I’m 12. When I started my current day...

Setting FK Constraints in Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how...

Webinar: Navigating the Database Landscape in 2026

For a number of years, we’ve produced the State of the Database Landscape report,...

Read the latest Blogs

Forums

SSMS 22 Latest Update Crashing

Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...

Transactional Replication setup issue

Hi! I've been banging my head against the wall for 2 days now trying...

The Power of Data and Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Power of Data and...

Visit the forum

Question of the Day

What's the Date?

In SQL Server 2025, there is a new function that returns the current date without the time. What is it?

See possible answers