Steve,

Great topic. I think the more appropriate question would be; is there any company that has not had a data breach?

We see in the news, time and time again every...

Maxtardiveau,

I agree with what you’re saying. When I worked at Dell Computers, we presented a similar issue to Microsoft in relation to the Microsoft Office suite. Their response was “it’s...

Scott wrote:

(Any thoughts on article concepts focusing on "going back to basics" and "relearning the essentials"?)

I don’t know if this is still an idea...

• This reply was modified 2 years, 3 months ago by  Aubrey Love.

Jeffry,

I suppose my wife is somewhat correct in accusing me of being OCD. I have a tendency to group my constraints by constraint type, then table name, then column name.

All...

Jeffrey,

Actually I've never had that issue.  (Yet!)

In that scenario, I would have to break tradition and add the schema name prefix to the table name when naming the constraint.

Jeff,

I don’t see a need to call the “column name” on the PRIMARY KEY either. But, since I use the 3-part naming convention on all the other constraints, I just...

• This reply was modified 2 years, 9 months ago by  Aubrey Love.

Maybe I’m out of sync with all others, but I have always preferred the 3-part naming convention.

“PK_tableName_columnName”

This allows for distinct constraints in one table. For example, if I have multiple...

This is a good reminder to all that a constraint is an object just like tables, views, functions, triggers, etc. Since you are trying to create two objects with the...

Sean Redmond,

Here are couple of options for online training that I would recommend.

Option 1:

Linux full course: (YouTube) about 7.5 hours using Ubuntu, Zorin, etc.

Link - The Complete Linux Course: Beginner...

• This reply was modified 2 years, 9 months ago by  Aubrey Love. Reason: Clarifying the links

Mastery level: to know everything there is to possibly know about a given subject without the need of an outside reference.

True, you are on the mark with my point. In...

“Jack of all trades, master of none.” That is the phrase that first comes to my mind while reading this article. That has been my life’s story.  I have worked...

I know this thread is a little old, but if you are still looking for reviewers, I would love to help. I see a lot of articles on this site...

I’m going to have to side with Jeff on this one. With on-premise servers, both the initial and long-term costs may be more than the cloud, financially speaking. However, what...

Heh... almost forgot... "Seatbelts save lives" (at least people laughing so hard)

Alas, my office chair is not equipped with a seat belt, just a couple of retainer rails,...

Thanks. I'll put together an article and submit it to see how things tic along.

I read the contributor pages, seems fairly straight forward.