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

SQL Homework – December 2018 – Configure SSMS

by Kenneth Fisher

SQLStudies

I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...

2018-12-03

207 reads

Dealing with multiple AD accounts

by Kenneth Fisher

SQLStudies

To help promote the seperation of duties one of the things my company has done is to divide our permissions...

2018-11-29 (first published: 2018-11-19)

2,402 reads

Parameterized dynamic SQL is parameterized.

by Kenneth Fisher

SQLStudies

Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...

2018-11-23 (first published: 2018-11-15)

2,538 reads

The Cloud and Shadow IT.

by Kenneth Fisher

SQLStudies

Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck....

2018-11-21

940 reads

SQL Homework – November 2018 – Constraints

by Kenneth Fisher

SQLStudies

You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed...

2018-11-14 (first published: 2018-11-05)

1,943 reads

T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108

by Kenneth Fisher

SQLStudies

Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a...

2018-11-13

229 reads

Zombie SQL

by Kenneth Fisher

SQLStudies

It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...

2018-11-12 (first published: 2018-10-31)

2,907 reads

Missing those we’ve lost

by Kenneth Fisher

SQLStudies

It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to...

2018-11-07

233 reads

How do I look at my error log if SQL won’t open?

by Kenneth Fisher

SQLStudies

Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you...

2018-10-31 (first published: 2018-10-22)

2,648 reads

Blogger Questions: What if I get a mean/rude comment?

by Kenneth Fisher

SQLStudies

There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time...

2018-10-29

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

Hyperscale Replicas IV

By Steve Jones - SSC Editor

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

The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek

By Dhananjay Chaudhari

Comments posted to this topic are about the item The SQL Server Date Magic:...

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