SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


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 www.sqlstudies.com.

Archives: November 2015

You should always have an “I got hit by a bus” backup plan

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens when your developer, DBA or whoever is hit by a bus?

The situation

User: Oh noes! The web sites down!

One quick call later

Developer: Hmm, it looks… Read more

8 comments, 2,448 reads

Posted in SQLStudies on 30 November 2015

Women in technology

Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s a great read and I highly recommend it. In fact, go read it right now. I’ll wait.

You’re back? Good. So, her article got me… Read more

0 comments, 624 reads

Posted in SQLStudies on 25 November 2015

Using multiple log files

The transaction log is made up of one or more files that are used sequentially. So in other words if you have multiple log files then new log information will only be written within one of those files at a time.

The good
To the best of my knowledge there… Read more

6 comments, 1,520 reads

Posted in SQLStudies on 23 November 2015

Naught to Speaker pt 3

Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass Summit 2015 and was enormously shocked to be accepted as an alternate. Well that was 5 months ago now and a lot has happened since then. I submitted, was… Read more

7 comments, 607 reads

Posted in SQLStudies on 18 November 2015

SSMS Setup

Every time I install a new version of SSMS I make a handful of changes to the default setup. For my own notes, and in case anyone is interested in some of the things you can do with SSMS I thought I’d post a list of those changes.

Physical Layout

Read more

9 comments, 891 reads

Posted in SQLStudies on 16 November 2015

Hiding one or more columns

This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain columns in a table. For example let’s say you have a salary column in your employee table that you don’t want everyone seeing.

There are two fairly simple options.


Read more

0 comments, 618 reads

Posted in SQLStudies on 12 November 2015

Why are you still using datetime?

It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a blog topic for me! In this case it’s the always fun Mickey Stuewe(b/t) and her topic is Data Modeling Gone Wrong. So let’s see ..… Read more

10 comments, 4,817 reads

Posted in SQLStudies on 10 November 2015

Questions from “SQL Server Security for Everyone”

I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by the way.)

First of all here are the PowerPoint slides:


Next there we a few questions I said I would look into and here they are:

  • I use relink…

Read more

2 comments, 513 reads

Posted in SQLStudies on 4 November 2015

Administrative Logins and Users

If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:

Please give me a list of all sysadmins.

This is because members of the sysadmin role are super users. They can do anything they want on the instance. But these… Read more

1 comments, 489 reads

Posted in SQLStudies on 2 November 2015