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

772 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

439 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,019 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

751 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,956 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

445 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,825 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

993 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,474 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

499 reads

Blogs

Vibe Coding a Login Tracking System

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

4 CPE Opportunity (Virtual) for Charity

By Brian Kelley

Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...

Data Céilí 2026 Call for Speakers!

By Andrew Pruski

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Read the latest Blogs

Forums

Deadlock graph anomaly

I've come across what appears to be a strange deadlock anomaly. As seen in...

Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

The Challenge of AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Challenge of AI, which...

Visit the forum

Question of the Day

Deprecated Feature Tracking

From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?

See possible answers