skreebydba

I have been working as a SQL Server DBA for about six years and my interests tend toward internals. However, I’ve been co-president of the Chicago SQL Server User Group since July of last year and in that time I’ve met a number of people who have been interested in working as a DBA but don’t know where to get started. This has inspired a series of posts covering an introduction to SQL Server. Topics covered will include:

• An overview of relational databases and SQL Server
• Downloading and installing SQL Server
• Creating a database
• Creating a table
• Creating an index
• Methods for loading test data
• SQL Server security
• Database backup and restore
• SQL Agent jobs

I am planning on posting these topics once a week over the next few months. If you have questions about a post or are interested in seeing other topics covered, let me know in the comments.