SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


First Look: SQL Server 2005 SP2 CTP


First Look: SQL Server 2005 SP2 CTP

Author
Message
Wayne-153714
Wayne-153714
SSC Veteran
SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)

Group: General Forum Members
Points: 232 Visits: 91
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/2793.asp


When in doubt - test, test, test!

Wayne

Hugo Kornelis
Hugo Kornelis
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10990 Visits: 11988

Hi Wayne,

>>I dont see a list of any new features included in the service pack<<

On the download page for the SP2 CTP, there's a link to an overview of all new features, conveniently labeled "review the What's New document". Clicking this link takes you to http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm. As you can see, there are LOTS of new features.

>>Most importantly, I had only about 20 minutes of down-time.<<

That's way to much for many shops. And way more than necessary. Instead of stopping all SQL Server services and then some in order to avoid a reboot, why not leave SQL Server running during the install process and accept a reboot when the installation is finished? Or are you trying to tell me that rebooting your system would have taken more than 20 minutes?




Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Wayne-153714
Wayne-153714
SSC Veteran
SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)

Group: General Forum Members
Points: 232 Visits: 91
Thanks for the comments, Hugo. I missed that link to new features. :-( Sorry.

Good point with the downtime. A reboot will take less time than shutting down the services, so that option whould be preferable.

Cheers,

Wayne


When in doubt - test, test, test!

Wayne

Tatsu
Tatsu
Say Hey Kid
Say Hey Kid (668 reputation)Say Hey Kid (668 reputation)Say Hey Kid (668 reputation)Say Hey Kid (668 reputation)Say Hey Kid (668 reputation)Say Hey Kid (668 reputation)Say Hey Kid (668 reputation)Say Hey Kid (668 reputation)

Group: General Forum Members
Points: 668 Visits: 307
Wayne,

Don't let the low rating of the article (at the time I am writing this) discourage you! I thought that article itself was fine but it didn't mention any of the changes that we might expect after we're done with the upgrade. Your presentation of the install process might be helpful for those less familiar with the SQL service pack process but for most of us here it may not be quite as valuable.

Thank you!

Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
Mark Harr
Mark Harr
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1588 Visits: 191

Here you are asked if you would like to automatically send error reports and feature usage data to Microsoft. I always leave these options unticked.

Strongly suggest that you do check the checkboxes for reporting errors.

I do for all MS software, and several times the error report will come back with a KB article or link to a hotfix that corrects the specific problem. In the case of unattended software (service software), the helpful links will be in the event log.

Even if you don't care about fixing the problem, the data submitted to MS helps to record and analyze problems, and to help MS prioritize their worklist.





Mark
Brian Knight
Brian Knight
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: Moderators
Points: 2559 Visits: 235

Mark, I too thought it was a great article to get the user an overview. I had forgotten about the Vista option altogether. You inspired me to produce a quick video about the new features and the installation process here in case anyone is interested: http://www.jumpstarttv.com/Media.aspx?vid=70

Brian Knight



Brian Knight
Free SQL Server Training Webinars
netmikem
netmikem
Right there with Babe
Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)Right there with Babe (746 reputation)

Group: General Forum Members
Points: 746 Visits: 361
Does anybody know when Microsoft is expected to release this service pack officially? Thanks.



Mark Harr
Mark Harr
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1588 Visits: 191
I could not find the link I saw, but I remember reading it was to be released before the official launch of Vista (since it is required to run SQL Server 2005 any edition on Vista).



Mark
Brian Knight
Brian Knight
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: Moderators
Points: 2559 Visits: 235
Right now, it's slated for a next month release but you never know. You've got to think remember that they won't support you on vista without SP2 so they releases have to match pretty close.

Brian Knight
Free SQL Server Training Webinars
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search