SQL Consulting: SQL Server Is Our Only Business.
posted on
The Meaning of Null If you think that this article will be confined to academic subtleties of no interest to real-world dba’s, let me first mention that misunderstanding the meaning of NULL cost a …
Continue Reading about The Two Million Dollar Misunderstanding →
posted on
Those who are new to SQL Server tuning are often puzzled why the query optimizer in SQL Server would prefer to scan an entire table instead of using a non clustered index that seems to fit the query …
posted on
If you are a longtime reader of this newsletter you probably know that I have no financial connection with Microsoft, nor do I have any connections to third party vendors for SQL Server add-ins. It is …
Continue Reading about SQL Server 2017 is a brand new world →
posted on
I came across this newsletter in my archives that I wrote a long time ago. However I think that there is still a need for this information. I can't guarantee that some of the features I discuss …
posted on
Microsoft is constantly improving SQL Server. There are new features in each new version and there are some old features that have been eliminated from the newer version. One reason for the …
posted on
The number one responsibility that a DBA has is to keep the data safe. Many things can harm your data but the one we are going to talk about now is data corruption. Since this article is written …
Continue Reading about Recovering From Database Corruption →