14Aug 2013 by Grant Fritchey 4 Comments

Painting the US Red

Redgate Software
We are bringing Red Gate, through the free SQL in the City event, to the United States again this year. This event has been hosted in London multiple times, Los Angeles, New York, Austin, San Francisco, Chicago and Boston. It's a fun day of training, presentations, and networking, all done the Red Gate way. I'm excited as can be to get to take part in this again. Best of all, we're bringing it to a whole slew of new cities; Atlanta, Pasadena and Charlotte. So if you've missed it in the past because it was too far away, hopefully we'll be closer to you this time and you can make it. We almost always completely fill these events, so please, register early. We'll be talking about all sorts of topics;…
Read More
12Aug 2013 by Grant Fritchey 19 Comments

You should NOT attend the PASS Summit

PASS
If you asked me, prior to today, if I would type or say those words, I would have laughed right at you. But then, I saw this question on Ask SQL Server Central. It's from a college student, not yet twenty-one, who was considering paying his (assuming it's a guy since their handle is 'Eagle Scout') own way to the Summit and wondered if it would be worth it. It pains me to say that I suggested that he not do it. Don't get me wrong. I think the PASS Summit is probably the single greatest resource you have to advance your career. Where else can you go to get that broad a choice in training? Where else can you go to get that many of the leaders of our industry, specializing…
Read More
07Aug 2013 by Grant Fritchey 7 Comments

Be Cautious When Critizing About Guidance

T-SQL
I recently posted some comments about some guidance offered by Microsoft when talking about the CXPACKET wait type. Nothing I said was wrong, no. But, evidently there are a few whip smart and agile people who work for Microsoft. Specifically, Rick Byham, who works for the team tasked with taking care of the SQL Server Books Online. Why am I calling Mr. Byham smart and agile. Evidently he saw the blog post and has completely updated the description for CXPACKET at MSDN: Occurs with parallel query plans when trying to synchronize the query processor exchange iterator. If waiting is excessive and cannot be reduced by tuning the query (such as adding indexes), consider adjusting the cost threshold for parallelism or lowering the degree of parallelism. WHOOP! That's awesome work. Thanks Mr. Byham. Of…
Read More
07Aug 2013 by Grant Fritchey No Comments

24 Hours of PASS Streaming Available

Azure, PASS
If you missed the 24 Hours of PASS Summit 2013 Preview, you missed some excellent sessions. I watched a few, but not all. But now, thanks to the wonders of modern technology, I can go back and catch the ones I missed. You can too. I'd like to call out my session, Be a Successful DBA in the World of Cloud and On-Premises Data. I know that my fellow DBAs and database developers are largely dismissive of Azure. I get it. But I really think you're missing out on this. It's another excellent tool in your toolbox that you need to start taking advantage of. Little things like getting a quick and easy installation of SQL Server 2014 or Windows Server 2012 R2 up and running. Helpful things like the…
Read More
05Aug 2013 by Grant Fritchey 19 Comments

Be Cautious Offering Guidance

Azure, SQL Server, T-SQL
Guidance is hard. Seriously, you'd think it would be easy. You'd think you say things like, don't shrink your database, most tables should have a clustered index, never go against a Sicilian when death is on the line, don't mix sharks and tornados, and that would be it. You'd be done. But it's not that easy. Even worse, it's SHOCKINGLY easy to get stuff wrong. An example. I was looking at information over at Microsoft Developers Network (MSDN) in the SQL Server Books Online. I was reading through information about wait types when I found this little beauty: Occurs when trying to synchronize the query processor exchange iterator. Know what that is? Yeah, OK, a few of you who memorize wait stats do (shut up Tom), but most of us…
Read More
02Aug 2013 by Grant Fritchey 6 Comments

Speaker of the Month, August 2013

Professional Development
I'm trying out a new blog post series, mostly for myself as an exercise. I'm going to pick one speaker each month that I've seen present recently and tell you what I thought of them. Now, don't panic. If you stunk up the place, I won't abuse you... by name. Kidding. This is going to be endlessly positive and supportive. I'll try to find places where you can go to see these speakers in the future, if I can (Lanyrd.com people). If not, maybe they'll notice this post and tell us themselves. For those interested in getting picked, don't bother me. This is arbitrary & random. However, be sure that you have a blog (or equivalent) that I can direct people to or I'll skip over you. If you don't…
Read More
29Jul 2013 by Grant Fritchey 1 Comment

Azure for Prototyping and Development

Azure
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…
Read More
24Jul 2013 by Grant Fritchey No Comments

24 Hours of Education

Azure, PASS
You absolutely need to learn more. I need to learn more (lots more). We all should be constantly learning more about our jobs, our businesses and the technology that makes it all happen. When presented with the opportunity, especially a free one, you should jump on it, with both feet. Here you go. Beginning at 12:00 GMT on the 31st of July you can attend the 24 Hours of PASS, for free. 24 Hours of PASS has been put on several years now in various forms. This year it's being put on as a "Summit Preview." What you're getting is 24 individual presentations by 24 different people on 24 different topics, all meant to whet your appetite for the PASS Summit. I'm quite privileged to get to take part this year.…
Read More
15Jul 2013 by Grant Fritchey 5 Comments

A Tale of Two Hotels

Misc
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…
Read More
02Jul 2013 by Grant Fritchey No Comments

SQL in the City London 2013

Redgate Software
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…
Read More