Competition: What’s your favorite Redgate tool?

RoseannaWRoseannaW Cambridge Posts: 345 Rose Gold 3
edited July 12, 2021 4:39PM in General Forum

Hello everyone,

Enter our competition to win a Pluralsight subscription >:O

At Redgate, we’re big on leveling up our skills and helping each other to grow and improve.

To help you level up your skills, we’re giving you the chance to win a 3-month subscription to Pluralsight* plus Redgate goodies.

To enter our prize draw, please answer this question in the thread below: ‘What’s your favorite Redgate tool and why?’

The competition closes on 31 August and the winner will be randomly selected from the entries received.

Good luck!

Roseanna

*Pluralsight is a technical skills platform that provides web development, IT certification and online training that helps you move forward with the right technology and the right skills. 

Communities at Redgate
«1

Comments

  • jermyh_controlupjermyh_controlup IsraelPosts: 1 New member
    SQL Prompt by far!!!
    It saves time more then any other tool in DBA/DB Developer day-to-day tasks!
    It makes order and adds a real valuable info enrichment
  • jboyerjboyer Posts: 4 Bronze 1
    SQLPrompt... cannot code without it!
  • Jeff ModenJeff Moden Posts: 7 Bronze 1
    I don't use SQL Prompt.  I used to work on a whole lot of different systems for many different companies and a lot of them did use it so I never picked up the habit so I wouldn't get used to using it and possibly being lost without it.  Who knows?  It could become a favorite tool.

    For now, though, and for  the last 10 years, SQL Compare has been my favorite RedGate tool.  The methodology we currently use for final checks after UAT is to do a restore of the production database(s) affected and do the full database deployment on that.  Then, we do a compare between that and the production database.  We also have a rigid standard for how the flower box of code must be laid out especially when it comes to revisions.  Yeah... I know that may sound stupid for this day and age but comparing the flower box with those revision tracking comments have saved our hinnies more than once because people can't seem to handle trunks right for SQL especially for long term projects that aren't even close to being CICD.

    It's a whole lot easier than pawing through trunks and branches and all sorts of other stuff to make sure that there is no regressive code and, at the same time, ensure that everything actually has been both peer reviewed and reviewed by a DBA.
  • hannuhannu Posts: 1 Bronze 1
    SQLPrompt -- i just can't work without it , saves me tons of time 
  • gbegbe Posts: 1 Bronze 1
    SQL Prompt too!
  • deboraht007deboraht007 Posts: 3 Bronze 1
    SQL Compare has saved me so much time and effort in numerous situations, but day to day it's SQL Prompt, hands down.
  • Sc0ttSc0tt Posts: 1 New member
    SQL Compare by far, saved hundreds of hours of testing while migrating servers! 
  • deepsompuradeepsompura Posts: 1 New member
    Sql Prompt is my favorite tool.. 
  • gnbfilhognbfilho Posts: 5 New member
    SQL Prompt! I get desperate when I have to code without it!
  • iSoftiSoft Posts: 1 New member
    Sql Prompt , every developer need it !
  • JimbogJimbog Posts: 0 New member
    SQL Dependency Tracker is a long time favorite. Is it still free?
  • I have been using SQL Compare, SQL Data Compare, and SQL Multi Script since around 2007 and it would be hard to live without any of them! I would cry if I had to :cry:
  • Marc_MMarc_M Posts: 1 New member
    SQL Monitor, helped me find & resolve issues on production databases that had existed for a long time.
  • I liked sql data compare a lot. With this lot of ours manual efforts saved and our data is in sync. We developed various automations using powershell and sql data compare to do automatic data compares. we are in process of leveraging sql compare tool as well. 
  • KevKev Posts: 4 New member
    We have SQL Toolbelt 
    SQLPrompt  - All day everyday it saves so much time
    SQLCompare - great tool to assist in generating change scripts from Dev to Prod
    SQLSourceControl - greet tool helping is with change management in our BI env
    SQL Data Generator - Just started using this tool. it has limited use for us but very helpful when i need to fill a table with some random test data 
  • JBSSJBSS Posts: 1 New member
    SQL Compare, hands down. 
    Just saves so much time deploying changes in development DB's to Live dbs.
  • SOlsonSOlson Posts: 4 Bronze 1
    most used: SQL Search, followed by SQL Source Control
  • lupjilupji Posts: 1 New member
    SQL Monitor by far the most useful tool. This is my best friend as I am a DBA. 
    Can't thank you guys enough.
  • Udit1995Udit1995 Posts: 1 New member
    SQL Change Automation and SQL Clone are two of my favorite redgate tools.
    With SQL Change Automation we successfully managed versioning of database having 15000+ objects. The speed with which this software reads the schema is exceptional, Also it creates migration scripts where sequence is automatically generated.
    SQL Clone helped us to create replica of database for various environment and best thing about SQL Clone is that size of the clone generated is comparatively very less than the original copy.

  • LouisSomersLouisSomers Posts: 12 Bronze 1
    SQL Source Control is my favorite by far, Having the whole schema neat and tidy split up into separate folders and files, and being able to trace changes back to bugs or features, and see who implemented those changes, when and why... That's so valuable!

    Without this ability we would absolutely require to build regression test automation in order to solve bugs flipflopping each other over time (fix of bug A causes bug B and vice versa where the bugs would swap existence in following releases). Regression tests are great, but using the Annotate / Blame feature of a source control tool can provide a faster route and save a ton of time and confusion.
  • GuenterGuenter Posts: 3 Bronze 1
    SQL Prompt for hourly needs, SQL Source Control for daily needs.
    Without the one I couldn't read code produced by others (long ago) and produce code readably by others (now).
    Without the other I'd be lost in a dev database used by all developers simultaneously.
  • masterssonmastersson Posts: 1 New member
    We have close to 100 different databases, many of which have some specific deployment requirements to ignore particular objects, Redgate's tooling particularly the combination of Sql Source Control with the DLM automation tools, allows for flexibility and filtering of files as well as comparison options!
  • sql prompt
  • MaterekeTMaterekeT Posts: 1 New member
    SQLPrompt -saves me lots of coding time 
  • ProMiProMi Posts: 1 Bronze 1
    SQL Prompt
  • SocialExodusSocialExodus COEUR D ALENE, IDPosts: 4 Bronze 1
    SQL Prompt, hands down.  I'd buy my own license if my company gets stingy on providing it lol
  • JonathanCJonathanC Posts: 6 Bronze 1
    SQL Prompt, followed closely by SQL Compare. Both are critical to my job functions.
  • SQL Prompt!  I never get tired of singing its praises.  Feel like such a newbie if I'm VM'd to a server without it.

    SQL Search gets an honorable mention.

    You'd think MS would cook the functionality of these into SSMS so a big THANK YOU to Redgate for filling that gap.
  • mmcdonaldmmcdonald Posts: 1 New member
    edited August 10, 2021 11:16PM
    SQLPrompt.  The auto complete -- check.  Dump directly to Excel ("new" format) -- check.  Procedure parameters -- Check.  Formatting -- check.  Drag/drop -- check.  Save tabs -- check.

    HUGE time saver -- CHECK

    SQL Search is a great frequently used freebie :)
This discussion has been closed.