The Curious Engineer

All blogs / Databases

dilkushp

learn.microsoft.com/en-us/archive/blogs/dilkushp

DatabasesDevOps / SRE / infrastructureMicrosoft blogsMSDN archive

’15’20’25
Posts
18 from 27 Jul 2013 to 19 Nov 2014
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/dilkushp/feed.xml

2014 8

  1. Run Network Trace for longer time without generating huge amount of data
  2. Data Management gateway setup fails without any Error message to work with.
  3. Refreshing Excel files which has Data Sources not supported by PowerBI.
  4. Refresh PowerQuery connections using powerBI data source
  5. Using Odata feed on Azure client whose Data Source is configured against DMG on Azure VM
  6. Install SQL ODBC driver on SUSE Linux
  7. MDS Admin user no longer exist, what now?
  8. SQL Browser memory management problem on machine with more than 32 logical processors

2013 10

  1. Login failed for user on portal and SSMS when username has “@” in it.
  2. SSIS: Update & Insert to same table in Data Flow task causing “This operation conflicts with another pending operation on this transaction. The operation failed.”
  3. Easiest way of loading JSON data in SQL using C#
  4. SSIS 2012 Automation (Powershell and C#)
  5. Connect to SharePoint Online from SSIS (Insert)
  6. Connect to SharePoint Online from SSIS (Select)
  7. Case Study: Import data from XML to SQL (Part-2)
  8. Case Study: Import data from XML to SQL (Part-1)
  9. Accessing varbinary federation key programmatically
  10. Fragmentation in SQL Azure!