Agradecimentos ao Fernandor por ter nos enviado o transcript!!
Grant [MSFT] (Moderator): Welcome to the live chat about the first SQL Server “Katmai” CTP. We’ll begin in a few minutes.
Grant [MSFT] (Moderator): Before we begin, I would like to begin by posting the chat rules and instructions for customers:
1. This chat will last for one hour. During this hour, our Experts will respond to as many questions as they can. Please understand that there are some questions we cannot respond to due to lack of information or because the information is not yet public.
2. We encourage you to submit questions for our Experts. To do so, type your questions in the send box, select the Submit a Question radio button and click SEND. Questions sent directly to the Guest Chat room will not be answered by the Experts, but we encourage other community members to assist.
3. We ask that you stay on topic for the duration of the chat. This helps the Guests and Experts follow the conversation more easily. We invite you to ask off topic questions after this chat is over, but not during.
4. Please only submit your question once.
Grant [MSFT] (Moderator): We are pleased to welcome our Experts for todays chat. I will have them introduce themselves now.
Bill Ramos[MSFT] (Expert): Hi All – My name is Bill Ramos and Im the Lead Program Manager for Relational Engine Manageability. Ill be addressing any issues associated with SSMS.
Richard Waymire MSFT (Expert): Hi, I’m Richard Waymire, a program manager on the management platform team.
Bill Ramos[MSFT] (Expert):
Q: [1] I saw on many foruns many questions if in the sql serve 2008 it goes to be implemented the intellicense.It goes to be implemented on the next CTP?
A: Hi Fernandor – We do plan to have T-SQL intellisense for the 2008 release. Is there something in particular you want to make sure is in the product? Thx Bill
Maria Balsamo [MSFT] (Expert): My name is Maria Balsamo, I manage the TAP program for the SQL Server Development team. I work with the internal MSFT customers.
Bill Ramos[MSFT] (Expert):
Q: [1] I saw on many foruns many questions if in the sql serve 2008 it goes to be implemented the intellicense.It goes to be implemented on the next CTP?
A: P.S. This will go into CTP5. Cheers Bill
Jun Fang [MSFT] (Expert): Hi, I am Jun Fang, a development lead in engine programmability team.
Rob Zare [MSFT] (Expert):
Q: [2] 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.
Srini Acharya[MSFT] (Expert): Hi, I am Srini Acharya. I am a senior Program manager in the relational Engine – Programmability team. I also own the Table-valued Parameters feature released in June CTP.
Bill Ramos[MSFT] (Expert):
Q: [1] I saw on many foruns many questions if in the sql serve 2008 it goes to be implemented the intellicense.It goes to be implemented on the next CTP?
A: P.S. It won’t be in the very next CTP – but in one later. I would like to know if there is a strong desire to have intellisense on DDL types of operations like CREATE TABLE or help in commands like BACKUP/RESTORE.
Bill Ramos[MSFT] (Expert):
Q: [8] Asking the experts – Hi, Is the intellicense feature going to be optional? I mean is it possible to turn it off if needed?
A: Hi Lucky,
Maria Balsamo [MSFT] (Expert):
Q: [9] Any plans to add multiple mirrors to database mirroring?
A: There are not 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.
Bill Ramos[MSFT] (Expert):
Q: [8] Asking the experts – Hi, Is the intellicense feature going to be optional? I mean is it possible to turn it off if needed?
A: Opps – Hit the enter key too soon. We will have the option to turn off intellisense. We also want to make sure we can be performant enough to not interupt typing.
Bill Ramos[MSFT] (Expert):
Q: [16] Bill – If intellisense can be responsive than some ISVs implementations I would love to see it for those types of operations. Especially infrequently used ones requiring highlight + F1
A: Hi Mike, We will make sure that we can be more responsive that the others. Thx. Bill
Gopal MSFT (Expert):
Q: [21] When will change data capture appear in the CTP and will CDC be based on triggers?
A: CDC is currently available as part of CTP3, the capture mechanism is log based
Bill Ramos[MSFT] (Expert):
Q: [23] Bill – Yes, strong desire to have intellisense on DDL types of operations.
A: Hi Phil – Good to hear. We are thinking about replacing the existing View Designer with the intellisense feature on CREATE/ALTER VIEW statements. This would include auto completion of joins. Bill
Jun Fang [MSFT] (Expert):
Q: [12] What about UDT (.NET) and FOR XML statement?
A: If the UDT implements XML serialization, then it will be supported in FOR XML statement.
Maria Balsamo [MSFT] (Expert):
Q: [7] Are there any methods to add geometry to GEOMETRY COLLECTION data type in SQL Server Katmai Spatial.
A: Chandra — I am trying to get an answer to your question about geometry collection. Please wait while I call a few developers.
Gopal MSFT (Expert):
Q: [15] Any improvments to peer to peer replication i n 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.
Bill Ramos[MSFT] (Expert):
Q: [18] What new enhancement have you made for partition tables? I am very interested in any improvements with merge and splitting of partitions on VLDB’s.
A: Hi Tommy – Are you looking for DDL improvements? Or – are you looking for help managing partitions using SSMS?
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?
Richard Waymire MSFT (Expert): 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: [28] Any Plans for additional Backup types. Like incremetal backups (not backing up all changes since last full, just changes since last incr. backup)?
A: Hi Clemens – The only change planned is to support Compressed backups. Bill
Richard Waymire MSFT (Expert): Q: does the KatMAi support the load balancing Active Active ?
A: This is not something that is planned for SQL Server 2008.
Rob Zare [MSFT] (Expert):
Q: Any Plans for additional Backup types. Like incremetal backups (not backing up all changes since last full, just changes since last incr. backup)?
Maria Balsamo [MSFT] (Expert):
Q: [5] I’m not crazy, but I’d like to know if MS will put Sql Server to run on other plataforms like Unix ?
A: Marcelo, No, MSFT does not have any plans to port SQL Server to any other operating system, like Unix.
Bill Ramos[MSFT] (Expert):
Q: [30] In my opinion i’d like comands for all DDL,DCL and DML,because many times we forget the all commands
A: Hi Fernandor. Thanx for your feedback.
Maria Balsamo [MSFT] (Expert):
Q: [7] Are there any methods to add geometry to GEOMETRY COLLECTION data type in SQL Server Katmai Spatial.
A: Chandra, I received an answer to your geometry question. No, you will not be able to do that directly. You will need to write your own method to do this.
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: [34] Bill – 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: Hi Mike – 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.
Gopal MSFT (Expert):
Q: [36] Any Enhancements in replication
A: We are enhancing the peer-peer replication feature. We have added support for adding new nodes without having to take a topology wide outage, also a topology viewer page has been added to the configuration wizard to make the peer-peer configuration easier.
Richard Waymire MSFT (Expert): Q: Hello … will SQL2008 be making any inroads into the “grid computing” space (multiple servers handling one logical DB)?
A: We’re certainly researching options there, but don’t expect to deliver anything in the SQL Server 2008 timeframe.
Richard Waymire MSFT (Expert):
Q: [19] 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: A: We are actively working on improving the management experience for Service Broker. Check back in future CTPs….
Bill Ramos[MSFT] (Expert):
Q: [38] We would really like to put “notes” into the database properties (sys.databases?)… a database catalog, if you like with info like app server, web server, business unit, etc. Any chance of getting something like that? Seems simple.
A: Hi Todd – You do have the ability to add extended properties for database objects with SQL 2005. That is the only form of annotation we will support for 2008. Thx. Bill
Richard Waymire MSFT (Expert):
Q: [25] Hello … will SQL2008 be making any inroads into the “grid computing” space (multiple servers handling one logical DB)?
A: A: We’re certainly researching options there, but don’t expect to deliver anything in the SQL Server 2008 timeframe.
Richard Waymire MSFT (Expert):
Q: [17] does the KatMAi support the load balancing Active Active ?
A: A: This is not something that is planned for SQL Server 2008.
Carolyn [MSFT] (Expert):
Q: [44] 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.
Bill Ramos[MSFT] (Expert):
Q: [45] Thanks bill.. I was confused Forgot you can connect to 2005 but can’t put CTP SSMS on box with 2005 SSMS. That is what I wanted to see change in RTM. And great news about intellisense!
A: Thx
Richard Waymire MSFT (Expert):
Q: [14] 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: 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.
Kevin [MSFT] (Expert):
Q: [22] Will there be better integration between database mirroring, log shipping and transactional replication?
A: Greetings.
Jun Fang [MSFT] (Expert):
Q: [13] What kind of spatial indexing will be in SQL Server 2008, and in which CTP will it appear?
A: We use a multi-level grid indexing scheme for spatial indexing. It will be in CTP5.
Richard Waymire MSFT (Expert):
Q: [42] What news about Debug for Stored Procedures?
A: It’s hopefully on the plate for SQL Server 2008 SSMS – we are working on it…
Bill Ramos[MSFT] (Expert):
Q: [43] Were there any changes made to the storage engine and transaction logging, like row format and log record structure?
A: Hi Mcfly,
Rob Zare [MSFT] (Expert):
Q: [46] any compatability 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 compatability to make this process as smooth as possible.
Carolyn [MSFT] (Expert):
Q: [40] Is there any enhancments 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.
Gopal MSFT (Expert):
Q: [36] Any Enhancements in replication
A: We are making enhancements to the peer-peer replication feature. The ability to add a new node without having to take a topology wide outage and also a new topology viewer page in the configuration wizard to help configure the topology using a viewer. This will now enable administrators to do maintenance operations like deleting a node, delete a link between two nodes etc.
Kevin [MSFT] (Expert):
Q: [22] Will there be better integration between database mirroring, log shipping and transactional replication?
A: re: integration of mirroring, log shipping, and replication, these technologies are separate, and each have their own tradeoffs, so they will confinue to be separate solutions. We are making improvements to all of them, and the goal is to make them easier to use.
Richard Waymire MSFT (Expert):
Q: [17] does the KatMAi support the load balancing Active Active ?
A: A: A: This is not something that is planned for SQL Server 2008.
Carolyn [MSFT] (Expert):
Q: [20] 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.
Bill Ramos[MSFT] (Expert):
Q: [43] Were there any changes made to the storage engine and transaction logging, like row format and log record structure?
A: Hi Hanno – We do plan to change our storage format to expand on the data compression feature we started with VarDecimal Storage in SP2. This is not in this CTP. Thanx. Bill
Maria Balsamo [MSFT] (Expert):
Q: [47] what enhacements are you planning with Data Mining?
A: We have 2 improvements planned for data mining in SQL Server 2008.
Bill Ramos[MSFT] (Expert):
Q: [55] Were there any changes made to the storage engine and transaction logging, like row format and log record structure? Mcfly?
A: Sorry – See answer below. The short answer is yes.
Carolyn [MSFT] (Expert):
Q: [29] 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. Thank you.
Gopal MSFT (Expert):
Q: [41] Replication with pdas has a lot of troubles, are you making something with this?
A: We are not making any specific changes to merge replication for CE subscribers but there are some performance improvements that are planned which will help merge replication performance in general.
Bill Ramos[MSFT] (Expert):
Q: [27] What about of load balance process on sql 2008
A: Hi Marcelo,
Kevin [MSFT] (Expert):
Q: [32] Can you make better use of a mirrored database? I like database snapshots, but they have to be manually created. Is there a way to always read from the mirror?
A: A mirror secondary is logically always in recovering mode, which is why you can’t directly attach to it. I understand the desire to use the secondary, but at this point reporting against a snapshot is the best you’ll be able to do.
Maria Balsamo [MSFT] (Expert):
A: 1. Improving Time Series Prediction: Time series predictions are among the most important uses of data mining – for example, to project sales, or inventory. This improvement enhances the accuracy of time series predictions.
In SQL Server 2005, time series prediction was notably accurate for the near term – typically a few data points ahead of the historical series. In the next version, this near term accuracy is enhanced with an algorithm for the longer term using a version of the well-known ARIMA algorithm. The new results combine the best of both techniques, but with a single experience for the user – no need to select the best algorithm for the purpose at hand. Of course, there are useful parameters for those needing finer control.
Bill Ramos[MSFT] (Expert):
A: Opps – We do plan to have a feature to having SQL Server classify workloads depending on CPU and memory comsumption. This is not in this CTP. Thx. Bill
Rob Zare [MSFT] (Expert):
Q: [56] 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 specialy for identifying the logged user priviliges, 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.
Bill Ramos[MSFT] (Expert):
Q: [27] What about of load balance process on sql 2008
A: Hi Marcelo – I should have answered this.
Kevin [MSFT] (Expert):
Q: [35] High Availability: Will there be a kind of “load balancing” (active/active) by using just one cluster instance. To get more out of the hardware resources?
A: In mscs clustering, it is the instance that fails over, so you can’t have both sides of an active/active cluster running the same instance at the same time. SQL Active/active clusters have different instances on each side.
Srini Acharya[MSFT] (Expert):
Q: [31] 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.
Qingsong Yao[MSFS] (Expert):
Q: [62] Which CTP # is the current June CTP?
A: CTP #3
Maria Balsamo [MSFT] (Expert):
A: The first improvement is: Time Series Stability: Time series predictions are among the most important uses of data mining – for example, to project sales, or inventory. This improvement enhances the accuracy of time series predictions.
In SQL Server 2005, time series prediction was notably accurate for the near term – typically a few data points ahead of the historical series. In the next version, this near term accuracy is enhanced with an algorithm for the longer term using a version of the well-known ARIMA algorithm. The new results combine the best of both techniques, but with a single experience for the user – no need to select the best algorithm for the purpose at hand. Of course, there are useful parameters for those needing finer control.
Carolyn [MSFT] (Expert):
Q: [11] 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 improvments that we are reviewing, prioritizing and scheduling currently.
Maria Balsamo [MSFT] (Expert):
A: The second improvement is: Preparing training and testing sets is an essential in any data mining methodology. This improvement provides this functionality – and more. It is also possible to filter the mining structure to enable users to build models on subsets of data from the data source – for example, you can now easily build separate models for male and female customers using the same mining structure.
Partitioning data into training and testing sets is an essential step in any data mining methodology. The commonly-used and widely-supported CRISP-DM Guide 1.0 specifically refers to this step:
Before we actually build a model, we need to generate a procedure or mechanism to test the models quality and validity. For example, in supervised data mining tasks such as classification, it is common to use error rates as quality measures for data mining models. Therefore, we typically separate the dataset into train and test set, build the model on the train set and estimate its quality on the separate test s
Bill Ramos[MSFT] (Expert):
Q: [61] Any tools for refactoring t-sql code into “better” code? Or help on how to write more optimized code?
A: Hi Peter. We have no immediate plans for refactoring code into better code for 2008 – we’ll start with basic intellisense. Thx. Bill
Carolyn [MSFT] (Expert):
Q: [51] How extensible is the katmayia 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: [54] 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.
Kevin [MSFT] (Expert):
Q: [57] Thanks, Kevin. Will you make it easier to failover from a database mirroring configuration to a log shipping secondary, and then failback?
A: Mirroring and log shipping describe relationships between the two machines.
So, it doesn’t make sense to talk about failing from a mirroring primary to a log shipping secondary.
It’s not the individual machine that is “mirroring” or “log shipping”, it is the pair as a whole.
What may happen in the future is to make it easier to migrate between availability solutions, but this is not a Katmai feature.
Rob Zare [MSFT] (Expert):
Q: [66] Is the SSAS actions tab will not be in the future release, if no, Is there is any tight integration between notification services & analysis service actions.
A: I’m not sure if I understood the question correctly, but there are no plans to remove the Actions tab, nor are there any plans to add tighter integration with Notification Services.
Carolyn [MSFT] (Expert):
Q: [60] 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.
Kevin [MSFT] (Expert):
Q: [63] How does the new “transparent failover” mechanism in database mirroring work? Does SQL Server automatically reconnect you to the new principal? What if the application had just issued a statement within a transaction, or just issued a commit?
A: Mirroring failovers have not significantly changed in Katmai except that the client-side caching of the connection configuration is now persisted, rather than being lost between app restarts. We’re trying to track down who inserted the term transparent failover into the presentations and what they had in mind.
Rob Zare [MSFT] (Expert):
Q: [68] Is there a Major Issues between the performance Point server 2007 and Katmai ?
A: I’m not aware of any major issues at present. Both the SQL and Performance Point teams will do a fair amount of compatibility testing prior to release.
Carolyn [MSFT] (Expert):
Q: [52] What news about front end in business intellinge 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: [64] Any enhancements concerning monitoring of SQL Server?
A: Hi Clemens, Yes – we do have additional support for monitoring. The new Declaritive 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. Cheers, Bill
Kevin [MSFT] (Expert):
Q: [69] Kevin, we have a number of large customers that want a mirrored pair at one site, and a log shipping standby at a remote site for disaster recovery. If we lose the main site, we want it to be easy to failover to the log shipping standby.
A: That’s an interesting scenario. I’ll bring it up and see what we can do. It won’t likely be a Katmai feature, but it may make it onto the map for a future release.
Bill Ramos[MSFT] (Expert):
Q: [70] There was some UI-Bugs like unlocking Accounts in SSMS (2005) will they be fixed in katmai?
A: Hi Ralf – This particular issue is high on our list of things to fix in a later CTP. Thx. Bill
Kevin [MSFT] (Expert):
Q: [74] what CTP will have backup compression available?
A: It’s looking like CTP5, which should ship towards the end of the summer.
Rob Zare [MSFT] (Expert):
Q: [47] what enhacements 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.
Jun Fang [MSFT] (Expert):
Q: [72] Which standards will Spatial comply with?
A: Katmai Spatial complies with OPENGIS.
Torsten Grabs (Expert):
Q: [48] Are there any improvement with doing index maintenance on individual partitions with the ONLINE option?
A: We are considering improvements to indexed views such that a subset of indexable queries can be partition aligned. This is supposed to address the current limitation where indexed views need to be re-created when partitions are switched.
Bill Ramos[MSFT] (Expert):
Q: [79] Will there be enahncements for the DAC in katmai?
A: Hi Ralf – There are not planned changes to DAC. Is there something in particular that you have in mind? Thx. Bill
Eddie Fong (Expert):
Q: [71] When do you plan to release next CTP?
A: July is when we plan to release our next CTP
Kevin [MSFT] (Expert):
Q: [78] How will the files you store with the FILESTREAM datatype be accesible without conncting to SQL Server (in other words via the filesystem), read/write, read or not at all? (Sorry if this was asked and answered before, was stuck in traffic).
A: Not at all. The whole concept of FILESTREAM (as opposed to WinFS) is that this is a database column with a unique storage attribute. Thus access is controlled via SQL. The pattern is that you make TSQL calls to obtain the transaction context (you must be in a transaction), and to obtain a logical path for the cell in the database. you then hand both of these items to a new API (which is a wrapper around ntCreateFile with Extended Attributes) to do the open.
Bill Ramos[MSFT] (Expert):
Q: [76] Will there be more reports like performance dashboard? And maybe some documentation?
A: Hi Peter – The answer is yes and yes. We will likely condolidate the reports that we have and definitely provide documentation. These are not in this CTP. Thx. Bill
Bill Ramos[MSFT] (Expert):
Q: [91] to DAC: it’s nice to see, that you can get info like ssf sysdbreg but in helptext from sys.databases you can see commands that normaly don’t work like has_access(db, uid)
A: I see – we’ll look into this. Thx. Bill
Bill Ramos[MSFT] (Expert):
Q: [91] to DAC: it’s nice to see, that you can get info like ssf sysdbreg but in helptext from sys.databases you can see commands that normaly don’t work like has_access(db, uid)
A: P.S. It would be helpful for you to post this request through out Connect web site. Cheers. Bill
Richard Waymire MSFT (Expert):
Q: [93] 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…
Bill Ramos[MSFT] (Expert):
Q: [81] How about a new datatype such as array?
A: Hi Fernandor, 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. Cheers, Bill
Torsten Grabs (Expert):
Q: [89] When should we use the $PARTITION function? We have started including the $PARTITION functioin in most of join and where statements to help the optimizer filter on a single partition and have seen improved query performance.
A: Tommy, using the partition function in clauses can help you to achieve partition elimination. If you can express a partition-eliminating predicate w/o the partition function over the fact table, this would be my preferred approach. This makes the queries more readable and easier to maintain.
Kevin [MSFT] (Expert):
Q: [96] We’d love to see >2 mirrors: one synchronous mirror at the same site for HA, and one or more asynchronous mirrors offsite for DR. Log shipping is the only way we can get a third, async standby, but the failover story isn’t clean,and it is mins behind
A: Yes, we recognize the value of this scenario, however it will take significant work to make it happen. It is on the roadmap for a future release, but not Katmai.
Richard Waymire MSFT (Expert):
Q: [97] this was in BOL for 2008… Multiple instances of SQL 2008 are not supported on a single computer, within 64-bit platform Katma 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: [100] once again to DAC: I would like to have this connection as a really troubleshooting interface e.g. with help to DBCC page etc.
A: Hi Ralf – Understood.
Jun Fang [MSFT] (Expert):
Q: [90] In the new spatial engine, will there be the ability to “import” spatial boundary information from the popular formats (ESRI shp files, MapInfo, etc)? Will there be “save as” functionality to extract to these formats?
A: We support importing and exporting data in the “well-known-text” and “well-known-binary” formats. I don’t think we support importing ESRI files directly, though I am not 100% sure. I can double check it later. I think all these popular formats support conversion to and from “well-known-text” and “well-known-binary” formats, so there shouldn’t be a problem importing the data.
Torsten Grabs (Expert):
Q: [99] Any improvement with implementing partition tables on existing tables? We need a much better way to migrate large tables into a partition structure without taking downtime. Partition tables are great, but very hard to implement on existing tables.
A: Tommy, could you please explain in a bit more detail what you want to do when migrating an existing table into a partitioned one and what issues you are facing?
Richard Waymire MSFT (Expert):
Q: [105] why does it say that in BOL 2008?
A: As I said above, email me the info and I’ll chase it down.
Richard Waymire MSFT (Expert):
Q: [108] KenJ asked the experts: Any possiblity of a Windows 2008 Server Core Installation for SQL Server?
A: What do you mean by a Core Installation?
Jun Fang [MSFT] (Expert):
Q: [92] What type of spatial indexing support does Katmai Spatial have? Any R-Tree support as of now.
A: Katmai uses a multi-level grid indexing scheme. We don’t support R-Tree as of now, though we compared our performance against Oracle which uses R-Tree, and in most cases we tried our performance is better.
Bill Ramos[MSFT] (Expert):
Q: [106] Linked-server (especially with Oracle) improvements or enhancements?
A: Hi Todd, 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: [4] Do you plan add support of new languages (Russian, Ukrainian) for full-text search?
A: Yes, Russian and Ukrainina (among others) will be included and enabled by default in full-Text Search for our next release.
Kevin [MSFT] (Expert):
Q: [107] Log stream compressionin database mirroring: is that optional? How much CPU overhead is there? What compression rates are obtained?
A: I’ll have to check, but my understanding is that it’s not optional. Compression rates will as always depend on the contents being sent. If you have text data, you’ll see very significant compression. If you’re updating JPG impages in blobs, you won’t see much, as they are already compressed.
Rob Zare [MSFT] (Expert):
Q: [86] Any Cube building enhancements?
A: Not in this CTP, but we’re actively working on this for a future CTP.
Kevin [MSFT] (Expert):
Q: THX
Carolyn [MSFT] (Expert):
Q: [82] 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? Thanks!
A: Yes, we would like to add this feature back in for Katmai. It’s on the list, but no guarantees.
Bill Ramos[MSFT] (Expert):
Q: [98] Will there be enhancements in SQLDIAG. For example a more userfrinedly output – maybe some reports based on collected data/traces?
A: Hi Clemens, We have no planned changes to SQLDIAG – other than supporting connections to Katami. We have work planned for you to collect your own data/traces and write reports against them in a future CTP. Thx. Bill
Srini Acharya[MSFT] (Expert):
Q: [112] Is the conflict detection supported in this CTP?
A: We will be supporting change tracking of data in a table in the upcoming CTP (CTP4 or CTP 5). This can be used for detecting change conflicts
Carolyn [MSFT] (Expert):
Q: [77] 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.
Boris B (Expert):
Q: [102] Multiple instances of SQL 2008 are not supported on a single computer, within 64-bit platform Katma only supports x64 in this release and there is no IA64 supported is enabled.
A: If you are reading this from a Readme file, this should be a temporary limitation of CTP3. Multiple instances and side-by-side installations will be supported
Srini Acharya[MSFT] (Expert):
Q: [115] Bill, I noticed that, for array emulation, the new Table Valued Parameters perform much slower than splitting delimited strings into table variables. Is the optimization of this feature complete?
A: Ken,
Srini Acharya[MSFT] (Expert):
A: Ken,
Kevin [MSFT] (Expert):
Q: [118] Will we see any additional functionality in the restore area (e.g. object level restore)?
A: Table level restore is not a Katmai feature. The biggest change in the backup/restore area is backup compression.
Boris B (Expert):
Q: [109] THX
A: No problem – replying to this to clear question manager.
Bill Ramos[MSFT] (Expert):
Q: [119] will new performance monitoring features have any inteligence? – highlighting root causes rather than symptoms?
A: Hi Dan, Our goal is to identify the root causes as much as possible. Thx. Bill
Torsten Grabs (Expert):
Q: [117] We are partitioning tables with millions of records with over 600 clients data. I want a better way to make an existing table a partition table and partition by client ID. I know I can do a metadata move to get it in a partition structure on 1 partition.
A: As I understand you are not trying to switch new data into an already existing partitioned table, right? If you want to My recommendation would be to do a partition-wise SELECT INTO.
Boris B (Expert):
Q: [37] Any possiblity of a Windows 2008 Server Core Installation for SQL Server?
A: Ken, could you please clarify your question?
Gopal MSFT (Expert):
Q: [110] Any new Replication functionalities to other databases like DB2, similar to the Oracle Publishing feature in SQL 2005?
A: No we are not adding any heterogeneous publication support in Katmai.
Srini Acharya[MSFT] (Expert):
A: Ken, Regarding your question about TVP: TVP optimizations are complete and we see significant performance improvements when you are sending large number of rows from client to server ( anything more than 100 rows) as opposed to sending them as parameter arrays. But the main purpose of TVPs are for ease of programming as well as provide strong type checking at the paramter layer. So, custom solutions to send the values as CSV and splitting them into table variables may perform similarly or better, but will increase the code complexity in the SP
Srini Acharya[MSFT] (Expert):
Q: [115] Bill, I noticed that, for array emulation, the new Table Valued Parameters perform much slower than splitting delimited strings into table variables. Is the optimization of this feature complete?
A: Ken, TVP optimizations are complete and we see significant performance improvements when you are sending large number of rows from client to server ( anything more than 100 rows) as opposed to sending them as parameter arrays. But the main purpose of TVPs are for ease of programming as well as provide strong type checking at the paramter layer. So, custom solutions to send the values as CSV and splitting them into table variables may perform similarly or better, but will increase the code complexity in the SP
Rob Zare [MSFT] (Expert):
Q: [111] 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: [127] are there enhancements planned in MDX / XMLA and the GUI for the rights management in AS?
A: Currently not.
Fernlope [MSFT] (Expert):
Q: [102] Multiple instances of SQL 2008 are not supported on a single computer, within 64-bit platform Katma only supports x64 in this release and there is no IA64 supported is enabled.
A: Katmai will support IA64 platform. Does this answer your question?
Jun Fang [MSFT] (Expert):
Q: [113] In the new spatial engine, does it integrate with SSAS. like defining a geographic visual dimension
A: This is not planned for Katmai.
Torsten Grabs (Expert): Tommy, you do not need to do the copy back in. This should be a meta-data operation for you. The copy out into a staging table, I agree, you need face. Does that make more sense?