SQLChicken.com

SQL Server DBA Tips & Tricks

By

Presenting at SQLSaturday #40 – South Florida

I'M ON A BOAT!

This is just a quick note to say that I’ll be in South Florida this weekend presenting at SQLSaturday #40. This weekend and the following week are particularly awesome for a few reasons:

  1. My birthday is Friday!
  2. Look at this lineup, it’s PACKED with #awesomesauce
  3. SQL BBQ on Sunday
  4. SQL Cruise next week!!!!

So…yeah, it’s going to be an awesome week for sure. On Saturday I’ll be presenting two sessions:

If you’re there please come say hi, even better come to my sessions! If not, don’t worry I won’t be offended as I’m going up against some awesome sessions (although I’ve noticed a trend where I always end up in same time slots as Brent!). So if you’re in South Florida area come join us, it’s free! Sessions start at 8:30 and go until about 4:30-5. Also even if you’re not attending you can connect with all attendees and speakers via the networking page. Hope to see you there!

Share

By

Professional Development Event:Taking Control of Your Career

This is just a reminder that this month’s Professional Development virtual chapter meeting we have MVP, PASS Board member, and all-around badass Jeremiah Peschka (Blog | Twitter) presenting on Taking Control of Your Career. Here is the abstract of the presentation:

Raises, promotions, and job offers don’t happen by accident; you need a plan. Through careful planning you can create and reach impressive goals. But what’s the point of reaching your goals if nobody notices? “If you build it, they will come” doesn’t apply when you’re building your career.

In this session Jeremiah Peschka will show you:

  • How to set achievable goals
  • The importance of planning your career
  • Methods for recording and communicating your accomplishments

When: June 16th, 2010

Where: LiveMeeting Link

Time: 1:00 PM EST – 2:00 PM EST (UTC-4)   [Use this online time converter tool to find time in your area]

If you’re interested in presenting at a future meeting for the PASS Professional Development virtual chapter please feel free to email me and let me know!

Share

By

PASS Professional Development VC Reboot!

This is just a quick post to let everyone know that this week marks the return of the PASS Professional Development Virtual Chapter! I’ve had the honor of becoming the new VC leader and I’ve got a great group of folks helping me out! Here is your Professional Development Virtual Chapter committee:

Jason Massie (Blog | Twitter)

Kathi Kellenberger (Twitter)

Mark Caldwell (Blog | Twitter)

Big ups to them as they’ve been absolutely awesome in helping get this chapter back up and running and we’re starting back up with quite a bang!

Read More

Share

By

SQLSaturday 31 Chicago: Recap

Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d like to again give a HUGE thanks the organizers of the event: Wendy Pastrick (Blog | Twitter), Aaron Lowe (Blog | Twitter) and Ted Krueger (Blog | Twitter) as well as all of the awesome volunteers that helped out.

My wife Jessica (Blog | Twitter) and I arrived into Chicago Friday afternoon. We had time to catch a bite at Grand Lux Cafe with some friends and my sister. Pretty nice place, kind of like a Cheesecake Factory but a little better. My wife’s a foodie so she was loving it! After lunch I got the pleasure of meeting Brent Ozar (Blog | Twitter), Jeremiah Peschka (Blog | Twitter) and Jeremiah’s friend John Jakubowski (Blog | Twitter) as they picked me up and we headed out to the ‘Burbs for the speaker’s dinner. We had plenty of time in car to talk about all things geek such as NoSQL, Ruby on Rails, PASS and a few other choice subjects not fit for print. Let’s just say I learned some strip clubs in Ohio have free steaks for lunch.

Read More

Share

By

Quest Virtual Training – SQL Server Training on DMV’s

Quest Software put on a great all-day training event today on all things DMV courtesy of Brent Ozar (@brento on Twitter), Kevin Kline (@kekline on Twitter) and Ari Weil (@aweil on Twitter).

If you missed this great live event, don’t fret as you can catch the videos on-demand here. One of the amazing things about this event is also the fact that in-chat there are literally hundreds of folks swapping information and resources. Unfortunately when you watch it on-demand you miss out on some of those great chat conversations. Well fear not! I’ve saved the chat log and made it available for download for you so you can see the kind of interaction this great SQL community has. As was mentioned in chat several times, with the economy being the way it is training opportunities are priceless. So check out the on-demand recordings and definitely check out the chat logs as in conjunction with the live event and Twitter (event hashtag is #questQA)

Quest-Virtual-Training-chatlog (.zip format)

Share

By

Upcoming Presentation: SQL Server 101 Series

I’m extremely proud to announce that I’ll be a part of a fantastic webinar series being put on by Pragmatic Works on SQL Server 101. Basically a 2-week-long series of webinars covering all the information you need to know to get started in SQL Server. I’ll be leading off the week with Introduction to Managing a SQL Server Database where I’ll cover some of the basics for an administrator getting started in the field. That same afternoon make sure you catch Patrick LeBlanc (aka @patrickdba on Twitter) presenting on Beginning T-SQL (register here for this session).

The rest of the week has some amazing presenters and content with folks like Steve Jones (Blog | Twitter), Brad McGehee (Blog | Twitter), Brian Knight (Blog | Twitter), Adam Jorgensen (Blog | Twitter), Christian Bolton (Blog | Twitter), and Devin Knight (Blog | Twitter)! HOLY CRAP, how did my name get mixed in with this elite bunch?!? Each session has its own registration link so make sure you register for the ones you think you’ll make as registrations are limited to 1,000 per session. Hope to see you all online that week!

SQL Server Global Webinar Series event page

Register for my talk here

And finally here’s a video introduction from Brian and Devin Knight about what to expect that week

Share

By

SQLSaturday #21 – Orlando: Recap

I’d like to preface my recap with a huge thanks to Kendal Van Dyke (Blog | Twitter) for being such a gracious host and letting me stay with him last weekend for the event. Kendal is a great guy, DBA and father and I really appreciated his invitation.

My SQLSaturday adventure started Friday as I left work and headed to Orlando to make it to the speaker’s dinner. I swung by Kendal’s house so we could head out there together. On a complete side-note, the city of Celebration really is quite the charming little town. It’s like driving straight on to the set of The Stepford Wives, which can be a good or a bad thing depending on what you make of that! The speaker’s dinner was held at a restaurant/bar about 40 minutes north so Kendal and I had some nice one-on-one geek talk about work, life and all the madness fun stuff going on with the PASS elections last week.

The speaker’s dinner was great, I got to meet some new folks like fellow SQL Twit (and co-author) Ken Simmons (Blog | Twitter), Regional PASS mentor and all-around awesome human being Andy Leonard (Blog | Twitter) as well as got to have some quality geek time with the rest of the speakers. Sitting down with fellow geeks and talking shop is always a fantastic time and I highly recommend you take advantage of it any time you get. I got to take advantage of a similar situation the next day which I’ll get to in a bit. After the dinner Kendal and I went back to his place and like anyone who has presented can attest to we both stayed up late tweaking and completing our slide decks in preparation for the next day.

The next morning Kendal and I arrived at the event and due to some miscommunication with signage we got into the wrong parking lot but thankfully Kendal remembered the right place to be from a  previous event there so we finally parked in correct lot. The check-in process was pretty smooth but the only thing I’d have to ding Jack/Andy for is the placement of vendor tables in that opening hallway. The doorway to and from that vendor hallway was really crammed and made it a bit of a hassle to get to/from but I can’t ding them too bad as you can tell it was placed there out of necessity since we didn’t have a large open space like a cafeteria to take advantage of. To counter my ding I should give kudos to the very large maps provided on the walls throughout the event that showed where each classroom was. I thought this was a FANTASTIC idea and was especially helpful when last-minute room changes were made. Some other great stuff that happened prior to sessions starting I got to meet another fellow SQL tweep Gareth Swann (Blog | Twitter)!

[NOTE: All presentation materials can be downloaded at the event page SQLSaturday website, go to Schedule and click on sessions to get slidedecks/code samples)

The first session I attended was Andy Leonard’s session on Database Design. As was mentioned by Jonathan Kehayias (Blog | Twitter) this session was standing room only after the small group of people who made it in after the room change confusion. Andy is a knowledgeable, personable and funny speaker and I was very surprised to discover this was his first time presenting at a SQLSaturday event. I really enjoyed the style in which he presented code examples. The first sample of code was the easy way which many take. It’s easy, and it works. The next code sample would be a better way to do it and finally he showed the “best” (or best compared to other samples) in how to code. Some examples of what makes code “better” is making re-executable SQL code. For example wrap your code with IF EXISTS checks so that if the code were run again it can fail gracefully or at least skip unnecessary code executions. Some other nuggets were that Andy likes to save the output from his script executions, which he referred to as deployment artifacts, and archives them for documentation purposes. Something really nice I took away from this is that I finally got an explanation of what that sqlcommand button/mode does in SSMS. This mode allows you to (amongst other things) chain scripts together so if you have several deployment scripts you can launch them all from within a single script file in order. Another very cool thing I took away from this presentation is Andy talking about how he read a paper from NASA regarding their code deployment/development process entitled “They Write the Right Stuff”. In it they describe how NASA actually looks to tweaking processes before they look to tweaking code to ensure quality and Andy had some very good insights as to how to carry that over to the SQL world. If you get a chance to chat with Andy or attend one of his sessions I HIGHLY recommend it! One last funny thing to come out of this session was Jonathan Kehayias keeping track of how long it took for him to answer a question with “it depends”. I believe Andy clocked in at somewhere near the 20 minute mark.

The second time slot was time for me to present my Policy Based Management talk. I had about a dozen folks in attendance including Aaron Nelson (Blog | Twitter), Ken Simmons, and Bonnie Allard from the Spacecoast SQL Server User Group. I attempted to broadcast the session via LiveMeeting (big thanks to Jeremiah Peschka for providing me with that) but alas it didn’t work because 1) I’d never done it before so after the fact I realized I broadcasted only webcam with no sound and no screen shared out and 2) Internet connection at the venue was spotty so I wasn’t even sure if connection didn’t drop during event. Overall I think the talk went ok, nothing blew up too badly but I did learn some valuable lessons thanks to feedback from those in attendance. I think from here on out I am going to break up the PBM into two presentations: One intro and basic overview and second more demo heavy and advanced tips/tricks. There really is just so much stuff in it that it is very hard to try and cram everything into an hour session and not forget something or rush. Hopefully if Ken can make it down to SQLSaturday Tampa in January we can do this two-part session together (and maybe even at PASS 2010? Hehe). On a side note this is the second SQLSaturday I’ve presented this talk and the number of those coming out were about a dozen while other sessions I’ve attended were pretty much full houses. So I ask this question to you, all five of you who read this the general audience: Does Policy Based Management simply not interest you or rather Does PBM seem like to much of a “niche” topic that you feel you can’t/won’t be using? I’d be very curious to know how people view this very powerful tool. It really is not that hard to implement/use and can be extremely useful for developers and DBA’s alike. Please leave your thoughts in comments below or if you’d rather email me directly at jorge<at>sqlchicken<dot>com.

Immediately following my session, in the same room, was Ken Simmons presenting on Automating Routine Maintenance. I thought this presentation was very well done and presented some really good things to think about and implement as a DBA. The ever SQL-omniscient Brent Ozar (Blog | Twitter) even got some credits in regards to the different images used in Ken’s slide deck which were funny and appropriate (gotta love car analogies). Ken covered some great stuff such as covering what a fail-safe operator was and how it differentiated from a regular operator in SQL Server (hint: fail-safe operator is written to system registry, rest are kept in msdb). This was cool as I didn’t know exactly what the fail-safe operator was or why it was there! Now that I know I’ll be implementing it in my systems back home. Some other important topics he touched on were performing DBCC checks on your databases and what some of the check options are and why you should be using them. Same goes with traceflags. He also covered statistics in databases and he had a really awesome analogy for this one that involved driving home. He likened SQL Stats to someone driving to and from work everyday. After awhile you know which route to take and which route is fastest so that’s the one you always take. But what if one day there’s construction and you need to detour from your usual route for a week? Well when this happens you need to update your mental stats as to which route you need to take in order to get to your destination fastest. The database engine works in a similar fashion. Again, car analogies FTW! For the record it took Ken almost 50 minutes before he dropped the “it depends” bomb.

Lunch was a bit of whirlwind for me since I pretty much just had time to grab my box lunch, eat and head over to my room for my mini presentation on Twitter and SQL Server. I rather liked this session as it just felt more laid-back than the PBM talk and with only 15 minutes to fill there wasn’t as much pressure. The presentation was aimed more towards those who have not used Twitter due to being hesitant on finding a useful value to the tool as opposed to finding out what Miley Cyrus had for breakfast. I gave a few examples of how Twitter has helped me personally at work, the best example being getting direct help from Paul Randal (Blog | Twitter) when I had a database corruption issue. Thanks to the relationships cultivated on Twitter with the rest of the SQL Commmunity I think I have added more value to both my organization and myself as I can always reach out to others and get help on topics I’m not necessarily comfortable or familiar with (read also: SSRS and SSIS). In addition to just reaching out for help I can stay up to date on latest happenings in the SQL Community as well as training opportunities such as free webcasts, events and blog posts that help me learn more about my specialty. If I sound like I’ve drank some sort of Kool-Aid it’s because I really can’t say enough how great Twitter has been in connecting to the SQL Community. If you haven’t tried it yet I highly suggest you give it a shot. If you need a list of folks to follow on Twitter then head over to SQLServerpedia as they have a nice collection of folks already on the Twitter bandwagon. Make sure to drop me a line at http://twitter.com/sqlchicken .

At this point my intention was to head over to Kevin Kline’s End to End Troubleshooting session but as I was walking to the room I noticed a few guys sitting around the pavement chatting. What caught my eye was WHO it was since it was a couple of folks I hadn’t met yet and was really anxious to. The sidewalk gang consisted of Andy Leonard, Jonathan Kehayias, Buck Woody (Blog | Twitter), Joe Webb (Blog | Twitter), Joe Healy (Blog | Twitter) and (eventually) Ken Simmons. Despite all the great content available at the event I thought the hour spent with these guys (yup, ended up missing the session, sorry Kevin!) was invaluable. How often do you get to sit around a group of guys of that caliber and hear their thoughts on SQL Server and, as was the case in this particular conversation, get some inside stories from the world of Microsoft! This wraps back to the whole “social networking” aspect of one’s career and I highly encourage everyone to take advantage of opportunities when presented. In this case I weighed my options: Can I download Kevin’s slide deck or catch another similar session online? Yes and probably. Am I going to get another opportunity to get face to face time like this outside of going to PASS Summit? Probably not. If you attend a SQLSaturday event (or any event rather) and you see someone you’d like to talk to then go introduce yourself! Heck, even milling around and simply listening to two or three top guys discussing shop-talk together can bring all sorts of new information into your world. I guarantee you that those “big name guys” are just as excited to meet you as you are to meet them. If you’re going to PASS this year and want to learn or practice networking skills I highly recommend you sign up for Don Gabor’s pre-conference session on Networking to Build Business Contacts. After our “sidewalk session” was done we started heading to our next classroom destinations when another impromptu networking opportunity presented itself with none other than Joe Celko (Blog)! I just got to spend a few minutes with Joe but man that guy is so ridiculously smart and personable I was blown away! I had heard how nice of a guy he really is as opposed to his evil cantankerous online alter-ego but Joe really is a great guy. He talked about the future of SQL a bit and how indexes may actually no longer be necessary thanks to something about hashing (again this guy is way out of my league in SQL-smarts so I’m probably butchering his words). So after all of this networking practice it was only right that my next session was to go see Andy Warren (Blog | Twitter) present on Social and Not So Social Networking for the DBA!

Again, this was another standing-room only session and for good reason. Andy is a fantastic speaker and its almost like he’s a wisdom machine that just produces knowledge nuggets every time he speaks and you can quote me on that one. I showed up a little late due to my social activities from before so I didn’t realize (until I saw Jonathan Kehayias’ tweets) that Andy had projector issues so he was “working without a net” so to speak. I’ve attended this session before by Andy but it’s always interesting to see which way the conversation goes as the presentation is almost a forum in the way Andy prods the audience for their thoughts and views and goes from there. What I love about Andy’s speaking (and him in general) is that he has a definite viewpoint on things that are quite often different than mainstream views are and he forces you to really think about stuff. For instance it wasn’t until after then event was over that Andy delivered his first, and highly-anticipated, tweet! Did he just create an account that day? Nope, he actually created it months ago when another fellow SQL Tweep convinced him to create an account but Andy refused to jump in and start tweeting unless he could see a real returnable value from said technology or tool. This is something important for all of us to really think about before we just start jumping on-board trends. Jonathan was tweeting some great Andy quotes throughout the session and you can see some of those over at Jon’s SQLSaturday recap post.

The last session I attended was Joe Celko’s “Celko on SQL” session. Since I regrettably won’t be able to make it to PASS Summit this year, and I wasn’t sure the next time Celko was going to be down around my neck of the woods, I wanted to take advantage of this opportunity. The session consisted of Joe basically going back through the history of the SQL ANSI Standard (for those of you who don’t know, Joe is on the ANSI board, yes that board that met for 3 days to come to the conclusion that its pronounced S-Q-L not “sequel”) and all the fun things that came out of it and why some things behave the way they do. He had different slide decks based on topics such as the JOINs which we delved into a bit. This session didn’t have any code samples to take away or best practices to implement but its always interesting to see the history of your product and the minds behind said product. Special thanks to the Central Florida Oracle User Group for pitching in to bring Joe to SQLSaturday. Here’s another pitch for PASS but there’s plenty of opportunities like this at PASS Summit where you can talk directly to the folks that write the code that run the queries you bless/curse on a daily basis. So if you’d like a reason to give to your boss to attend, there’s a pretty good one right there.

The day wrapped up as all SQLSaturdays do with the distribution of SWAG to the masses. Andy Warren was chucking stuff left and right from the balcony to the people whose number he called out below which made for an entertaining way to wrap up the day. Huge thanks and congratulations goes out to Jack Corbett (Blog | Twitter), Andy Warren and their dedicated volunteers for putting on such a great event. Events like these and the people I meet energize me and reaffirm how much I love what I do and how much I love the community I’m a part of because of it.

Share

By

Tampa Bay SQL Server User Group Recap 10/13

I know this is a bit late but you know what they say, better late than never! This month’s meeting was quite exciting as we had a big-name speaker come in. This month we had Kevin Kline (Blog | Twitter) of Quest Software come in and speak to us about Disk I/O Tuning on SQL Server.

Typically our meetings kick off with announcements and general discussion but because we had Kevin this month (he was in town for SQLSaturday #21) we let Kevin have as much time as possible so we skipped our normal routine and got right to it! First off Kevin is a fantastic speaker and has a real easy-going presentation style which I really enjoyed. Many times during the presentation felt more like a dialogue as he engaged the audience on many topics. One of the great things about a speaker engaging the audience as such is that more nuggets of information can come out that sometimes even the presenter wasn’t aware of. For instance during one exchange between Kevin and Jonathan Kehayias (Blog | Twitter) something came up (pardon me for taking horrible notes and not remembering exactly what it was!) but it was something new to Kevin. The meat of the presentation (Slide deck can be found here) was geared much towards explaining the different RAID types and their respective benefits within a SQL Server implementation. Other great disk information such as partition alignment (which you DEFINITELY want to do as it nets you up to 30-40% performance gain!), which perfmon counters you should focus on to baseline/monitor your disk performance, SQL file configurations (i.e. multiple data files), SAN tips/tricks/gotchas, and more. One really cool tidbit that Kevin shared with us, in regards to seeing real-world performance examples, is the online MMORPG EVE Online is actually back-ended with SQL Servers all on solid state drives (SSD)! How cool is that? Here’s an article on it and how they benefitted from using this technology.

Overall it was a great meeting and a huge “thank you” to Kevin for speaking at our group this month! If you ever get the chance to catch a Kevin Kline presentation I can’t recommend it enough. If you’re going to PASS Summit this year Kevin will be presenting The Ultimate Free SQL Server Toolkit (Database Administration) as well as Team Management Crash Course (Professional Development). If the Team Management one is the same presentation as the one he gave during the 24 Hours of SQL PASS event I HIGHLY recommend you attend that one as there are some great bits of information in there!

Next month on November 17th our presenter will be Jonathan Kehayias presenting Understanding SQL Server Memory Management. Visit the user group website and register to attend.

Share

By

SQLSaturday #21:Orlando

SQLSaturday is gonna be HUUUUUUGE!

SQLSaturday #21 is gonna be HUUUUUUGE!

I’m excited about next weekend’s SQLSaturday as its going to be one HUGE event. If you live anywhere in the Southeastern United States you should be excited as well! Why? Well for starters next is, for all intents and purposes this is going to be like PASS Summit: East Coast Edition.

For starters, the week leading up to SQL Saturday will feature some top-notch seminars. Each seminar is $149 and includes full-day training as well as lunch. Here’s the seminar schedule for the week:

Monday: Essentials of Managing SQL Server by Andy Warren (Blog | LinkedIn)

Tuesday: Learn BI in a Day by Brian Knight (Blog | Twitter)

Wednesday: Real World Performance Tuning by Kevin Kline (Blog | Twitter)

Thursday: From Zero to SSIS by Andy Leonard (Blog | Twitter)

Friday: Performance Tuning Methodology by Buck Woody (Blog | Twitter)

In addition use code “KKLINE” to get a 20% discount if you register for two or more seminars! Even better if you sign up for the Wednesday, Thursday and Friday sessions together you can knock $200 off the price by using the discount code “Bundle” at checkout. Also worth noting is that Kevin Kline will be visiting various user groups around the state next week. Here’s the schedule:

  • Tuesday, Oct 13, Tampa SQL Server User Group (http://www.tampasql.com)
  • Wednesday, Oct 14, Orlando SQL Server User Group (http://www.opass.org)
  • Friday, Oct 15, Jacksonville SQL Server User Group (http://jacksonville.sqlpass.org)
  • And that’s just the week leading up to the main event!!!EXCLAMATIONPOINT

    On Saturday we have a plethora of great speakers and sessions. In addition to all the guys I’ve previously mentioned in this post we also have guys like Chad Miller (Blog | Twitter), Joe Celko (Blog), Joe Webb (Blog | Twitter), Kendal Van Dyke (Blog | Twitter), Jonathan Kehayias (Blog | Twitter), Ken Simmons (Blog | Twitter) and more presenting! This SQLSaturday is also seeing the introduction of the mini-sessions. Mini-sessions are 15-minute presentations aimed at first-time speakers to encourage them to present at a big event without the pressure of having to fill that hour time slot.

    So what are you waiting for? Oh what you want one more thing to entice you? Ok, how about free T-shirts for the first 150 to arrive to the event? Swag? We got it in spades. We only have a few seats left so hurry up and register!

    Share

    By

    PASS Virtualization VC Webcast: Virtualizing SQL Servers

    For those who don’t know, PASS has several Virtual Chapters. Each VC has its own distinct topic they focus on. The most recent VC established is the Virtualization Virtual Chapter (say that 3 times fast). Our group is dedicated to helping spread the education of virtualization to folks who are thinking of jumping into the virtualization realm with their SQL Servers. We’re pretty excited as we have some top notch virtualization experts such as Duncan Epping (Blog | Twitter), Scott Lowe (Blog | Twitter) and Brent Ozar (Blog | Twitter) who will be syndication their blogs on the Virtualization VC’s blog feed.

    Tomorrow afternoon Wednesday, September 30th at 12pm EST | 4pm GMT, the PASS Virtualization Virtual Chapter is proud to host our first webcast featuring Denny Cherry (Blog | Twitter) discussing the pros and cons of moving SQL Servers into a virtual environment. We’ll be talking about when it’s a good idea, when it’s a bad idea, and why there’s no hard-set answers. We’ll be focusing on how to make this decision and how to gather the metrics you need to make a good decision. Audio will be provided through the speakers. This presentation will be presented via Windows LiveMeeting so make sure you arrive early and make sure everything is ready to go on your end. See you tomorrow at the presentation!

    Meeting Invite Link: https://www.livemeeting.com/cc/usergroups/join?id=BP7D93&role=attend&pw=x_](2cfJ4

    Share