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

675 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

571 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,434 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,288 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,515 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

721 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

2,993 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,094 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

503 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,616 reads

Blogs

Inspecting TSQL Abstract Syntax Trees

TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....

Becoming a creator, my website experience

By DataOnWheels

Over the past few months, I have debated starting a new blog to discuss...

T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement

It’s that time of the month again, and once again, I’m late and I’m...

Read the latest Blogs

Forums

Collecting active node hostname at centralized location

So folks we have around 30/40 sql server failover cluster insatnce with each having...

Beginner in sql server

Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...

fast farward curson vs while loop on @table

By rajemessage 14195

hi, need to known weather fast farwand cursor is faster than a while loop...

Visit the forum

Question of the Day

Getting the Indexed Columns

I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?

SELECT   
    INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail')

See possible answers