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

Database default locations

by Kenneth Fisher

SQLStudies

One of the options you had when installing your instance was setting some default file locations.
Defaut data file locationDefault log...

2014-10-01 (first published: 2014-09-29)

8,101 reads

Intro to Auditing in SQL Server on SQL Shack

by Kenneth Fisher

SQLStudies

I had an article published yesterday on http://www.SQLShack.com.
Intro to Auditing in SQL Server.
It’s worth reading if I do say...

2014-10-01

1,219 reads

Changing configuration settings with sp_configure

by Kenneth Fisher

SQLStudies

I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...

2014-09-24 (first published: 2014-09-22)

7,701 reads

What I know about batch files

by Kenneth Fisher

SQLStudies

For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how...

2014-09-24

622 reads

What are trace flags?

by Kenneth Fisher

SQLStudies

Trace flags are one of those things that I’ve heard about more and more over the last five or six...

2014-09-18 (first published: 2014-09-11)

7,926 reads

Triggers are not toys!

by Kenneth Fisher

SQLStudies

For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL...

2014-09-17

1,440 reads

I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

by Kenneth Fisher

SQLStudies

Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this...

2014-09-15

1,185 reads

T-SQL Tuesday #58: Passwords

by Kenneth Fisher

SQLStudies

It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host...

2014-09-12 (first published: 2014-09-09)

6,716 reads

Finding a job!

by Kenneth Fisher

SQLStudies

I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years...

2014-09-04 (first published: 2014-08-27)

7,698 reads

Pausing an MSSQL Instance

by Kenneth Fisher

SQLStudies

I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop...

2014-09-04

3,835 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

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

Eight Minutes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Eight Minutes

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