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

Disaster Recovery’s big brother Operational Recovery

by Kenneth Fisher

SQLStudies

I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...

2013-06-20

941 reads

ORDER BY the numbers

by Kenneth Fisher

SQLStudies

Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...

2013-06-19 (first published: 2013-06-17)

2,780 reads

Best practice recommendations for writing Dynamic SQL

by Kenneth Fisher

SQLStudies

Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...

2013-06-13 (first published: 2013-06-12)

5,588 reads

Using the OVER clause

by Kenneth Fisher

SQLStudies

Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has...

2013-06-10

684 reads

Backup a password, change it, then restore it.

by Kenneth Fisher

SQLStudies

A couple of months ago I talked about moving a login from one server to another without the password. The...

2013-06-05 (first published: 2013-05-30)

2,341 reads

Easy way to generate a restore script.

by Kenneth Fisher

SQLStudies

Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....

2013-06-05

997 reads

Pattern searches beyond ‘%string%’.

by Kenneth Fisher

SQLStudies

I was asked today to take a table with a social security column and put all 0s if the column...

2013-06-03

907 reads

Using CROSS APPLY to calculate an aggregate across a single row.

by Kenneth Fisher

SQLStudies

I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...

2013-05-28

1,468 reads

The many uses of CROSS APPLY

by Kenneth Fisher

SQLStudies

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...

2013-05-23 (first published: 2013-05-20)

21,509 reads

Using CROSS APPLY instead of a calculated variable

by Kenneth Fisher

SQLStudies

Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working...

2013-05-22

871 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By Brian Kelley

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By Meagan Longoria

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Bungur Tlpn/wa:085373737551

By balijepalli.p

Jl. Bungur Besar Raya No.32 & 32A, Gn. Sahari Sel., Kec. Kemayoran, Kota Jakarta...

BCA KCP Alaydrus Tlpn/wa:085373737551

By balijepalli.p

Jl. Alaydrus No.47 & 47 A, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...

MENARA BCA d/a GRAND INDONESIA, Tlpn/wa:085373737551

By balijepalli.p

Tlpn/wa:085373737551 Jl. MH Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers