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

778 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

1,060 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

469 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

588 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

425 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,037 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

644 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,063 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

643 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,663 reads

Discuss

Blogs

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By Eduardo Pivaral

Most apps that call an LLM send every request to the same model. That...

Advice I Like: Responsibility

“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...

Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports

Originally published April 2022; substantially updated July 2026. This post is a complete replacement...

Read the latest Blogs

Forums

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Another Model, More Data Loss

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Another Model, More Data Loss

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers