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

What does that N in nvarchar really mean?

by Kenneth Fisher

SQLStudies

In any study of Data Types in SQL Server you are going to have to look at the various string...

2015-12-28

2,392 reads

‘Twas 4:45 Friday

by Kenneth Fisher

SQLStudies

I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents...

2015-12-23

507 reads

What is the current database context?

by Kenneth Fisher

SQLStudies

Every now and again it can be very helpful to know what the current database context is when you are...

2015-12-21

679 reads

Can we get a license for DDL Triggers?

by Kenneth Fisher

SQLStudies

There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...

2015-12-17 (first published: 2015-12-14)

1,700 reads

Scripting out multiple scripts from the Object Explorer Details window.

by Kenneth Fisher

SQLStudies

A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what...

2015-12-16

598 reads

DBA Myths: Database file extentions

by Kenneth Fisher

SQLStudies

Every now and again I hear or read that the only file extensions for a SQL Server database are mdf,...

2015-12-10 (first published: 2015-12-02)

2,342 reads

Using unique constraints

by Kenneth Fisher

SQLStudies

I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was...

2015-12-10

1,636 reads

Apathy – A quick path to the naughty list.

by Kenneth Fisher

SQLStudies

It’s the Christmas season! And it’s T-SQL Tuesday! And Bradley Ball (b/t), SQL’s very own superhero (one of many really...

2015-12-08

531 reads

You should always have an “I got hit by a bus” backup plan

by Kenneth Fisher

SQLStudies

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens...

2015-12-07 (first published: 2015-11-30)

2,454 reads

Using multiple log files

by Kenneth Fisher

SQLStudies

The transaction log is made up of one or more files that are used sequentially. So in other words if...

2015-11-27 (first published: 2015-11-23)

1,560 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

Hyperscale Replicas IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas IV

The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek

By Dhananjay Chaudhari

Comments posted to this topic are about the item The SQL Server Date Magic:...

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers