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

Make BOL your friend

by Kenneth Fisher

SQLStudies

One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...

2014-06-30

4,045 reads

Dealing with a long string

by Kenneth Fisher

SQLStudies

Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...

2014-06-25

2,554 reads

sp_SrvPermissions & sp_DBPermissions V5.0

by Kenneth Fisher

SQLStudies

These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...

2014-06-23

689 reads

Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.

by Kenneth Fisher

SQLStudies

Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...

2014-06-20 (first published: 2014-06-18)

2,339 reads

I don’t want to grant permission to all the tables in the database at once.

by Kenneth Fisher

SQLStudies

A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...

2014-06-16

1,166 reads

What is this default trace you speak of?

by Kenneth Fisher

SQLStudies

I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...

2014-06-12

842 reads

MJ Swart offers free technical editing

by Kenneth Fisher

SQLStudies

A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me...

2014-06-09

887 reads

Who has the DAC open?

by Kenneth Fisher

SQLStudies

The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...

2014-06-05 (first published: 2014-05-28)

2,620 reads

15 years of experience with Identity columns

by Kenneth Fisher

SQLStudies

An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...

2014-06-04

1,051 reads

What is the difference between Money and Decimal(19,4)

by Kenneth Fisher

SQLStudies

One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....

2014-06-02

1,973 reads

Blogs

The First Steps: Understanding the Basics of FinOps

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management...

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By Vinay Thakur

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

Read the latest Blogs

Forums

would it be so terrible to install ssms on a few user desktops?

Hi, ssms is free here. I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers