Database Lifecycle Management

Red Gate 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

The Red Gate Way…

DevOps, PASS, Professional Development, Red Gate Software, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, TSQL
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

Worst Day of a DBAs Life

Professional Development, Red Gate 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

Monitoring Structure Changes

Azure
Most everyone I know works with environments that are carefully controlled and structured. All changes go through rigorous testing and full documentation. Absolutely nothing happens in a production environment that hasn't been thought through, discussed, planned for and written down. But, there are a few, a very few, who work in a slightly different kind of environment that they refer to as "the real world." In this "real world" changes to a production environment can happen without approval, planning or testing. Scary, right? There's good news for these poor benighted souls. Red Gate is testing out a new piece of software called SQL Lighthouse. It's meant to monitor your systems for changes so that you know what has happened and when in case you don't have a good source control…
Read More

Speaking this Fall

PASS, Red Gate 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

Painting the US Red

Red Gate 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

SQL in the City London 2013

Red Gate 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

Helping Database Administrators

Red Gate Software, SQL Server 2005, SQL Server 2008, SQL Server 2012
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

SQL Saturday #187 Richmond And More

Professional Development, Red Gate Software
In just a couple of weeks I'll be flying down to Richmond, VA to speak at SQL Saturday #187. I'll be presenting two topics, Backups for the Accidental DBA and Query Tuning in the Clouds. It's going to be a great event with a bunch of excellent speakers. If you're in the area, come on down and say hello. And, if you have some time on Friday before the event, Red Gate Software is hosting a special 1/2 day seminar targeting the database professional just getting started with their career. There are only a few seats left, so if you're interested, sign up quick. Steve Jones and I will be presenting on several topics from monitoring to backups, database corruption and indexing. It'll be great way to learn, network, see…
Read More

SQL In The City: Seattle

PASS, Red Gate Software
If you missed all the great speakers on the five city tour of SQL in the City, don't despair. Many of the same people will be back at SQL in the City in Seattle. It's scheduled on Monday before the PASS Summit proper starts, so if you're looking to get your learn on early and you can't sign up for a pre-con, this is a great, free, opportunity to pick up some additional instruction. Check out the list of speakers. It's going to be an event worth attending. I've seen the early drafts of the feedback forms from the prior five events. People really seem to enjoy this slightly different approach. In short, Red Gate puts on a heck of a show. During the five city tour, I was able…
Read More