Voice of the DBA

Tag: Redgate

  • SQL in the City Sydney in Two Weeks

    It’s two weeks to our next SQL in the City Summit, this time in Sydney. I’m excited to be going back, though it’s a quick trip for me. Likely I’ll be fueled on lots of coffee for the two days I’m in Australia, so if I’m speaking a bit fast, remind me that the rest of you aren’t on a whirlwind, halfway around the world trip.

    2019-08-29 10_29_58-Redgate's SQL in the City Summit Sydney

    We had great reviews on our previous tour, and I was sad to miss Sydney, but we’re coming back on Sept 27. The schedule is slightly different, but we’re thrilled to have Damian Brady from Microsoft talking about their DevOps transformation.

    Anderson and myself will represent Redgate and deliver a few session on our tools, and we’ll have the amazing Hybrid DBA, Hamish Watson coming as well.

    Register today and come learn more about Compliant Database DevOps and Redgate solutions to help you write database code more efficiently.

  • Changing the SQL Data Masker Connection Target

    This post will explain how to change the connection in your masking set when using SQL Data Masker from Redgate.

    I’m writing this more for myself than anyone else. I find myself using Data Masker for different databases at times, and I keep forgetting this. I just spent more than the 2 minutes I’d expect on Google searching, so I’m adding a post in hopes that I’ll remember this.

    When you start creating a masking set, you’ll connect to a SQL Server and choose a database. Later, you might want to change this, or test the masking set elsewhere. Where is the connection string? I had thought it would be in the settings somewhere, but it’s not.

    It’s in the controller.

    The controller is usually at the top of the list, but there could be other ones. However, they are the most left displayed items.

    2019-09-02 14_28_27-SimpleTalk_Prod_Mask_ Data Masker for SQL Server

    Double click the controller, and you’ll see something like this.

    2019-09-02 14_29_14-Edit Rule Controller

    Here you can change the instance and database needed. To save the changes for your session ,click the “Update Rule Controller” on the right. To save the changes in the set, save the entire set.

    Hope this helps you, and hope it helps me remember how to do this.

  • 20 Years of Compare

    When we started SQLServerCentral, there were originally 7 of us. We all decided to “invest” $50 to get the site going. With this seed money, we paid for a VM that hosted both SQL Server and IIS. This was enough money to run the site for 6+ months, and we set about building an online educational community and trying to raise some revenue by selling advertising.

    Our first customer was Redgate Software, and the primary reason that we approached them was SQL Compare. At the time, one of my partners was a very happy customer of SQL Compare and thought that others should know about it. The rest is history, with SQLServerCentral, Redgate, and SQL Compare growing and changing across the years.

    That was 18 years ago, and Redgate turns 20 this year, having grown and changed quite a bit in that time. In conjunction with the celebration, we’re releasing SQL Compare v14, with a Linux command line version. That’s something I could never have conceived up in 2001 when we started SQLServerCentral. There are plenty of other features in the new version, and I’m amazed at how useful the SQL Compare technology has become two decades after its first release.

    SQL Compare is the industry standard technology for comparing databases. It powers our Database DevOps automation tools as well as many manual processes that tens of thousands of customers run every day. From synchronizing work between developers to detecting drift to building rollback scripts, SQL Compare ensures that many of us can find out the state of the various instances in our environments. It’s a simple technology, but one that hundreds of thousands of people depend on every day.

    When I first heard of this product, I never imagined that this would be as popular a tool as it has become. The idea of comparing two databases to find the differences was something novel at one point. Today, it’s become an indispensable part of many developers’ workday. Join me today and wish Redgate and SQL Compare a Happy Birthday, and tune into SQL in the City Streamed later on today, where we’ll talk a little about SQL Compare and its history.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • SQL in the City Streamed is Today

    Today is SQL in the City Streamed!!!

    2019-08-23 14_49_07-Redgate Friend, Events, And Community Activities

    Only three of us, Sad smile, as Kendra has other commitments. Still, it’s exciting for Kathi, Grant, and myself to be presenting the Birthday Edition as Redgate turns 20 this year.

    Join us later today for the broadcast, which will have some fun tech, new tips, and some nostalgia about the company and the last 20 years.

    Register today