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

How to remove additional (unwanted) log files

by Kenneth Fisher

SQLStudies

Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a...

2014-11-05

1,208 reads

Force only certain values to be unique

by Kenneth Fisher

SQLStudies

I thought of something rather interesting the other day while answering a question asking for help with some table structures....

2014-11-03 (first published: 2014-10-22)

6,574 reads

My DTS Package won’t load with the error “here were errors loading package”

by Kenneth Fisher

SQLStudies

You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
Error...

2014-11-03

782 reads

Playing with the log – Before the first full backup

by Kenneth Fisher

SQLStudies

The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the...

2014-10-29

1,820 reads

Update to “The clustered index columns are in all of the non clustered indexes.”

by Kenneth Fisher

SQLStudies

I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments...

2014-10-29 (first published: 2014-10-20)

6,079 reads

A script to list the DTS connection information for every package on the instance.

by Kenneth Fisher

SQLStudies

For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...

2014-10-27

670 reads

UNION vs UNION ALL

by Kenneth Fisher

SQLStudies

You might be wondering why I’m going into such a simple subject. Well the way I see it there are...

2014-10-16

2,756 reads

TSQL Tuesday #59: My Hero, My Inspiration, My Wife

by Kenneth Fisher

SQLStudies

TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t)...

2014-10-14

1,163 reads

You can’t use aggregate/windowing functions with CROSS APPLY

by Kenneth Fisher

SQLStudies

One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well...

2014-10-13 (first published: 2014-10-06)

9,196 reads

Required reading before upgrading SQL Server.

by Kenneth Fisher

SQLStudies

I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q...

2014-10-08

1,301 reads

Blogs

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

One of the first things I review when I inherit a new SQL Server...

AgentDBA vs Critical SQL Server

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

Read the latest Blogs

Forums

ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777

Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...

BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777

By layanan_Bca88

Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...

ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777

Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...

Visit the forum

Question of the Day

Detecting Characters

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:

SELECT CustomerNameID,
       CustomerName
 FROM dbo.CustomerName
 WHERE CustomerName = LOWER(CustomerName)

Here is the sample data I am testing with:

CustomerNameID CustomerName
1              John Smith
2              Sarah Johnson
3              MICHAEL WILLIAMS
4              JENNIFER BROWN
5              david jones
6              emily davis
7              Robert Miller
8              LISA WILSON
9              christopher moore
10             Amanda Taylor

How many rows are returned?

See possible answers