The philosophy of unexplained..
BI, Data Access and Machine Learning
Thinking in Data…
I am writing this blog after a long time and many things have changed. I have travelled in data land...
Author: Jay[MSFT] Date: 10/01/2014
Consuming SQL Server Data Service aka “Dallas” Service in SSIS
Lets assume a scenario…You are a BI guy of your team and your company has just started...
Author: Jay[MSFT] Date: 06/18/2010
Missing Byte Order Mark in Flat file generated with Flat File Connection Manager in SSIS
I have recently worked on a problem where we come across a situation such as the following:...
Author: Jay[MSFT] Date: 06/15/2010
Resolving 'Operating system error code 5' with BULK INSERT - A different perspective
PROBLEM DECRIPTION While executing a BULK INSERT command from a remote connection the following...
Author: Jay[MSFT] Date: 02/16/2009
Horror of Closing Connections in Finalize()…
Problem Your ASP.NET Web-site times out during production with the following error:...
Author: Jay[MSFT] Date: 09/04/2008
Latest SQL Injection of components
I just received two back to back cases on the SQL Injection attacks today. I found that attackers...
Author: Jay[MSFT] Date: 06/25/2008
FileNotFoundException: File name: 'Microsoft.EnterpriseManagement.Reporting.Security'
Problem: You may not able to browse Reports after installing and uninstalling the MOM reporting. And...
Author: Jay[MSFT] Date: 01/31/2008
Dynamically binding Report Viewer Control to un-typed datasets
Solution Plan: 1. Drop a ReportViewerControl to your favorite web-form 2. Drop a new...
Author: Jay[MSFT] Date: 01/23/2008
Creating and viewing a SQL Server 2005 Reports using a dynamic connection string
In this project we will try to make a report which can use a dynamic connection to a Northwind...
Author: Jay[MSFT] Date: 11/30/2007
Error Code: 500 Internal Server Error. The request was rejected by the HTTP filter. Contact the server administrator. (12217)
Problem: You may see the following error while browsing the reports in SQL Server 2005 Reporting...
Author: Jay[MSFT] Date: 07/13/2007