Category Archives: SQL Server

Strange use of NULL in SQL Server and Oracle

I am not going to participate in the debate of whether NULL is good or the billion dollar mistake. At least not now. All scholars agree that introducing NULL was a mistake, but I tend to be very skeptical about … Continue reading

Posted in SQL Server

Using SQL Server to solve Einstein’s puzzles

A particular category of logic puzzles have to do with the satisfaction of constraints. Among those are the so called “Einstein’s puzzles”, also called “zebra puzzles“. The first time I saw such a puzzle was about 10 years ago. I … Continue reading

Posted in SQL Server

Case by case explanation of the CAP theorem

You know the saying: “You can have it done fast, cheap or right; choose two”. This is something no boss or customer wants to hear, but it is also very true. It is like a law of nature. You cannot … Continue reading

Posted in SQL Server

A frequent transaction log backup misunderstanding

Some SQL Server students or new DBAs seem to ignore the fact that you have to take transaction log backups, if you do not use the SIMPLE recovery model. In other words, if you set FULL or BULK LOGGED as … Continue reading

Posted in SQL Server

The OLAP oxymoron

The mid 90’s were marked by the mass adoption of the Internet. This revolution was so significant, that has somewhat lessened the effect of other advances, quite revolutionary on their own right. One of them was On-Line Analytical Processing, or … Continue reading

Posted in SQL Server