SQL Server 2008 Q & A
I had some questions from the SQL Server 2008 Overview webcast and I wanted to share those questions and answers with all of you.
Questions:
- How will a java web application make use of ADO.Net?
They would use the JDBC driver that we provide with SQL Server 2008
- I have heard that the entity framework is being delayed and is set to NOT be in the Orcas release - can we expect it to be released fully once Katmai is released?
That is current the plan
- Does 2008 have the capability to partition /split a table?
Yes it does – we have had this functionality since SQL Server 2005
- What resources are available to upgrade from MSDE and SQL 2003 to SQL 2008
We will support upgrades of SQL Server 2005 to SQL Server 2008
- Has anything with SSIS in 2008 changed?
Scale, Performance and Data Profiling
- In terms of the Linq Entity framework is the reason for the release delay to release in conjunction with Katmi?
We will release the CTP of the entity framework in December.
- If SharePoint service is not supported by SQL 2008, will SP1 be released at the same time as SPS?
MOSS needs to support SQL Server 2008 as we are the platform for them; they are targeting their SP for support.
- Are you able to audit SA activities or 'selecting sensitive data' in SQL2008
Audit table selects and who was logged in – we can't select what data was accessed
- Transparent data encryption encrypts - mdf and ldf? If so what are the steps to restore?
You can encrypt the database and log files. IF you mean backup/restore – I would point you to BOL for CTP5
- I am only seeing the July CPT but you indicated one had been released today? Where is the download?
We will be posting on the web within 2 days
- Can you upgrade SQL 2000 or SQL 7 databases directly to SQL 2008 ?
We will support upgrades from SQL Server2000 and later.
- You mentioned partitioning, did that you mean you can partition a table?
Yes we can partition the table transparent to the end user or app