Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

First Look: SQL Server 2005 SP2 CTP Expand / Collapse
Author
Message
Posted Tuesday, January 2, 2007 12:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:48 AM
Points: 143, Visits: 61
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/2793.asp


When in doubt - test, test, test!

Wayne

Post #333816
Posted Tuesday, January 9, 2007 1:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 6,002, Visits: 8,267

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
Post #335278
Posted Tuesday, January 9, 2007 2:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:48 AM
Points: 143, Visits: 61
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

Post #335283
Posted Tuesday, January 9, 2007 8:47 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 4, 2014 9:46 AM
Points: 295, Visits: 280
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
Post #335364
Posted Tuesday, January 9, 2007 12:06 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 12:21 PM
Points: 1,327, Visits: 155

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
Post #335479
Posted Tuesday, January 9, 2007 6:45 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234

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
Post #335640
Posted Thursday, January 11, 2007 8:25 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, August 22, 2014 7:44 AM
Points: 606, Visits: 312
Does anybody know when Microsoft is expected to release this service pack officially? Thanks.


Post #336179
Posted Thursday, January 11, 2007 8:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 12:21 PM
Points: 1,327, Visits: 155
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
Post #336189
Posted Thursday, January 11, 2007 9:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Post #336195
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse