Here are answers to some questions that came up during my MSDN event in Sacramento yesterday.
1. Is HTTP endpoint creation supported in SQL Server Express edition?
2. Is WSE supported for web services created through HTTP endpoints in SQL Server?
WS-Security (Oasis) will be the only feature of WSE 2.0 that will be supported as part the security model in the RTM of SQL 2005.
3. How can the cache be invalidated (or marked dirty) through an ASP.NET app? Along the same lines, how can the cache be dirtied if the app is retrieving this info from a database, and the records in the dB have changed, for example?
This is a new feature of Yukon and Whidbey – automatic notification of when data changes is available. (not available with VS.net 2003) Check out http://msdn.microsoft.com/library/en-us/dnvs05/html/querynotification.asp
4. Is ClickOnce be supported on a device running the Compact Framework?
ClickOnce publication doesn’t have a dependancy on web servers.
6. What are the fundamental differences between Reporting Services in SQL Server 2000 and 2005?
Some new features in SQL RS 2005 are:
a. SharePoint Integration and Client-Side Printing. These features will be in SQL RS 2000 SP2, due to ship in April, and will also be in SQL RS 2005.
b. No longer needs Visual Studio. The Report Designer is now available in the SQL BI Workbench, so you don’t need a development tool to build reports.
c. Improved support for MDX. There is now a graphical query designer for MDX.
d. The Report Builder. Everything associated with Report Builder, including the Model Designer, are new features in SQL Server 2005.
e. You can add your own controls to the toolbox, so if you want a cool new data area, you can get it. For example, you could add custom chart types.
f. The SDK now includes documentation for adding custom rendering engines. So if you wanted to add support for output in WordPerfect, the SDK now tells you how to do it.
g. There’s a zillion minor improvements in controls and configurability.
If I’ve missed any questions, please drop me a note.