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

Blogger questions: What if someone else wrote about the same subject?

by Kenneth Fisher

SQLStudies

I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a...

2016-02-03

564 reads

The CONNECT permission

by Kenneth Fisher

SQLStudies

The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...

2016-02-03 (first published: 2016-01-27)

3,147 reads

Reusing schedules in SQL Agent

by Kenneth Fisher

SQLStudies

I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor...

2016-02-01 (first published: 2016-01-25)

1,501 reads

What is RESULT SETS?

by Kenneth Fisher

SQLStudies

I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...

2016-01-26 (first published: 2016-01-14)

8,045 reads

Start SQL Server without tempdb

by Kenneth Fisher

SQLStudies

tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.
While at the...

2016-01-20

10,553 reads

Ad-hoc Changes

by Kenneth Fisher

SQLStudies

TSQL Tuesday #74: Be The Change
Each month, on the first Tuesday of the month, the announcement for the blog...

2016-01-18 (first published: 2016-01-12)

1,531 reads

To the page and back again

by Kenneth Fisher

SQLStudies

To the page
It’s not one of those things you have to do frequently but every now and again you need...

2016-01-18

539 reads

MSDTC Requirements for SSIS Transactions

by Kenneth Fisher

SQLStudies

MSDTC is frequently required when using transactions within SSIS. And not just when you are connecting to two SQL Server...

2016-01-12 (first published: 2016-01-06)

3,715 reads

Do you check for TRUSTWORTHY databases as part of your security audits?

by Kenneth Fisher

SQLStudies

I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do...

2016-01-06 (first published: 2015-12-30)

2,470 reads

2015 a year in review

by Kenneth Fisher

SQLStudies

It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell...

2016-01-04

442 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 Golden City Mall No.Telp:087757645171

By Xay Nha Nhanh

Whatsapp:087757645171 Golden City Mall, Ground Floor G-23-27, Jl. KH Abdul Wahab Siamin Surabaya No.2-8,...

BCA KCP Industri No.Tlp.083179431643

By wiseenglishedu

Jl. Industri II No.14, Muktiharjo Lor, Kec. Genuk, Kota Semarang, Jawa Tengah 50197

BCA KCP Semanggi Telp:cs.(0821)8171955

By telediousnom7887

Whatsapp:08218171955 Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Bend. Hilir, Kecamatan Tanah Abang,...

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