Whats coming in SQL 11

I keep hearing little bits about whats coming in SQL 11 and I’m getting really excited. I comment about how certain things don’t get fixed and so when I see things do get fixed it makes me smile.

The latest is undo in SQL Server Integration services.My connect item hasn’t just been closed, but closed as fixed.

http://connect.microsoft.com/SQLServer/feedback/details/308794/enable-undo-in-ssis-package-designer

The just need to get the projects working in VS 2010 and away we go.

http://sqlblogcasts.com/blogs/simons/archive/2010/07/26/make-yourself-heard-how-to-change-sql.aspx

Published 27 July 2010 19:40 by simonsabin

Comments

# Twitter Trackbacks for Whats coming in SQL 11 - Simons SQL Blog [sqlblogcasts.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 Whats coming in SQL 11 - Simons SQL Blog         [sqlblogcasts.com]        on Topsy.com

27 July 2010 20:20 by SimonS Blog on SQL Server Stuff

# Whats coming in SQL 11

I keep hearing little bits about whats coming in SQL 11 and I’m getting really excited. I comment about

27 July 2010 22:21 by retracement

# re: Whats coming in SQL 11

SQL Server is really becoming something to be really proud about. You can audibly hear sighs of fear from my Oracle DBA co-workers upon each release.

Here is my very quick list that needs improving to cast Oracle into a ditch :-

1. Improvements to DB Mirroring such as mirror of mirror (comparable to Dataguard)

2. Database Flashback. We are getting there with snapshoting, but there is much work to be done, really should be possible to have something implemented in SQL 11?

3. Oracle style Real Application Clusters. A friend of a friend has indicated to me this might even be in SQL11. Dont know how true this is, but I know this would send fear into the Oracle DBA's heart. This is a flagship solution for them, and they would hate to see SQL get it.

4. A server wide setting to allow a server wide ISOLATION LEVEL change from the default. I know this might not be to everyone's taste, but trust me people, READ COMMITTED has it's critics. SNAPSHOT isolation is the closest locking model to Oracle and would seriously be prefered by ex-Oracle developers who think the NOLOCK hint is absolutely fine for application concurrency. Allowing for the server wide change from default would in my opinion be the single greatest enhancement that could be made to SQL to win over the Oracle community.

Think that is it for the time being.

25 August 2010 17:07 by SSIS Team Blog

# Upcoming Product Changes

We’ve been hard at work on the next version of SQL Server, and it’s (almost) time to start sharing some