HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names

using (AdomdConnection conn = 
             new AdomdConnection("Data Source=tfsDB;Initial Catalog=Tfs_Analysis; MDX Compatibility=1;")) 
    {  
        conn.Open();  
        using (AdomdCommand cmd = new AdomdCommand(" ....... mdxQuery here ....... ", conn))  
        {  
            DataSet ds = new DataSet();  
            ds.EnforceConstraints = false;  
            ds.Tables.Add();  
            DataTable dt = ds.Tables[0];  
            dt.Load(cmd.ExecuteReader());  
            return dt;  
        }  
    }

var reportData = new DataSet();
reportData.ReadXml("yourfile.xml");
var connection = new SqlConnection("DB ConnectionSTring");
var sbc = new SqlBulkCopy(connection);
sbc.DestinationTableName = "yourXMLTable";

INSERT Customers 
SELECT * 
FROM OPENXML ...

create unique nonclustered index idx on dbo.DimCustomer(emailAddress)
where EmailAddress is not null;