Geo Diverse SQL Server site locations

Looking for a couple options to setup a geo-diverse sql cluster configuration
between two separate site locations. Trying to determine what tryp of
replication I should use and/or creating transactional and snapshot
publications. The sites will have the same high end hardware for the servers
and SAN arrays. We utilize about 4 databases with one of them being the
master DB for history of our services. Any input is helpful.
Corey
Depending on the SAN vendor, they have some solutions out there.. Or else
there are 3rd party products from NSI, Xosoft,Neverfail just to name a few
that can help
"Corey" <Corey@.discussions.microsoft.com> wrote in message
news:E703FBF0-8671-4308-A929-DEC2DA58DECC@.microsoft.com...
> Looking for a couple options to setup a geo-diverse sql cluster
configuration
> between two separate site locations. Trying to determine what tryp of
> replication I should use and/or creating transactional and snapshot
> publications. The sites will have the same high end hardware for the
servers
> and SAN arrays. We utilize about 4 databases with one of them being the
> master DB for history of our services. Any input is helpful.
> Corey

Generating reports dynamically

I am new to reporting and Yukon and trying to understand reporting services.
I am trying
to determine if it is possible to define reports programmatically and send
them to a yukon server (or SQL server 2000) and have it generate an Excel
report and place it at the specified location on the file server. What
complicates this picture is that the reports to be generated/queries to be
performed are very complex. Can such complex queries be defined dynamically
and sent to the server via an API call ... can we use a stored procedure, if
necessary, to return the data?
I looked briefly at RDL and the web services but could not determine if they
could be leveraged for our solution. Any input you have will be greatly
appreciated.Yes, you can generate reports dynamically via the API... you can also run
them,,, you can create subscriptions to run immediately, and send the report
to a file share..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"IP" wrote:
> I am new to reporting and Yukon and trying to understand reporting services.
> I am trying
> to determine if it is possible to define reports programmatically and send
> them to a yukon server (or SQL server 2000) and have it generate an Excel
> report and place it at the specified location on the file server. What
> complicates this picture is that the reports to be generated/queries to be
> performed are very complex. Can such complex queries be defined dynamically
> and sent to the server via an API call ... can we use a stored procedure, if
> necessary, to return the data?
> I looked briefly at RDL and the web services but could not determine if they
> could be leveraged for our solution. Any input you have will be greatly
> appreciated.|||Thank you Wayne. Can you please point me to which API can be used for this
purpose and any websites that I can go to for more information on this.
Thanks in advance,
IP
"Wayne Snyder" wrote:
> Yes, you can generate reports dynamically via the API... you can also run
> them,,, you can create subscriptions to run immediately, and send the report
> to a file share..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "IP" wrote:
> > I am new to reporting and Yukon and trying to understand reporting services.
> > I am trying
> > to determine if it is possible to define reports programmatically and send
> > them to a yukon server (or SQL server 2000) and have it generate an Excel
> > report and place it at the specified location on the file server. What
> > complicates this picture is that the reports to be generated/queries to be
> > performed are very complex. Can such complex queries be defined dynamically
> > and sent to the server via an API call ... can we use a stored procedure, if
> > necessary, to return the data?
> >
> > I looked briefly at RDL and the web services but could not determine if they
> > could be leveraged for our solution. Any input you have will be greatly
> > appreciated.

Generating a cached copy of the report

Is there a way to programatically determine if a report should be generated from the cache or run against real-time data?

I have a situation wherein I would need to programmatically figure out if the datasource needs to be a cached version or real-time data based on certain options that a user defines (not report parameters)...

any help would be very appreciated.Not before running the report, but afterwards you can look at the ExecutionDate property. Depending on the version of SRS you are using that can be retrieved in different ways.|||

NOt sure what you're trying to do: data sources are not cached in Reporting Services. Report are.

Essentially, if you want cache to work, you need to set the data source to use stored credentials and not use any User!UserID or User!Language references in your report.

The GetCacheOptions method provides caching information on the report itself.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_5jas.asp

-Lukasz

|||

Yes, I would like to have the report cached with the underlying data in it.

If I were to have it cached per UserID, would having references to User!UserID in the report take care of it?

Sorry if this is a pretty basic question, but I am trying to finalize if this is possible using Reporting services.
Thanks

|||The cache is not per user, it is shared between users (based on parameters). You can use a post query filter on UserID but referenceing the user it in the query doesn't make any sense. All of the caching options are discussed in the online help.|||If the report uses UserID in a post-query filter, the report will get cached, but the filter will be re-executed for each user.|||

I am trying to get around the user global variable to run reports. I have security implemented by User in the reports. i.e. a userID is only allowed to select the following regions in the region parameter,

I also have a hidden parameter that has two values; online and offline. The parameter is defaulted to online when running the reports interactively and for subscriptions to batch. When it is online, I get the current logged on userID using a CLR function. We get around the batch parameters by using a master userID that has access to all the data (all regions) in the subscriptions.

When the subscription is run with batch, will the interactive users pick up the cached report or run it again as the interactive parameter is online? From your reply, the cache that is selected is based on the parameter list for the report.

The real question is caching based on the parameters passed to retrieve from cache or is there a way around it? Or is there a way to determine if a cached version of the report is being run so that I can plug in my master userID?

Thanks

Generating a cached copy of the report

Is there a way to programatically determine if a report should be generated from the cache or run against real-time data?

I have a situation wherein I would need to programmatically figure out if the datasource needs to be a cached version or real-time data based on certain options that a user defines (not report parameters)...

any help would be very appreciated.Not before running the report, but afterwards you can look at the ExecutionDate property. Depending on the version of SRS you are using that can be retrieved in different ways.|||

NOt sure what you're trying to do: data sources are not cached in Reporting Services. Report are.

Essentially, if you want cache to work, you need to set the data source to use stored credentials and not use any User!UserID or User!Language references in your report.

The GetCacheOptions method provides caching information on the report itself.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_5jas.asp

-Lukasz

|||

Yes, I would like to have the report cached with the underlying data in it.

If I were to have it cached per UserID, would having references to User!UserID in the report take care of it?

Sorry if this is a pretty basic question, but I am trying to finalize if this is possible using Reporting services.
Thanks

|||The cache is not per user, it is shared between users (based on parameters). You can use a post query filter on UserID but referenceing the user it in the query doesn't make any sense. All of the caching options are discussed in the online help.|||If the report uses UserID in a post-query filter, the report will get cached, but the filter will be re-executed for each user.|||

I am trying to get around the user global variable to run reports. I have security implemented by User in the reports. i.e. a userID is only allowed to select the following regions in the region parameter,

I also have a hidden parameter that has two values; online and offline. The parameter is defaulted to online when running the reports interactively and for subscriptions to batch. When it is online, I get the current logged on userID using a CLR function. We get around the batch parameters by using a master userID that has access to all the data (all regions) in the subscriptions.

When the subscription is run with batch, will the interactive users pick up the cached report or run it again as the interactive parameter is online? From your reply, the cache that is selected is based on the parameter list for the report.

The real question is caching based on the parameters passed to retrieve from cache or is there a way around it? Or is there a way to determine if a cached version of the report is being run so that I can plug in my master userID?

Thanks