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,102 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,220 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,712 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

623 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,933 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,440 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,186 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,717 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,700 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,835 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