Archive for the ‘CSSUG’ Category

Blog Series – An Introduction to SQL Server

April 29, 2013 Leave a comment

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.

Categories: CSSUG, SQL Server, T-SQL Tags: , ,

The SkreebyDBA Spring 2013 Midwest Tour Finishes Up

April 14, 2013 Leave a comment

Yesterday was SQL Saturday Chicago, and it wrapped up a week where I presented four times in seven days. Things started out with my presentation at SQL Saturday Madison last Saturday. You can read my post about that here.

The April meeting of the Chicago SQL Server User Group was Thursday and I presented on Tools to Make Make Multi-object Administration Easier. About 30 people turned out and I think it went pretty well. Each time I present, I get more comfortable using ZoomIt and my presentation remote. Thanks to everyone who came out for the meeting, especially to those who provided feedback.

The speaker dinner was Friday night at La Hacienda in Addison. The food was good and the company was better. I met Mark Vaillancourt (b|t) and Hope Foley (b|t) for the first time and was able to catch up with other members of SQLFamily.

I don't know if it was pre-presenting jitters, but I had trouble sleeping and spent a few early-morning hours tweaking my demos and learning how to use a VMWare snapshot. This is the first presentation I've used a VM and I've realized my Windows admin skills are lacking. I plan on getting much practice in the coming months.

Things were well under way when I made to DeVry at about 8:15 a.m. After talking to volunteers Bill Lescher (t) and Bob Pusateri (b|t), I grabbed some grub and made my way up to the speaker's room, joining Aaron Lowe (b|t), Ted Krueger (b|t), David Klee (b|t) and Erin Stellato (b|t). It was my first time in a speaker room and it was great being there with such a distinguished group.

I made my way down to my room as Ed Leighton-Dick was finishing up his presentation on Service Broker and was able to set up. I presented to a group of seven, I am hoping because I was presenting at the same time as Erin Stellato and David Klee. There were some good questions and I am glad to have another presentation under my belt. You can find the slides and scripts from my presentation here.

After lunch, I joined Ted Krueger and Ross LoForte to provide a group of DeVry students an introduction to SQL Server. Ted gave an overview of SQL Server, Ross got into more detail about the various SQL Server components and I finished up with how a database works. I am happy to have had a chance to give back to DeVry, as they've generously donated space for SQL Saturday the last three years.

I closed out the day with Erin Stellato's presentation on Demystifying Database Statistics. I was my second internals presentation of the week, and it reminded me what I love about SQL Server most and has inspired to dedicate more time to studying.

Many thanks to Wendy Pastrick (b|t), Bill Lescher, Ted Krueger, Bob Pusateri and everyone else who made SQL Saturday Chicago such a great event.

SkreebyDBA Midwest Tour – 2013

April 2, 2013 Leave a comment

Saturday, April 6th is the first stop on the SkreebyDBA Midwest Tour 2013. I will be presenting on Interrogating the Transaction Log at SQL Saturday Madison. If you are in the area and would like to register, you can do so here. If you've never been to a SQL Saturday, it is a great opportunity to get a free day of training and meet others in the SQL community.

The second stop on the tour will be the April meeting of the Chicago SQL Server User Group, Thursday April 11th. I will be presenting on Tools to Make Multi-object Administration Easier. If you are interested, register here before 4pm on April 9th.

The final stop on the tour is SQL Saturday Chicago, Saturday, April 13th. I'll be doing the Multi-object Administration presentation again. This will be my third SQL Saturday Chicago, and it is also the third at DeVry University in Addison. DeVry has donated the space each year, and I'll be helping present an introduction to SQL Server to a group of DeVry students with Ted Krueger (b|t) and Bill Lescher (t). You can find more information about SQL Saturday Chicago and register here.

As I said, this will be my third SQL Saturday Chicago. At my first, I saw Jes Borland (b|t) present on Making Your Voice Heard!. Now two years later, I'll be presenting at my second SQL Saturday. I feel extremely fortunate to be a part of the SQL Community and encourage you to get involved as well.