As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections

Posted on by

I just received my e-mail from PASS, which says, “As a PASS Member in Good Standing, you are entitled to vote in the 2010 PASS Board Elections.” I am not sure exactly what a “PASS Member in Good Standing” means, but I guess I qualify as the e-mail provided me with a link to vote. If you are a PASS member, and did not get an e-mail allowing you to vote, please contact PASS immediately to ask them why you did not receive the e-mail.

This year there are three spots available on the board and there are five candidates, including:

  • Mark Ginnebaugh
  • Geoff Hiten
  • Allen Kinsel
  • Douglas McDowell
  • Andy Warren

You can find out more about these candidates at the SQLPASS Board of Directors web page. You can also find interviews with the candidates at Andy Leonard’s blog.

In selecting three candidates I voted for, I had a great difficulty as I personally know four of the candidates, and I would have liked to have voted for all four of them. These include Mark Ginnebaugh, who is a great PASS user group leader and businessman; Geoff Hiten, an outstanding SQL Server MVP and PASS user group leader, and a person who is not afraid to speak his mind; Andy Warren; who has been a long-time supporter of the SQL Server community, and who has shown in his last term of office that he is working towards greater PASS Board transparency; and Allen Kinsel, who has dedicated large amount of his time to the PASS program committee the past several years. All four of these are great candidates, and I can recommend all four of them to anyone who is still deciding on who to vote for.

So if you did get your PASS Board Elections e-mail, be sure you carefully review all of the candidates and select people who you think will lead PASS to a brighter future.

Interview with SQL Server MVP Glenn Berry

Posted on by

This is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections in November 2010. This interview is with SQL Server MVP Glenn Berry (blog | Twitter).

 

Glenn Berry

Tell us a little about yourself Glenn.

After high school, I spent four years in the Marine Corps, serving in the Infantry and in Armor. I got out as a Sergeant and went to college. I have a B.A. in Economics and an M.A. in International Affairs. I initially wanted to be an intelligence analyst similar to Jack Ryan’s character in the Tom Clancy books. I spent a few years as a developer before I grew up and discovered that I liked being a DBA much better. I have been a Database Architect at NewsGator for about four and half years.

Continue reading →

SQL Server Monitoring Checklist

Posted on by

It’s been awhile since I have worked on my checklist series of blog posts that will eventually be turned into a book. This time around the checklist focuses on the kinds of things you might want to monitor on your SQL Server instance to ensure that they are working as you expect.

Unlike some of my previous checklists, this one is different in the fact that the checklist is asking if you are monitoring a particular aspect of a SQL Server instance, and if you are, how you are performing the monitoring, and how often are you performing the monitoring. My goal is not to suggest what you should monitor, how you should monitor, or how often you should monitor, but only to get started thinking about what kinds of things you should be monitoring on a periodic basis. Towards the end of the list I have provided a list of some of the more common ways you might consider monitoring different aspects of your SQL Server instances.

Continue reading →

DBA Tracy Hamlin Wins the 2010 Exceptional DBA of the Year Award

Posted on by

Tracy Hamlin Tracy Hamlin (Twitter) has been voted as the 2010 Exceptional DBA of the Year by the SQL Server community. The annual awards program, hosted by SQL Server Central and sponsored by Red Gate Software, drew the largest number of community votes in its three-year history.

Tracy receives a trophy, full conference registration for the PASS Community Summit 2010 in Seattle, four nights’ accommodations, and $300 in travel expenses. Along with this year’s other finalists – John Burnette of Fidelity Information Services, Jonathan Kehayias of Tampa General Hospital, Ted Krueger of Pharmedium Services, Kevan Riley of Destinology, and Jorge Segarra of University Community Hospital – she receives a copy of Red Gate’s SQL Toolbelt.

Continue reading →

Checkout SQLServerIO.com for Useful Information on SQL Server Storage Systems

Posted on by

At the recent SQLSaturday #28 in Baton Rouge, LA, I had the opportunity to meet Wes Brown (Blog | Twitter), and attend his session on “Understanding Storage Systems and SQL Server”. I enjoyed his presentation and also discovered that Wes has a blog where he shares his deep knowledge of SQL Server I/O. If you are interested in learning more about SQL Server I/O, his blog offers useful posts, presentations, and some software tools he has written for himself. For example, he has a Disk Drive RAID Configuration Tool that you can use to help give you an idea of RAID performance based on drive characteristics and other factors.

How Do You Defragment Your SQL Server Indexes

Posted on by

I give a lot of presentations based on best practices, and in all of them I stress the importance of regularly rebuilding or reorganizing indexes. Both the REBUILD and the REORGANIZE options have their pros and cons, so I thought it would be interesting to do a poll to see which method(s) was preferred by DBAs. The results are to the left.

After seeing the results of the poll (which was not scientifically designed), I was rather impressed with how many DBAs use a combination of both the REBUILD and the REORGNIZE methods to defragment their indexes. To me, this indicates a high level of knowledge of how to best defragment indexes, as using a combination of both options allows the DBA to choose which method is best for a particular index, rather than taking the brute force method of using either REBUILD or REORANIZE to defragment all of their indexes.  I was also impressed that only a very small percentage of the poll’s respondents didn’t defragment their indexes, or know what index defragmentation was.

Continue reading →