Getting Deadlock Error During Processing

Issue: Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC error. Transaction (Process ID n) was deadlocked on thread| communication buffer resources with another process and has been chosen as the deadlock victim. Cause: A deadlock is a circular blocking chain, where two or more spids are each blocked by…

1

SSDT Query Builder: MDX Query returning NULL instead of AllMembers

  *SSDT – SQL Server Data Tools *SSMS – SQL Server Management Studio In SSDT Query Designer getting Null for All members: One of my customers recently reported this issue so thought of sharing with world…… Demo given below will provide an insight…………… Simple query, where we are doing cross join of allmembers from Product…

0

Configuring: PowerPivot for Excel 2013

  For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps: In Excel 2013 By default PowerPivot add-in is disabled and you need to enable it manually – 1) File –> Options –> Add-in –>Manage Select (Com Add-Ins)   2) After Selecting Com Add-in click GO, by default Add-ins are disabled Further…

1

How to use Network Monitor to capture network traffic

  Often I need to share these steps with customers while troubleshooting Connectivity issues, so thought to write an article with screenshots which will ease in collecting traces: Please go to the following URL and install the latest version of Network Monitor 3.4 , make sure you download the right version depending upon your machine’…

1