Latest Video Programs


From the Editor's Desk...

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.

Micro Services  -  Micro Services is a happening buzz word. But not without merit. You find them being implemented in just about any language or environment. Perhaps they should be on your radar. They definitely have a big impact on the DBA.

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