Sriram's 2 Cents

Happy New Year 2013

Author: sriramgmsft Date: 01/01/2013

Some SQL Server Licensing Scenarios

  I recently was asked about licensing SQL Server in the following two scenarios that may be...

Author: sriramgmsft Date: 06/20/2011

SQL Server Benchmark tools and stress testing tools

This is a FAQ and I recently collected information based on some available resources: The following...

Author: sriramgmsft Date: 06/20/2011

Building Private Clouds with SQL Server

Microsoft released a reference architecture to build a Private Cloud to consolidate your database...

Author: sriramgmsft Date: 06/09/2011

My first post from MSDN Broadcaster

I am including the below podcast link from MSDN Broadcaster about SQL Azure – check it out: What...

Author: sriramgmsft Date: 06/08/2011

Microsoft Desktop Player

This is a great tool for you to search for relevant information on Microsoft properties all...

Author: sriramgmsft Date: 06/08/2011

MSDN Broadcaster

I am going to start using MSDN Broadcaster to start publishing content to this blog, if you are a...

Author: sriramgmsft Date: 06/08/2011

Moving FileStream data to new location

SQL Server 2008 introduces File Stream data type that lets you store BLOB data in an efficient...

Author: sriramgmsft Date: 06/03/2010

Oracle and SQL Server Interoperability options

SQL Server provides various options for interoperating with Oracle 1) SSIS - Microsoft SQL Server...

Author: sriramgmsft Date: 03/18/2008

What's new in SQL 2008 Data Mining

  Engine and algorithm improvements: To improve the accuracy and stability of some predictions...

Author: sriramgmsft Date: 03/18/2008

SQL Server in a Virtual Environment - Part 2


Author: sriramgmsft Date: 03/18/2008

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:  

Author: sriramgmsft Date: 03/18/2008

Announcing SQL Server Data Services

Author: sriramgmsft Date: 03/18/2008

SSIS - A hosting scenario

Issue: 4 instances of SQL Server installed on a 4 node cluster with any SQL Server instance possibly...

Author: sriramgmsft Date: 03/18/2008

Accessing SSAS cube from Java

I was recently asked this question and so did some research and here are some of the options: 1)...

Author: sriramgmsft Date: 03/18/2008

What can and cannot be clustered, what is and is not instance aware

SQL Server 2005 includes a number of different services and it is an interesting topic of discussion...

Author: sriramgmsft Date: 09/11/2007

Do i have to store Sharepoint content in SQL Server?

One frequently asked question is if SQL Server is the only option to store content in a sharepoint...

Author: sriramgmsft Date: 08/27/2007

SQL Server Best Practices

This is a great site to bookmark for SQL Server best practices. There are best practices in several...

Author: sriramgmsft Date: 08/26/2007

SQL 2008 - Encryption - No more app changes!!

If you have used SQL 2005 encryption before, you might have hated the fact that you need to rewrite...

Author: sriramgmsft Date: 08/21/2007

If you guys havent heard of msdewey, you should definitely check it out - Search for...

Author: sriramgmsft Date: 08/21/2007

SQL Server 64 bit clients

An interesting topic/discussion i came across today is connecting to SQL Server 2005 64 bit server...

Author: sriramgmsft Date: 08/14/2007


I just created this blog and hope to post some useful tidbits. I am a database technology specialist...

Author: sriramgmsft Date: 08/13/2007