SQL BI / Data Access Technologies
( SSIS, SSRS, SSAS, Data Access, POWER BI, PBI RS, Azure AS, SSMA, LINQ, System.Data ... )
Things to know before developing MS XML applications.
XML is a method for putting structured data in a text file . Microsoft XML Core Services...
Author: Snehadeep Date: 10/13/2009
SQL Connectivity errors related to SPN and troubleshooting them.
You might get the following error when there is any issue related to a SPN in the environment: 1)...
Author: Snehadeep Date: 10/08/2009
How to convert an IEnumerable to a DataTable in the same way as we use ToList or ToArray
LINQ provides us some extension methods to convert an IEnumerable to a collection e.g. ToList(),...
Author: Snehadeep Date: 04/08/2009
How to find out the data-reader referencing an ADO.NET connection object to fix the error: "There is already an open DataReader associated with this Command which must be closed first"
Sometimes while executing a DB command in ADO.NET we come across below error. There is already an...
Author: Snehadeep Date: 04/08/2009
How to force System.Xml.Xsl.XslCompiledTransform class to not use self closing tags for empty nodes
In .NET 2.0 framework when you use System.Xml.Xsl.XslCompiledTransform class for transforming a...
Author: Snehadeep Date: 04/08/2009