20Oct 2014 by Grant Fritchey 4 Comments

Database Lifecycle Management

Redgate Software
There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every application and if you do a similar search, there aren't very many people talking about Database Lifecycle Management at all. Why not? I'm positive you're deploying a database with your applications. I'm also positive, because of the unique problems that databases present, primarily around data persistence, that you need to think about how to get your database(s) deployed. Unfortunately, even for strong, capable data professionals, deployment is something thought about later. Or, you're still doing the old school method of waiting until there's a deployment script that you're going to review, line-by-line, before you run it against production. There's a better way. What you need to do is start thinking…
Read More
20Aug 2014 by Grant Fritchey 2 Comments

The Red Gate Way…

DevOps, PASS, Professional Development, Redgate Software, SQL Server, T-SQL
As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind them, ingeniously simple. But, we do a lot of other things too. There's the Simple-Talk web site where we publish serious articles on all aspects of development and database administration across platforms and programming languages. There's SQL Server Central, the single largest SQL Server community on the planet. There's Ask SQL Server where you can get direct answers to your direct questions about SQL Server. If all that's not enough, there are all the books, which we give away for free, on, again, all aspects of programming and database administration. But, we like to do more, so we also bring you training, the Red Gate way, at the SQL in…
Read More
08Jul 2014 by Grant Fritchey 5 Comments

Worst Day of a DBAs Life

Professional Development, Redgate Software
Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We've been posting some really fun stories with, I hope, a kernel of useful information inside each. Chances are, if your DBA career has been like mine, your worst days don't involve explosions and car chases. But now they're asking for people to write up stories, what was the worst day in your life as a DBA. I know, I know, first world problems, right? Regardless, I have yet to put a company out of business or kill anyone with any errors I've made, although I've worked at places where either was possible. But the one day that just stands out, well it started about three weeks ahead of the bad day. I…
Read More
10Apr 2014 by Grant Fritchey 2 Comments

I’m a Traveling Man

PASS, Redgate Software
We are coming into quite a busy time for my speaking schedule. I'm hitting the road. It does one thing for me that I truly love, I get to talk to people. So, if you have questions, want to chat, need to call me a pompous know-it-all to my face, I've got some opportunities for you. Next week, April 13-16, is SQL Intersection. You can register by clicking here. The following week, I've got two events. First, on Friday April 25th, Red Gate Software is hosting a free half day SQL in the City Seminar in the Chicago area. We'll be talking database deployment all day. Go here to register, but don't wait, seats absolutely are limited. And, since this is a Red Gate event, at the end of the…
Read More
22Oct 2013 by Grant Fritchey 2 Comments

SQL in the City, US Tour 2013, Recap

Professional Development, Redgate Software
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…
Read More
19Sep 2013 by Grant Fritchey No Comments

SQL Lighthouse

Azure, Redgate Software
Red Gate is constantly experimenting with technology. Because of a long history working within the Microsoft space, a lot of the new experimentation is in and around Azure. One new venture that could be online soon is SQL Lighthouse. It's a mechanism for dealing with changing structures in an unrestricted Windows Azure SQL Database where you have multiple developers making changes. Potentially, this is pretty interesting. Please follow the link, check it out, and sign up to be alerted when the program becomes available. Many people are just getting started with Azure, especially wrapping their heads around the concepts of using a Platform as a Service rather than having infrastructure, local, virtual, or on the cloud. If this is you, and you have an MSDN license, you can get that…
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
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
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
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