SQL Server 2005, now available as a "community technology preview," is an odd beast. For those who believe their databases should be little more than simple data access routines with business logic ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

Microsoft announced today that SQL Server 2008 R2 is released to manufacturing just 20 months after SQL Server 2008, the platform on which it is built. SQL Server 2008 R2 (codenamed Kilimanjaro) ...

Here's a quick look at the improvements to the R2 release that I think will be useful come the May release date. Microsoft is nearing completion of the next version of SQL Server. The R2 release ...

SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, ...