Skip to content

Sponsor: Do you build complex software systems? See how NServiceBus makes it easier to design, build, and manage software systems that use message queues to achieve loose coupling. Get started for free.

Learn more about Software Architecture & Design.
Join thousands of developers getting weekly updates to increase your understanding of software architecture and design concepts.


Follow @CodeOpinion

Random

SQL Server Transaction Log File (LDF) Misconception

A common misconception is that setting the recovery model to simple will cause SQL Server not to use the transaction log file (LDF), preventing it from growing to an abnormal size. In fact, the simple recovery model will still use the transaction log when performing transactions, however it will reclaims log space to keep space requirements small. The actual file size will not be reduced by reclaiming space.  Same as performing a transactional backup will not reduce the actual file size. This is important becase if you have a long running transaction that is performing many insert/update/delete statements, the transaction… Read More »SQL Server Transaction Log File (LDF) Misconception

Leaders in Big Data

Charles Fan from VMWare makes an interesting note regarding CRAP data. Data is mostly event driven and not CRUD’y anymore.