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…
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…
I've already made my own intentions clear. I'm casting one of my votes for Allen Kinsel. But, I get three votes. Some of you may be asking yourselves, why didn't recommend two other candidates? Honesty time. First, no one else asked me to. I'm actually glad of this. If I received requests for help from more than three of the candidates, I would be very hard pressed to choose. Yes, I ultimately have to, but I don't have to publicly reject anyone. At this point, it looks like I'm ready to vote for every other candidate. That's a good thing from my standpoint, maybe not so much from theirs. However, if anyone wanted a little help, they should have asked. That's a good policy with life in general. Second, I…
Women, for the entire male half of the population, I apologize. Those who know me well recognize, pretty easily, that I am hardly "politically correct." My mode of address can be blunt and even rude. But... I think it's also recognized that I'm very even-handed with my blunt statements. Female or male, if you have in some way crossed me, I'm generally pretty clear about letting you know. So while I absolutely have prejudices (and I won't get into what I think mine are), they are not around Male/Female abilities. Yes, there are differences between the sexes coming from a million+ years of biology and Darwinism, but by & large, especially when talking about cognitive abilities, we're evenly matched. In the computing world, I'm an "old guy." With three or…
Psssttt! Developers. Man, have I got something good for you. Are your DBAs slowing down your development processes? Are they keeping you from flying down the track? Bypass them. Let's assume you're working in the Microsoft stack. Let's further assume you have an MSDN license. Guess what? That gives you access to Azure... hang on, come here. You want to hear this. Let me tell you a quick story. See, I'm not a developer (not anymore). I'm a DBA. Wait, wait, wait. I'm on your side. It's cool. I'm just like you guys, but in a different direction. See, I had a database designed and already up as a Windows Azure SQL Database. I'm working with a number of Boy Scouts on their Eagle projects. They're going around to all…
This is a long and convoluted post about my experiences at two hotels, but it has a point for DBAs and other data pros. Please stick around to the end. I stay in hotels fairly frequently. I have friends who stay at them even more than I do. We tell each other stories about turning left in the middle of the night when the bathroom in this hotel is on the right. And, we share good and bad experiences in order to help ensure that our travels are quick, safe, and as worry free as possible. All of us tend to focus on staying at one hotel chain or another in order to maximize our benefits. My personal chain is Hilton. I've recently had a very bad experience and a…
Wow! You'd think that an event might get a little worn by the third time you're doing it. That maybe it would be just a repetition of what you've done before. And, I guess, in some places, that does happen. But not here. This event was as fresh as it ever was. Maybe it was the beautiful new venue, but I don't think so. I think it was the crowd. We had a ton of great people show up, more than we expected (awesome and wonderful in and of itself), and they were an engaged, enthusiastic group. Presenting in Europe, as an American, can be quite intimidating. There's the language issues and all that. But the main thing is that people across the pond tend to get at information a…
See this: That's right. The install worked. All I had to do was get a completely clean server set up. No domain controller. Now to get my learn on. Microsoft has a web site with a number of introductory samples. I'll start there and work through them. The very first example gets me set up with some data that it builds by running a Powershell script, importdata.ps1. But I'm not going to just blindly follow along. I want to see what the heck is happening so I can start understanding this stuff. By the way, thank you Microsoft for making the samples in PowerShell and not forcing me to relearn Python or something else. That would have been frustrating. The script is really simple. It has two scenarios you can…
I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good. The organizers put everything together pretty well and the venue was quite nice. Plus, since I grew up in Oklahoma (Tulsa), it was a chance to go home. The event was good, but my presentation went a little downhill. The name of the session is "Top Tips for Better Stored Procedure Performance." I should rename it to just say "T-SQL Query Performance" because it's not focused on stored procedures, but on queries. The presentation is 1/3 talking about how you write your queries, naming syntax, formatting, etc. The second 2/3 is all about common mistakes made in writing T-SQL such as using NO_LOCK everywhere, nesting views, joining and nesting multi-statement…
I can't help it. I get really terribly excited when I publish a book. Maybe it should be old hat. Maybe I should be jaded. But I'm just a 12 year old (it's been argued 10) in reality so I get really, really jumping up & down excited when I get that wad of paper and my name is on the cover. It just doesn't seem to get old. What am I talking about? Oh, sorry. Let me explain. After about nine months of work, my new, revised edition, of the Query Performance Tuning book is available. I want to publicly, and loudly, thank Joe Sack(blog|twitter) for the incredible job he did as tech editor. His hard work, and ruthless criticism, made this book what it is. Despite the scar…