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

Filtering Object Explorer

by Kenneth Fisher

SQLStudies

I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the...

2013-10-02

894 reads

Detaching a database

by Kenneth Fisher

SQLStudies

In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL...

2013-10-01 (first published: 2013-09-26)

1,660 reads

The MERGE statement doesn’t have a WHERE clause.

by Kenneth Fisher

SQLStudies

What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw...

2013-09-30

1,356 reads

DBA Myths: You can’t use an alias in a DELETE statement

by Kenneth Fisher

SQLStudies

Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course,...

2013-09-24

878 reads

sp_DBPermissions V2.0

by Kenneth Fisher

SQLStudies

Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...

2013-09-23 (first published: 2013-09-18)

2,449 reads

sp_SrvPermissions V2.0

by Kenneth Fisher

SQLStudies

Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...

2013-09-23 (first published: 2013-09-18)

2,078 reads

Brad Shultz’s blog on reviewing your database

by Kenneth Fisher

SQLStudies

This is possibly the best blog I have every read on the subject of reviewing a database. It is witty,...

2013-09-17

708 reads

DBA Myths: You can’t use an alias in an UPDATE statement.

by Kenneth Fisher

SQLStudies

I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an...

2013-09-16

883 reads

Certifications: What are they good for?

by Kenneth Fisher

SQLStudies

Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and...

2013-09-11

537 reads

How do the fixed Database and Server roles map to more specific permissions?

by Kenneth Fisher

SQLStudies

I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the...

2013-09-09

1,024 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 KCU MOJOKERTO No. Telpon 087781685658

By learningsupports

WHATSAPP 087781685658 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto, Jawa...

BCA KCP Dewi Sartika Telp:Cs.WA:0831•7943•7466

By imranali1290

WhatsApp 0831•7943•7466 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta Timur,...

BCA KCP Asia II TELP/CS:083135765355

Whatsapp:083135765355 Sudut, Jl. Asia No. 128/168 dan, Jl. Asia Jl. Lampung No.130/170, Sei Rengas...

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