Entries Tagged 'Journal' ↓

At the recent PASS meeting for the Las Vegas Chapter, I gave a quick talk on filtered indexes for SQL Server 2008.  I posted a powerpoint presentation over at slideshare.net, check it out!

We had a few people over last night to check out Kalen Delaney’s new  DVD from http://sqlserverdvd.com. I decided to have a database movie night and invite a few professionals from the Las Vegas area where I live.  I invited about 10 people, but due to my poor planning and short notice only a few were able to attend.  The group was distributed pretty evenly among the many faces of the DBA: a BI specialist, a software developer with responsibilities in SQL Server, and a guy who does tech support for about 150+ sites running SQL 2000/2005 but doesn’t really ever have to deal with anything more than adding accounts or moving data around.  At around 7:30PM on a balmy spring evening we plopped down on my oversize couches, snaked power cords all over the living room, calmed my dog down and got to business.

The DVD, for those of you that don’t know, is the first in what appears to be a 10 part series from Kalen Delaney that essentially mirrors her 5 day course.  Imagine, getting a 5 day training course from a seasoned professional for about $300.  That is exactly what you’re getting, without the crappy hotel and bad coffee.  Chuck Boyce has built a little community around the project and in under a few months has already recruited a new player with a new DVD.  Being that the best video training for SQL Server has been amateur and uninspired up until now, we’re seeing something really important happen.  The majority of the people who don’t like reading have been forced to in the past to learn by experience or through a mentor.  For what may be the first time in history, people who don’t like to read and don’t have the money for expensive personal training can become the kind of DBAs that the world needs : capable, well informed, and extremely knowledgeable about the details that keep the software running.  After looking at the course outline as a group, there are some subjects that people were positively frothing for…especially indexes!

The DVD was great in that there was something for everyone. Despite having read Kalen’s book about the SQL storage engine, I myself found some new and interesting information, and I think everyone in the group walked away with some information that was important to them. The video also did something somewhat unexpected, for me, and that was it raised questions about not only the content of the video (which were easily explained by at least one person in the group) but also regarding real life scenarios that were only loosely tied to the topics of the video.  People were discussing everything from strange lockout and error issues on testing servers with only two users (hint : temp tables are BAD) to asking questions like “Just what the hell is socks and how does it apply to SQL?”  (Once we figured out he was talking about Sarbanes Oxley, the explanations came quickly and easily.)

I found that about half of our four hour viewing time was spent paused and talking amongst the group.  This is a really great way to watch the DVD as it keeps the topics lively and helps you to see these lessons from perspectives other than your own.  Kalen gives you the facts, but it is up to you to creatively use the information to your benefit.  While she often gives examples for useful ways to apply her knowledge, there is no way that she can cover every possible situation, but you can get a lot closer with 4 people from different jobs putting their brainpower into figuring out how to best utilize the information.  This is not to say that you won’t get anything out of watching it alone, you’ll just have to think a little harder and watch it a few more times.  I plan on watching the DVD one more time just to make sure that I didn’t miss anything.

We spent a lot of time paused and discussing the ramifications of the DVD, especially what to do with the DMVs and how they could apply in the real world for someone like a developer (Pro tip : it is a great way to get your boss to upgrade your development machines!!)

Kalen’s speaking voice was great and she didn’t stumble much, like most presenters do. She is obviously confident and comfortable in her knowledge and being in the public eye.  She doesn’t have any strange speech patterns to distract you, and she has no facial or vocal tics which makes it very easy to watch her and focus on the material at hand.  Nothing drives me crazier than a presenter or teacher that takes over the stage and puts the subject matter in the background.  Kalen understands this, obviously, and while being fresh, personal, and well spoken she is not the focus of the lesson, the subject matter is.  One thing I did notice was that the sound changed dramatically from the lessons to the demos. I’m not sure if it was going from mono to stereo or from stereo to surround, but it was apparent on my surround setup.  Audiophiles beware, but for everyone else I recommend laughing it off and pointing fingers, because you probably won’t hear it over normal TV or computer speakers.  As for the production values on the rest of the disk, they’re great.  The picture was clear on my TV, there was no hum or static, and Kalen’s voice was right up in the front rather than her keyboard, her CPU fan, or anything else that you commonly get on instructional DVDs.  You won’t be disappointed with the quality, and it really does give you a feeling of being in a classroom environment.

It is great to see some decent video training for once.  This is a great thing for the community.  Most of all I’m excited to see the people that I know with a passing interest get more involved in the future of the database-fu, and I can only imagine that this kind of enthusiasm will spread if we get enough enthusiastic database pros passing the url to SQLServerDVD to the baby DBAs of the world.

On a side note, before you watch this DVD stick it in your computer and copy the script files.  There are some places that claim the scripts are on the website, but the only thing on the website is a quick note to let you know about the files on the DVD.   I think the scripts should be posted on the website as well as the DVD! We just typed our queries and notes in because we were too lazy to do the whole stop the movie, copy files to everyone, etc. song and dance.  It worked out fine, Kalen doesn’t move too fast and you have time to pay attention and try things out even if you have to type a few lines of code.  Hunt and peck people will have enormous trouble and should definitely copy the scripts beforehand.

It was great fun to geek out DBA style with Kalen’s video, and I really look forward to doing something similar with future videos.

Hey guys, I’m having a screening of Kalen Delaney’s new DVD. You saw the details on my blog, but if you didn’t get a chance, check out http://sqlserverdvd.com for more info.  I’m having the screening tomorrow at 7:30 PM in my house.  I’ve invited about 10 people, if we get a good turnout next time we’ll have it in a bigger place.

 Contact me directly for directions!  wharrislv at gmail dawt com

 Chuck Boyce from SQLServerDVD was cool enough to offer us a copy of the DVD to auction off amongst the attendees.  Come and get your free loot, under the condition that we take care of him next time he comes to Vegas!

I’d love to see some replies to this one, what makes you a geek?

I’m 29 now, got my first network admin job at 17 and first computer at 16. I spent that first year with a computer going crazy reading and learning back when SLIP connections to the net were hard to get!

I had an account on AOL on opening day.   I canceled my Compuserve account to afford it.

I turned down an offer to purchase a Cray supercomputer from a university.  It was bigger than the bedroom I wanted to put it in.

I can draw out the signal path of a mixing board, and have spent enough time recording music to be able to help people create semi professional home recording setups for under $5,000.

I blogged about Microsoft’s proposal to buy Yahoo at 3am, a few hours after Reuters caught it.

I’ve sold 4 different domain names for over $500 a piece.

I’ve run networks for international companies that had voip solutions, thanks to me, as far back as 1996.

My friend and I set up an always on VPN connection so that we could play Rise of Nations over the “LAN” of Cox Cable.

I ran NT 3.51 in a production environment before anyone even considered anything besides mainframes, netware, and unix.

I can make free calls from a large retailer’s phone system here in Las Vegas.

I’ve been heavily into databases for about 6 years, and into MySQL for about 2 years as I’ve been working part time with some crazy web developers. I’m all about design and architechting, standards based SQL programming, and MS SQL administration. Sometimes I write normal sentences in SQL via IM to amuse my developer friends.

I remember when slackware linux was the frontrunner, and I remember when linux was hard to install!

My bookshelves are overflowing with books in general, most of which are about technology related subjects.  You can see the list of books in my bedroom here.

I had a DEC machine in my bathroom, running TCP/IP.  I looked lovingly at it while surfing the Internet from my bathtub.

I’ve modded an xbox with no tools so that my wife could play emulated NES Tetris.

I vote for people based on their stance on technology related issues like Net Neutrality and spectrum availability.  Lessig owns me.

I’m pretty good with linux administration, exchange server, windows server, solaris, and more recently sharepoint and virtualization technologies like vmware.

I recently ordered a machine with 16gb ram for my bedroom, which will include a VMWare server running SSL tunneling to Amsterdam so that I can torrent in peace.

I read the Vista Resource kit from cover to cover for fun.

I know how to program and I never do it.  I’ve learned c, c++, hypercard, pascal, and shell scripting.

I know how easy it is to get into someone’s computer, and how much easier it is to steal an identity.

I know the IT systems in casinos like the back of my hand, I spent 8 years installing and supporting custom software for the gaming industry.  I’ve seen server rooms the size of a football field.

I’ve administered an OS/2 based document management system with an optical storage back end.

I’ve repaired broken CRT monitors with only a soldering iron and a screwdriver.

I had all my music in MP3 form before P2P really existed.

I can get BIOS level remote control to servers in China from my phone.

I actually know how BGP works.

I’ve chaired a special interest group for a local Macintosh user’s group.

I’ve been running IPv6 for years at home.

I’ve been offered to preview and review a technology book in the Head First series.

I’m going to add more as I think of them…what makes you a geek?

Lynn put hers up, so now it is my turn…

Yahoo live is a really great videoconferencing solution that is wonderfully simple to use, well designed, and a ton of fun with friends!  You can check my feed out below

You can go to http://live.yahoo.com/wharrislv if you want a direct link.

If you watch, though, say hi or leave a comment here! I’m very curious and it seems creepy when people don’t reveal themselves to me. That being said, I won’t be angry if you’re too shy.