XML
- BizTalk server to act as switch.
- SQL 2000 to accept raw XML requests. Currently uses IIS and an ISAPI dll for the beta.
- Resultsets formatted for displaying on web-page or XML client
- Images can be returned as URL for direct viewing from client
- GET and POST HTTP commands used
- On the SELECT statement use "FOR XML xxx" parameter to retrieve in XML format.
The xxx parameters indicate what sort of XML formatting to use.
- Updategrams – updates the database directly with XML. May not make SQL 2000
release.
DMO/WMI
- SQL 2000 gives WMI/WBEM support.
- SQL DMO footprint reduction of 50% over 7.0 SP1
- SQL DMO 2000 compatible with SQL 7. 80 new interfaces plus improved interfaces use
"2" interface names to comply with COM standards. Original names there for
backward compatibility.
- DMO vs WMI :-
DMO is installed on clients and is hierarchical
WMI SQL Provider – is installed on server, less network round-trips, consistent
management access and provides event notification. I.e. can write an app that sits and
waits for triggers to be created, database to be extended etc. and report on this.
- SQL WMI Provider needs WMI 1.5 core files to be installed.
- WMI schema stored in a separate WMI namespace called "MicrosoftSQLServer"
under the root namespace. MSSQL is used as a prefix for all classnames.
- WMI calls DMO with SQL 2000. With future versions it will bypass SQL DMO and talk
directly.
Full-Text
- 9x better incremental support. 30% faster full crawl.
- Works in fail-over cluster
- Column level linguistic analysis
- Maintains list of changes to indexed data (change tracking)
- Image filtering – supports MS Office documents and HTML
- Custom filters can be written to support 3rd party file formats
Miscellaneous
- Windows CE version of SQL Server. Doesn’t use same server engine. Supports all
WinCE cpu’s. DML/DDL, cursors, cascading RI, security, encryption, Unicode. Ship
slightly after SQL 2000 RTM. Bi-directional merge replication. ANSI syntax. EVB, eVC, ADO,
OLEDB to connect/tools.
- WMI/WBEM support.
- Active Directory integration. Gives directory lookup and location transparency. Search
for servers of certain versions, running IP, clustered etc. Registers with
sp_ActiveDirectory_Start – registers as a "Service Connection Point".
Registers missing databases, updates db properties. Trigger in MSDB updates on backup.
- MDAC 2.6 disk footprint down from 17MB to 12MB. No longer ships Jet or FoxPro drivers.
- OLE-DB provider for DB/2 (HIS 2000) now has two-phase commit with MSDTC and ReSync
Service (SNA LU6.2). Improved scalability and performance. New DRDA agent, no RPC, no
service.
- ODBC Driver for DB/2. ODBC v3.0. 3 part names. Isolation levels. Stored procedures with
params. Named cursors. Better scalability and performance.
- New distributed query providers – Active Directory and Exchange 2000.
SQL Server 2000 Preview 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
