SQL Server 2008 Resources

Online Transaction Processing in SQL Server 2008

http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_oltp.mspx

White paper: “Online Transaction Processing in SQL Server 2008,” from Microsoft. Discusses what transaction processing is, scale and performance, high availability, security and manageability.

SQL Server 2008 and Microsoft Data Platform Develo

http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_dp.mspx

White paper: “Microsoft SQL Server 2008 and Microsoft Data Platform Development,” from Microsoft. Discusses what the data platform is, improved productivity, the ADO.NET entity framework, LINQ, visual Studio, the comprehensive data platform, data connectivity technologies, rich data programmability capabilities; your data, any place, any time; scalable data-centric solutions, scalable data storage, and scalable data applications.

Programming SQL Server 2008

http://www.code-magazine.com/Article.aspx?quickid=990712122

Article: “Programming SQL Server 2008,” by Vaughn Washington. Discusses choosing a data access technology, new programming constructs (table-valued parameters), new building blocks (new and enhanced Date and Time types), removing size limitations, system types, and putting the pieces together.

A Look at SQL Server 2008

http://www.winsupersite.com/showcase/sql2008.asp

Article: "A Look at SQL Server 2008," by Paul Thurrott. Discusses what SQL Server is, SQL Server today, moving to Katmai (code name for SQL Server 2008), trusted platform, abilities, dynamic development, pervasive insight, and scheduling and pricing.

SQL Server 2008 Manageability

http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_manageability.mspx

Atricle: "SQL Server 2008 Manageability," from Microsoft. Discusses automating management with SQL Server 2008, optimizing performance with SQL Server 2008, and scalable management with SQL Server 2008.

SQL Server 2008 Product Overview

http://www.microsoft.com/sql/techinfo/whitepapers/sql2008overview.mspx

White paper: “SQL Server 2008 Product Overview,” from Microsoft. Discusses the SQL Server 2008 Data Platform Version, what’s new in SQL Server 2008, mission critical platform, dynamic development, beyond relational data, and pervasive business insight.

SQL Server 2008 for Data Warehousing

http://www.microsoft.com/sql/techinfo/whitepapers/sql-for-datawarehousing_2008.mspx

White paper: “Choosing Microsoft SQL Server 2008 for Data Warehousing,” from Microsoft. Discusses what data warehousing is, the state of data warehousing, the realities of data warehousing today, and putting the technology set together.

Business Intelligence in SQL Server 2008

http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_bi.mspx

White paper: “Business Intelligence in SQL Server 2008,” from Microsoft. Discusses what business intelligence (BI) is, unifying data storage and access, building and managing sophisticated BI solutions, and extending the reach of your BI solution.

Server Consolidation with SQL Server 2

http://www.microsoft.com/sql/techinfo/whitepapers/sql_srv_consol.mspx

White paper: “Server Consolidation with SQL Server 2008,” from Microsoft. Discusses what server consolidation is, flexibility, manageability, and scalability and performance.

SQL Server 2008 New DATETIME Data Types

http://www.sql-server-performance.com/articles/dev/datetime_2008_p1.aspx

Article: “SQL Server 2008 New DATETIME Data Types,” by Dinesh Asanka. Discusses the DATE data type, the TIME data type, the DATETIME2 data type, the DATETIMEOFFSET data type, DateTime functions, the CONVERT function, and points to remember.

SQL Server Tips

http://www.mssqltips.com/

The MSSQLTips.com website has a daily SQL Server tip. Additional resources include webinars, a newsletter, a list of the recent tips, a list of tips submitted by the community, forums, blogs, product information, and downloads.

Installing SQL Server 2008

http://www.databasejournal.com/features/mssql/article.php/3713706

Article: “Installing SQL Server 2008,” by Don Schlichting. Discusses the steps involved for the installation of SQL Server 2008 including: SQL Server 2008 setup, system configuration check, components to install, SQL Server Database Services, analysis services, reporting services, integration services and setup.