Category Archives: Coding

How about generate objects DDL from T-SQL ?

Some time ago, I’ve been trying to figure out how to generate the DDL of objects from the T-SQL command line. Powershell allows us to do that, from the PS command-line, as well as SMO. But SMO is not usable … Continue reading

Posted in .NET, Coding | Tagged , , | Leave a comment

SATA and write-through

Basically, this post originates in a inspiring comment from James Hamilton a couple of years ago on SATA and write reliability. We all know that Enterprise-Class transactionnal database systems use concepts such as ARIES to enforce transactionnal consistency. SQL Server … Continue reading

Posted in Coding, Storage engine | Tagged , | Leave a comment