It would be nice if you had asked that DBA why he was worried about others stealing his ideas. If you're working in an environment where others frequently show off...

I would like to add my two cents here too as I happen to work both as a .NET developer and a SQL Server DBA a lot. At one of...

After dealing with different bosses, I have learned over time that dealing with me can also be a hard job for my boss. Trying to understand each other may be...

It depends on the exact profession but in my opinion nothing can replace a solid theoretical background. Especially with databases, because thinking in sets instead of records requires a mind...

In my humble opinion you should always prefer "when' over "if", that should be true for security as much as for recovery. With recovery the "when" scenario makes you practice...

Maybe now is the right time to switch to multi-factor authentication on all your accounts. Well, at least on all accounts that allow this additional security measure. Notice that even...

I guess it should be...

One concept not yet mentioned are transactions. When you change anything in a database, always start with a BEGIN TRANSACTION and check the number of rows, or even better, check...

Unlike testing applications, where failure is an common sign of some flaws in the code, testing database facilities like stored procedures, user defined functions, views and queries is much harder,...

With most persistence frameworks or query facilities (like Linq) it is very easy to fetch complete objects and then access only a few properties of these objects in a for...

I live in the Netherlands (some of you may call it Holland) and I do believe we have a superb internet connectivity. By now most parts of our beloved country...

Most of you are asking for readable SQL and good example data. But how often can you transform real problems into such an academic setting? More often than not, bad...

SQL has strong roots in relational algebra, this makes it harder to implement but easier to verify. If you use concepts like 'eventual consistency' it is much harder to find...

David Lean (8/27/2013)

---

1. In general it costs just as much to develop code with poor performance as it does to develop fast code. The same can be said for security....

Maybe a honeypot will attract outsiders, but it will not save you from insiders compromising your security. IMHO if organisations will use honeypots and decoys on a larger scale, some...