Welcome to Atlanta .NET Regular Guys Sign in | Join | Help

SQL Server 2005 Service Pack 2 - Community Technology Preview (CTP) November 2006

Courtesy of Teo Lachev:

The second CTP (Community Technology Preview) build of the forthcoming SQL Server 2005 Service Pack 2 was released today. Besides bug fixes, SP2 includes major BI features and enhancements including:

Reporting Services

  • SharePoint 2007 integration – this one is a true enzilla (enhancement Godzilla) and deserves a separate post. Suffice to say that unlike the previous Explorer and Viewer webparts, SP2 will allow you to move the report catalog to SharePoint to enable publishing, viewing, and managing SSRS 2005 reports within SharePoint 2007.
  • Report Builder support for Oracle or above (previously only SQL Server and Analysis Services 2005 were supported for Report Builder models)
  • New .NET Data Provider for Hyperion 9.3 BI+ Essbase Enterprise Analytics
  • Select All option has been restored with multi-valued parameters (it was disabled in SP1 for performance reasons).

Analysis Services

  • Better Excel 2007 integration – advanced filtering, cube formulas, offline cubes.
  • Data mining add-ins for Excel 2007 -- Table Analysis Tools for Excel, Data Mining Client for Excel, Data Mining Templates for Visio
  • Performance improvements with subselects, arbitrary shapes, running sum calculations, visual totals, ROLAP dimensions, cell writeback, many-to-many dimensions, 64-bit NUMA hardware, semi-additive measures and unary operators.
  • Supportability enhancements – enhanced memory dumps, filtered dumps, best practices analyzer

More information about what's new in SQL Server 2005 SP2 CTP2 is available in the readme file.

Published Wednesday, November 08, 2006 8:31 AM by Dan Attis
Filed Under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


# workerbees

Will recommend ur site. Have a great time. Thanks a lot
Friday, January 12, 2007 10:52 AM by workerbees

# There are many ways you can help Children’s.

Whether tragic events touch your family personally or are brought into your home via newspapers and television, you can help children cope with the anxiety that violence, death, and disasters can cause.

Listening and talking to children about their concerns can reassure them that they will be safe. Start by encouraging them to discuss how they have been affected by what is happening around them. Even young children may have specific questions about tragedies. Children react to stress at their own developmental level.

The Caring for Every Child's Mental Health Campaign offers these pointers for parents and other caregivers:

* Encourage children to ask questions. Listen to what they say. Provide comfort and assurance that address their specific fears. It's okay to admit you can't answer all of their questions.
* Talk on their level. Communicate with your children in a way they can understand. Don't get too technical or complicated.
* Find out what frightens them. Encourage your children to talk about fears they may have. They may worry that someone will harm them at school or that someone will try to hurt you.
* Focus on the positive. Reinforce the fact that most people are kind and caring. Remind your child of the heroic actions taken by ordinary people to help victims of tragedy.
* Pay attention. Your children's play and drawings may give you a glimpse into their questions or concerns. Ask them to tell you what is going on in the game or the picture. It's an opportunity to clarify any misconceptions, answer questions, and give reassurance.
* Develop a plan. Establish a family emergency plan for the future, such as a meeting place where everyone should gather if something unexpected happens in your family or neighborhood. It can help you and your children feel safer.

If you are concerned about your child's reaction to stress or trauma, call your physician or a community mental health center.
Thursday, January 18, 2007 5:54 AM by John Atkins

# clasificalia

It is understandable at once, that development of your site was a titanic work!
__________<<_My Home Page_>>____________
Friday, January 19, 2007 12:10 PM by clasicalia

# Free porn here! w

Sunday, March 30, 2008 2:54 AM by Houbborofp

# Buy Viagra Online Only 1.21 Per Pill.

Good Day Dear Customers!
Please visit our pharmacy and get 4 free viagra pills for any orders and get 12 free viagra pills for orders >300$

[url=http://aaaanet.com/]buy viagra[/url]
[url=http://aaaanet.com/cialis]buy cialis[/url]
[url=http://aaaanet.com/levitra]buy levitra[/url]
Sunday, July 13, 2008 12:19 AM by BedroomDoctor

# thx

hey ))
its very  point of view.
Nice post.
realy gj

thank you ;)
Monday, September 01, 2008 10:07 PM by BougBouhillibre

# impotence statistics

[b]Buy cheap viagra[/b]

[url=http://buyviagranow10.buyusarx.com/viagra.htm][b]reasons for impotence
[/b][/url]10 pills x 100mg $39.95
[b]30 pills x 100mg $89.95[/b]
[b]60 pills x 100mg $129.95[/b]
[b]90 pills x 100mg $149.95[/b]
Sunday, September 07, 2008 4:51 PM by rexonerEnzync

# testosterone impotence

[b]Buy cheap viagra[/b]

[url=http://doctorcialis.buyusarx.com/viagra.htm][b]impotence pills
[/b][/url]10 pills x 100mg $39.95
[b]30 pills x 100mg $89.95[/b]
[b]60 pills x 100mg $129.95[/b]
[b]90 pills x 100mg $149.95[/b]
Monday, September 08, 2008 6:31 PM by rexonerEnzync

# prostate impotence

[b]Buy cheap viagra[/b]

[url=http://doctorviagra.buyusarx.com/viagra.htm][b]prostate and impotence
[/b][/url]10 pills x 100mg $39.95
[b]30 pills x 100mg $89.95[/b]
[b]60 pills x 100mg $129.95[/b]
[b]90 pills x 100mg $149.95[/b]
Monday, September 08, 2008 8:47 PM by rexonerEnzync

# treatment of impotence

[b]Buy cheap viagra[/b]

[url=http://buycialis.buyusarx.com/viagra.htm][b]high blood pressure impotence
[/b][/url]10 pills x 100mg $39.95
[b]30 pills x 100mg $89.95[/b]
[b]60 pills x 100mg $129.95[/b]
[b]90 pills x 100mg $149.95[/b]
Friday, September 12, 2008 2:44 AM by rexonerEnzync

# impotence age

[b]Buy cheap viagra[/b]

[url=http://doctorviagra.buyusarx.com/viagra.htm][b]smoking causes impotence
[/b][/url]10 pills x 100mg $39.95
[b]30 pills x 100mg $89.95[/b]
[b]60 pills x 100mg $129.95[/b]
[b]90 pills x 100mg $149.95[/b]
Friday, September 12, 2008 2:44 PM by rexonerEnzync

# prolan1111

ocIRS2 it`realy.... good info.... imho
Tuesday, September 16, 2008 7:49 AM by prolan1111

# VwAhjtLCpLaQ

Monday, September 22, 2008 2:57 AM by VGQwbZtIZxoaUWJmUYl

What do you think?