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

SQL Connectivity issues: A guided walk through

by Kenneth Fisher

SQLStudies

The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.
Announcement
Walk Through
If you look...

2017-02-06

416 reads

My SQL logins don’t work. Again.

by Kenneth Fisher

SQLStudies

My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one...

2017-02-02 (first published: 2017-01-25)

2,387 reads

Changing what SSMS opens on startup

by Kenneth Fisher

SQLStudies

When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...

2017-02-01

778 reads

Azure quick start

by Kenneth Fisher

SQLStudies

In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...

2017-01-30

675 reads

Creating a connect entry.

by Kenneth Fisher

SQLStudies

I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...

2017-01-30 (first published: 2017-01-23)

1,116 reads

What is COPY_ONLY?

by Kenneth Fisher

SQLStudies

You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...

2017-01-19 (first published: 2017-01-16)

2,532 reads

Lead Blocker

by Kenneth Fisher

SQLStudies

Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and...

2017-01-18

2,999 reads

A detailed view into your Azure resources

by Kenneth Fisher

SQLStudies

I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com

To give you an idea why I find...

2017-01-13 (first published: 2017-01-05)

1,458 reads

Why won’t my SQL Logins work?

by Kenneth Fisher

SQLStudies

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...

2017-01-12

811 reads

Connect suggestion to add included columns to sp_helpindex

by Kenneth Fisher

SQLStudies

I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the...

2017-01-10

462 reads

Blogs

Flyway Tips: AI Generating Migration Script Names

AI is a big deal in 2026, and at Redgate, we’re experimenting with how...

The Book of Redgate: Get the right stuff done

Another of our values: The facing page has this quote: “We admire people who...

Runing tSQLt Tests with Claude

Running tSQLt unit tests is great from Visual Studio but my development workflow...

Read the latest Blogs

Forums

No Defaults Passwords Ever

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No Defaults Passwords Ever

Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

Hi, We have low latency high volume system. I have a table having 3...

The Long Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long Name

Visit the forum

Question of the Day

The Long Name

I run this code to create a table: Create table with unicode name When I check the length, I get these results: Table with length of name shown as 132 characters A table name is limited to 128 characters. How does this work?

See possible answers