Latest Video Programs


From the Editor's Desk...

It's Time to Break Your Business Rules Out of Your Database  -  For years we have held on to the best practice of keeping your business rule implementation close to the data, by enforcing them in a SQL database. I don't think that is wrong. However, I think you need to ask yourself, very seriously, what is the cost of that design decision. What are you giving up?

Design With Clarity  -  You can design a database, and using good naming conventions, you can provide valuable clarity to your schema without extra work.

Collaboration is the Best Primary Key  -  Based on the feedback on naming conventions for a primary key, it seems there is no front runner for a best practice. See what I mean...

Primary Key Names  -  This is a topic that continues to arise. Developers tend to have one position. DBAs have another. Today I share a recent conversation from both sides.


Separation of Storage from Access  -  If you think about it, what do all of these database engines have in common: BTrieve, Fox Pro, Dbase, Omnis, Paradox, FireBird, SQL Server, Oracle, Sybase, MySQL, Posgres, Informix? They all support the independence of the internal storage from the data access tool, SQL. Why is that significant today?

Stateless Apps and RowVersion  -  Have you ever used a stateless app where they tried to implement database locking? There's a exercise in futility, resulting in more bugs than anything. A better implementation may be to use Optimistic Locking with a RowVersion data type in an SQL Server database.

Getting Into the Cloud  -  The Cloud has matured far beyond Fad status. Still, it seems big business hesitates to commit core applications into the Cloud. What's going on?

Use an Alias To Enable Collaboration  -  What do you do when you have a different database connection string that other developers on your project? You can create an Alias to connect to the database, so that the same name may be shared by all developers.

Community Content - News, Articles, How-To Information and More from Around the World