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

All authors

#PowershellBasics: Get input using Read-Host

by Kenneth Fisher

SQLStudies

Conditions are the life blood of programming. This condition is met so now I need to do this task. That ... Continue reading

2020-02-11 (first published: 2020-02-05)

555 reads

SQL Homework – February 2020 – Write a blog post.

by Kenneth Fisher

SQLStudies

Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what ... Continue reading

2020-02-07 (first published: 2020-02-03)

308 reads

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

by Kenneth Fisher

SQLStudies

If you read the title to this post and your first thought was That’s not SQL is it? then you ... Continue reading

2020-02-05 (first published: 2020-01-27)

874 reads

Changing the owner of a schema removes all direct permissions of objects owned by the schema.

by Kenneth Fisher

SQLStudies

This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow ... Continue reading

2020-01-31 (first published: 2020-01-22)

407 reads

Common commands and tasks to make dealing with Windows Core easier.

by Kenneth Fisher

SQLStudies

I don’t know how many of you are working with Windows Core these days but personally I think it’s a ... Continue reading

2020-01-29 (first published: 2020-01-20)

439 reads

Insperation

by Kenneth Fisher

SQLStudies

Inspiration: The process of being mentally stimulated to do or feel something, especially to do something creative. a person or ... Continue reading

2020-01-29

20 reads

Permissions required for row counts to show up on Object Explorer Details

by Kenneth Fisher

SQLStudies

I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on ... Continue reading

2020-01-23 (first published: 2020-01-16)

394 reads

My experiences with Imposter Syndrome: T-SQL Tuesday #122

by Kenneth Fisher

SQLStudies

Jon Shaulis (blog|twitter) is hosting T-SQL Tuesday this month. Thanks Jon! And the subject is obvious if you read the ... Continue reading

2020-01-21 (first published: 2020-01-14)

566 reads

Help! My restore has finished but the database still has a status of recovering.

by Kenneth Fisher

SQLStudies

I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, ... Continue reading

2020-01-17 (first published: 2020-01-08)

698 reads

What is the program_name in sys.dm_exec_sessions?

by Kenneth Fisher

SQLStudies

If you’ve ever looked at the output for sys.dm_exec_sessions you may have noticed the column program_name. Frequently you’ll see entries ... Continue reading

2020-01-13 (first published: 2020-01-06)

639 reads

All authors

Kenneth Fisher

#PowershellBasics: Get input using Read-Host

SQL Homework – February 2020 – Write a blog post.

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

Changing the owner of a schema removes all direct permissions of objects owned by the schema.

Common commands and tasks to make dealing with Windows Core easier.

Insperation

Permissions required for row counts to show up on Object Explorer Details

My experiences with Imposter Syndrome: T-SQL Tuesday #122

Help! My restore has finished but the database still has a status of recovering.

What is the program_name in sys.dm_exec_sessions?

Blogs

Take Time to Gain Perspective

The Fringe Festival

Demo for Parameter Sniffing and Memory Grant Feedback

Forums

Fulltext filter daemon host (FDHost) process has stopped abnormally

Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer

Database Mail Configuration

Question of the Day

Database Mail Configuration