Archive

Posts Tagged ‘CSSUG’

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: , ,

Chicago SQL Server User Group October Meeting

October 15, 2012 1 comment

Last Thursday was the October meeting of the Chicago SQL Server User Group. This was the fourth meeting that Aaron Lowe (b|t) and I have run and things have gone remarkably smoothly. Many thanks to Bill Lescher (t), Ross LoForte and all of the folks at the Microsoft MTC for providing us a solid foundation and great facilities to work with.

The sponsor for this month’s meeting was SWC Technology Partners. Erica Lee and Lowry Kozlowski spoke about the company and the positions they have open. Thanks to Erica, Lowry and SWC for their time and for the pizza.

That brought us to the presentation portion of the evening. I was on deck to give my first presentation in front of a user group, entitled Interrogating the Transaction Log. While I hadn’t practiced as much as I would have liked, I’d run through the various sections enough to be confidently nervous. I feel like I did a decent job, but would have definitely benefited from some additional practice. The only glitch I ran into was that my laptop refused to go into duplicate presentation mode, which meant I had to keep looking over my shoulder during the demos. Despite that, the feedback I received was positive and a number of people told me they had learned something new, which was why I wanted to present in the first place.

Thanks to everyone who attended the meeting and provided feedback. Further thanks to Jes Borland (b|t), Paul Randal (b|t), Kimberly Tripp (b|t), Brent Ozar (b|t), Aaron Lowe and all of the others who have provided encouragement, inspiration and advice.

Thoughts on the Chicago SQL Server User Group

July 18, 2012 1 comment

It is official. Aaron Lowe (b|t) and I are the new co-presidents of the Chicago SQL Server User Group. Our first meeting was last Thursday, and it went off without a hitch. Many thanks to Rick Alaras and Casey Gwozdz from Computer Associates for their presentation on Erwin and for the pizza. Also, thanks to Ross LoForte and the rest of the Microsoft staff for their continued support of the user group. Finally, eternal gratitude to Bill Lescher for his 10 years of service running CSSUG. The example he set made me want to get involved.

One of the things Aaron and I are interested in doing is giving people a safe environment to begin presenting on SQL Server topics. Jes Borland does a great job describing the effect presenting can have on one’s personal and professional development and the role that user groups can play in this post.

The Professional Association for SQL Server has local user groups worldwide. If you aren’t a member of PASS, register. If you are a PASS member but aren’t active in your local user group, get involved. And if you live in the Chicago area and are interested in presenting at CSSUG, feel free to contact Aaron or me. Any SQL Server-related topics are welcome, and presentations can be as short as 15 minutes.

Categories: CSSUG, PASS, SQL Server Tags: , ,