I'm guessing you're talking about a database modeling or entity relationship diagram (ERD) tool. I don't know of an extension for SSMS or Visual Studio, but there is a tool...

When it comes to hacks against corporate or government targets, it is entirely plausible that in many cases the public disclosure itself is of more importance to the hacker than...

.. The downside of chaining to slack and then Pagerduty is that is Slack is down, what happens? It's not often Slack goes down, but with my prior luck,...

I believe you have two issues:

(1) Your SSIS package(s) are probaly logging a tremendous amount of event detail.

(2) The above has caused your SSISDB database to swell and then the...

Synonyms can be useful for whomever created them, but confusing for others who stumble across them by accident. It depends on the purpose, but I prefer views instead.

Yes, setting up an event monitoring solution is phase 1. The next phase is setting a solution for alerting, collaboration, triage, and incident workflow. Historically, we had error and threshold...

• This reply was modified 6 years, 3 months ago by Eric M Russell.

If this user is to have only reader access going forward, then I would suggest changing the owner of the schema to someone else, like DBO.

ALTER AUTHORIZATION ON SCHEMA::schema_name TO...

I guess the problem with users as it relates to security and deployments would be that: if a process is not simple, then they won't follow it. So the solution...

Just out of curiosity, how does Microsoft inform someone they have been awarded MVP status?

Back in the 1950s, it was predicted that mass produced frozen TV dinners would enable most Americans to purchase homes without kitchens and restaurants would be obsolete. While technically possible,...

One design pattern is to separate the PII database from the operational database using a service oriented architecture and that PII database could even be hosted by a 3rd party...

For a highly selective and sensitive database, something  like AIDS patients or voter records, address should be protected. Not only can it be used in conjunction with other public databases...

So, how is it possible that an employee (even an IT administrator) clicking on an executable attachment can somehow wipe out the bulk of the organization's databases, network file shares,...

• This reply was modified 6 years, 4 months ago by Eric M Russell.

Steve, your final point about how the insurance industry can help stimulate the progress of enterprise IT security is a good one. It's essentially the same same concept as the...

• This reply was modified 6 years, 4 months ago by Eric M Russell.

I know I'm not a Villain, but I'm not sure where I fall on the spectrum between Hero versus Anti-Hero.

https://writerswrite.co.za/heroes-and-anti-heroes-whats-the-difference/

How far I'm willing to go beyond the call of duty...

• This reply was modified 6 years, 4 months ago by Eric M Russell.