Skip to content

Instantly share code, notes, and snippets.

@rusanu
Last active August 29, 2015 14:04
Show Gist options
  • Save rusanu/80d576523585601e6710 to your computer and use it in GitHub Desktop.
Save rusanu/80d576523585601e6710 to your computer and use it in GitHub Desktop.
The Accidental DBA (SQL Server)

Work in progress.

Who

I am a developer with my company. I like to learn new things so I snooped at our SQL Server instance. In no time I ended being the 'go to' person for it and now am a de-facto DBA. My job is still 110% dev, DBA duties are the extra percents left...

I am a sysadmin with my IT department. I was asked to take care of the SQL Server instance installed to serve the management reports. I read some things about SQL Server administration and I'm not keeping an eye on it. I wish I could use cron jobs.

I am a PowerPivot wizard. My buddy helped my create this daily job that imports the sales into my own database. I installed the SQL Server myself.

I manage Sharepoint deployments for our customers. I know Sharepoint has a SQL Server instance.

What

I know databases needs to be backed up. I take a database backup every week. The backups are stored on my workstation disks.

The data in my server is important. My company would survive loosing this data, but some people would be furious.

If the server would crash today I wouldn't know what to do.

I am often asked to look at database performance problems. I know how to look at execution plans but they're voodoo.

I know there are service packs, but I don't keep track of them. I don't know what a cumulative update is.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment