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

Haunted SQL: The ghost of Management Studio

by Kenneth Fisher

SQLStudies

Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...

2017-10-30

667 reads

Permissions required for developing with Temporal Tables

by Kenneth Fisher

SQLStudies

Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table...

2017-10-26 (first published: 2017-10-16)

1,799 reads

HA HA HA

by Kenneth Fisher

SQLServerCentral.com

Editorial

Crossword puzzle focusing on high availability

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2017-10-25

374 reads

Discuss

Schema only backup or schema only DB copy

by Kenneth Fisher

SQLStudies

Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded...

2017-10-25

1,122 reads

Updateable CTEs

by Kenneth Fisher

SQLStudies

CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t...

2017-10-18

1,970 reads

Small identity columns

by Kenneth Fisher

SQLStudies

We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small...

2017-10-17 (first published: 2017-10-09)

1,848 reads

sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)

by Kenneth Fisher

SQLStudies

I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into...

2017-10-11

428 reads

The Alpha and the Omega. The BEGIN and the END.

by Kenneth Fisher

SQLStudies

The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do...

2017-10-04

951 reads

Haunted SQL

by Kenneth Fisher

SQLStudies

I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about...

2017-10-03

339 reads

SQL Homework – October 2017 – Sample/Test Database(s)

by Kenneth Fisher

SQLStudies

Last month your homework was to set up your own lab. Now it’s time to put a sample database or...

2017-10-02

431 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers