Welcome to Teched 2013 We're starting off with some type of James Bond video. Chase scene with a really cool car. Not quite French Connection, but good. OK, that was, if a little ballsy, "you'll never crack it" Jeez, how to upset people. And the car from the video drives out on stage. And that is Brad Anderson arriving. Guy7 looks like he does crossfit. "We spend our time making other people great" He's laying out the path of the future and, shock of shocks, he said SQL. Out loud. On stage. Twice. That's pretty cool. SQL Server often feels like a red-headed step child. Iain McDonald, comes out to introduce information about Windows Core. The OS covers everything from the phone to tablets to xbox to your servers. The…
I earned my nickname. I'm proud of it. I am the Scary DBA. I don't really like to advertise my other nickname, Rant (get it, Grant shortened to another word). I earned that one too. I'm not proud of it at all. I got that one because I sometimes don't listen as much as I should and, because I tend to be more than a little passionate about my job and my databases, I would go off on a rant. And yeah, I stood in the way of some development processes and approaches that I shouldn't have. Instead of facilitating the development team and trying to understand their problems and issues, I just said "No." Usually at length. I just finished reading this post from Martin Fowler, whose work I've  enjoyed,…
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the world. I could go into a dark closet (a well-lit cube, but hang with me here) and hide from everyone (except the people in the cubes next to me, my boss, the teams I supported, the people I passed on the way to the toilet, others) and just be a hermit (except for the daily stand-ups, weekly status meetings, occasional training) and only ever talk to people when things went wrong at 3AM (or at 2PM when the CIO and a bunch of other managers would be standing in my desk). As long as I did my job well, maintaining the backups, running maintenance, and setting appropriate security settings, I…
Just so we're clear, I use SQL Server. I like SQL Server. But, this doesn't mean I have anything against Oracle. It's fine. It's good. But, I know very little about it. However, throughout my career I've found myself needing to understand it better. Either because I'm trying to train Oracle people to better use SQL Server and I need to be able to speak a little of their language to facilitate translation. Or, because I'm defending SQL Server on some technical point that the Oracle people don't completely understand. Or, because I've said something stupid about Oracle in my ignorance. Now, you know how busy you are, and I know how busy I am, so I doubt either of us has the time we really need to learn Oracle…
I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only factor that needs to be taken into consideration when making a decision. You could even change it from "being" right to "doing" right. Although, I mean it in a technical sense, not a moral one. If you haven't read it already, go ahead, I'll wait... I agree with her. I've been that guy... more than once.... okay, okay, a bunch of times. You know that guy. The one who just couldn't see past the point that we were doing something wrong, something stupid, something that would bite us in the butt for the next three or four years. Oh yeah, that guy. The popular one (not at all). The one…
Wow! How's that for a recap? The concept for the SQL in the City events is pretty simple. Put on a free event that instructs people on SQL Server, Azure, and related technologies along with a healthy smattering of Red Gate tools. All teaching is done by some of the best people in the business (and me). This was the second event in London. The concept was launched there last year and succeeded quite well. This year the event filled it's registrations so quickly that Red Gate felt obligated to have a second day, which almost completely filled up too. There were more than 350 people in attendance on Friday, and then, on Saturday, a day off, another 250+ people showed up. That's well over 600 attendees over the two…
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it, most of these events you’re going to see the sessions, but you really should plan on networking too. Here’s your chance to get started on that: Southern New England SQL Server Users Group, East Greenwich,RI – 3/14/2012: TSQL Deployment and Continuous Integration Best Practices SQL Saturday 120, Orange County - 3/24/2012: I’m presenting two times here. They’re both presentations that I’m working up for Connections. Common Backup Problems and How To Deal With Them TSQL Deployment and Continuous Integration Best Practices SQL Connections:Las Vegas 3/26 – 3/29/2012: I get it. You don’t go to Vegas to network. That doesn’t mean you can’t still do that too. I’m presenting three sessions.…
And we’re off. We opened with a video of people saying “Connect, Share, Learn†and “This, is Community†Rob Farley & Buck Woody came out with a song about long running queries. [8:20]Wayne Snyder has been working with the PASS organization since 1999. He spoke at the first PASS Summit and he’s been on the board forever. He has finally hit the point as immediate-past president where he has to leave the board. We’ve got a great little thank you for him from all sorts of people. Wayne is a magnificent guy, seriously. If you see him, thank him for his service. [8:28]We have a new executive committee, Bill Graziano as President, WHOOP, Douglas McDowell is Executive Vice-President and Thomas LaRock is VP of Marketing and finally, Rushabh Mehta is…
Bill Graziano has come out on stage, looking marvelous, in a traditional kilt and stockings. Thanks Bill. For those who don’t know, Day 2 at the Summit every year is Kilt Day. [8:19]Outstanding volunteers being recognized are Tim Radney and Jack Corbett. These are some outstanding people who work their bottoms off for the PASS Community. If you meet them, thank them. The 2011 PASSion Award goes to Lori Edwards. She’s simply amazing. Congratulations Lori and thank you for all the work you’ve done! [8:23]Time to eat our vegetables. We’re looking at the financials. It’s a slightly painful process, but important to understand where the money goes since this is a non-profit organization managed by volunteers. You should understand where the money comes from and where it goes. [8:25]Quentin Clark…
There’s a project over on code plex to come up with a mechanism for validating databases and generating the necessary scripts to allow you to move those databases, and data, over to SQL Azure. It’s called the SQL Azure Migration Wizard. There’s no real install yet since it’s just a beta. You can download the executable and run it. It’s pretty straight forward stuff. It’s primarily focused on validating that there is a database, script or series of calls (from a trace event file) that will be properly compatible with SQL Azure, but it can also generate a deployment script from the database. Here’s the opening screen: Not much to it. I’ll walk you through the Analyze and Migrate path which covers most of the functionality of the app. Clearly,…