03Jan 2014 by Grant Fritchey 2 Comments

Speaker of the Month, January 2014

Professional Development
A whole new year. Cool. I was at SQL Saturday DC, #233, at the beginning of December. I sat through several really good presentations. I could honestly give the award this month to any of the ones I took notes on, but I have to pick one person (although, not always, my award, my rules). So, speaker of the month for the brand new year is Konstantin Melamud (li|t). Yet another speaker without a blog. Maybe I should enforce my own rules at some at some point. <sigh> Anyway, I enjoyed Konstantin's presentation. Let's talk about it. Performance Tuning - Index Optimization was an excellent presentation. Konstantin came at the topic very carefully. He started off with a knowledge level baseline, right at the start. I thought that was a…
Read More
20Dec 2013 by Grant Fritchey 2 Comments

Tribal Awards: Vote Now!

Professional Development
The #tribalawards voting is now online. Get over there and get it done. I honestly don't care who you vote for because that is a great list of wonderful people in every single category. But if I were to pick one category, in which I'm nominated, that I'd like to win, it's Person You'd Like to Have a Beer With. So please at least consider making me happy. Then, next time I'm presenting in your area, we could share a frothy beverage and you can claim credit for my win which will result in my being forced to buy a round. See, it absolutely works out in your favor. But seriously, well, as serious as I can be when one of the categories is Best Karaoke, I think the people…
Read More
18Dec 2013 by Grant Fritchey No Comments

Speaking in 2014

Professional Development
I love that I get to travel around and learn from my #sqlfamily. We're still filling in the majority of the 2014 schedule, but the plans are to go to as many events as Mrs. Scary will let me. I'd like to alert you to a couple coming up in January, and then I should be able to get a fuller schedule for the first quarter posted soon (that way you can complain to me in person about Managed Backups). On Friday, January 10th, I'll be presenting a SQL in the City Seminar on Database Deployment in Cambridge, UK. Presenting in the UK is just fantastic. And this is a live event. And it's at the stately Red Gate Towers. Oh, and this is a free event, but seating is…
Read More
06Dec 2013 by Grant Fritchey No Comments

Speaker of the Month, December 2013

Professional Development
This will be my fifth speaker of the month post. Do a search to see the others. I try to find speakers that people may not have heard of who are out there, working hard, doing a good job. But, sometimes, I'm going to see a presentation by someone who is a community speaker, and... well, it just might stand out so much that I don't have a choice but to award them (remember, my contest, my rules, and the rules are utterly arbitrary). The speaker of the month is Ami Levin (b|t). The session I attended at SQL Saturday Dallas was called Physical Join Operators. It was all about hash match, loop and merge joins. Stop yawning. I'm into that sort of thing. What I expected was, hopefully, an…
Read More
12Nov 2013 by Grant Fritchey 19 Comments

Cargo Cult Data Professionals

Professional Development
Ever since David Moutray introduced me to the concept of cargo cult programming, it's been running round and round in my head. I'm actually coming to believe that this is a major issue in all walks of life. True or not, we're absolutely seeing it in the data professionals space. Don't believe me? OK. A few questions. Do you work for one of the organizations that absolutely requires NOLOCK on all queries (even INSERT/DELETE/UPDATE)? Why? Because it runs faster? Why don't you just use READ_UNCOMMITTED for your isolation level? What's that? Never heard of isolation levels? I'll bet you also don't know what is meant by "dirty reads" then either. READ_COMMITTED_SNAPSHOT anyone? In short, you're guilty of being in a cargo cult. You've got this form in your head of…
Read More
11Nov 2013 by Grant Fritchey No Comments

For the Aspiring DBA

Professional Development
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess stuff up and cause a system to crash and burn, maybe you’re in the wrong job. The amount of information you have to learn is insanely huge, coupled with the fact that you are straddling application development, system administration and business needs, multiplied by the factor that all the apps, all the code and the very server structure on which you’re building everything is constantly changing. Concerned now? Good. Stay that way. The one piece of advice I want to offer you is that very state of concern. You are in a wonderful and horrifying position. If you’re working in the database administration space, you’re tasked with protecting the data…
Read More
04Nov 2013 by Grant Fritchey 3 Comments

Speaker of the Month, November 2013

Professional Development
Yeah, I'm a couple of days late. Tough. My blog. My rules. Speaking of rules. Speaker of the Month is chosen by me based on my whims, interests and the direction of the wind on every other Tuesday at 3PM. No whining. I saw a ton of excellent sessions during the month of October. I was at SQL in the City, SQL Saturday Charleston, and the PASS Summit, so I had an embarrassment of riches to choose from. One session stood out. It's on a topic that, frankly, I find incredibly dull. But not this presentation. Without further ado, for November I'm picking Chris Bell (b|t) and his presentation, Indexing Encrypted Data (oh stop yawning, this is good). Chris went to town on the slides. He's clearly very carefully built…
Read More
22Oct 2013 by Grant Fritchey 2 Comments

SQL in the City, US Tour 2013, Recap

Professional Development, Redgate Software
Red Gate visited three cities this year with our SQL in the City event; Pasadena, Atlanta and Charlotte. I just wanted to give you a quick assessment of how the events went from my point of view. Overall, each and every one of these events was awesome. I can safely say that because each and every one of these events provided something special, the opportunity to network with our peers and with the developers and project managers at Red Gate (who are also our peers, but not usually available to us). I both took part in the networking and stood back and watched it happen. I love seeing a bunch of data pro's sitting (or standing) in a circle exchanging war stories, ideas, questions, thoughts or suggestions. It means you…
Read More
09Oct 2013 by Grant Fritchey 2 Comments

Do Be a Gatekeeper

Professional Development
I read this fascinating blog post called "Don't Be a Gatekeeper" by Julie Zhuo. Please read that first. It really resonated for me in a lot of ways. Everything she said is 100% applicable to our jobs as data professionals. Work to make things more robust. Create processes and structures and an environment where you don't have to be the hero all day every day. Yes, absolutely. But... ah, there's this nagging little voice at the back of my head. Let's ignore it for a moment. Are you a gatekeeper for your developers? Why? Get out of their way. Listen to what Ms. Zhuo has to say. Your development team doesn't need you squatting on their servers preventing them from moving as fast as they can. In fact, they need…
Read More
04Oct 2013 by Grant Fritchey 4 Comments

Speaker of the Month, October 2013

Professional Development
This month I saw several good speakers talking on a variety of topics. Making this choice was hard. I'm really glad people don't know who I've decided not to pick because I would be singularly unpopular. The rules for speaker of the month are simple. This is an utterly arbitrary and random decision made by me based on criteria that crosses the gamut from careful evaluation of speaker skills, to reading chicken guts, to the random coin toss. In short, I pick, my way, no whining. But, I really, really want you to have a blog (or something like it) that I can point people to. That said, I'm making an exception this month (see arbitrary and random above). I'm doing this because I really enjoyed the session, Stop That,…
Read More