Announcing the Analysis Services Stored Procedure Project

A few months ago, a few community-spririted Analysis Services guys (including me) got together to create some example Analysis Services stored procedures. I'm happy to announce that beta 1 of our project is now available to download here:
http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASStoredProcedures
The idea was to create a set of useful extensions to MDX to help solve common problems and at the same time provide some example source code to help people writing their own stored procedures. Please take a look and tell us what you think!

Very Nice!

How about a function that takes care of divide-by-zero and returns NULL if the denominator is 0? Ie. ReturnDivide(division). That would clean up a lot of iif mdx.

|||

We discussed this exact problem, but Mosha explained that using a sproc in this way would do more harm than good. Basically, the problem is that there's no way of marking a sproc as being deterministic (ie will always return the same result for the same cell) and so that means that if you use a sproc in a calculated member then the value returned by that calculation will never be cached. As a result, it's probably better to use IIF instead so that subsequent requests for the result returned by a calculation for any given cell in the cube will be returned from the cache.

To answer your other question about IIF, if <mdxstatement> is a calculated measure whose result can be cached, then no, it will only be executed once and the second time it's evaluated the value will be returned from the cache. So it's good idea to create a calculated measure to hold the value of <mdxstatement> even if you don't intend to display the result to the user and set its Visible property to False.

HTH,

Chris

|||

Just so I understand:
You are saying that the following MDX script will make the server calculate [measures].[summation] once in the scope iif statement:

Create Member [Measures].[Summation] AS

Aggregate({[DimMember1], [DimMember2]});

Scope ([DimMemberX]);

this = iif([Measures].[Summation] = 0, NULL, [SomeSet] / [Mesures].[Summation];

End Scope;

Whereas this statement will make it calculate it twice:

Scope ([DimMemberX]);

this = iif(aggregate({[Dimmember1], [Dimmember2]}) = 0, NULL, [Someset] / aggregate([DimMember1], [DimMember2]));

End Scope;

|||

Yes, that's what I understand.

Chris

Announcing SQL Server Everywhere Edition

Today we are announcing SQL Server Everywhere Edition, a light weight database designed for client applications that run from desktops to mobile devices. Pl see the section 'Dynamic Applications' in the Microsoft's Data Platform Vision and Roadmap from Paul Flessner, Sr VP, Microsoft.

Microsoft’s Data Platform Vision and Roadmap: Your Data, Any Place, Any TimeMicrosoft’s Data Platform Vision and Roadmap: Your Data, Any Place, Any Time

http://www.microsoft.com/sql/letter.mspx

The new product is based on the familiar SQL Server Mobile Edition.

-Durga Gudipati

Program Manager, SQL Server Everywhere Edition

We are in the very begining of migration to 3rd party solution for storing user documents. We currently use SQLCE2.0 and we were terribly disapointed that MS decided not to license its interoperability of SQLCE3.0 databases across all platforms.

I need to know the licensing policy of the new product before May 16th. Is it going to be royalty-based or similar to SQL Mobile (i.e. virtually free)?

|||

Can you please provide more information than this letter

|||

some more info but not much

http://blogs.msdn.com/search/SearchResults.aspx?q=SQL+Server+Everywhere+Edition&o=Relevance

|||

SQL Everywhere (SQL Ev) will be free on desktops, laptops/tablets and mobile devices running MS OS.

The first CTP will be in summer and release will be by end of the year.

Once released, SQL Everywhere replaces SQL Mobile.

-DurgaG

Announcing Matisse, the Post-Relational SQL Database

Matisse (www.matisse.com), the ultimate database for .NET and Java, is an innovative Post-Relational SQL database for .NET and Java environments that natively supports Objects and XML. The Matisse database represents an outstanding solution for database architects confronted with complex business or scientific modeling needs.

Matisse greatly simplifies the architecture of applications, removing the need for an Object-Relational mapping layer and the severe limitations that come with it. This feature alone cuts the length of the application code by 30% to 50%, thus paying off in terms of faster time-to-market due to shorter database development cycles, lower TCO due to lower maintenance requirements, and higher overall database performance.

To leverage existing corporate expertise in relational databases, Matisse Software embraces the SQL standard to operate on semantic networks of information instead of being limited to manipulating two-dimensional tables. This powerful approach opens new frontiers for building application and services that manage complex business processes and rich data.

For more information, please visit www.matisse.comAnother silver bullet...|||whats post relatinal sql database? they making up words?

Jim|||well, tried it, struggled with install and initial setup, and...there's a lot of work ahead for them before they can really claim anything. so far, - back to the drawing board, guys :)|||Originally posted by ms_sql_dba
well, tried it, struggled with install and initial setup, and...there's a lot of work ahead for them before they can really claim anything. so far, - back to the drawing board, guys :)

The pdfs were flashy though...
Jim|||Well, with no transaction logging (and no point in time recovery) as well as not a lot of security (you are either DBO, or read-only. No middle ground), I should darn well hope it is fast.|||Originally posted by MCrowley
Well, with no transaction logging (and no point in time recovery) as well as not a lot of security (you are either DBO, or read-only. No middle ground), I should darn well hope it is fast.

sounds like a stripped down version of Access...

Announcing a GUI tool for configuring dialog security and routing

Hi,

I am not

able to get “Service Broker” under my database? Can you tell me what is wrong

with my installation?

Regards,

If you are using SQL Server Management Studio Express, it does not have the functionality to view or create Service Broker objects. The paid version of the same lets you view Service Broker objects but not create them. Unfortunately, the only way to create, alter and use Service Broker objects is via T-SQL commands. Please look at the Service Broker section of Books Online, the SQL Server online documentation on MSDN.

Announcing - SQL Server Database Publishing Wizard CTP 1

The SQL Server group at Microsoft has just launched theSQL Server Hosting Toolkit with the release of theDatabase Publishing Wizard Community Technology Preview 1.

The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server. The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster. In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles. In the coming months we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.

Details on the Database Publishing Wizard as well as the download can be found athttp://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.

We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!

Thanks,

Dan Winn

Senior Program Manager, Microsoft SQL Server

Does the SQL Server Hosting Toolkit work alongside Visual Web Developer ?
Will it transfer ASPNETDB.MDF across to a shared SQL 2005 server - without having to write stacks of code ?
Will new ASP users be able to use it ?

Good to see that Microsoft is responding, otherwise you are going to frustrate a lot of VWD newbies ...

Just seen that DiscountASP.NET have a SQL 2005 Attach MDF Tool ... it seems they have recognised that thousands of new VWD user are having real problems moving databases from local to server.

|||

this is a great little tool, thanks for making it available! I've been looking for a utility to pull an image of a hosted database for some time but had no luck finding it. This tool actually works to pull data of a remote SQL 2000 Server.

Whatever you add in the future, please keep the command line available. That will enable this tool for backup purposes.

For a moment I was confused when I could not open the result file in vim. Apparently the format is unicode or whatever 2 byte character encoding is called. I think it would be useful if there was an option to generate plain-simple 1 byte character text files. If only because the size gets cut in half :)

|||

Thanks for your feedback Nocturnal. We'll definitely be keeping the command line. Interesting idea on the single byte text output. The problem would be potential data loss, but we might be able to detect that and throw an error...

By the way, check out the new CTP we just released athttp://www.codeplex.com/sqlhost

Thanks,
Dan

|||darn! a perfect tool for me... only if the source database supports sql server 2000. I'm pushing it the other way around, 2000 to 2005. :(|||I use it with SQL 2000. Did you try and did it not work?|||

Yeah, it didn't.

My source table is 2000, targe is 2000 as well, publish schema only. Get an error while in Gathering list of objects to script. says need 2005 or later. :( had to use the Red Gate sql compare instead.

|||

Very Very Good efforts by the team.

This tools are very much appreciated and welcomed.

I think backup, restore facilities should be included in future versions they are a must. I think dotnet panel is utilising them very smoothly.This could be a disadvantage for users if their host is providing some panels and this is a common scenerio.

----------------------------------------
A little information required here...

What if i upload a new data from my local SQL2005 to remote SQL2005. I just want my local sql2005 to be along with remote sql2005, i do not want to over write the remote sql2005. Is it possible...?

e.g:- my remote has 10 datas. I want to add 2 datas more from my local sql2005 to remote sql2005 to make it 12 datas on remote.
If i over write it will become 2 on remote, i will looose 10 datas.

I hope i have cleared. Thi facility if not added to day, should be considered for future
--------------------------------------------

I was surprised no one has mentioned the links for great tutorials for this tool by Mr. Scott Guthrie.

Any how its here...

Tutorial 1

and

Tutorial 2

Cheers!

|||thank you!|||I would like to be able to select which tables, views, functions, and stored procedures to move.|||

We are currently using the Team Edition for Database Pros plug in for VS Team Suite, along with Web Deployment Projects and Team Build for Team Foundation Server.

Do you think this new utility has a place in that kind of environment? Currently, the database project generates a SQL deployment script when we do a team build, and we can also use the database project's Schema Compare and Data Compare to sync our live databases.

|||;) Good to hear. Very appreciated. I will have a look at it|||

Same problem tried with Sql 2000 and failed :(

|||

I tried with SQL 2000 but got an errors.

DBMaster

MyBlog

Ann:www.SQL-Scripts.Com

Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge them on our site. If you lodge your script you could win a prize. In
addition to scripts there are many documents, news feeds and articles.
We have a monthly contest for the first people to lodge 20 scripts in one
month.
Please help to make this site great.
Webmaster at www.SQL-Scripts.com
You are spamming this group. Please cease & desist.
Lots of people manage to get commercial messages expressed by the simple
expedient of placing their URL or service statement in their signature line.
Note that spam messages are not their mode. They get their messages out by
responding intelligently to huge volumes of posts. They really help people
and they're here more to give than to get
HTH
-Larry-
"www.sql-scripts.com" <webmasterNOSPAM@.SQL-SPAM-Scripts.Com> wrote in
message news:udzZVZlJEHA.624@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Announcing the release of a new web site : www.SQL-Scripts.com
> At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
> different database system. Using our search system you can find scripts
> that you need quickly and simply. If you have scripts that you use why
not
> lodge them on our site. If you lodge your script you could win a prize.
In
> addition to scripts there are many documents, news feeds and articles.
> We have a monthly contest for the first people to lodge 20 scripts in one
> month.
> Please help to make this site great.
> Webmaster at www.SQL-Scripts.com
>

Ann:www.SQL-Scripts.Com

Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge them on our site. If you lodge your script you could win a prize. In
addition to scripts there are many documents, news feeds and articles.
We have a monthly contest for the first people to lodge 20 scripts in one
month.
Please help to make this site great.
Webmaster at www.SQL-Scripts.com
You are spamming this group. Please cease & desist.
Lots of people manage to get commercial messages expressed by the simple
expedient of placing their URL or service statement in their signature line.
Note that spam messages are not their mode. They get their messages out by
responding intelligently to huge volumes of posts. They really help people
and they're here more to give than to get
HTH
-Larry-
"www.sql-scripts.com" <webmasterNOSPAM@.SQL-SPAM-Scripts.Com> wrote in
message news:udzZVZlJEHA.624@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Announcing the release of a new web site : www.SQL-Scripts.com
> At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
> different database system. Using our search system you can find scripts
> that you need quickly and simply. If you have scripts that you use why
not
> lodge them on our site. If you lodge your script you could win a prize.
In
> addition to scripts there are many documents, news feeds and articles.
> We have a monthly contest for the first people to lodge 20 scripts in one
> month.
> Please help to make this site great.
> Webmaster at www.SQL-Scripts.com
>