Archives: April 2009
Another excellent blogger here on SSC, Jeffery Yao, has posted up an interesting idea http://www.sqlservercentral.com/blogs/jeffrey_yao/archive/2009/04/20/database-administration-literature-criticism.aspx .
As a PASS chapter leader I often get asked the question, What book do you recommend for SQL Server? Several years ago you could recommend a single book to cover ALL SQL Server topics… Read more
I’ve often described SQL Server to people new to databases as a data pump.
Just like a water pump, you have limited capacity to move water in or out of a system usually measured in gallons per hour.
If you want to upgrade your pumping systems it can be a… Read more
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially. If your data set is growing over time you will end up using any memory that is not consumed today.
I’m here to tell you I don’t think it is… Read more
One of the fun facts about SQL Server and the relation model is the whole concept of three valued logic. Now I’m not breaking any new ground here I am just touching on something that trips people up when they expect a result and don’t get it due to the… Read more
"Any technology, no matter how primitive, is magic to those who do not understand it."
Arthur C. Clarke penned three laws of prediction
- When a distinguished but elderly scientist states that something is possible, he is almost certainly right. When he states…