Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Man of Mystery

Wes Brown is a PASS chapter leader and SQL Server MVP. He writes for SQL Server Central and maintains his blog at http://www.sqlserverio.com. Wes is Currently serving as a Senior Lead Consultant at Catapult Systems. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays.

Archives: April 2009

So, what book do you recommend?

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

2 comments, 173 reads

Posted in SQL Man of Mystery on 19 April 2009

SSD, The Game Changer

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

24 comments, 339 reads

Posted in SQL Man of Mystery on 13 April 2009

You thought SQL Server ate up memory…

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

6 comments, 632 reads

Posted in SQL Man of Mystery on 11 April 2009

NULL is not = to anything

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

3 comments, 516 reads

Posted in SQL Man of Mystery on 9 April 2009

It’s all magic to me.

Technorati Tags: ,

"Any technology, no matter how primitive, is magic to those who do not understand it."

freefall 

Arthur C. Clarke penned three laws of prediction

  1. When a distinguished but elderly scientist states that something is possible, he is almost certainly right. When he states…

Read more

3 comments, 314 reads

Posted in SQL Man of Mystery on 5 April 2009