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

SQL Homework – July 2017

by Kenneth Fisher

SQLStudies

For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...

2017-07-03

407 reads

Temp table quiz

by Kenneth Fisher

SQLStudies

Brent Ozar (b/t) posted a pop quiz on twitter earlier today.

Go ahead and give it a shot .. I’ll wait.
So?...

2017-06-26

665 reads

Turning ANSI_PADDING off, and why you shouldn’t

by Kenneth Fisher

SQLStudies

I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...

2017-06-26 (first published: 2017-06-15)

3,168 reads

Dynamically generate the command line DMA statement for each database

by Kenneth Fisher

SQLStudies

If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...

2017-06-21

646 reads

Adding Identity to an existing column

by Kenneth Fisher

SQLStudies

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...

2017-06-19

1,613 reads

SQL Crossword

by Kenneth Fisher

SQLStudies

I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know...

2017-06-16 (first published: 2017-05-31)

2,803 reads

Buzzword Bingo

by Kenneth Fisher

SQLStudies

Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....

2017-06-13

968 reads

Running multiple queries at the same time.

by Kenneth Fisher

SQLStudies

I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at...

2017-06-08 (first published: 2017-05-24)

9,456 reads

UDP vs TCP

by Kenneth Fisher

SQLStudies

If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance...

2017-06-07

537 reads

Backup to NUL

by Kenneth Fisher

SQLStudies

Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...

2017-06-05

5,105 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

How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?

By Dr. Medha Sharma

Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...

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

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