Setting Defaults for New SQL Compare Projects

Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went looking for how to set this as a default. It wasn’t obvious to me, but since I can ping the Redgate Software developers and support staff, I found an answer for this post.

If I start SQL Compare by clicking a project, it opens and my settings are there. When I start SQL Compare, it brings up the New Project dialog, shown here:

2020-12-01 10_01_10-New project_

However, if I don’t want a new project, and close that, I have a basic interface. Going through the menus, I don’t see any way to set global options.

2020-12-01 10_02_01-SQL Compare

There are Application Options, but these aren’t anything to do with projects.

2020-12-01 10_02_09-Application options

However, I realized that I missed something a support person pointed out to me. On the options tab for any project is a button that says “Save as my defaults”.

2020-12-01 10_03_55-(local)_SQL2017.SimpleTalk_1_Dev v localhost.SimpleTalk_1_Dev.scp

I can set things from any project, or I can click the “My Projects” button in the toolbar, which gives me a list of projects (I don’t save many).

2020-12-01 10_03_38-Microsoft Edge

At the bottom of this is an “edit” button, which opens the familiar project dialog. I can click Options from there and see options.

2020-12-01 10_08_22-(local)_SQL2017.SimpleTalk_1_Dev v localhost.SimpleTalk_1_Dev.scp

When I do that, I can now set the items that I care about. The Ignore Comments is one, but there a few others I think cause issues. I do want to ignore encryption objects. I shouldn’t have the same ones  in dev as prod, so I’ll check that. Others:

  • Use database compat level (likely better than server version these days)
  • Online = ON
  • Ignore identity seed and increment (this could get changed)
  • Ignore WITH ENCRYPTION

I can then click the “Save as my defaults”. This will ensure new projects have these options. If I have old projects I want to update, I can always click the “My defaults” in the project to load what I’ve saved. This animation shows how the button works.

compare_options

Now I can easily ensure that projects work as expected on my machine. Unfortunately, these defaults are stored in the registry, so this is a client by client basis, but you can ensure all your projects are set up the same by default.

SQL Compare is a fantastic product to make it easy to see what has changed in a database. If you’ve never used it, give it a try today.

Posted in Blog | Tagged , , | Comments Off on Setting Defaults for New SQL Compare Projects

Prized PII

If I asked you what specific type of information criminals would like to capture about you, what would be your response? Take a minute and think of something and then leave it in a comment after reading the rest of this.

I know that usually more than one piece of data about me is needed, and while most of this data is probably somewhere in a database, and perhaps leaked in a breach, it’s not necessarily organized. I still think it’s good to protect information where I can. Every year my wife laughs as people wish me Happy Birthday in Facebook, on a day that’s not my birthday. I think any day is as good as any other to wish me well, and so I disclose April 1 to my friends. In fact, I often disclose a slightly incorrect birthday when sites and organizations ask me, unless I have some legal obligation to type in my real date.

There was an article that caught my eye about the data that thieves most often want. It opens with a story about pharmacists using personal data to bill insurance for non-existent medications, which is criminal activity for sure, but there’s not much you can do about these people using your data. The piece then goes on to talk about the value of healthcare fraud and how data related to this is even more valuable than credit card numbers.

That isn’t something I’d have expected, though, I do live in the US. With the high cost of healthcare, I shouldn’t be surprised. Fraud is big business, and there is a large volume of claims, providers, and statements that people have to review. If you’ve tried to go through your statements, they often don’t seem to be easily relate-able to the treatment you may have received. I think this creates opportunity for fraud, as it might not be something an individual can catch.

I haven’t worked with healthcare data, but I suspect anyone that does will need extra protection on their systems, and certainly encryption along with the prevention of PII in non-production environments is important. I also think this is the type of data that you may want to be more careful about in your own life. Though how you can be more careful escapes me.

Steve Jones

Listen to the podcast at Libsyn, Stitcher or iTunes.

Posted in Editorial | Tagged , | Comments Off on Prized PII

Daily Coping 14 Dec 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag. 

Today’s tip is to do something helpful for a friend or family member.

This one is for my wife, her employee, my daughter, and for me.

I installed an electric winch last winter to raise and lower the arena door. We use this almost daily to move hay in and out.

Attach7512_20200221_134709

Someone ran it too far and bent the drum axle. As a result, the winch didn’t work and I had to go out late one night, and hook up the manual winch again. A pain for me one night, but an ongoing pain for everyone.

It’s been broken for a week, and it’s been cold, so I haven’t worked on it. However, I ordered a new winch a few days back and when it arrived, I took a few hours to remount it and hook it up so that everyone can enjoy the convenience of electricity rather than the 70 turns the crank takes to open the door.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 14 Dec 2020

Closure with the Professional Organization for SQL Server

I know that this isn’t the correct name, though the by-laws still list this as the corporation. Perhaps this is one more sign of the failure to evolve and grow that I’ve felt from the organization.

Three directors of the PASS Board of Directors resigned this week. Mindy Curnutt, longtime member, volunteer, and advocate for the community was first, with Melody Zacharias and Hamish Watson following suit. You can read their open letters (Mindy, Melody, Hamish), which appear to hint at some sort of disagreement, argument, ethical or moral failure, or maybe just anger. I have no idea what happened, I’m curious as to what it could be, but I also think this might be something better left to fade away.

I’ve had my disagreements with the organization in the past, and I certainly think the culture and governance of the executive board is broken. In the aftermath of outcries from various prominent members of the community, Grant Fritchey left a note that there are legal issues as to what is happening now. I do not know if these are financial/debt issues or something else, and I am not speculating on what these are.

I do appreciate Grant’s engagement with the community, and in my memory, since Kevin Kline, he has been one of the very, very few to actually engage with the community on controversial issues. I haven’t always agreed with him, but I respected and appreciated the effort. However, most directors that have served on the executive committee, which includes the Executive Director from C&C, release very little information. Updates take place relatively rarely and little is proposed or discussed with members publicly.

There is no law or legal liability that would prevent an announcement of acknowledgement of the resignation of directors or a news release that thanks Mindy, Melody, and Hamish for their service. No penalty for noting they have resigned. Here, I’ll make it easy for you on Twitter:

@SQLPASS: Today Mindy Curnutt resigned from the PASS Board of Directors. We thank Mindy for her many years of service and wish her well in future endeavors.

@SQLPASS: Today Melody Zacharias resigned from the PASS Board of Directors. We thank Melody for her many years of service and wish her well in future endeavors.

@SQLPASS: Today Hamish Watson resigned from the PASS Board of Directors. We thank Hamish for his many years of service and wish him well in future endeavors.

No copyright here, feel free to cut and paste. It would be even easier to drop these three notes on the https://www.pass.org/About-PASS/PASS-News page, because, well, this is news.

Instead, we have the same lack of engagement, trust, respect, and leadership  that have permeated the culture for well over a decade. No accountability to the membership, or the board of directors, that I can see. Whether this is the appointed members (President, VP-Finance, VP-Marketing), and/or the executive director, they operate indepedently of the community and the board. This has been my primary complaint, and I suspect also, the complaint from many in the SQLFamily community.

I see no reason for a large organization to exist primarily to run a profitable conference that pays salaries and bonuses to an organization that are de facto employees, with management that doesn’t seek to be a part of the community.

As I write that, I’m saddened, mostly for the employees of C&C. Over the years I have had many opportunities to work with Marcella, Craig, Anika, Leeza, Erick, Audrey, and likely others I am forgetting. They have worked hard to ensure events have run smoothly, and I’ve appreciated their help and assistance in various matters. They have been a part of the community and I hope they continue to do so. I’m saddened that they may find themselves cast aside if the organization fails. I do hope they receive proper notice and compensation if this is the case.

My one regret in all of this is that SQL Saturday is inextricably bound up in the legal mechanisms of PASS. Andy Warren, Brian Knight, and I gifted this to the organization, trusting they would be good stewards of the events. They have been, and I know that these events will continue, either under this moniker or another. Our community is too strong to let these lapse. We will find a way for these to continue, whether with PASS or not.

I hope Microsoft continues to support community events and organizations, but I do not hope they provide any more assistance to the PASS organization. The lack of governance and transparency along with the poor culture of the executive committee and management company in engaging with the community, lead me to the conclusion this is not the place to invest and engage with a community.

The organization has helped a strong community grow over the years, but it has outlived its usefulness. It is time for an evolution to something new that better exists to serve the community rather than the organization itself.

I continue to support SQL Saturday events and chapters regardless of affiliation.

Posted in Blog | Tagged , | 5 Comments