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

Automation starts by doing something once, very very carefully: T-SQL Tuesday #110

by Kenneth Fisher

SQLStudies

After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s...

2019-01-08

217 reads

Identity in a SELECT

by Kenneth Fisher

SQLStudies

Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?
SELECT
IDENTITY(INT,...

2019-01-02 (first published: 2018-12-19)

7,687 reads

SQL Homework – January 2019 – Baselines

by Kenneth Fisher

SQLStudies

Happy New Year! Every year for New Years we all make a big deal of coming up with New Years...

2019-01-02

1,080 reads

Using Microsoft Learn

by Kenneth Fisher

SQLStudies

I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...

2018-12-31

444 reads

Oh Query, Query, Query

by Kenneth Fisher

SQLStudies

I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...

2018-12-18 (first published: 2018-11-28)

2,766 reads

Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

by Kenneth Fisher

SQLStudies

Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...

2018-12-17

1,054 reads

Bulk insert and an identity column

by Kenneth Fisher

SQLStudies

TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...

2018-12-12

1,117 reads

Moving SSISDB is not as easy as it sounds

by Kenneth Fisher

SQLStudies

We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...

2018-12-10

248 reads

My backup script (where, how, how big, etc.)

by Kenneth Fisher

SQLStudies

A while back I wrote about how to find where your backups are. And I’ve also written about I use...

2018-12-10 (first published: 2018-11-26)

2,092 reads

UDL files and connection strings

by Kenneth Fisher

SQLStudies

A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...

2018-12-05

7,471 reads

Blogs

Wait… Could This Be the End of Index Maintenance?

By Monica Rathbun

While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...

Copilot on the Power BI Report Canvas vs. Modern Report Builder

(This is the second post in a three-part series on how AI is changing...

The #MS_DatabaseConnector## Role: #SQLNewBlogger

I had seen these roles in various instances, but never dug into the new...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server

Comments posted to this topic are about the item Packing and Decoding Device Status...

SQL Server Audit Failures

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Audit Failures

Visit the forum

Question of the Day

SQL Server Audit Failures

If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?

See possible answers