Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server databases for development and testing. Oh god, that sounds like marketing speak. To heck with that. Let me tell you why I'm so excited about SQL Clone and why I think you're going to be excited too. Once Upon a Time... Almost two years ago one of the developers here at Redgate called me over. He wanted to show off this neat trick he'd figured out. What I saw was a good-sized database, about 200gb, created on his local instance of SQL Server in about 10 seconds. Now, that's fast. Further, he showed me the files and disk space on his machine, and it was only taking up a few…
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL Saturdays over the last couple of months, I decided to refresh and update that original content and post it again. I keep hearing how the job market has changed. That companies just don't want to pay for training any more. However, I don't recall any of my employers in the past ever actively wanting, desiring, begging me, please, oh, please, can't you go out to a little training? In fact, for the most part, I pretty much always had to beg the boss to send me out to training. I had to sell it. I don't think that's a new development. Let's review the selling points to help you convince the boss.…
It's weird being an introvert who likes to talk to people, but what can I do. I like talking to people. I have a number of upcoming trips, quite literally all over the world, that provide us with the opportunities to get together and have a chat. First, I'll be at SQL Saturday Boston (the 500th SQL Saturday event, HUZZAH!), this weekend, March 19th 2016. I'll be talking about the Query Store and I'll be doing a presentation for PASS since this is a milestone event. The first SQL Saturday event in Boston was #34, six years ago, which I helped organize. It's been quite the journey. I'm going to SQL Saturday Madison on April 9th. I'll be talking about the Query Store and how to automate your database deployments.…
I spend a lot of time talking about the need for automation within your databases, especially in support of development, deployment, and through process management. It's because I learned the hard way just how important this stuff is. It took a pretty strong developer (in the sense of abilities, he didn't beat me up) to convince me that I was doing database development the wrong way. However, once he made me see the light, I was like one of the Blues Brothers, on a mission. However, I think this is one of the hardest parts to get people to understand. If you have a mostly, or completely, manual deployment process, you're experiencing pain from the inefficiencies that causes. However, it's a pain that's just embedded into the organization so much, that…
You know you want to go on the SQL Cruise. You can. You just have to convince the boss that it's worth doing. It is. I've said it before and I'll repeat it as necessary, SQL Cruise changes peoples lives. I've watched people go on the cruise with a job and come back with a career. People don't just learn on the Cruise. They get energized. They get engaged with the data professional community. How do I profit by promoting SQL Cruise? I don't. Tim Ford is a friend and I'm supporting him. My company, Redgate Software, is a sponsor of the cruise, so I'm supporting them. I could just be doing the bare minimum in support of these parties. However, I'm not getting paid anything special by anyone for doing more.…
I recently spent two days consulting with a company on their database development and deployment processes. They are a small, capable, team of developers, database developers and a DBA who have embraced the idea that they need to be able to automate their deployments. I wasn't in there to teach them much of anything, but to help walk them through what the possibilities were for their deployments. It was a great experience and I learned a lot. They recognized that it was time to change what they did and how they did it in order to achieve greater efficiencies. They recognized that, while they were successfully building and deploying their databases (a capable team, remember), they were experiencing pain that they could alleviate. Like Peter, it was a time for change. I…
Alternate Title: I'm traveling a bunch. Let's get together and talk. A bunch of trips and presentations coming up, so I thought I'd share. First, I'll be SQL Saturday Omaha for my first time ever presenting in Nebraska. I'm excited to add this state to my list (which is almost over 40 now). If you're not doing anything August 15th, let's have a chat. Next, fingers crossed, I'll get selected to fly back to my home state, Oklahoma, to go to SQL Saturday OKC. These guys put on a great event and hey, it's Oklahoma so how can it be bad. I hope they announce soon. I need to schedule my flights. This one is on August 29th. September also has several events. First, I'll be at SQL Saturday Las…
When I attend sessions at events, I try to mix it up. I'll go to a session that, really, I probably will never use the information, just to expand my knowledge level a little. I also go to sessions by the masters so that I can try to expand my skill set. I go to sessions on topics that I feel like I know well just to reinforce my own learning and understanding. That's where I got the Speaker of the Month for May 2015, Denis McDowell (t). I went to his session titled DevOps for the DBA at SQL Saturday #380 in New York City. I present pretty regularly on this topic and I've helped build multi-day training courses on it. Seriously, I feel like I probably know it.…
No, that's not a threat. It's an offer to help out. Redgate Software is very serious about the efforts we're putting into creating the tools needed to support your Database Lifecycle Management (DLM) processes. DLM is a vital part of supporting both Agile development methods and moving towards an automated DevOps style of systems management that tightly integrates your software development and deployments with your database development and deployments. I've said it before and I'll say it again, you can get really good at performing manual tasks, or you can get really good at automation. You want to get good at automation and we're here to help. Getting a smooth process from source control, continuous integration, continuous delivery and continuous deployment can be a lot of work, but work with huge…
Sjor Takes (b|t) has just barely started blogging, but he's got a great post about a discussion he had with a colleague. It's worth a read. When you get done, I'll provide my answer to the question posed at the start and conclusion of his post. I had a great discussion with one of the smarter people I know late last year. Since I'm going to disagree with this person rather vehemently, I'm going to keep them nameless. We were discussing databases and DevOps and how it relates to the developer, the data professional, specialized DBAs and businesses. It was mostly a great conversation except for this person's opening. This isn't an exact quote, but it paraphrases their beliefs fairly well: The DevOps movement is, intentionally, about getting rid of the…