SQL Quiz Part 2

Posted: December 9, 2008 in Uncategorized

The first SQL Quiz that I did, had some results that I could not anticipate. I hope that we created a chain where people can learn from the mistakes that DBA’s have made in the past. There has been a number of great results and a number of great stories. I would like to start another Tag Quiz Game. I hope that this one has the same results as the first one. This way we can continue to get great information from Many DBA’s.

Sp here are the rules, please answer the question with at least two answers, once you have completed the answer please tag 2 people that you know to answer the questions as well. If you get tagged by this Quiz please let me know I would like to add all the results to the bottom of this blog so all the answers are in one place.

The Questions for this quiz…

What are the largest challenges that you have faced in your career and how did you overcome those?

Here are my Answers…

The first may sounds sort of simple for most DBA’s but it was a big challenge that I was facing when I first started working with SQL Server. I worked at a company where the database was in 100% stored procedures. We were supporting a web page that was answering 10,000+ requests a day on SQL Server 6.5. There was a business need to know what people were searching for on the database the most often, however since or traffic was very sporadic we put 3 SQL Servers behind the web servers to take the load. This was easy because we could create transactional replication and push from one publisher to two subscribers. The only time the database was written to by people internal to the company.

The thing that I found myself to be most proud of was the fact that I needed to be able to gather all the stored procedures execution parameters. So I need to know what City was being searched in the most. Or what category was being searched in the most often. The way that I tackled this problem: I modified the Stored Procedures to do a quick dump of the parameters into a single table. Then I replicated tables from Server 1 and Server 2 to Server 3. I then had Server 3 combine all the results into one database and created a query to group the searches. I then used SQL Mail to send the results to myself and the CEO. This way we knew what was being searched on most often and we were able to use that in our Marketing.

My Second Answer…

Again this is a little old school but I was working at a resale company. This company had no way to see the enterprise in a fashion where the health of all the SQL Servers were being monitored. This was pre SQL Server 2008. I installed on all 60 plus of the server SQL H2 and was able to start working on some custom reports. It was very satisfying that I could tell the CTO that a server that was 2000 miles away was going to run out of disk space in about 60 days if we did not make a change. Now that SQL H2 has gone the way of the Dodo bird, Data Collector looks to be a great replacement.

Now that they are down on paper they do not have the same feeling as they did when I completed the actions. I would love to see what Jason Massie and Brent Ozar Have to say about this.

Here are the others that have taken the Quiz that I know of…

If you have noticed that I missed one please let me know.  I don’t always get a ping back on the ones that have been answered.

About these ads
Comments
  1. [...] Chris Shaw posted a new SQL Quiz where he asks: “What are the largest challenges that you have faced in your career and how did you overcome those?” [...]

  2. [...] Chris Shaw posted a new SQL Quiz where he asks: “What are the largest challenges that you have faced in your career and how did you overcome those?” [...]

  3. [...] admin on Dec.09, 2008, under SQL, Tech Chris Shaw posted out a new SQL Quiz on this blog.  Various SQL Server Professionals have been tagged since [...]

  4. Tim Ford says:

    I’ve answered the call from Brent Ozar. I will now ping Tom LaRock and Joe Webb for their answers. My answer is located here: http://www.ford-it.com/sqlagentman/

  5. [...] he did it again, and I got tagged by Denny and Tim (who apparently does not read or subscribe to Denny’s [...]

  6. SQLBatman got me and I posted my answer at http://jmkehayias.blogspot.com/ and called out Kendal Van Dyke and Deepak Ranagarajan for their answers.

  7. [...] Chris Shaw called us out again. This time, it was Tom LaRock who tagged me in this round. This time around, the question is ‘What are the largest challenges that you have faced in your career and how did you overcome those?’ [...]

  8. [...] Quiz Part 2 Gee, thanks TJay. I have apparently been tagged to take part in a quiz started by Chris Shaw. It’s an experiment in learning where a series of people answer the same question, hopefully [...]

  9. [...] Chris Shaw posted a new SQL Quiz yesterday, asking “What are the largest challenges that you have faced in your career and how did you overcome those?” Brent Ozar tagged me when he responded to Chris’ challenge. [...]

  10. [...] I’ve read a number of responses from Chris Shaw’s first DBA networking quiz.  I missed out on the first one, but I have been tagged by Grant Fritchey for the second round. [...]

  11. [...] Chris Shaw posted a second SQL Quiz where he asks: "What are the largest challenges that you have faced in your career and how did you overcome those?” [...]

  12. [...] Peschka talks about soft skills – there’s another DBA quiz going around from Chris Shaw, and there’s a lot of good answers out there, but Jeremiah’s is notable [...]

  13. I posted my response (http://tinyurl.com/623var) and tagged Andy Warren and Jack Corbett.

  14. [...] circle of tags, let's see if Andy Warren and Brian Knight, my business partners, can continue Chris' challenge. Comments There are no comments on this post Leave a Comment Only members of [...]

  15. [...] a question I’ve seen a lot this past week after Chris Shaw started tagging people with the question. I first noticed this on the Scary DBA blog (Grant Fritchey) and since then [...]

  16. [...] was recently tagged by Tim Mitchell to give a response to Chris Shaw’s SQL Quiz Part 2 so here it goes.  It looks like most people who have answered have pretty long responses but I [...]

  17. [...] Chris Shaw’s SQL Quiz: Interesting reads; feeling a little left out that nobody tagged me.  Could be that I cal myself a developer these days, instead of a DBA (one of these days I need to write a post on that topic).   Anyway, you may also want to check out the following responses: [...]

  18. [...] diabolical idea of Chris Shaw. I'm actually late to the game because I got tagged a week ago by Jason [...]

  19. [...] those pingbacks; I lament felling left out of Chris Shaw’s quiz, and the next thing you know, he tags [...]

  20. [...] also tagged me to tak part in Chris Shaw’s second SQL challenge – “What are the largest challenges that you have faced in your career and how did you [...]

  21. [...] Chris Shaw posted a SQL Quiz, setting it up as a game of tag, and I got my tag from SQL Fool (@SQLFool on Twitter) when she answered the question -“What are the largest challenges that you have faced in your career and how did you overcome those?” [...]

  22. [...] Recent highlight: SQL Quiz Part 2 [...]

  23. [...]  Got tagged again. Here are the details: [...]

  24. […] Chris Shaw posted a new SQL Quiz where he asks: “What are the largest challenges that you have faced in your career and how did you overcome those?” […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s