You can generate report models based on an Oracle database running version 9.2.0.3 or later by using Model Designer, Report Manager, or Microsoft Office SharePoint Server 2007 when running in SharePoint integrated mode.

To generate models based on Oracle databases, you must be running an Oracle client version 9.2.0.3 or later. The Oracle client directory must be located in the system path and both the Report Server Windows service and Report Server Web service must have permissions to access the files in this directory.

In addition, verify:

• The Reporting Services Oracle data processing extension is available in your Reporting Services installation.
• The Oracle client is installed in a folder that can be accessed by the Report Server Windows service and the Report Server Web service.
• The Report Server Windows service, Report Server Web service, and unattended execution accounts must all have Read and Execute directory access to the Oracle client installation.

When building a report model based on an Oracle database, your connection string appears similar to the following:

Data Source="Oracle9";Unicode="True" where "Oracle9" represents the logical name of the Oracle server.

For additional information and limitation click here.

Bye,

Ronen

• Read more
• 1 comment(s)

The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:

• Redistributable components for SQL Server 2008.
• Add-on providers for SQL Server 2008.
• Backward compatibility components for SQL Server 2008.

Click to GO to Download site

Enjoy,

Ronen

• Read more
• 1 comment(s)

Multicore processors, which consist of multiple processing execution units or "cores" on one chip, promise to boost computing power, allowing servers, workstations, and PCs to perform more functions simultaneously.  Because most server-side software is licensed "per processor," it has caused confusion among some software vendors regarding whether to charge their customers "per processor" or "per core."

find more at http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx

it is about SQL 2005 but relevant for 2008 as well.

further more, to Compare Editions–Enterprise and Standard folow this link

Bye,

Ronen

• Read more
• No comments

As most of you might have already heard, SQL Server 2008 SP1 is out and can be downloaded from the Microsoft site. The build number is 2531 (so the complete version number is now 10.0.2531.0).

Among the bug fixes and improvements (all listed in KB 968369) you will also find the Click-Once version of the Report Builder (being a stand-alone application in the RTM release), so it's easier to deploy the Report Builder now. After the installation you will find the button for launching the Report Builder just where it was in SQL Server 2005.

Bye,

Ronen

• Read more
• 2 comment(s)

• Read more
• No comments

The ascmd command-line utility enables a database administrator to execute an XMLA script, Multidimensional Expressions (MDX) query, or Data Mining Extensions (DMX) statement against an instance of Microsoft SQL Server Analysis Services. This command-line utility contains functionality for Analysis Services that resembles the sqlcmd utility included with SQL Server. For more information, see the topic sqlcmd Utility in SQL Server. The execution results of the script, query, or statement can be stored in a file together with relevant SQL Server Profiler trace information.

What can you do with it?

• Backing up a database in an UnTrusted domain
• Automating the build and training of a data-mining model
• Batch processing multiple partitions
• Creating a "cache warmer" application and clearing the Analysis Services data cache
• Creating a new database on a server
• Creating a validation procedure on an ETL run
• Discovering when a partition was last processed
• Querying an Analysis Services cube from the command line

Where can you find it?

You can find it under C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Administrator\ascmd

If does not exist, you should download the Sample code from codeplex .

In order to compile the project, you need to generate a strong name key file.

Follow this steps:

1. Open a Microsoft Visual Studio 2008 command prompt. Click Start, point to All Programs, point to Microsoft SQL Server 2008, point to Visual Studio Tools and then click Visual Studio Command Prompt.
2. Use the change directory command (CD) to change the current directory of the command prompt window to the folder where the samples are installed.

Note:

If the default installation location was used, the samples are located in <system_drive>:\Program Files\Microsoft SQL Server\100\Samples.

1. At the command prompt, run the following command to generate the key file:

sn -k SampleKey.snk

Important:

For more information about the strong-name key pair, see "Security Briefs: Strong Names and Security in the .NET Framework" in the .NET Development Center on MSDN.

To build the sample :

After generating the strong name key file, build the sample using the following instructions.

1. From the File | Open menu, click Project and open the solution file ascmd.sln.
2. From the Build menu, click Build ASCMD.

To test the EXE file browse into :

C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Administrator\ascmd\CS\ascmd\bin\Debug

Note:

Microsoft Visual Studio is fully supported on x86 and x64-based computers, but is not supported on Itanium-based computers. As soon as the ascmd command-line utility is compiled, the ascmd command-line utility can be executed on any x86, x64, or Itanium-based computer.

It is a best practice to compile the appropriate version of the ascmd command-line utility because performance might be decreased when you execute 32-bit code on a 64-bit computer.

* it is also working with VISTA,VISTA64BIT and WINDOWS 7 - I have not found a bug yet.

Enjoy ,

Ronen

• Read more
• 2 comment(s)