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

What is the “cost” in Cost Threshold for Parallelism?

by Kenneth Fisher

SQLStudies

tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...

2017-04-17

517 reads

No space queries

by Kenneth Fisher

SQLStudies

You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The...

2017-04-13

406 reads

The more things change, the more they stay the same

by Kenneth Fisher

SQLStudies

Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other...

2017-04-11

489 reads

Creating a list of random numbers

by Kenneth Fisher

SQLStudies

I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...

2017-04-05 (first published: 2017-03-22)

2,357 reads

How do I change the increment of an identity column?

by Kenneth Fisher

SQLStudies

Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...

2017-04-05

498 reads

Compressed backup errors and TF 3042

by Kenneth Fisher

SQLStudies

Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time...

2017-04-03 (first published: 2017-03-16)

1,677 reads

Hiding tables in SSMS Object Explorer

by Kenneth Fisher

SQLStudies

Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...

2017-04-03

529 reads

Increasing and decreasing the performance level of your Azure SQL Database

by Kenneth Fisher

SQLStudies

One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...

2017-03-29

736 reads

Limits vs Goals

by Kenneth Fisher

SQLStudies

It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us....

2017-03-27 (first published: 2017-03-14)

1,136 reads

sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

by Kenneth Fisher

SQLStudies

It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well,...

2017-03-27

513 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

I Struggle

By Grant Fritchey

Comments posted to this topic are about the item I Struggle

Hyperscale Replicas IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas IV

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers