Sql Server Yukon book proposal
I decided to post this here with the hope that a book publisher or another author might be interested. This was a tentative Outline / TOC Sql Server Yukon book that myself and few others had proposed to a couple of publishers. When we first shopped it, we got the response that Yukon was too far out but that they would keep us in mind. We have never heard back from anyone despite several followups. My guess is that the bloody state of the technical book publishing industry is to blame. If you are a publisher and are interested, click the contact link on my blog to get ahold of me.
If you are an author working on some Sql Server book or a Whidbey book and need a co-author (or someone for a chapter or two), let me know.
If you have any suggestions with regards to the book Outline / TOC, let me know. This was fairly tentative given what we knew at the time of the writting.
Introduction: This is an outline / TOC for the proposed book “Enterprise Developer’s Guide to Microsoft Sql Server Yukon.” Microsoft is currently working on the next major upgrade to its enterprise database. This major upgrade is expected to add a number of new features to the database and to the features that developers may use to build solutions for customers. For this point forward, the term “Sql Server” will refer to the Microsoft Sql Server “Yukon” release unless otherwise stated.
Outline:
1. Introduction to Sql Server.
What is it.
Short History.
Design Goals.
Architecture.
Engine.
Tools.
2. Sql Server Yukon Management Tools.
Sql Workbench
Profiler.
DTS.
SqlCmd.
Sql Computer Manager.
3. Database Design.
Creating databases and tables.
Normalizing data.
Primary Keys.
Foreign Keys.
Indexes.
Full Text Search.
Views.
4. Datatypes in Yukon.
Standard datatypes.
New, enhanced datatypes.
Large varchar / varbinary
Time.
SqlUtcDataTime
SqlUtcTime
SqlDate
5. T-SQL Language & Enhancements.
T-SQL Language.
Stored Procedures.
DDL
Integrate with the CLR.
Triggers.
Genealogy.
6. Integration with the .NET Framework.
CLR support.
Security.
Sql Server Namespaces
System.Data.SqlServer.
System.Data.SqlFunctions
Attributes.
SqlContext.
SqlPipe.
SqlTriggerContext.
GetReturnResultSet.
Development.
Stored Procedures.
Functions.
Comparing the .NET and TSql equivalent functionality.
Debugging.
7. Data Access and programmability.
ADO.NET.
Connection.
Command.
DataAdapter.
DataReader.
ResultSet.
Async Support.
Multiple Resultsets.
BulkCopy
Paging.
SqlDataTable.
Changes to System.Data.SqlTypes
Ole-Db.
ODBC.
Classic ADO.
DMO.
8. Integration with XML.
XQuery.
XPath.
Web Services.
9. Notification Services.
10. Service Broker aka Message queueing.
Featureset
Dialogs.
Service Instance.
Message ordering.
Full & half duplex.
Message management (breakup and putback together).
Scalability enhancements.
11. Tuning for an application.
Profiling application calls.
Diagnostic Data.
Profiler.
Performance Monitor.
12. Transaction support.
Cursors.
Integrity and locking.
Integration with other data sources.
Replication and other design issues.
13. DataAnalysis.
OLAP
Data Warehousing.
Business Intelligence and Analysis.
Analysis tools.
Excel.
Access.
14. DBA issues.
Installation.
Configuring.
Sql Server Agent and maintennance.
Replication.
Transferring data.
Bulkcopy.
DTS.
Bakup/Recovery.
15. Migration.
16. Server and Hardware Performance settings / tuning.
CPU assignment.
Threading.
Memory allocation.
Hard drive configuration.