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

Synchronous vs Asynchronous

by Kenneth Fisher

SQLStudies

You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...

2016-10-24

774 reads

Installing SQLCMD

by Kenneth Fisher

SQLStudies

For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...

2016-10-19

889 reads

Using Snippets

by Kenneth Fisher

SQLStudies

A while ago I talked about Templates. This is an easy way to get a, well, template of a piece...

2016-10-17

460 reads

Too many indexes!

by Kenneth Fisher

SQLStudies

Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...

2016-10-13

581 reads

If backups are taken in silence can a recovery still take place?

by Kenneth Fisher

SQLStudies

My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a...

2016-10-11

418 reads

Pinned Tabs

by Kenneth Fisher

SQLStudies

It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...

2016-10-10 (first published: 2016-09-27)

2,024 reads

Floor, Round, and Ceiling

by Kenneth Fisher

SQLStudies

I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...

2016-10-05

631 reads

A quick fix for a full identity column.

by Kenneth Fisher

SQLStudies

A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
Negative...

2016-10-03 (first published: 2016-09-21)

2,053 reads

Becoming a Microsoft MVP

by Kenneth Fisher

SQLStudies

I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...

2016-10-03

632 reads

Constant Data Types

by Kenneth Fisher

SQLServerCentral.com

Data Types

Data types are an important part of how tables and variables work. Did you know that constants have databases too?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

Log in or register to rate

You rated this post out of 5. Change rating

2016-10-03

1,657 reads

Discuss

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