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

436 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,010 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

748 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,952 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

440 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,812 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

988 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,473 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

496 reads

Blogs

Why Databases Still Fascinate Me

I get asked a lot about why or how I began working with databases...

Monday Monitor Tips: ServiceNow Integration

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Inspecting TSQL Abstract Syntax Trees

TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....

Read the latest Blogs

Forums

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...

Cannot get KB959420

By fabio@fullin.com.ar

Hi, we lost our sever sql2000 To restore database to a new one we...

Do You Really Need HA?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Really Need HA?

Visit the forum

Question of the Day

The New Database CheckDB

I run this code:

create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')

What is returned?

See possible answers