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
01Jul 2013 by Grant Fritchey 15 Comments

Getting Started With SQL Server 2014 the Easy Way

Azure, PASS
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server 2014. I don't blame you either. I want to spend hours swimming through it too. But, you're thinking to yourself, "Heck, I'd have to download the silly thing, provision a new VM, walk through the install... Nah. Too much work." I don't blame you. I found myself on the road the day the software was released, so I was going to attempt to do all that work on a hotel wireless system. In short, I was going to have to wait, no options. Or were there? Actually, there is a much easier option. Azure Virtual Machines. And no, it's not that I can simply get a Windows Azure VM ready to go…
Read More
24Jun 2013 by Grant Fritchey 4 Comments

I Don’t Care

Azure
It's funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message. When thinking about cloud-based data management, things come down to a simple, if misleading, statement; I don't care. I don't care about operating systems or servers or disks. I need to have a database and it needs to be available and I need a reasonable assurance of performance. Within those parameters, I just don't care if the OS is patched or not, if the SAN is configured perfectly. I could care less if there are appropriate alerts on the internal network switches. None of that matters to me a whit. I just don't care about any of that because I'm focused on building a database and writing code and getting an app online. The infrastructure just needs to…
Read More
17Jun 2013 by Grant Fritchey 6 Comments

Azure First

Azure
Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on a massively accelerated schedule. Because of this, they're doing lots of code on lots of things that may, one day, end up in your full blown SQL Server instance, but are currently only available in Windows Azure SQL Database. This is because of that accelerated schedule. It frees Microsoft developers up to experiment a little. I saw some evidence of it the other day. I had been working on a series of queries for the pre-conference seminar that I helped put on at TechEd (and one that I'm doing for the PASS Summit). When I write queries, I use SQL Prompt. Sorry to be plugging Red Gate products on the…
Read More
10Jun 2013 by Grant Fritchey 1 Comment

Praise and a Suggestion for AlwaysOn

Uncategorized
One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are awesome. It's basically shared nothing clustering at a database-by-database level. You can set up a series of secondary machines that will enable you to failover a database in the event of an outage. This is a huge advantage in high availability and disaster recovery scenarios. We're talking serious business continuity. Further, you can set up one of those secondary machines to allow for reads, meaning, you get a reporting database that allows you to offload read queries from a transactional machine. Another giant win. But wait, it gets better. Now, with the capabilities that are coming with Azure Virtual Machines and Azure Virtual Networks you can go even further. It's…
Read More
04Jun 2013 by Grant Fritchey 4 Comments

Helping Database Administrators

Redgate Software, SQL Server
Let's be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on line. Some maintenance routines for statistics and maybe for fragmentation are also helpful. Set up security. In most of the important ways, you're done. Sit back, monitor the whole thing and collect your paycheck. BWA-HA-HA! Yeah, well, it's a nice dream. The reality is that you're dealing with constant change that throw this simple set of maintenance monitoring tasks into the garbage. No, you've got new databases under development. Sometimes by development teams that are absolute rocket scientists and you sit at their feet learning how they did some really cool piece of code. And sometimes by development teams that more resemble crazed monkeys throwing poo at the walls to…
Read More