Sriram's 2 Cents

Oracle and SQL Server Interoperability options

SQL Server provides various options for interoperating with Oracle 1) SSIS - Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) Read More...

Posted Tuesday, March 18, 2008 9:08 PM by sriramgmsft | 1 Comments

What's new in SQL 2008 Data Mining

  Engine and algorithm improvements: To improve the accuracy and stability of some predictions in time series models, a new algorithm has been added to the Microsoft Time Series algorithm. Based on the well-known ARIMA algorithm, the new algorithm Read More...

Posted Tuesday, March 18, 2008 7:30 PM by sriramgmsft | 0 Comments

SQL Server in a Virtual Environment - Part 2

  Read More...

Posted Tuesday, March 18, 2008 7:22 PM by sriramgmsft | 1 Comments

SQL Server in a virtual environment - Part 1

Here is a slide deck I recently used to discuss using SQL Server in a virtual environment:   Read More...

Posted Tuesday, March 18, 2008 7:17 PM by sriramgmsft | 1 Comments

Announcing SQL Server Data Services

http://www.microsoft.com/sql/dataservices/default.mspx Read More...

Posted Tuesday, March 18, 2008 7:11 PM by sriramgmsft | 1 Comments

SSIS - A hosting scenario

Issue: 4 instances of SQL Server installed on a 4 node cluster with any SQL Server instance possibly failing over to any other node. All 4 nodes have SSIS installed on them. (I am assuming you have not clustered the SSIS service). You want users to be Read More...

Posted Tuesday, March 18, 2008 7:09 PM by sriramgmsft | 1 Comments

Accessing SSAS cube from Java

I was recently asked this question and so did some research and here are some of the options: 1) XMLA is the protocol designed for universal access to SSAS from heterogeneous clients - http://msdn2.microsoft.com/en-us/library/ms187178.aspx 2) 3 rd party Read More...

Posted Tuesday, March 18, 2008 7:05 PM by sriramgmsft | 1 Comments