January 11, 2011 at 3:17 am
Hello everybody, Can anyone tll me which positive things to look out for while migrating from SQL 2005 to SQL 2008 (FROM DEVELOPER POINT OF VIEW)
January 11, 2011 at 3:37 am
sql_butterfly (1/11/2011)
Hello everybody, Can anyone tll me which positive things to look out for while migrating from SQL 2005 to SQL 2008 (FROM DEVELOPER POINT OF VIEW)
http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
The things I like most as developer are the new DATE/TIME data types, the MERGE statement and CDC.
But there is so much more...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 11, 2011 at 7:19 am
From the developer point of view? Honestly, not much. Most of the changes were in the BI space and in administration.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 7:32 am
Grant Fritchey (1/11/2011)
From the developer point of view? Honestly, not much.
Spatial data, filtered indexes, new date and time datatypes, merge, filestream, sparse columns etc are 'not much'? Thinking of R2 perhaps? 😉
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2011 at 7:43 am
I guess I wasn't thinking of the data types as "developer" specific information. But yeah, I love spatial data, so there's one.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 8:11 am
I suppose it depends on what we call a developer. If we take that as application (front-end) developer, then there really isn't much of real interest. Database developer - whole 'nother story.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2011 at 10:57 pm
We are going to be migrated to SQL 2008 sooner or later. What things we need to keep in mind while migrating ? To be precise, I am talking about database as well as Application developer.
(Though I'll look into the new datatypes mentioned)
January 11, 2011 at 11:36 pm
sql_butterfly (1/11/2011)
We are going to be migrated to SQL 2008 sooner or later. What things we need to keep in mind while migrating ? To be precise, I am talking about database as well as Application developer.(Though I'll look into the new datatypes mentioned)
I would surely look at Policy Based Management to maintain best practices.
At first glance, this has not much to do with development, but through PDM you can for example enforce naming conventions for tables, primary keys et cetera.
Also look at the improved full-text indexing and the integration of BLOB with FILESTREAM.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 12, 2011 at 3:35 pm
Lets not forget Intellisense 😀
January 12, 2011 at 11:45 pm
siamak.s16 (1/12/2011)
Lets not forget Intellisense 😀
I'm not always convinced it is an improvement 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2011 at 2:13 am
Intellisense is not an improvement if you have objectsnames in your database starting with "TOP" or "ON" .... SQL-Promt from RedGate is much better if you like using Intellisense.
Nice features for developers that have not been mentioned yet are for me:
Declare and Set in one like ("Declare @Int Integer = 0")
Multi-Line-Insert with values ("Insert into @Table (A) Values(1), (2), (3)")
But as the others said, there are lots of new features and I am doing whatever I can to open the eyes of the executives in our company so we will upgrade a last but the keep being stubborn... after 2-3 years in the old company working with SQLS 2008 it is hard to get used to 2005 again.
January 13, 2011 at 2:28 am
And how can I forget?
Compound operators alla += -= /= *=
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2011 at 5:58 am
Koen (da-zero) (1/12/2011)
siamak.s16 (1/12/2011)
Lets not forget Intellisense 😀I'm not always convinced it is an improvement 🙂
Not when you compare it to Red Gate's SQL Prompt it isn't.
Same thing in Denali, BTW.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply