User profile for rjdudley

You ask as if it’s not still January... / comments

You ask as if it’s not still January...

0 votes

Agree on including tests but excluding tSQLt framework. I've also worked with DBEs who want to use a separate test instance of their database because they don't want the framework in the regular pipeline because it won't be in prod. / comments

Agree on including tests but excluding tSQLt framework. I've also worked with DBEs who want to use a separate test instance of their database because they don't want the framework in the regular p...

0 votes

Actually participated in a discussion on the Gartner forums about data masking products, was able to explain that RG Data Market was not like TDE and pointed out the Gartner study. / comments

Actually participated in a discussion on the Gartner forums about data masking products, was able to explain that RG Data Market was not like TDE and pointed out the Gartner study.

0 votes

Thank you for the stuff! / comments

Thank you for the stuff!

0 votes

Hey David! AWS Aurora may become a tool in our toolbox. We've been pushing our DBEs to automate deployments more and more, using SQL Change Automation. It pains me to think we'll have to fall back to SQL Change Manually for systems which choose Aurora. So I was wondering if the automated deployment capabilities would possibly be expanded into the MyQL and/or Aurora worlds. Thanks! Rich / comments

Hey David!AWS Aurora may become a tool in our toolbox. We've been pushing our DBEs to automate deployments more and more, using SQL Change Automation. It pains me to think we'll have to fall back...

0 votes

We're finally getting a serious effort going. For background we have around 1800 team members just in technology, with somewhere around 50 database engineers (DBEs) shared across the development teams. Various development teams over the last couple of years tried their own initiatives, but the DBEs were reluctant to change. The DBEs saw it as their work to do, and there was no technology-wide initiative for CI/CD so it just never got done. We now have a technology-wide mandate for CI/CD • What are the key drivers for change – frequency of deployment, reduced overheads, data protection and compliance, reduce application downtime etc? • Is the cost of investing in new technology a blocker, or is there an understanding that the eventual financial benefits will require investment in tech? • How does the database become part of the conversation? Is it part of initial planning, or is it a hurdle along the way? / comments

We're finally getting a serious effort going. For background we have around 1800 team members just in technology, with somewhere around 50 database engineers (DBEs) shared across the development ...

0 votes

1. Who is typically driving the process within organizations – development teams, DBAs, IT operational management, senior directors, CEO/CTO? We're finally getting a serious effort going. For background we have around 1800 team members just in technology, with somewhere around 50 database engineers (DBEs) shared across the development teams. Various development teams over the last couple of years tried their own initiatives, but the DBEs were reluctant to change. The DBEs saw it as their work to do, and there was no technology-wide initiative for CI/CD so it just never got done. We now have a technology-wide mandate for CI/CD, which has come from the top down to everyone, but it was a few team members advocating very strongly to the senior leadership. 2) What are the key drivers for change – frequency of deployment, reduced overheads, data protection and compliance, reduce application downtime etc? Our CI/CD adoption corresponds with a wider understanding of agile across teams. We've been trying agile for several years, tweaking our processes, and we're ready to take the next step. For us it's largely the ability to deploy more frequently, with less friction, and without working our DBEs to exhaustion. 3) Is the cost of investing in new technology a blocker, or is there an understanding that the eventual financial benefits will require investment in tech? Not really, especially since our DBEs all use RedGate tools and have a lot of familiarity with them. One of our sayings is "numbers and money follow, they do not lead", so we're not afraid to make investments. Compared to some of the other things we buy, RedGate is relatively cheap. 4) How does the database become part of the conversation? Is it part of initial planning, or is it a hurdle along the way? For us, from the beginning. / comments

1. Who is typically driving the process within organizations – development teams, DBAs, IT operational management, senior directors, CEO/CTO? We're finally getting a serious effort going. For back...

0 votes

You just need to go to My Account >> My Products. Find your product, and click "Manage". You can then remove licensed users. You should then be able to install and re-register and be good to go. / comments

You just need to go to My Account >> My Products. Find your product, and click "Manage". You can then remove licensed users. You should then be able to install and re-register and be good to go.

0 votes

Finally finished my blog post on using RedGate tools to solve data quality problems: http://rjdudley.com/data-quality-problems-and-redgate-solutions/. / comments

Finally finished my blog post on using RedGate tools to solve data quality problems: http://rjdudley.com/data-quality-problems-and-redgate-solutions/.

0 votes

I'm with you! Every time I write a SQL query (about a bajillion times a day) I wish the syntax started with FROM instead of SELECT. I do the same thing--use the ssf snippet and trim the column list, then build out the JOINs. / comments

I'm with you! Every time I write a SQL query (about a bajillion times a day) I wish the syntax started with FROM instead of SELECT. I do the same thing--use the ssf snippet and trim the column li...

0 votes

How can we help you today?

rjdudley

Comments