Entries for Mario Cannistrà

SQL Server 2005 Mobile Edition : free like Express or has a price ? [SQL Server 2005 Mobile Edition : free like Express or has a price ?]

Mario Cannistrà — Fri, 11 Nov 2005 14:43:36 GMT

In this web page:
http://www.microsoft.com/sql/editions/sqlmobile/sqlmobile.mspx

there's a link to "How to Buy SQL Server Mobile".

That page has a table with prices for various SQL Server editions.
Also the free Express edition is shown, but Mobile edition is missing !
http://www.microsoft.com/sql/howtobuy/default.mspx

Anyone has correct info about this subject ?

thanks,
mario

in reply to SQL Server 2005 Mobile Edition : free like Express or has a price ?

Developing Parts for Vista's sidebar: how to create .part files ? [Developing Parts for Vista's sidebar: how to create .part files ?]

Mario Cannistrà — Wed, 02 Nov 2005 09:01:15 GMT

Does anyone know where to find instructions on how to create .part files ?

thank you,
mario

in reply to Developing Parts for Vista's sidebar: how to create .part files ?

Did you ever have the need of "queuing" SQL Jobs execution? [Did you ever have the need of "queuing" SQL Jobs execution?]

Mario Cannistrà — Tue, 25 Oct 2005 13:45:43 GMT

I recently met this problem and received disaccording answers from different information sources.

I have many users using an old client-server application to launch long-running procedures. They run for a minimum of 15 minutes to 60 minutes or more.

The procedures’ inner workings have already been examined from senior developers and from the DBA: no more optimizations are feasible.

Due to the high demand of processing and to the resource contention on the main database, I think that these activities should be queued.

The approach I’m suggesting is:

group all data processing routines in one or more stored procedures
modify the client application to “request” processing instead of directly executing it and receiving a job number
manage a queue of SQL jobs launched from a Windows Service
modify the client application to get the status of the user’s jobs
organize jobs in “classes” with different characteristics (maximum run time for the job, start and stop hour of day in which execution is allowed,…)

What is your opinion about this solution?

I think this approach could solve this specific problem and represent the framework to be used for projects with similar needs.

I look forward to read your comments.

in reply to Did you ever have the need of "queuing" SQL Jobs execution?