Echoing what I have advocated for years now is that we need to design our networks so that there is a clear demarcation, and physical/electronic isolation between internal and external systems, with...

It seem more and more I m asking why we want to do many of the things we see being done with technology, and I have concluded that 'Because we...

Well, we already have the SQL code stored inside the database so it can be deployed along with database changes to the server.  Maybe we should also make it possible...

Probably the riskiest experience I dealt with over the years was one position where I worked for a manager with a huge ego and small experience.  One day while I was...

Unfortunately, I firmly believe from what I saw during my years in IT is that 'big data' is often the result of system design that is incomplete and lacking in foresight. ...

As with any business process, implementing changes can be under-managed or over-managed.  Several years before I left a DBA position I discovered that a particular set of about a dozen self-requested...

I think one thing all of this discussion points out is the importance of proper validation of data either at the application level or the database update level. or probably both...

crmitchell (12/23/2016)

---

Until that one occasion where it does matter. As Murphy and Sod will cheerfully...

gfish@teamnorthwoods.com (12/21/2016)

---

Let me suggest a much simpler way of avoiding the CPU spike caused by running multiple jobs at once. Simply combine them into one job, with the contents of...

skeleton567 (12/20/2016)

---

Igor Micev (12/20/2016)

---

skeleton567 (12/19/2016)

---

Two things are going to cause CPU spikes by scheduled jobs:

1. Poor design that causes a requirement that a job be run too frequently.

2. ...