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

Thank you!

by Kenneth Fisher

SQLStudies

I won’t be able to make it to the PASS Summit this year but I still consider myself part of...

2014-03-19

678 reads

Start with stupid

by Kenneth Fisher

SQLStudies

True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked...

2014-03-17

576 reads

:CONNECT in SSMS

by Kenneth Fisher

SQLStudies

Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...

2014-03-13

1,439 reads

T-SQL Tuesday #52: Keep your head down!

by Kenneth Fisher

SQLStudies

It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...

2014-03-11

1,291 reads

Impersonating a server level permission

by Kenneth Fisher

SQLStudies

Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...

2014-03-07 (first published: 2014-02-26)

2,548 reads

Characters you should never ever use in an object or schema name!

by Kenneth Fisher

SQLStudies

You can put pretty much any character you want into an object or schema name by enclosing the name in...

2014-03-05

727 reads

Using SQLFiddle

by Kenneth Fisher

SQLStudies

SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...

2014-03-03

3,052 reads

What’s the difference between a temp table and a table variable?

by Kenneth Fisher

SQLStudies

I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...

2014-02-24

1,099 reads

Finally added a (t) to my (b)

by Kenneth Fisher

SQLStudies

I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....

2014-02-20

506 reads

DBA Myths: An index on a bit column will never be used.

by Kenneth Fisher

SQLStudies

Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...

2014-02-19 (first published: 2014-02-17)

2,619 reads

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

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

March 2026 SQL Server Security Updates

By Brian Kelley

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...

How Fabric Mirroring Transformed with SQL Server 2025

By Meagan Longoria

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

Read the latest Blogs

Forums

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

Upgrading Admin Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrading Admin Queries

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