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

SQLStudies

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,094 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, 416 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

5 comments, 1,349 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, 455 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

7 comments, 552 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.

CREATE…

Read more

0 comments, 426 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,597 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:

KennethFisher_SQLServerSecurityforEveryone_20151013

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

  • I use relink…

Read more

2 comments, 348 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

0 comments, 315 reads

Posted in SQLStudies on 2 November 2015