Voila un extrait d’un chat sur Katmaï entre les équipes Microsoft et un panel d’utilisateur qui a eu lieu le 11 juin 2007.
Ce chat a pour but d’apporter des informations sur les améliorations présentent dans la CPT de juin 2007, ainsi que sur les futrus innovations.
Vous pouvez retrouver l’intégralité du chat à cette adresse
Bill Ramos[MSFT] (Expert):
Q: I saw on many forums many questions if in the sql serve 2008 it goes to be implemented the intellisense. It goes to be implemented on the next CTP?
A: We do plan to have T-SQL intellisense for the 2008 release. It won’t be in the very next CTP – but in one later.
Maria Balsamo [MSFT] (Expert):
Q: Any plans to add multiple mirrors to database mirroring?
A: There are no plans to add multiple mirrors (multiple secondary systems) to database mirroring. We realize this is a highly desirable request, however it will not be possible to deliver this feature in SQL Server 2008.
Gopal MSFT (Expert):
Q: When will change data capture appear in the CTP and will CDC be based on triggers?
A: CDC is currently available as part of the June CTP, the capture mechanism is log based.
Michael Rys [MSFT] (Expert):
Q: What about UDT (.NET) and FOR XML statement?
A: In order to use CLR UDTs and FOR XML, you have to write an explicit cast to XML for CLR UDTs that support XML serialization.
Gopal MSFT (Expert):
Q: Any improvements to peer to peer replication in Katmai?
A: Yes, we have added the ability to add nodes without quiescing the system, today if you have to add a new node to an existing topology and connect it to more than one peer, you need to quiesce the system. Also check out the new configuration wizard in CTP3. The wizard uses a topology viewer to help configure the topology. You will now be able to add and also delete nodes.
Richard Waymire MSFT (Expert):
Q: How is it decided where functionality goes SSMS or VSDBPro…is debugging SP’s coming back into SSMS, or is SSMS just going to be pushed more towards configuration and analysis, while VSDBPro is going to be use for sp, udf, etc creation?
A: The two teams are working cooperatively yet have different goals. VSDBPro is all about the offline development experience, SSMS is an online development experience. So they will have many capabilities in common.VSDBPro is also focused on Visual Studio Team Suite integration. As to debugging, it’s under active consideration to come back to SSMS in SQL Server 2008.
Bill Ramos[MSFT] (Expert):
Q: Any Plans for additional Backup types. Like incremental backups (not backing up all changes since last full, just changes since last incr. backup)?
A: The only change planned is to support Compressed backups.
Richard Waymire MSFT (Expert):
Q: does Katmai support the load balancing Active Active?
A: This is not something that is planned for SQL Server 2008.
Richard Waymire MSFT (Expert):
Q: Hello, I’m Wayne Gadberry, DBA at Viatech Consulting and was curious if we can expect any improved management tools around Service Broker? Thank you.
A: We are actively working on improving the management experience for Service Broker. Check back in future CTPs….
Bill Ramos[MSFT] (Expert):
Q: I know the CTP SSMS will not work with 2005/2000. Will the RTM work? If so will some of the features (like intellisense) work with 2005 at RTM (or is the intellisense server driven)?
A: The CTP for SSMS should allow you to connect to SQL 2000 and 2005 servers. The plan is to make intellisense work across all SSMS supported versions of SQL Server.
Richard Waymire MSFT (Expert):
Q: What news about Debug for Stored Procedures?
A: It’s hopefully on the plate for SQL Server 2008 SSMS – we are working on it…
Srini Acharya[MSFT] (Expert):
Q: Is there any support for compressing a resultset before sending it back to the client?
A: We are adding support for NULL compression in the TDS protocol layer as part of implementing sparse columns in SQL Server 2008. This will result in some amount of compression in the result set. But, there are no plans for a generic result set compression.
Carolyn [MSFT] (Expert):
Q: What news about front end in business intelligence suite?
A: What front ends are you asking about? Microsoft ships several « front end » tools for BI. Reporting Services has several of them, Excel has BI support, as does PerformancePoint for scorecard applications and ProClarity. I guess the big news is that Microsoft has a variety of tools depending on your needs.
Bill Ramos[MSFT] (Expert):
Q: Any enhancements concerning monitoring of SQL Server?
A: Yes – we do have additional support for monitoring. The new Declarative Management Framework will provide monitoring against policies that you define. You can try this out with this CTP. In future CTPs we will ship BPA rules. In future CTPs we will also have enhanced performance monitoring that allows you to collect data over time – not server side traces – to collect anything you desire and then report against it. We also plan to incorporate many of the reports found in the SP2 Performance Dashboard.
Eddie Fong (Expert):
Q: When do you plan to release next CTP?
A: July is when we plan to release our next CTP.
Bill Ramos[MSFT] (Expert):
Q: Will there be more reports like performance dashboard? And maybe some documentation?
A: The answer is yes and yes. We will likely consolidate the reports that we have and definitely provide documentation. These are not in this CTP.
Bill Ramos[MSFT] (Expert):
Q: How about a new datatype such as array?
A: We’ve added a Table Valued Parameter data type used for passing in array like values into stored procedures and functions. This is better than arrays since type values are typed. You can check out the feature in this CTP.
Richard Waymire MSFT (Expert):
Q: I heard that multiple instances of SQL server have been depreciated for sql 2008. Is this correct?
A: No, that’s not correct. They’re still going strong…
Q: this was in BOL for 2008… Multiple instances of SQL 2008 are not supported on a single computer, within 64-bit platform Katmai only supports x64 in this release and there is no IA64 supported is enabled.
A: Hmm, sounds like a mistake. Can you email me the exact navigation link and I’ll investigate? rwaymi@microsoft.com
Bill Ramos[MSFT] (Expert):
Q: Linked-server (especially with Oracle) improvements or enhancements?
A: We have no additional improvements planned for linked servers other than bug fixes. Everything hinges on the OLEDB providers that you use. Was there something in particular you were looking for?
Fernlope [MSFT] (Expert):
Q: Do you plan add support of new languages (Russian, Ukrainian) for full-text search?
A: Yes, Russian and Ukrainian (among others) will be included and enabled by default in full-Text Search for our next release.
Srini Acharya[MSFT] (Expert):
Q: Is the conflict detection supported in this CTP?
A: We will be supporting change tracking of data in a table in an upcoming CTP. This can be used for detecting change conflicts.
Q: What can you say about scale out solutions in Sql Server 2008?
A: The main focus in performance improvement in SQL Server 2008 is on better query optimization and execution on a single SMP system. Given the rapid advances in multi-core processor technology, we think this will satisfy the performance needs of the bulk of our customers. Take a look at our “Scalable Shared Database” feature from SQL Server 2005, a read-only shared-disk scale out feature that is very effective for scaling out data warehouse query workloads. Also, some of the largest web properties in the world use application-level scaleout, with the app directing the request to the right SQL Server instance. One has over 270 TB and tens of millions of users. Distributed Partitioned Views are a useful scale out option for many users as well.
Pablo Castro (Expert):
Q: Sql2008 will support databases over network or better over internet through http (like virtual directories)?
A: We are working on a new project to expose data over HTTP interfaces in a way that is natural for the web environment. The project is still in its early stages, and it is available in CTP form. More information at http://astoria.mslivelabs.com.
Shishir Mehrotra (Expert):
Q: Will we get some benefit from the Stratature aquisition in SQL 2008?
A: From the Stratature acquisition Q/A:
How do these products relate to SQL Server?MDM capabilities will be delivered through Microsoft Office System applications and servers on top of an infrastructure provided from SQL Server. Stratature’s products are currently implemented using SQL Server.
Grant Culbertson (Expert):
Q: What prevision for show CTPs? For Month? Weeks?
A: I’ll assume this question is really asking about how often we plan to release CTPs. The current plan is to release a new CTP about
every 60 days for the rest of the year.
Reporting Services
Carolyn [MSFT] (Expert):
Q: Is there any enhancements in SSRS report model. by means of creating a report model from an analysis service datasource, and not relational?
A: We don’t have any currently on the schedule but will likely review this functionality in the next few months and determine what enhancements if any will be made. Please submit your feedback via Microsoft Connect so we can see the areas that you would like to see enhanced. Be as specific as possible, that would help us greatly.
Carolyn [MSFT] (Expert):
Q: Can you tell us a little bit more about integration of SoftArtisans technology in ReportingServices?
A: There are two main feature areas that we are working on integrating currently. The first is a render to Office Word feature that would allow users to export reports to Word format. The second feature area is authoring reports in Office applications (Word and Excel specifically). This feature by SoftArtisans currently allows you to install an addin to Word and Excel and generate RDL reports. We’re still in planning for this integration so timing and exact feature set is not yet determined.
Carolyn [MSFT] (Expert):
Q: Are you planning any changes to Reporting Services MDX query builder? Any changes to how Reporting Services will work with MDX queries?
A: We currently don’t have big changes planned for the MDX query builder but may make small enhancements. If there are specific issues or features you would like us to support, please provide that feedback through Microsoft Connect.
Chris Hays (Expert):
Q: any enhancements in SSRS parameters & customizing them as well?
A: The only change in parameters is: Parameter prompts are now allowed to be expressions – Needed for autolocalized reports.
Brian Welcker (Expert):
Q: will sql RS be able to append reports? make multiple reports print together with pagnination?
A: Other than the subreport support in SSRS 2005, there are no new capabilities planned for this area.
Brian Welcker (Expert):
Q: will RS have « keep together » functionality for grouping?
A: Yes, keep together properties have been added to groups.
Carolyn [MSFT] (Expert):
Q: How extensible is katmai for the ad-hoc reporting of microsoft (Excel services). and is there is a library of controls for excel services to customize?
A: Excel Services is owned by the Office Excel team. They are on a different ship schedule from us so are not part of the Katmai release. Reporting Services ships Report Builder for ad-hoc reporting. You can find documentation online for Report Builder with SQL Books online. Search for Report Builder or ad hoc reporting.
Carolyn [MSFT] (Expert):
Q: With the advent of SP2 and running Reporting Services in SharePoint Integrated mode, you lose the Data Driven Subscriptions feature of Reporting Services. Are there any plans to bring Data Driven Subscriptions back into Katmai Reporting Services?
A: Yes, we would like to add this feature back in for Katmai. It’s on the list, but no guarantees.
Carolyn [MSFT] (Expert):
Q: I heard that Dundas Charting is going to be integrated with SQL Katmai. is it true.
A: Yes. Reporting Services will offer enhanced charting with Dundas charts in Katmai. We are also reviewing support for other Dundas controls.
Carolyn [MSFT] (Expert):
Q: recalling « reviewing support for other Dundas controls » The support is for Dundas controls for reporting services only? or plans for .NET Dundas MAP OLAP Services as well?
A: We are currently looking at Dundas support in Reporting Services. Additional support by other SQL/Microsoft teams will be determined.
Carolyn [MSFT] (Expert):
Q: What about the integration of the Dundas Charting… Will it be completely integrated when SQL 2008 will ship?
A: We are working on integrating an enhanced Dundas chart control so yes, there will be chart enhancement. Integration of other controls is still in planning.
Carolyn [MSFT] (Expert):
Q: What are the major enhancements in the reporting services?
A: We are working on several big areas for Reporting Services: scalability and performance, a server independent of IIS, support for new report structures (some significant enhancements/changes to RDL), integrating Dundas and SoftArtisans technology. We also have a raft of customer-requested improvements that we are reviewing, prioritizing and scheduling currently.
Carolyn [MSFT] (Expert):
Q: Will Dundas Charting be available on MSDN download?
A: We are reviewing the plan for availability of Dundas controls. There’s currently no plan in place to make them available on MSDN.
Analysis Services
Rob Zare [MSFT] (Expert):
Q: Could you please share what changes (if any) are planned regarding MDX language?
A: No major changes are currently planned. We will be extending the CREATE MEMBER syntax to support defining caption, display folders and associated measure group. CREATE SET will be enhanced to allow support for captions and display folders, as well as, the ability to define dynamic named sets. Also, a CREATE KPI command will be added.
Rob Zare [MSFT] (Expert):
Q: are there enhancements planned in MDX / XMLA and the GUI for the rights management in AS?
A: Currently not.
Jun Fang [MSFT] (Expert):
Q: In the new spatial engine, does it integrate with SSAS. like defining a geographic visual dimension?
A: This is not planned for Katmai.
Rob Zare [MSFT] (Expert):
Q: What are improvements to Analysis Services 2008? I saw new feature visual attribute relationship in Dimension Editor, and also I saw « Design warning » interface where you can enable/disable design warnings. Anything else we should check in SSAS 2008?
A: This CTP includes a redesigned dimension wizard, a new attribute relationship designer, and real-time design/best practice warnings. The warnings are implemented in AMO, exposed in the UI via blue squiggly lines, and can be dismissed individually (a single occurrence) or turned off all together.
Rob Zare [MSFT] (Expert):
Q: any compatibility concerns when migrating 2005 Analysis Service database to katmai?
A: Generally speaking, migration will be much more straightforward between 2005 –> 2008 than it was for 2000 –> 2005. As always, we’ll be doing a lot of testing around both migration and backwards compatibility to make this process as smooth as possible.
Rob Zare [MSFT] (Expert):
Q: any plans to extended the authentication of the analysis database connection to both windows authentication and SQL Server Authentication, it’ll make a big difference especially for identifying the logged user privileges, than using impersonation.
A: No such plans for this release, but we’ve heard this request before and are looking into making enhancements to the security model for a future release.
Rob Zare [MSFT] (Expert):
Q: what enhancements are you planning with Data Mining?
A: Key improvements planned: Enhanced time series algorithm with ARIMA; support for holdout and cross-validation; models built on filtered subsets of the mining structure data. Note: none of the preceding are in this CTP.
Rob Zare [MSFT] (Expert):
Q: Any Cube building enhancements?
A: Not in this CTP, but we’re actively working on this for a future CTP.
Integration Services
Grant Dickinson (Expert):
Q: Does Katmai SSIS provide 2 dataflow components as an input to another dataflow component (ie multiple dataflow inputs)?
A: It sounds like you want to do the equivalent of a relational JOIN, in which case the MergeJoin component should do the trick. Alternatively if it is the equivalent of a UNION you are looking for then a Merge component should do the job. In both cases, two transforms can simultaneously feed another transform as per your request.
Denise Draper (Expert):
Q: Cluster-aware SSIS?
A: No, our recommendation is not to cluster SSIS.
Grant Dickinson (Expert):
Q: is there is any features for SSIS Testing Data warehousing as well?
A: Not at this stage.
Grant Dickinson (Expert):
Q: Is there going to be support in SSIS to translate lineageIDs in which errors have occurred to column names in the error log output? Currently all we can get is the ErrorDescription by using Component Metadata and the column LineageIDs.
A: We have this on our list of things we want to attend to when we complete our ‘major feature’ work, however it depends on time and resources whether this will make it or not.
Grant Dickinson (Expert):
Q: What is the major enhancements in SSIS beside the data capture engine?
A: CDC is actually built by the SQL Replication team, but SSIS worked closely with them to ensure their design would fit with expected SSIS use cases. Other features SSIS is working on include performance, connectivity, C# scripting support, Lookup Transform improvements and some of the cross-box work such as the new DateTime types.