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,103 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,745 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,935 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,703 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

Advice I Like: Rewards from Work

The greatest rewards come from working on something that nobody has words for. If...

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...

Why your data still can’t answer a simple question

By Joyful-Craftsmen

Every organization I talk to has the same problem dressed up in different clothes....

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Comments posted to this topic are about the item The day-to-day pressures of a...

Analysis Services Model w/ Direct Query and (Default Veritpaq)

Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...

Don't Panic

By Grant Fritchey

Comments posted to this topic are about the item Don't Panic

Visit the forum

Question of the Day

Identities and Sequences IV

When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?

See possible answers