桃子视频

Tag: chain-post

Categories
Syndication

What Three Events Brought You Here?

Looks like yet another chain-post going around, this time started by SQL Jedi Paul Randal on ? Interesting question and very similar to one of my very first posts Starting the SQL Journey? So I got , aka , but also , aka , and finally by , aka . I’m guessing since 3 people tagged me I should definitely answer this one so here it goes!

Update: Ok now a 4th , the lovely Donabel Santos aka !

Update deux: Thanks for ()

As I mentioned before I’ve somewhat covered this topic in a previous post but this one is nice as it forces me to choose 3 key points.

1. Leaders Club

In 8th grade I took part in an after-school flag football league put on by the YMCA. The league was ran by a guy named Chris Shraeder. Chris, in addition to working for the YMCA, also led the . While playing in the league Chris asked me and a few others to come join the club. Up to this point in my life I had always been involved in some sort of leadership position such as Student Council or Safety Patrol (yeah that鈥檚 right, I wore that bright orange sash with pride!) but this was the first program truly dedicated to developing leadership skills. Leaders Club gave me the opportunity to lead various groups (teens, camp kids of various ages, even adults when I refereed adult flag football). One of the greatest things that this program allowed me to do was to really learn how to build and foster a community from the inside out and these skills ultimately helped me out a great deal to get where I am today.

2. Attending my first meeting

This was huge for me as it started my path into being involved with not only the local SQL community but ultimately the SQL community around the world! My first job out of college I worked as a desktop technician for the . In this position one of the responsibilities I ultimately took on was administrating a small web server that ran our desktop inventory web app. This app was back ended by an Access database. Yeah, you can already see where this one is going. So because I took a database course in college, and I said 鈥測es鈥� when my manager asked me to be the secondary for the department in SQL Server. The person who was the primary was my friend Eric Byszeski, whom at the time was the desktop staff supervisor as well as my predecessor in my position. He, like me, was also an accidental DBA and I learned what I could from him. Our environment was relatively simple in that we only had one SQL 2000 server that held several databases for small systems. Eric taught me the basics such as how to use Enterprise Manager, how to do backups and restores, and check database integrity. As I kept reading blogs and articles on how to improve your SQL environments my hunger to learn more kept growing. SQL 2005 came out and I soaked up everything I could about it. Luckily I got to stand up a new 2005 instance and got the excitement of setting up a new SQL server from scratch! Looking back I鈥檇 probably slap my old self for some of the choices made but hey, that鈥檚 progress right? Anyhow, in my adventures in learning I came across the fact that there was a user group in the area so I decided to attend. I was blown away by the fact that there were so many people just in my local community with so much knowledge and experience to share! From the local meetings and events, to the various blogs and webcasts, as well as the social networking with others from around the world I was able to grow professionally and personally. When I first started attending that group a few years back I actually did a show-and-tell type presentation wherein I basically admitted to the group that I barely had an idea of what I was doing. Now this week I鈥檓 helping our user group leader organize . It鈥檚 been a hell of a ride and there鈥檚 still so much more!

3. Meeting my Wife

I know that this might seem like a cheesy 鈥済imme鈥� to some but for me this moment truly changed my life. Brace yourself because I鈥檓 about to do some soul-baring, . Prior to meeting my wife I was like many post-college kids. Towards the end of college I picked up the habit of smoking umm鈥laucoma medicine鈥 habit which stuck with me a few years. I was also surrounded with folks around me whom I considered friends but it wasn鈥檛 until I pulled back and realized how negative they all were and I was following the same pattern. My post-college life had me jump from 鈥渞elationship鈥� to 鈥渞elationship鈥�, going out to bars and partying almost every weekend and basically coasting through life. Then I met . One of the great things about her is that she is amazingly positive. At the beginning of our relationship, due to the fact that I always looked at the negatives rather than positives of a situation, we had our issues. As time went on I began to learn to stop being so negative and change my thought processes. During our courtship I did a LOT of growing up and soul-searching. I stopped doing drugs, I quit getting drunk (note: addictive personalities + alcohol = nothing good), I discovered that I have clinical depression and so I needed medication to balance that out, I separated myself from those I thought were friends and found that no longer being around people with negative behaviors really makes a world of difference. Jessica has also been my greatest supporter and best friend throughout everything (which is why I married her!). In terms of my career, one of the toughest things for me to do was leave SWFWMD as I had been there almost 5 years and I was comfortable. I knew I wanted to expand my SQL skills and I needed a place where I could do that. I found an opportunity with (my current employer) and I was truly scared to make the leap but with Jessica鈥檚 love and support I finally made the jump and it has made all the difference. I would definitely not be here professionally or personally if I didn鈥檛 have her in my life and for that I鈥檓 truly grateful.

Tagging Time

Well at first I was going to tag Kevin 鈥淐aesar鈥� Kline since he . So given the fact that it鈥檚 taken me forever to get this post out, and since everyone else seems to have been tagged I am opening this up to the world. If you are reading this and you have a blog, consider yourself tagged!

Categories
Syndication

Goals and Themeword for 2010

Well looks like another chain-post, this time started by none other than the ( on Twitter). He poses the question ““. From there I actually got tagged by not only but also so I guess I’d better reply!

After reading everyone’s posts I thought long and hard about what my theme word would be for this year I decided on (drum roll please):

Organization

As my wife and co-workers will gladly attest to, I battle with A.D.D. (self-diagnoses folks, no official meds/doctors were involved). As I become more involved with the SQL community and finding more things I’d like to do I find I really need to find a system that works and stick with it. Earlier this year I bought David Allen’s ‘‘ book as I’ve heard great things about the methodology and how it has helped folks. Unfortunately I got a quarter of the way in and let my boss borrow it and haven’t gotten it back yet. Fortunately I follow some great folks on Twitter like who write posts about such as which allow me to get the general idea without having to read the book (but I will dammit, I will).

Any who, I’ve already taken some steps to try and get myself organized but this year I’m going to try focusing even more. One of things I’ve done so far is download on my as well as . I still need to organize consistent lists but so far I’ve done half-decent job of adding tasks as I get them and assign them in the few lists I have so far. What I’ve failed to do thus far and will start doing this year is . Apparently this is a key part of the whole process and I’ve been slacking on it. D’oh! Well no more, I say! Another thing I’m going to try to do is little things to help myself get more organized like actually plan out my day rather than just show up to work, do morning checks and wing it the rest of the day. I need something more concrete otherwise my mind wanders all over and all hope is lost.

As far as direct goals I have one glaring goal that is most definitely my number one:

!

  • Yup, that’s right it’s THAT important. I missed out this past year and while it was cool feeling like I was part of the action via Twitter it’s most definitely not the same. There are so many people in the community I’d like to meet and so much good content at that conference that I cannot let another year go by and miss out on the action. I’ll probably get shot down but I’m going to attempt to ask my boss next week if there’s a chance in hell they’ll register me and get the (good until January 15th). Push comes to shove there’s going to be some bank robbing in my future, just sayin’.
  • Other non-felony related goals include me finishing what I started and getting the last two certifications knocked out so I can be a full-fledged MCITP:Database Administrator. My first and only certification is in 2005 so if I’m feeling froggy this year I’ll not only knock out MCITP but I’ll take the upgrade exam as well to make it a 2008 one. Also in the distant horizon I was considering doing the database developer track as well. We’ll see how that goes.
  • I’m in mid process now but I’ll add it here too: writing first book. Right now I’m currently co-authoring with and . We’re all very excited about this book and hope to have it published in March/April time frame I believe. This has been a very interesting challenge so far and hopefully the next book I get to write won’t be so tough based off this learning process.
  • In the last couple of weeks myself and some coworkers have started dabbling in application development using VB.NET which has got me excited to all sorts of new opportunities. I’m hoping to learn more about application development and pick up some C# as well and start creating some truly helpful in-house applications to help support our staff at work.
  • Continue speaking/presenting/blogging. This year I’m planning on submitting presentation to PASS and see where that leads. Maybe company will pony up the cash if I’m a speaker at the conference! Honestly I just really enjoy presenting and teaching so even if I don’t get to present at a major conference I’ll continue doing rounds in Florida user groups and any other group that will have me (via LiveMeeting).
  • Compete in a major fitness event (i.e. triathlon or marathon). Seeing Tom talk about and seeing others go out and do similar feats I figure “why not me?”. My wife and I are also fans of the The Biggest Loser on NBC so watching them run a marathon especially after everything they’ve gone through I think I should be able to do the same. This year I downloaded the Couch to 5k app on my iPhone and I’ve stopped/started program a few times. I need to see it all the way through and keep pushing from there. Hopefully by year’s end I can say I’m a marathoner. We’ll see how that develops.
  • [Late addition] I’d like to blog more technical articles. I started this blog not really knowing how or what I’d be blogging on or about but I’d really like to add more technical content to my..err content. I’m going to aim for doing at least 4 submissions to one of the major sites like SQLServerCentral this year.

Well that’s all I can think of for now but at least this gives me something I can refer back to later and see where I’m at. Now time to tag a few folks:

Ron Dameron (– )

Jonathan Gardner ( 鈥� )

Tim & Lori Edwards ( 鈥� 鈥� )

and just for kicks lets get out of the SQL circle and have my wife try one out:

Jessica Segarra (– )

Categories
Syndication

DBA Horror Stories

In light of the fact that this weekend is Halloween I figured this would be a great time to start this meme: Give us your best database/IT horror story to date.

I鈥檝e been fortunate to date as far as the databases I鈥檝e dealt with not having any crazy problems. For that I鈥檓 thankful. Given that fact my story is more of a general IT horror story. It was a dark and stormy night (actually it was clear, humid, hot day day but those don鈥檛 work as well for these). I woke up this fine morning to hear the call with the two words every IT pro dreads to hear: major outage. As I got into work, fueled up on coffee I got details of what happened that fateful morning.

Every month our operations staff does a generator load test wherein we switch from commercial power to generator power for testing. On this day, however, the generator felt saucy and fate gave us the finger. They threw the switch as they had done so many times before when 鈥渟omething happened鈥� and a major failure happened in the generator. Normally this wouldn鈥檛 be too bad as you can switch right back to commercial power but, nay, not this day. For some reason the switch was unable to cut back so our whole data center went down faster than Balloon Boy鈥檚 family credibility. Like over-caffeinated monkeys on speed everyone leapt to action to find out the extent of the affected systems and implement the appropriate DR plans. After some scrambling the picture looked bleak. Despite having an alternate data center it turned out some of the systems on that side relied on the SAN鈥n the datacenter鈥hat was now down and out. Awesome. Over the next few hours meetings were held to determine which systems needed to come back up, in what order (yes, I know, this should have already been established but as we soon discovered our DR plans were dated). Power was restored by noon and that鈥檚 when the real work began.

As we began bringing systems back online a flurry of disk checks and fixes began. Things slowly began shaping back to normal as everyone hunkered down and brought everything back up. But not all was well in Whoville. Ripping out a SAN from underneath servers is not the greatest thing to happen. To make matters really awesome we鈥檙e a heavy VMware shop and guess where our VMDK files are? Yeah鈥ell in the midst of the madness we lost 2 LUNs due to corruption. Couple this with the fact that some of those servers turned out not to be backed up and needless to say you have a recipe for pure FUN! The good news is we have a good staff of dedicated folks who stayed as long as it took to get as many systems back online and working again. By 2:00 am (the failure occurred around 7:00 am) we were 95% back up and running with no major losses of data. Over the next few weeks I got the pleasure of working the every living hell out of the restore feature of Arcserve as well as check and double-check servers were being backed up.

Moral of the story is:

Have an up-t0-date DR plan, you never know when disaster is going to strike. Jonathan Kehayias recently about this.

Time to do some tagging:

(since I mentioned him already)

aka MidnightDBA (let鈥檚 put that new netbook to work ;-D )

Happy Halloween everyone!

Categories
SQL Quiz Syndication

Database Mirroring Freak Show 鈥� SQL Quiz from Chris Shaw

Chris Shaw ( | ) started another . He tagged , Brent tagged and Tom tagged me. This particular quiz is a two-part question and here are my responses. Excuse my lack of wit and charm. It鈥檚 late, my caffeine supply is running low and my cat is eyeballing me in a most peculiar fashion.

Do you feel that you have a reliable SAN solution? If so, what鈥檚 the secret?

It鈥檚 hard for me to answer this one given that just a few weeks ago our data center (SAN included) came crashing down hard. Now given that the problem was a faulty generator test and not the SAN itself that was the problem I can鈥檛 really place blame there. Honestly I can鈥檛 say anything really bad about our SAN. Tons of disk space, tons of cache, it does what its supposed to do. We鈥檙e also in the middle of finding a replacement for a SAN administrator so what SAN solutions we have in place now could radically change in the coming months. As far as secrets go I鈥檇 say you just need to make sure you have an open line of communication with your SAN administrator. They have no idea what鈥檚 going on in your world and you have no idea what鈥檚 going in theirs. Clear communication of needs need to be there as a SAN admin worth his salt is going to know what they need to do on their end to make sure you get the best performance on your end (i.e. proper RAID levels for your LUNs depending on needs, I/O throughput, etc.).

Explain Database Mirroring in layman鈥檚 terms

Everyone else seems to be giving off-the-wall answers to this so I鈥檒l give it a go as well. Not going to lie, took me a good portion of my drive to Melbourne last week to finally come up with an example.

Think of clustering as a conjoined twin. You鈥檙e talking to the same body. Both heads can hear the conversation but ultimately the two are stuck together because they have to share the same base trunk. Now if you were to punch one twin in the face and knock him out you鈥檇 still be able to talk to the other head but you鈥檙e still lugging around that base. Now, imagine a set of regular twins (non-conjoined). This is your database mirroring in that you have two separate entities. You knock one out but the other is still chugging along just fine. Only difference being that the location of the second one doesn鈥檛 really matter because he doesn鈥檛 have a shared trunk to deal with. I鈥檓 sorry if that explanation sucks, if you鈥檙e bored written by someone who doesn鈥檛 have a fascination for using genetic defects to compare feature sets. Ok time for me to tag a couple of unwilling victims fellow bloggers: