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

758 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,967 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

448 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,904 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,477 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

576 reads

Blogs

Creating a Local Model Chatbot on Windows

After my session at VSLive last week, I had a few questions from the...

To refer and to be referred

By Mala Mahadevan

Referrals have never been more important in the job market. They’re no longer nice...

A New Word: Dorgone

dorgone– adj. wondering if you could slip away from an event or group conversation...

Read the latest Blogs

Forums

Querying Multiple Tables for the Same Information

I have about 100 Tables that are all suffixed with _Modify. These tables record...

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

Finding Gaps in Sequential Data Using SQL Server

Comments posted to this topic are about the item Finding Gaps in Sequential Data...

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers