Cleveland DBA

SQL Server administration in Cleveland, OH

The problem with SQL Saturday…

The problem with user conferences is that they usually leave me with a slight case of ADD the following Monday.  So much stuff, I have to try it all NOW!!!  SQL Saturday #75 this past weekend in Columbus was no exception.  There were some really good presentations and for a couple time slots it was tough choosing which one to attend.  Here’s a very brief recap of the sessions I went to.

Baseline Basics – Erin Stellato (blog|twitter):  This was a really informative presentation, a lot of information.  I’ve done baselining in the past using Perfmon and, more recently, Powershell.  But the best part of this presentation was the second half where Erin discussed analytical methods.  I’m looking forward to checking out PAL (Performance Analysis of Logs).  In fact, I’m running a Perfmon baseline right now just so I can check it out.  There’s also ClearTrace  for analyzing Profiler traces.

SANs and SQL Server – Kevin Boles (twitter):  I really need to get more involved in the hardware configuration of our database servers.  Ours is an environment where the “SAN guys” only want to know how much disk you need and where you want it attached.  The DBAs don’t have much more input beyond that.  That needs to change.

Build your own SQL Server Cloud – Sarah Barela (blog|twitter):  Externally hosted clouds didn’t allow Sarah the kind of control she wanted over the environment, so she decided to build her own.  In this session she provided a somewhat high-level overview of what the requirements were for her cloud and how she accomplished them using Hyper-V, mirroring, resource governor etc.

SQL Server Partitioning – Kevin Boles:  A good overview of partitioning, some best practices, and some shortcomings.  To date we have not used partitioning here, but this is good information for our datawarehouse team.

The 4-hour DBA – Sarah Barela:  This one was about automating the tasks you perform regularly and also partly about letting go of some of the control over your environment.  I know, that last part can make a DBA squirm.  I was hoping Sarah would provide more concrete examples and/or scripts, so I was a little disappointed, but it did get me thinking about the tasks I personally hate doing and how I can automate some of them.

WIT Lunch – Sarah Barela, Jen Myers (blog|twitter), Erin Stellato and Jes Borland (blog|twitter):  This was a very interesting discussion on how to encourage more young people (not just girls/women) to consider a career in technology.  Good stuff.

But I think the best part of this SQL Saturday was meeting and speaking with such wonderful people.  There was a discussion after the event about how supportive the SQL Server user community is and how unique they are (or seem to be) in that respect.  Where else do you have people giving up their personal time, be it evenings at user group meetings, or whole Saturdays (whole weekends for some out-of-towners) to help their colleagues improve their skills?  It’s fantastic!

June 13, 2011 Posted by | Professional Development | , | Leave a comment

Stuff I learned today – XML and CLR

Well, to say I “learned” about XML and CLR is a bit disingenuous.  More accurately, the instructor went over XML and CLR.  But to be honest, I know so little about either subject that it was a bit like listening to Charlie Brown’s teacher.  But anyway, we covered it and it gave me some ideas as to how they can be used, so I’ll have more to offer the next time a developer comes to me asking “How can I…”  And that was kind of the point of picking this class in the first place.

In other news I’m heading down to Columbus this weekend for SQL Saturday #75.  I’m looking forward to some good sessions to cap off this Week ‘o SQL Learnin’.

Have a great weekend folks!

June 10, 2011 Posted by | Features, General, Professional Development | , , | Leave a comment

Women In Technology

You’re probably aware that March is Women’s History Month, and even the SQL Server community is celebrating.  Here are a few of the events for this month:

SQL University – Women in Technology Week

If you haven’t already checked out SQL University, you really should.  For one thing, it’s free.  For another, it’s community driven.  Bloggers are spending their time to provide you with a quality SQL Server education.  And did I mention it’s free?  This week the focus is on Women in Technology (WIT).

24 Hours of PASS

Another free (!) resource, 24-hours of PASS is a 24-hour blitz of webcasts on SQL Server topics from database administration to business intelligence to development.  This time around all of the sessions are being presented by women.

SQL Saturdays

Depending on where you are, there may be a SQL Saturday going on in your area this month.  SQL Saturdays are generally free (there may be a small fee for lunch), and are great ways to learn and get involved in the SQL Server community.  And most of them have a WIT panel/discussion.

Bloggers

Take some time this month to check out some of the fine women (including yours truly) blogging about SQL Server and all things geek.  I’ve listed a few on my new blogroll to get you started.

Now get out there and celebrate that geeky woman that makes your life and work easier.  Maybe bring her some bourbon.  I hear she likes that.

March 10, 2011 Posted by | General, Professional Development | , , , | 1 Comment