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

CREATE SCHEMA can do what?!?!?

by Kenneth Fisher

SQLStudies

So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...

2013-05-21 (first published: 2013-05-15)

4,122 reads

Dragging a name from the object explorer to a query window

by Kenneth Fisher

SQLStudies

In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...

2013-05-16 (first published: 2013-05-13)

3,848 reads

Comparing an inner join vs a subquery

by Kenneth Fisher

SQLStudies

I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...

2013-05-08 (first published: 2013-05-03)

5,916 reads

Free SQL Books

by Kenneth Fisher

SQLStudies

I was looking for a way to put BOL on my Kindle when I found a few good links I...

2013-05-08

1,349 reads

GO

by Kenneth Fisher

SQLStudies

Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...

2013-05-06

911 reads

Well I finally passed the 70-451

by Kenneth Fisher

SQLStudies

So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...

2013-05-01

805 reads

INFORMATION_SCHEMA the un-sung system views

by Kenneth Fisher

SQLStudies

I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....

2013-04-29

2,577 reads

How do I tell the stored procedure name from inside the stored procedure?

by Kenneth Fisher

SQLStudies

I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...

2013-04-24

745 reads

Who writes your documentation?

by Kenneth Fisher

SQLStudies

I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do...

2013-04-22

811 reads

Calculating the length of a string (Len vs DataLength)

by Kenneth Fisher

SQLStudies

This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...

2013-04-15

1,222 reads

Blogs

AI: Blog a Day – Day 6: Embeddings – How AI Understands

By Vinay Thakur

Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...

The Book of Redgate: Mistakes

This is kind of a funny page to look at. The next page has...

ADF Pipeline Debugging Fails with BadRequest – The Sequel

By Koen Verbeeck

A while ago I blogged about a use case where a pipeline fails during...

Read the latest Blogs

Forums

Dynamic Unpivot

I have a table I didn't design that has tons of repeating groups in...

Writing as an Art and a Job

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing as an Art and...

String Similarity II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item String Similarity II

Visit the forum

Question of the Day

String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?

See possible answers