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,121 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,846 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,914 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,348 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

909 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

803 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,572 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

735 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

810 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,174 reads

Blogs

Using Prompt AI for a Travel Data Analysis

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By Ige Adetokunbo Temitayo

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

2025 Wrapped for Steve

I’ve often done some analysis of my year in different ways. Last year I...

Read the latest Blogs

Forums

reaching ftp thru winscp but erroring in ssis ftp task connection

Hi, below i show various results trying to reach our ftp site (a globalscape...

Finding Motivation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Motivation

The Last Binary Value of the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Binary Value of...

Visit the forum

Question of the Day

The Last Binary Value of the Year

What does this code return?

SELECT cast(0x2025 AS NVARCHAR(20))

Image 1:

Image 2:

Image 3:

Image 4:

See possible answers