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 ...

SQL Server consolidated its No. 1 position in the 2002 worldwide OLAP market, where Microsoft's presence continues to drive down the value of the average sale. But even so, Redmond is not enjoying the ...

Later this year, Microsoft will revamp its SQL Server 2000 database with a new reporting services add-on. SQL Server 2000 Reporting Services will make its debut as business intelligence (BI) vendors ...

Online analytical processing (OLAP) databases are purpose-built for handling analytical queries. Analytical queries run on online transaction-processing (OLTP) databases often take a long time to ...

SQL Server 2005, code-named Yukon, will include updated Reporting Services that let developers send out report-processing capabilities with their custom applications. That will be done in the form of ...