23Aug 2013 by Grant Fritchey No Comments

SQL CAT is on the Move

Misc
Not a big deal really, but they're consolidating from the SQLCAT.COM to put everything on MSDN. Read all about it here. I love the SQL Customer Advisory Team. They tackle some of the hardest problems out there and then tell us about how they did it. That's a resource you can't ignore.
Read More
22Aug 2013 by Grant Fritchey 2 Comments

Get Started with Windows Azure SQL Database

Azure
Learning new things can be daunting. First, you have to come up with the spare time. Then you have track down resources. For computers, computing and programming, this is both extremely easy and extremely difficult. That difficulty is especially true when it comes to gathering resources for learning things that, while you learn, are potentially going to cost you money. It's a difficult decision to make to risk cash on exploring a new technology. Here's the good news, for several reasons, you don't need to sweat this to get going with Windows Azure SQL Database (WASD). A couple of years ago Jamie Thompson (b|t) set up an account on Azure, all on his own, that allowed people to connect up to it and play with a copy of the AdventureWorks…
Read More
21Aug 2013 by Grant Fritchey No Comments

Speaking this Fall

PASS, Redgate Software
I've been at home through the whole month of August, restingworking hard, but it's time to get on the road again. First up, it's off to San Diego for two events. On Friday, September 20th, Red Gate (my Lord and Master) is hosting a free afternoon session of training. Steve Jones (b|t) and I will be walking through several sessions oriented towards the DBA and the skill sets they need to get things done. It's a free event, training done the Red Gate way, so register here, get some free training, a little networking and finish up with a frothy beverage. Then it's off to SQL Saturday San Diego the next day, Saturday, September 21st. As I write this, they haven't posted the schedule, so I'm not sure what session I'll be doing,…
Read More
19Aug 2013 by Grant Fritchey No Comments

Azure Changes, While I’m Working

Azure
My laptop is out for repair. I'm working currently on a Surface Pro instead. It's spurred me to do something I've been meaning to do anyway. I've started setting up a full demo & testing VM on Azure. I already had the VM up and running (it takes 5 minutes for crying out loud), but I hadn't bothered setting up Red Gate software on it and getting it fully prepped to support my work, demos, or whatever else I might need. But, I finally did. It's working out surprisingly well. I just have to remember to shut the silly thing down when I'm done with it or it does start to bite into my MSDN credit. Anyway... I was working on the VM for a big chunk of the day…
Read More
15Aug 2013 by Grant Fritchey 3 Comments

Azure and Your MSDN Account

Azure
I've heard over and over again that the reason people don't want to learn Azure, to explore it, to understand where it's applicable to them and their business (and where it's not, because, it does have well-defined limitations) is because they don't want to pay for it. Fine. Don't. Do you have an MSDN account? What? You do? Then you have access to a credit in Azure and an account with a spending limit. Your credit level is dependent on what level of MSDN you currently subscribe to, but who cares. You not only will NOT pay anything to play in Azure, you will NEVER pay anything. You can't go beyond your limit. Want some more incentive (not that you should need any now)? Cool. Set up your Azure account…
Read More
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