Category Archives: SQL Server

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 →

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 →

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 →

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 →

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 →