dilkushp
Run Network Trace for longer time without generating huge amount of data
We see many scenarios where issues are intermittent and we have to collect network traces for such...
Author: Dilkush Patel Date: 11/19/2014
Data Management gateway setup fails without any Error message to work with.
Recently I ran into issue where DMG fails to install and as such on error windows there is nothing...
Author: Dilkush Patel Date: 10/08/2014
Refreshing Excel files which has Data Sources not supported by PowerBI.
Consider you have Excel file which has Data coming from SharePoint list or DB2 or Teradata or MySQL...
Author: Dilkush Patel Date: 09/24/2014
Refresh PowerQuery connections using powerBI data source
First thing first 1) We can refresh power query connections created against SQL Server and Oracle...
Author: Dilkush Patel Date: 06/26/2014
Using Odata feed on Azure client whose Data Source is configured against DMG on Azure VM
Recently we have come across many requests where people wanted to install DMG gateway on Azure VM...
Author: Dilkush Patel Date: 06/26/2014
Install SQL ODBC driver on SUSE Linux
We have Few very good documents available for installing SQL ODBC on RedHat linux but when it comes...
Author: Dilkush Patel Date: 06/11/2014
MDS Admin user no longer exist, what now?
Consider this scenario, your organisation started using SQL MDS (Master data Service) and at this...
Author: Dilkush Patel Date: 05/27/2014
SQL Browser memory management problem on machine with more than 32 logical processors
We have seen recently that on machines which has more than 32 logical processors sometimes SQL...
Author: Dilkush Patel Date: 03/30/2014
Login failed for user on portal and SSMS when username has “@” in it.
This is very interesting case which I came across and was not sure why login is failing even though...
Author: Dilkush Patel Date: 12/04/2013
SSIS: Update & Insert to same table in Data Flow task causing “This operation conflicts with another pending operation on this transaction. The operation failed.”
Consider below SSIS Package, Single Data Flow task which has è Source , which fetches data...
Author: Dilkush Patel Date: 12/03/2013
Easiest way of loading JSON data in SQL using C#
I was searching this on Google\Bing and unfortunately did not find much interesting hits. (I can say...
Author: Dilkush Patel Date: 10/31/2013
SSIS 2012 Automation (Powershell and C#)
Hi Everyone I recently ran into few cases where customer needed to automate SSIS Project...
Author: Dilkush Patel Date: 10/13/2013
Connect to SharePoint Online from SSIS (Insert)
In previous part we saw that how we can use Script Component as Source to pull data from SharePoint...
Author: Dilkush Patel Date: 10/01/2013
Connect to SharePoint Online from SSIS (Select)
We have SharePoint List Adapter available at Codeplex but problem is it does not connect to...
Author: Dilkush Patel Date: 10/01/2013
Case Study: Import data from XML to SQL (Part-2)
Hello again… In Case Study: Import data from XML to SQL (Part-1) we tried to save XML data to...
Author: Dilkush Patel Date: 09/14/2013
Case Study: Import data from XML to SQL (Part-1)
XML to SQL (or to any relational database) could be real pain if XML has schema with lots of nodes...
Author: Dilkush Patel Date: 09/14/2013
Accessing varbinary federation key programmatically
When we have federation with varbinary federation key and we want to access that federation key from...
Author: Dilkush Patel Date: 07/27/2013
Fragmentation in SQL Azure!
Do you think you are paying for whatever space you are using or you are paying extra? Most of the...
Author: Dilkush Patel Date: 07/27/2013