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

Want to be able to read your database between restores?

by Kenneth Fisher

SQLStudies

When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...

2016-07-20

779 reads

Is the network your last performance bottleneck?

by Kenneth Fisher

SQLStudies

Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options...

2016-07-18

445 reads

Altering a column in a large table: A case study

by Kenneth Fisher

SQLStudies

Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to...

2016-07-14

1,053 reads

Default database file sizes

by Kenneth Fisher

SQLStudies

It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing...

2016-07-12

761 reads

Finding, disabling and enabling foreign keys

by Kenneth Fisher

SQLStudies

Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...

2016-07-11 (first published: 2016-06-29)

1,970 reads

Zilch to Speaker: 2016 Summit Abstract Reviews

by Kenneth Fisher

SQLStudies

Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...

2016-07-07

451 reads

Perfectly Placed Parentheses

by Kenneth Fisher

SQLStudies

Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls etc....

2016-07-05 (first published: 2016-06-27)

2,916 reads

Phantom SSIS Changes

by Kenneth Fisher

SQLStudies

That SSIS change just won’t stick! There is a new business requirement, so now you have to change an existing...

2016-07-05

1,001 reads

Minimizing Cloud cost

by Kenneth Fisher

SQLStudies

The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working...

2016-06-27 (first published: 2016-06-20)

1,481 reads

Database snapshots

by Kenneth Fisher

SQLStudies

This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating....

2016-06-22

585 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

Hyperscale Replicas IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas IV

The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek

By Dhananjay Chaudhari

Comments posted to this topic are about the item The SQL Server Date Magic:...

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers