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’s in a partition?

by Kenneth Fisher

SQLStudies

In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...

2017-05-22

508 reads

Partitioning on a nullable column

by Kenneth Fisher

SQLStudies

tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...

2017-05-17 (first published: 2017-05-03)

2,130 reads

T-SQL FizzBuzz

by Kenneth Fisher

SQLStudies

I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...

2017-05-17

2,874 reads

Why shouldn’t I shrink my database log file?

by Kenneth Fisher

SQLStudies

TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....

2017-05-15

487 reads

Simple Security Report

by Kenneth Fisher

SQLStudies

Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...

2017-05-12 (first published: 2017-05-01)

2,311 reads

Dynamic SQL and the joys of QUOTENAME

by Kenneth Fisher

SQLStudies

I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...

2017-05-11

645 reads

Continuous Integration

by Kenneth Fisher

SQLStudies

It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...

2017-05-09

427 reads

Why is a Windows authenticated login more secure than a SQL authenticated one?

by Kenneth Fisher

SQLStudies

I had this question come up at work the other day and while I knew it was true I wasn’t...

2017-05-08 (first published: 2017-04-26)

3,871 reads

SSMS Tips: Copy Full Path

by Kenneth Fisher

SQLStudies

When you right click on a tab you’ll see a number of different options. You can set up new horizontal...

2017-04-24

393 reads

When should I add an index?

by Kenneth Fisher

SQLStudies

We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...

2017-04-21 (first published: 2017-04-19)

2,962 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