Share via


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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Date: 07/27/2013