<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Eugene Niemand’s Blog - Medium]]></title>
        <description><![CDATA[Technology and Programming professional and enthusist - Medium]]></description>
        <link>https://medium.com/eugeneniemand?source=rss----bb73f1ae5b5---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>Eugene Niemand’s Blog - Medium</title>
            <link>https://medium.com/eugeneniemand?source=rss----bb73f1ae5b5---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 16:48:47 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/eugeneniemand" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Reconfigure an existing Integration Runtime on a Virtual Machine without Reinstalling]]></title>
            <link>https://medium.com/eugeneniemand/reconfigure-an-existing-integration-runtime-on-a-virtual-machine-without-reinstalling-79992175eb6a?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/79992175eb6a</guid>
            <category><![CDATA[azure]]></category>
            <category><![CDATA[azure-data-factory]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Fri, 07 Feb 2020 09:15:44 GMT</pubDate>
            <atom:updated>2020-02-07T09:14:16.499Z</atom:updated>
            <content:encoded><![CDATA[<h3>How we save time when moving Azure Data Factory Integration Runtimes</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/564/0*fddpS2Rs_CDigwGc.jpg" /></figure><p>If you are using <strong>Azure Data Factory (ADF) </strong>and need to access data outside of Azure you need to install an <strong>Integration Runtime (IR) </strong>on a Virtual Machine (VM) that does have access to the data. At ASOS we have some sources that are still on premises or within VNETs in which case you need an IR. We are always evolving our implementations and recently had to split one of our solutions into two, which meant we had to reconfigure the IRs in multiple environments to connect to different ADFs in other Azure subscriptions.</p><p>The <a href="https://stackoverflow.com/a/56863689/217981">current recommendation</a> of re-configuring an instance is that you cannot enter another key and you will need to reinstall it. However, there is a much easier way to do this <strong>using a single line of PowerShell</strong>.</p><h4>Azure Data Factory</h4><p>In your ADF go to the <strong>Connections</strong> section then select the <strong>Integration Runtimes (IR) </strong>tab. Here you can add and edit IRs as well as get more info about them. Click the edit button (Fig 1) for your chosen IR.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/766/1*CydWfGG2aI0dYJpvS_lXPw.png" /><figcaption>Figure 1 — Integration Runtimes overview</figcaption></figure><p>You will be presented with the following screen (Fig 2). Copy<strong> Key 1 or Key 2</strong> to your clipboard or somewhere else as we will use it soon.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/614/1*LrFLD4TYALxQtu-rlhIPcA.png" /><figcaption>Figure 2 — Integration Runtime Settings</figcaption></figure><p>If you select the <strong>Nodes </strong>tab (Fig 3) you will notice that there aren’t any running nodes for the selected IR</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/621/1*x_ctiKMYvFStZwW4dNcLmw.png" /><figcaption>Figure 3— Nodes Overview</figcaption></figure><h4>On the VM hosting your IR</h4><p><strong>Remote Desktop</strong> into the VM hosting your IR and open <strong>PowerShell</strong>. Execute the below command. Remember to add the key you copied earlier to the <strong>gatewayKey</strong> parameter.</p><pre>&amp; “C:\Program Files\Microsoft Integration Runtime\3.0\PowerShellScript\RegisterIntegrationRuntime.ps1” -gatewayKey &lt;YourKeyCopiedInPrevStep&gt;</pre><p>It will take about a minute to execute and it may look like its hanging as <strong>there is no feedback or progress updates</strong> until its completed. After successful execution you should see a message like the one below (Fig 4)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RrXZs3Y1IkhX66fYJeAW-A.png" /><figcaption>Figure 4 — PowerShell Output</figcaption></figure><p>You can also open the <strong>Microsoft Integration Runtime</strong> (Fig 5) from the <strong>Start Menu</strong> and confirm that the <strong>Data Factory</strong> displayed is indeed the one that you want to connect to.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/786/1*HCSpl68_cktLncW1hziELQ.png" /><figcaption>Figure 5— Microsoft Integration Runtime</figcaption></figure><h4>Back in Azure Data Factory</h4><p>When you look at <strong>Nodes</strong> now you should see (Fig 6) the new node added and in a running status. You may need to refresh the page to see this.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/609/1*iL7dDmnyYmiaKZgz4nRa1Q.png" /><figcaption>Figure 6— Nodes Overview</figcaption></figure><h4>About the author</h4><p>Eugene is a Senior Data Engineer at ASOS with a passion for Test Driven Development, Agile Methodologies, Continuous Integration and Delivery using Microsoft Azure. In my spare time I tinker with Home Automation.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=79992175eb6a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/reconfigure-an-existing-integration-runtime-on-a-virtual-machine-without-reinstalling-79992175eb6a">Reconfigure an existing Integration Runtime on a Virtual Machine without Reinstalling</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[It worked on my machine…]]></title>
            <link>https://medium.com/eugeneniemand/it-worked-on-my-machine-fc10ccabef52?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/fc10ccabef52</guid>
            <category><![CDATA[parquet]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[spark]]></category>
            <category><![CDATA[azure]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Fri, 07 Feb 2020 09:10:31 GMT</pubDate>
            <atom:updated>2020-02-07T09:13:33.870Z</atom:updated>
            <cc:license>https://creativecommons.org/publicdomain/mark/1.0/</cc:license>
            <content:encoded><![CDATA[<h3>Azure Portal Corrupts Downloaded Files</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/298/1*R2QkStgc_yA9glJWy6E6Hw.png" /><figcaption>Credit: <a href="http://www.keepcalmandposters.com/poster/5273092_keep_calm_it_works_on_my_machine">http://www.keepcalmandposters.com/poster/5273092_keep_calm_it_works_on_my_machine</a></figcaption></figure><p>Have you ever had a situation where you’re working with a tester who has reported a bug, and you can’t for the life of you recreate it? It does after all work on your own machine…</p><p>We had an example of when downloading a parquet file using the Azure Portal Data Explorer, it corrupted the file and made it unreadable by Spark and <a href="https://github.com/elastacloud/parquet-dotnet/blob/master/doc/parq.md">parq</a>, however downloading the same file with the <a href="https://azure.microsoft.com/en-gb/features/storage-explorer/">Azure Storage Explorer</a> solved the problem.</p><p>We were two days from deploying to production and our tester raised a bug, reporting he could not read the file he downloaded using the Azure Portal Data Explorer. Executing the below, we got a very strange and unhelpful error. <em>We also got the same error using the spark-shell.</em></p><pre>C:\&gt; parq view &quot;C:\pathToMyFile\part-00000-tid-6568847690690471989-b6379e19-6e93-4b7b-8a8c-9da4bda0817a-26-c000.snappy.parquet&quot; </pre><pre>parq v3.2.0</pre><pre>[FAIL] don&#39;t know what type: 15<br>don&#39;t know what type: 15</pre><p>We started comparing versions of our Scala binaries to see if there were any obvious differences. This worked two days ago, what’s changed? We looked at logic, data types etc. Nothing obvious, we tried increasing resources on our Spark cluster — still no luck.</p><p>We ran our integration tests locally, used the same command and it all worked a treat. Okay, so the code is fine and produces a valid parquet file. We manually uploaded the same JAR to the cluster and ran the job again.<em> </em>The tester downloaded the file and the error occurred again, the engineer downloaded the file and the command worked fine.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/402/1*RNyLwHFvV-Iqgs7xtwv3PA.jpeg" /><figcaption>Credit: <a href="http://qadesigngurus.blogspot.com/2016/05/dev-vs-qa.html">http://qadesigngurus.blogspot.com/2016/05/dev-vs-qa.html</a></figcaption></figure><p>This is when it struck me <em>(at the time I was sitting between the tester and the engineer running the job — o</em>ur tester was using the Azure Portal and the engineer was using the Azure Storage Explorer to download the file. The engineer used the portal and lo and behold the same error occurred.</p><p>Upon further investigation, we noticed that the downloaded files had different sizes, the one from the portal was 5812KB and the storage explorer version was 4491KB. This is really strange, given they are as supposedly binary files, however using different tools to download somehow affects the file.</p><p>We still don’t know why this happened or what other files this could have an effect on. So if you come across this issue, my advice would be to avoid using the Azure Portal, and instead use the Azure Storage Explorer.</p><h4><strong>About the author</strong></h4><p>Eugene is a Senior Data Engineer at ASOS with a passion for Test Driven Development, Agile Methodologies, Continuous Integration and Delivery using Microsoft Azure</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fc10ccabef52" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/it-worked-on-my-machine-fc10ccabef52">It worked on my machine…</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server “TABULAR”]]></title>
            <link>https://medium.com/eugeneniemand/cannot-set-the-initialization-properties-for-ole-db-provider-msolap-for-linked-server-tabular-82be50766efb?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/82be50766efb</guid>
            <category><![CDATA[programming]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Thu, 25 Jun 2015 09:48:30 GMT</pubDate>
            <atom:updated>2018-01-02T14:05:28.768Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Description</strong></h3><p>When querying a SSAS instance using a linked server on a remote server while the same user also have a RDP session (Active/Inactive) to the same remote server using SSMS or any other method for ex SQL Unit Tests this error is produced:</p><pre>OLE DB provider &quot;MSOLAP&quot; for linked server &quot;TABULAR&quot; returned message &quot;The following system error occurred: &quot;.</pre><pre>Msg 7373, Level 16, State 2, Line 1<br>Cannot set the initialization properties for OLE DB provider &quot;MSOLAP&quot; for linked server &quot;TABULAR&quot;.</pre><h3><strong>Microsoft Connect Item</strong></h3><p>Please vote on this connect item if you experience the same <a href="https://connect.microsoft.com/SQLServer/feedback/details/1470258">https://connect.microsoft.com/SQLServer/feedback/details/1470258</a></p><h3><strong>Steps to Reproduce</strong></h3><p>The setup consists of 3 different machines:<br>LOCALHOST (LH)<br>REMOTE SQL SERVER (RSQL)<br>REMOTE SSAS SERVER (RSSAS)</p><p>Ensure that you don’t have a RDP session (active/inactive i.e. disconnected) to RSQL<br>Create Linked Server to RSSAS on RSQL using a domain service account for security context as below</p><pre>exec master.dbo.sp_addlinkedserver @server = N&#39;TABULAR&#39;, @srvproduct=N&#39;&#39;, @provider=N&#39;MSOLAP&#39;, @datasrc=N&#39;RSSAS\tabular_2012&#39;, @catalog=N&#39;GroupDW&#39;<br>exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N&#39;TABULAR&#39;,@useself=N&#39;False&#39;,@locallogin=null,@rmtuser=N&#39;domainX\builduser&#39;,@rmtpassword=&#39;SomePassword&#39;</pre><h4>Scenario 1:</h4><p>Now execute an open query from LH SSMS on RSQL for example:</p><pre>select<br>    *<br>from<br>    openquery (TABULAR, &#39;EVALUATE SUMMARIZE (&#39;&#39;#Loan Process&#39;&#39;, &#39;&#39;~Data Source&#39;&#39;[Source System], &quot;Agreed Final Loan To Income Ratio&quot;,[Agreed Final Loan To Income Ratio])&#39;)</pre><p>You get the results back from SSAS as expected</p><h4>Scenario 2:</h4><p>Login to RSQL via Remote Desktop to create a RDP Session<br>Now execute same query as before</p><pre>OLE DB provider &quot;MSOLAP&quot; for linked server &quot;TABULAR&quot; returned message &quot;The following system error occurred: &quot;.<br>Msg 7373, Level 16, State 2, Line 1<br>Cannot set the initialization properties for OLE DB provider &quot;MSOLAP&quot; for linked server &quot;TABULAR&quot;.</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=82be50766efb" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/cannot-set-the-initialization-properties-for-ole-db-provider-msolap-for-linked-server-tabular-82be50766efb">Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server “TABULAR”</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Vague SSIS error message — SSIS Error Code DTS_E_PROCESSINPUTFAILED]]></title>
            <link>https://medium.com/eugeneniemand/vague-ssis-error-message-ssis-error-code-dts-e-processinputfailed-2431bd090dc6?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/2431bd090dc6</guid>
            <category><![CDATA[programming]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Thu, 02 Oct 2014 07:51:46 GMT</pubDate>
            <atom:updated>2018-01-02T14:05:22.817Z</atom:updated>
            <content:encoded><![CDATA[<p>So today I got the error message below</p><pre>DFT Extract interface_RiskScorecard:Error: System.NullReferenceException: Object reference not set to an instance of an object.<br> at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)<br> at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)<br> at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) <br>DFT Extract interface_RiskScorecard:Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. <br>The ProcessInput method on component &quot;Parse Scorecard Name into properties&quot; (66) <br>failed with error code 0x80004003 while processing input &quot;Input 0&quot; (76). <br>The identified component returned an error from the ProcessInput method. <br>The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. <br>There may be error messages posted before this with more information about the failure.</pre><p>So this happened when I passed some names through RegEx in a script task to split it into different parts. If you look at the error there are some things that stand out:</p><ul><li>NullReferenceException: Object reference not set to an instance of an object.</li><li>Parse Scorecard Name into properties</li><li>Input 0</li></ul><p>Ok, so this sort of points me in the direction of where the error happened, well at least which task caused it. In my script task I’m setting the values of 4 output columns with the results of different RegEx expressions. Now you will notice this error does not point to the line in the code or which function it was. The only thing I had to go by was the “object reference…” message. This led me to looking for working with an object that could potentially be null when I’m trying to manipulate it. Eventually I found it, I was referencing the Length property on a string with a null value in an If Statement, but I did not expect it to be a null value. To fix it, I just had to add “myStrProp != null” to test nullability first before accessing the Length property. This is a very common error in C# programming and easy to fix. I just wish the error messages from SSIS script components gave a better message as to where the error is.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2431bd090dc6" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/vague-ssis-error-message-ssis-error-code-dts-e-processinputfailed-2431bd090dc6">Vague SSIS error message — SSIS Error Code DTS_E_PROCESSINPUTFAILED</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[QlikView — Open, Save, Close a QVW without reloading data using PowerShell]]></title>
            <link>https://medium.com/eugeneniemand/qlikview-open-save-close-a-qvw-without-reloading-data-using-powershell-c8dd920dd00a?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/c8dd920dd00a</guid>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[powershell]]></category>
            <category><![CDATA[qlikview]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Tue, 03 Sep 2013 14:02:09 GMT</pubDate>
            <atom:updated>2018-01-02T14:17:49.932Z</atom:updated>
            <content:encoded><![CDATA[<p>So you can open a QVW file from the command line with one of the following options</p><pre>/r  Reload, save, close.<br>/rp Partial-Reload, save, close.<br>/l  Reload, leave open.<br>/p  Partial-Reload, leave open.<br>/v  Pass variable.</pre><p>None of these options suited me, what I wanted was the following; Open QVW, immediately save it without doing anything i.e. not reloading data, not open script, nothing… then close the file. I was pointed towards the Automation Documentation over here <a href="http://community.qlikview.com/docs/DOC-1793">http://community.qlikview.com/docs/DOC-1793</a> and I was provided with a macro that uses the COM Object in one QVW that opens, saves and closes another QVW. This solved the problem and could be called from the command line.</p><p>I didn’t like this solution as it was a bit hacky… Having one file call another etc etc, and I use PowerShell for the rest of my automation; I figured there has to be a PowerShell solution and came up with the following script:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/f4c0ab9d611bf860bd8a8a58fd302010/href">https://medium.com/media/f4c0ab9d611bf860bd8a8a58fd302010/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c8dd920dd00a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/qlikview-open-save-close-a-qvw-without-reloading-data-using-powershell-c8dd920dd00a">QlikView — Open, Save, Close a QVW without reloading data using PowerShell</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQLPackage and SSDT dropping and recreating items where they already exist and no changes were made]]></title>
            <link>https://medium.com/eugeneniemand/sqlpackage-and-ssdt-dropping-and-recreating-items-where-they-already-exist-and-no-changes-were-made-dab49d9a496d?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/dab49d9a496d</guid>
            <category><![CDATA[sqlpackage]]></category>
            <category><![CDATA[ssdt]]></category>
            <category><![CDATA[certificate]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[programming]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Mon, 29 Jul 2013 10:37:18 GMT</pubDate>
            <atom:updated>2018-01-02T14:05:38.487Z</atom:updated>
            <content:encoded><![CDATA[<p>So I have been struggling for hours trying to figure out why my SQLPackage.exe task thinks it needs drop my Certificates even though I just deployed them and haven’t made any changes. Look at the example below, this is not the SSDT project or output it is only used for illustrating the problem and solution:</p><pre>create certificate [YourCertificateName]<br>authorization [dbo]<br>with <br>  subject = N&#39;Some description about your encryption certificate&#39;<br>  , start_date  = N<strong>&#39;01/01/2012 00:00:00&#39;</strong><br>  , expiry_date = N<strong>&#39;12/31/2050 00:00:00&#39;</strong><br>active for begin_dialog = on;</pre><p>If you run this from SSDT or SQLPackage where you have the above Certificate scripted as part of a Database Project and deploy this more than once you will notice that it is dropping and recreating the Certificate every time. This happens without you making any changes and the object already existing. My colleague <a href="http://sqlblogcasts.com/blogs/simons/">Simon Sabin</a> point out the following “The reason for this is that the dates in the above script aren’t ISO Standard.” This means that if you run a Schema Comparison you will notice the Certificate on the server looks like this:</p><pre>create certificate [YourCertificateName]<br>authorization [dbo]<br>with <br>  subject = N&#39;Some description about your encryption certificate&#39;<br>  , start_date  = N<strong>&#39;2012-01-01T00:00:00&#39;</strong><br>  , expiry_date = N<strong>&#39;2050-12-31T00:00:00&#39;</strong><br>active for begin_dialog = on;</pre><p>When a date is stored as a property or into a Date column it is converted to ISO standards and thus when you script an object using a different format they will look different even though they are the same and cause the object to be dropped and recreated.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dab49d9a496d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/sqlpackage-and-ssdt-dropping-and-recreating-items-where-they-already-exist-and-no-changes-were-made-dab49d9a496d">SQLPackage and SSDT dropping and recreating items where they already exist and no changes were made</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[T-SQL Code Documentor]]></title>
            <link>https://medium.com/eugeneniemand/t-sql-code-documentor-f065f7e7da86?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/f065f7e7da86</guid>
            <category><![CDATA[documentation]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[t-sql]]></category>
            <category><![CDATA[software]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Tue, 11 Jun 2013 16:34:02 GMT</pubDate>
            <atom:updated>2018-01-02T14:05:14.892Z</atom:updated>
            <content:encoded><![CDATA[<p>I recently resigned and was tasked to document all the important stored procedure and triggers. Yes I know this should have been done at the time but we have never had time, or should I rather say it’s never been priority.</p><p>I was deliberating over the different methods possible to document the T-SQL code. Red-Gate has SQL Doc but that only updates extended properties. I thought I could use Word and document what every Stored Proc or Trigger does but that document will be dead in the water. When making changes some of this come to mind… “Oh I need to update the documentation”… “Where is the documentation saved again?”… “Aargh!!! The other guy did not document his changes”. The last two can be mitigated by using source control or versioned docs like Google Docs or Sharepoint etc. and a bit of discipline.</p><p>The worst part is, how do you tie sections of the code to sections of the document?</p><p>Then I thought I can document the code by adding standard T-SQL comments. This makes sense as the documentation then exists inside the code at the exact point where it matters or explains something; this is sometimes referred to as “Living Documentation”.</p><p>Great, this solves my problem. Hold on, not so fast, how do business users easily view the documentation? Yes we can maybe install SSMS and grant them read only privileges but they won’t know what procedures to go look for when something breaks. They can’t search or browse all documentation. Heck, even if they did know the answer to all the above, will they know what for or where in the code to look?</p><p>I figured, I can get the definition of every object from SQL Server. I can then parse the definition text and extract the comments. The comments will need some structure; I can’t simply read all commented text as it will also extract commented code etc. It will just be a mess. I searched for a solution that implements the same documentation methods you find in C#, but I could not find anything simple and easy to use. Also none of the solutions did it the way I wanted to do it.</p><p>I wanted something simple, unrestrictive and easy to use. My only option is to build my own solution it can be found on codeplex <a href="https://tsqlcodedocumentor.codeplex.com/">https://tsqlcodedocumentor.codeplex.com/</a></p><p>Here is a short explanation of what T-SQL Code Documentor does:</p><ul><li>Consumes the supplied Definition text (See MVC Section below)</li><li>Using RegEx search for any text in the HTML/XML format &lt;Tag&gt;Some Text&lt;/Tag&gt;</li><li>Validate that all tags have matching Opening and Closing tags.</li><li>Read the text between the tags and do a bit of scrubbing.</li><li>Return a Markdown formatted string.</li></ul><p>I have a separate MVC project:</p><ul><li>It provides a connection string and reads all the objects (Schema, Name, Type and Definition)</li><li>It then Calls the T-SQL Code Documentor ExtractTagContents method for every object</li><li>Create a Markdown Heading for every Object</li><li>Append the return string from ExtractTagContents</li><li>Return an HtmlString to the View.</li></ul><p>And there you have it, all your database documentation on a web page that always displays the latest version and can easily be consumed by normal business users.</p><p>Here is an example of the comments:</p><figure><img alt="T-SQL Documentation Code" src="https://cdn-images-1.medium.com/max/813/0*z3u43pK5QGLaAu6v.png" /></figure><p>Here is the generated documentation</p><figure><img alt="TSQLDocumentation" src="https://cdn-images-1.medium.com/max/1008/0*l2twGhKMcnGEptjv.png" /></figure><p>I used John Gruber’s Markdown syntax <a href="http://daringfireball.net/projects/markdown/">http://daringfireball.net/projects/markdown/</a></p><p>I used Brian Jeremy’s version of a ported .Net Markdown library to generate the HTML</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/df898ae9544ce51db32029040f3b951c/href">https://medium.com/media/df898ae9544ce51db32029040f3b951c/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f065f7e7da86" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/t-sql-code-documentor-f065f7e7da86">T-SQL Code Documentor</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Go Directly To User Detail on SFDC]]></title>
            <link>https://medium.com/eugeneniemand/go-directly-to-user-detail-on-sfdc-4c92507fa5b0?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/4c92507fa5b0</guid>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[chrome]]></category>
            <category><![CDATA[jquery]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[extension]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Wed, 01 May 2013 07:01:50 GMT</pubDate>
            <atom:updated>2018-01-02T14:05:29.338Z</atom:updated>
            <content:encoded><![CDATA[<p>My wife works as a Salesforce Administrator. When Chatter launched she very quickly became annoyed with the new Chatter profile page that appeared when you clicked on a user’s name.</p><p>She wanted to go to the User Details page instead as this is where all the Admin gets done. She realised that to go to the User Details page all you needed to do was append noredirect=1 to the end of the Url.</p><p>I decided to develop a Chrome Extension to do this automatically for all User Profile links (i.e. Id’s that Start with 005).</p><p><a href="https://chrome.google.com/webstore/detail/go-directly-to-user-detai/jpdmkhlcnjjndfpgljcpmllddeidkdjc?utm_source=eugeneniemand.com">Go Directly To User Detail on SFDC</a></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FJAFzXV4y2FA%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DJAFzXV4y2FA&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FJAFzXV4y2FA%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="640" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/19db55f07ef40ee8281ed485332925f9/href">https://medium.com/media/19db55f07ef40ee8281ed485332925f9/href</a></iframe><p>Please feel free to download. If you have any feedback, bugs or suggestions please leave them on the Chrome Web Store.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4c92507fa5b0" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/go-directly-to-user-detail-on-sfdc-4c92507fa5b0">Go Directly To User Detail on SFDC</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER]]></title>
            <link>https://medium.com/eugeneniemand/ssis-error-code-dts-e-cannotacquireconnectionfromconnectionmanager-b9b69a586d2b?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/b9b69a586d2b</guid>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[ssi]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Fri, 20 Jul 2012 15:22:25 GMT</pubDate>
            <atom:updated>2018-01-02T14:05:14.979Z</atom:updated>
            <content:encoded><![CDATA[<h4>How often have you received the error below?</h4><h4>Error</h4><blockquote>SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Ovott” failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.</blockquote><p>Very helpful, I know… Please excuse the sarcasm. I spent days trying to fix this error as I just installed some database drivers before building a new package. At first I thought it was the drivers, so I removed them. Long story short It cost me Repairing/uninstalling and reinstalling SQL Server 2008 R2 from different images around 9 times before I could get SSIS to open packages again, but this is a whole other story.</p><p>So after getting SSIS working again I thought, hey everything is back to normal. Tried executing the package and to my surprise I was still getting this error.</p><h4>Problem</h4><p>I have to mention that this error only occurs when you execute the package, when you do a preview everything works which makes it even more confusing, but this makes sense as configurations only apply when you execute the package.</p><p>The error was due to using Package Configurations for my Connection Managers incorrectly.</p><p>Here is a preview of the results when I click preview.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*pa1IJ4Dm5iZekevX." /></figure><p>In the the configuration settings you can specify what properties you want to store to the database (or other media). When I initially set it up I checked the parent check box next to the connection which in turn checks all the check boxes below it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*N_mDdSOOdeMjkVbg." /></figure><p>Now this works fine when your connection manager uses Integrated Authentication, however when you are using SQL Authentication and you select all properties it will give you the above mentioned error.</p><p>When you execute the Package/Task this is what it looks like</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/973/0*hn8xD3uY3rQySy4l.png" /></figure><h4>Solution</h4><p>You need to either select connection string by it self or select a combination of Server, User, Password and other properties if required but don’t select connection string. When selecting all the properties I think they somehow cause a conflict and cause the above error. Here are two solutions:<br>Option 1 Connection String</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*nZbsioemqlJ40PDN." /></figure><p>Option 2 Multiple Properties</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*ab2YdacEpVbkOVJj." /></figure><p>After using any of these 2 solutions the package executes fine</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/790/0*DrjlRRPQWht4-qwj.png" /></figure><p>I Hope this helps and saves someone a bit of time…</p><p>Happy Coding</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b9b69a586d2b" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/ssis-error-code-dts-e-cannotacquireconnectionfromconnectionmanager-b9b69a586d2b">SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Warning: Could not open global shared memory to communicate with performance DLL]]></title>
            <link>https://medium.com/eugeneniemand/warning-could-not-open-global-shared-memory-to-communicate-with-performance-dll-954f2ce82516?source=rss----bb73f1ae5b5---4</link>
            <guid isPermaLink="false">https://medium.com/p/954f2ce82516</guid>
            <category><![CDATA[programming]]></category>
            <dc:creator><![CDATA[Eugene Niemand]]></dc:creator>
            <pubDate>Fri, 11 May 2012 11:20:52 GMT</pubDate>
            <atom:updated>2018-01-02T14:05:26.479Z</atom:updated>
            <content:encoded><![CDATA[<p>Today I was busy with SSIS and came across this error</p><pre>Warning: Could not open global shared memory to communicate with performance DLL;</pre><p>So how did this happen? I had a Data Flow Task with a OLE DB Source and an OLE DB Destination. In the source I executed a stored proc like this:</p><pre>EXEC [ExpandAccountDivision] @AccountId = ?</pre><p>I mapped the parameter to the appropriate variable and everything worked fine. Next I made a copy of the DFT and tried running it again, the initial DFT worked and the copied one failed and got the above error. I tried building, rebuilding, removing/re-adding the Data Flow Paths nothing seemed to work. Eventually I thought lets try changing the copy to run it without the parameter. Hey presto it worked, which lead me to the fact theirs a problem with the Parameter Mapping.</p><p>So I reverted back to using the parameter in the Command and checked the Parameter Mapping. What do you know, SSIS copied the DFT no problems, validated and built the package without a problem. But at runtime it gave this very misleading error, which was <strong>caused by SSIS not copying across the Parameter Mapping.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=954f2ce82516" width="1" height="1" alt=""><hr><p><a href="https://medium.com/eugeneniemand/warning-could-not-open-global-shared-memory-to-communicate-with-performance-dll-954f2ce82516">Warning: Could not open global shared memory to communicate with performance DLL</a> was originally published in <a href="https://medium.com/eugeneniemand">Eugene Niemand’s Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>