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

Database default locations

by Kenneth Fisher

SQLStudies

One of the options you had when installing your instance was setting some default file locations.
Defaut data file locationDefault log...

2014-10-01 (first published: 2014-09-29)

8,113 reads

Intro to Auditing in SQL Server on SQL Shack

by Kenneth Fisher

SQLStudies

I had an article published yesterday on http://www.SQLShack.com.
Intro to Auditing in SQL Server.
It’s worth reading if I do say...

2014-10-01

1,224 reads

Changing configuration settings with sp_configure

by Kenneth Fisher

SQLStudies

I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...

2014-09-24 (first published: 2014-09-22)

7,924 reads

What I know about batch files

by Kenneth Fisher

SQLStudies

For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how...

2014-09-24

624 reads

What are trace flags?

by Kenneth Fisher

SQLStudies

Trace flags are one of those things that I’ve heard about more and more over the last five or six...

2014-09-18 (first published: 2014-09-11)

7,955 reads

Triggers are not toys!

by Kenneth Fisher

SQLStudies

For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL...

2014-09-17

1,441 reads

I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

by Kenneth Fisher

SQLStudies

Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this...

2014-09-15

1,189 reads

T-SQL Tuesday #58: Passwords

by Kenneth Fisher

SQLStudies

It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host...

2014-09-12 (first published: 2014-09-09)

6,721 reads

Finding a job!

by Kenneth Fisher

SQLStudies

I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years...

2014-09-04 (first published: 2014-08-27)

7,704 reads

Pausing an MSSQL Instance

by Kenneth Fisher

SQLStudies

I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop...

2014-09-04

3,859 reads

Blogs

Take Time to Gain Perspective

By Brian Kelley

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Demo for Parameter Sniffing and Memory Grant Feedback

By MarlonRibunal

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Read the latest Blogs

Forums

Fulltext filter daemon host (FDHost) process has stopped abnormally

We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...

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

By Cláudio Tereso

Comments posted to this topic are about the item Automating OSM Data Refresh in...

Database Mail Configuration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Mail Configuration

Visit the forum

Question of the Day

Database Mail Configuration

If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?

See possible answers