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

Backup a password, change it, then restore it.

by Kenneth Fisher

SQLStudies

A couple of months ago I talked about moving a login from one server to another without the password. The...

2013-06-05 (first published: 2013-05-30)

2,327 reads

Easy way to generate a restore script.

by Kenneth Fisher

SQLStudies

Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....

2013-06-05

989 reads

Pattern searches beyond ‘%string%’.

by Kenneth Fisher

SQLStudies

I was asked today to take a table with a social security column and put all 0s if the column...

2013-06-03

898 reads

Using CROSS APPLY to calculate an aggregate across a single row.

by Kenneth Fisher

SQLStudies

I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...

2013-05-28

1,399 reads

The many uses of CROSS APPLY

by Kenneth Fisher

SQLStudies

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...

2013-05-23 (first published: 2013-05-20)

21,456 reads

Using CROSS APPLY instead of a calculated variable

by Kenneth Fisher

SQLStudies

Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working...

2013-05-22

863 reads

CREATE SCHEMA can do what?!?!?

by Kenneth Fisher

SQLStudies

So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...

2013-05-21 (first published: 2013-05-15)

4,108 reads

Dragging a name from the object explorer to a query window

by Kenneth Fisher

SQLStudies

In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...

2013-05-16 (first published: 2013-05-13)

3,823 reads

Comparing an inner join vs a subquery

by Kenneth Fisher

SQLStudies

I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...

2013-05-08 (first published: 2013-05-03)

5,889 reads

Free SQL Books

by Kenneth Fisher

SQLStudies

I was looking for a way to put BOL on my Kindle when I found a few good links I...

2013-05-08

1,196 reads

Blogs

How Redgate Flyway Can Boost Your DevOps Journey

A brief introduction to the tool and its advantages for database migrations DevOps is...

Building a Docker image with Docker Build Cloud

By Andrew Pruski

In a previous blog post we went through how to build a Docker container...

Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond

By Tracy McKibben

Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...

Read the latest Blogs

Forums

The Marked Transaction

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Marked Transaction

What happens when we drop a column on a SQL Server table? Where's my space?

By Cláudio Silva

Comments posted to this topic are about the item What happens when we drop...

Sort comma delimited string in column

I have a column that contains comma separated values. I'm trying to figure out...

Visit the forum

Question of the Day

The Marked Transaction

I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?

See possible answers