30Jul 2018 by Grant Fritchey No Comments

Identifying HIPAA, PCI & SOX Data for Masking

Redgate Software
Working for a company based in the UK (still currently a part of the EU) I had a lot of motivation to learn about the GDPR and what it means for data professionals. Further, the understanding that, through treaties and court precedent, the GDPR can apply to companies around the world also motivated me to learn about the privacy and protection mechanisms that it required. However, there is privacy and protection much closer to home from the data and security definitions in HIPAA, PCI and SOX. I've been doing a bunch of research on all these to better understand how they, along with the GDPR, and a whole slew of new legislation coming from around the world, will impact the database. More specifically, I've been trying to understand how best…
Read More
07Jun 2018 by Grant Fritchey No Comments

SQL in the City Streamed: June 2018

DevOps, Redgate Software
Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to learn about SQL Server, the Microsoft Data Platform, privacy and protection, the GDPR, and, of course, DevOps. All of that, with some great information on Redgate tools and how they can help tossed in there. Agenda Scroll down at the link and check out the agenda. We're covering a pretty wide range of topics this time. I have the keynote, and I'm not going to tell you what it's about yet. OK. I'll tell you a little. Twist my arm. I have a message about DevOps that I think is very important. When it comes to the database, we frequently think about development and deployment as nothing but change, and…
Read More
08Dec 2017 by Grant Fritchey 1 Comment

SQL in the City 2017

Redgate Software
Redgate is once again hosting a live, virtual event for SQL in the City. We're going to give you a lot of educational content on DevOps, SQL Server, Monitoring, GDPR and compliance. We'll also be doing all this with Redgate tools. Here's my promotional video for the event: [video width="1280" height="720" mp4="https://www.scarydba.com/wp-content/uploads/2017/12/SitC.mp4"][/video] I hope you'll join us for this event. It's live, so you can ask questions and we'll all try to help out. Go here to register.
Read More
25Oct 2017 by Grant Fritchey 2 Comments

PASS Summit and Redgate Software

Redgate Software
Next week is the PASS Summit. I'm so excited about it I could pop. Part of why I'm excited is because Redgate always does so much fun stuff at Summit. I'm presenting sessions, Steve Jones and our latest (and probably greatest) new team member, Kathi Kellenberger are also presenting sessions. This year is we're also going to be throwing a great party. Stop by the booth, talk to a Redgater (me included) and we'll get you a ribbon for the #redgaterocks party. It's taking place on Thursday, November 2nd at 1927 Events, 1927 3rd Ave. We'll have a bunch of our people at the booth ready and willing to show of all the cool new software we've been working on. If you're at PASS Summit, please track me down in the…
Read More
06Mar 2017 by Grant Fritchey 41 Comments

SQL Clone and a Little Competition

Database Lifecycle Management, DevOps, Redgate Software
Redgate has released a new product, SQL Clone. I've already talked about how excited I am about it. Now, it's your turn to get excited. Our developers evidently had too much time on their hands after building SQL Clone. They created a skill in Alexa that lets you clone a database using voice commands. In fact, I was recently visiting Redgate HQ and was able to try it out and you can watch here. [embed]https://www.youtube.com/watch?v=1zI2Oj9EZM8&feature=youtu.be[/embed] Now, in celebration of the launch of SQL Clone, we want to enable you to do some voice commands of your own. We're giving away five Amazon Echo Dots and one copy of SQL Clone to an overall winner. To enter, go into the comments and let us know what skill you would like to build for Alexa…
Read More
18May 2015 by Grant Fritchey No Comments

Come to Us or We’ll Come to You

Database Lifecycle Management, DevOps
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…
Read More
26Feb 2015 by Grant Fritchey 3 Comments

How to do DevOps as a SQL Server DBA

Database Lifecycle Management, DevOps
You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support for your development teams as you possibly can, that you have to have testing in place to ensure protection of the production environment, that you need to speed your processes. In short, you recognize the need for taking on a DevOps approach, an Application Lifecycle Management (ALM) approach, even, a Database Lifecycle Management (DLM) approach. Cool. Now what? Well, there are three fundamentals that you need to get under your belt. You need to get your database into source control. You need to set up a continuous integration process. You need to set up automated deployments. All tough nuts to crack. Hey, we get it. That's why Redgate Software is going…
Read More