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

Using DTEXECUI to generate a DTEXEC command line statement the easy way

by Kenneth Fisher

SQLStudies

SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...

2013-08-05 (first published: 2013-07-31)

2,701 reads

Generic Dynamic SQL Stored Procedure

by Kenneth Fisher

SQLStudies

Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...

2013-07-31 (first published: 2013-07-22)

3,604 reads

Notes on debugging Database Mail problems

by Kenneth Fisher

SQLStudies

I’ve had to debug database mail problems several times over the last year or so. Below is a collection of...

2013-07-29

1,390 reads

I’m going to my first SQL Saturday!

by Kenneth Fisher

SQLStudies

I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...

2013-07-24

660 reads

Scripting a partitioned table or index, a caution.

by Kenneth Fisher

SQLStudies

I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.
First here...

2013-07-22 (first published: 2013-07-15)

2,551 reads

Amusing SQL Trick – Hide yourself from SQL Server

by Kenneth Fisher

SQLStudies

I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...

2013-07-17

829 reads

Ordering steps in a SQL Agent job

by Kenneth Fisher

SQLStudies

Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...

2013-07-15 (first published: 2013-07-08)

2,194 reads

Writing Dynamic SQL (A how to)

by Kenneth Fisher

SQLStudies

A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...

2013-07-01

2,720 reads

Using OUTPUT to back up a change

by Kenneth Fisher

SQLStudies

How will you back out if your change doesn’t work?! Always take a backup! There should always be a back...

2013-06-26

2,423 reads

Metadata Functions (OBJECT_NAME for example)

by Kenneth Fisher

SQLStudies

What is a metadata function? According to BOL a metadata function is one that returns data about the database or...

2013-06-24

828 reads

Blogs

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers