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,021 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

753 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,958 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

446 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,863 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

994 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

523 reads

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By Meagan Longoria

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By Eduardo Pivaral

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

BCA KCP Kas Hang Tuah TLP/WA 08216977749

By Call Center Cs BRI QLola

Jl. Hangtuah, Kel Jl. Bambu Kuning No.54 E, RT./RW/RW.03/01, Kec. Tenayan Raya, Kota Pekanbaru,...

BCA KCP Pluit Raya Hub.0853•5504•2311

By greatdubai02

BCA KCP Pluit Raya Hub.0853•5504•2311 Jl. Pluit Raya No.200, Penjaringan, Kecamatan Penjaringan, Jkt Utara,...

BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311

By greatdubai02

BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not. ..."

See possible answers