Eric Moreau's web site (www.emoreau.com)http://www.emoreau.com/Rss/Rss.aspxThe latest headlines and articles from the world of www.emoreau.com(c) 2006-2014, emoreau.com, All rights reserved.5SQL Pivot Tips and Tricks<p>
In the last few weeks, I have been busy creating a complex report for a client. The output itself is in Excel so he can continue the analysis by slicing and dicing the data even further then what I am providing.
</p>
<p>
To be able to provide data in an appropriate format, I needed to rely heavily of SQL Pivots. You can find a definition of pivot tables on <a href="https://en.wikipedia.org/wiki/Pivot_table">WikiPedia</a>.
</p>
<p>
This month article is about some tricks I needed to figure out to render the data.
</p>
http://www.emoreau.com/Entries/Articles/2018/02/SQL-Pivot-Tips-and-Tricks.aspxTue, 20 Feb 2018 00:00:00 GMTNew article: SQL Pivot Tips and Tricks<p>
In the last few weeks, I have been busy creating a complex report for a client. The output itself is in Excel so he can continue the analysis by slicing and dicing the data even further then what I am providing.
</p>
<p>
To be able to provide data in an appropriate format, I needed to rely heavily of SQL Pivots. You can find a definition of pivot tables on <a href="https://en.wikipedia.org/wiki/Pivot_table">WikiPedia</a>.
</p>
<p>
This month article is about some tricks I needed to figure out to render the data.
</p>
<p>This article can be read from <a href="http://emoreau.com/Entries/Articles/2018/02/SQL-Pivot-Tips-and-Tricks.aspx">http://emoreau.com/Entries/Articles/2018/02/SQL-Pivot-Tips-and-Tricks.aspx</a></p>
http://www.emoreau.com/Entries/Blogs/2018/02/New-article-SQL-Pivot-Tips-and-Tricks.aspxTue, 20 Feb 2018 00:00:00 GMTInstrumenting Windows application using Application Insights<p>
Instrumenting applications have always been something useful for developers to find out which parts of their applications (and those that are not). But too often, that kind of feature that does not really bring tangible benefits to users is left aside and never implemented.
</p>
<p>
Microsoft has made available a very simple mechanism that will let you start instrumenting your application. This mechanism is available to any application running on a computer connected to the Internet. It is not reserved to Web applications.
</p>
<p>
All you need is an application and an Azure account.
</p>
http://www.emoreau.com/Entries/Articles/2018/01/Instrumenting-Windows-application-using-Application-Insights.aspxSun, 28 Jan 2018 00:00:00 GMTNew article: Instrumenting Windows application using Application Insights<p>
Instrumenting applications have always been something useful for developers to find out which parts of their applications (and those that are not). But too often, that kind of feature that does not really bring tangible benefits to users is left aside and never implemented.
</p>
<p>
Microsoft has made available a very simple mechanism that will let you start instrumenting your application. This mechanism is available to any application running on a computer connected to the Internet. It is not reserved to Web applications.
</p>
<p>
All you need is an application and an Azure account.
</p>
<p>This application is available at <a href="http://emoreau.com/Entries/Articles/2018/01/Instrumenting-Windows-application-using-Application-Insights.aspx">http://emoreau.com/Entries/Articles/2018/01/Instrumenting-Windows-application-using-Application-Insights.aspx</a></p>
http://www.emoreau.com/Entries/Blogs/2018/01/New-article-Instrumenting-Windows-application-using-Application-Insights.aspxSun, 28 Jan 2018 00:00:00 GMTCreating an Add-In for Outlook in .Net<p>
Outlook is a great tool, I love it. My life is in there! But there is one feature that used to be provided 10 years ago which is not available anymore. That feature is a possibility of showing appointments from multiple calendars into the Calendar pane. I have, surely like most of you, many email addresses provided by my clients, each mailbox having a distinct calendar. I know you can get a combined view in the calendar view but not in the Calendar pane which is sitting right next to your list of emails, always visible. I missed that feature a lot until I found some code (developed for an older version of Visual Studio and Outlook) which was not working so great for my needs.
</p>
<p class="Figure" style="text-align: center;">Figure 1: Toggling on/off the main Calendar pane
<br>
</br>
<br>
</br>
<img alt="" src="/Entries/Articles/2017/12/EricMoreau1.png"></img>
</p>
<p>
This article will show you how to create your own add-on to display your appointments from multiple calendars into a pane of Outlook 2017.
</p>
http://www.emoreau.com/Entries/Articles/2017/12/Creating-an-Add-In-for-Outlook-in-Net.aspxThu, 21 Dec 2017 00:00:00 GMTNew article: Creating an Add-In for Outlook in .Net<p>I just published a new article just before Christmas and year end! This article will show you how to create your own add-on to display your appointments from multiple calendars into a pane of Outlook 2017.</p>
<p>You can read it from <a href="http://emoreau.com/Entries/Articles/2017/12/Creating-an-Add-In-for-Outlook-in-Net.aspx">http://emoreau.com/Entries/Articles/2017/12/Creating-an-Add-In-for-Outlook-in-Net.aspx</a>.</p>
<p>
Outlook is a great tool, I love it. My life is in there! But there is one feature that used to be provided 10 years ago which is not available anymore. That feature is a possibility of showing appointments from multiple calendars into the Calendar pane. I have, surely like most of you, many email addresses provided by my clients, each mailbox having a distinct calendar. I know you can get a combined view in the calendar view but not in the Calendar pane which is sitting right next to your list of emails, always visible. I missed that feature a lot until I found some code (developed for an older version of Visual Studio and Outlook) which was not working so great for my needs.
</p>
<p class="Figure" style="text-align: center;">Figure 1: Toggling on/off the main Calendar pane
<br>
</br>
<img alt="" src="/Entries/Articles/2017/12/EricMoreau1.png"></img>
</p>
http://www.emoreau.com/Entries/Blogs/2017/12/New-article-Creating-an-Add-In-for-Outlook-in-Net.aspxThu, 21 Dec 2017 00:00:00 GMTVisual Studio 2017 crashes with an exception on PenIMC<p>I haven't used Visual Studio for the last few days and this morning without any particular reason (other than Windows Updates!), it keeps crashing on me in a very simple project.</p>
<p>The event viewer is showing that the faulting module is PenlMC2_v0400.dll. Notice that even if the exception is showing WPF, I am building (yet again) a simple Windows Forms project. It is probably Visual Studio itself (which is a WPF application) that has the issue.</p>
<p><img alt="" src="/images/PenlMCException.png" /></p>
<p>It appears that this exception is not new and comes back every so often. I have been able to fix my issue (so far) using the option B from the solution explained on <a href="https://developercommunity.visualstudio.com/content/problem/55303/visual-studio-may-terminate-unexpectedly-when-runn.html">https://developercommunity.visualstudio.com/content/problem/55303/visual-studio-may-terminate-unexpectedly-when-runn.html</a>. </p>
http://www.emoreau.com/Entries/Blogs/2017/11/Visual-Studio-2017-crashes-with-an-exception-on-PenIMC.aspxSun, 26 Nov 2017 00:00:00 GMTWatermark in Windows Forms<p>
I really hate when HTML forms shows the label into the edit controls without any labels. It is frustrating when you have tools that automatically fill controls but once filled you don’t know if the right information has been set to the correct control. Without a label, you don’t know if the first name field is filled correctly!
</p>
<p>
But after this rant, this feature of showing a watermark is very useful to display additional information like the format or a mandatory indicator or … Lately, I found out that it was easy to add that kind of watermark to some Windows Forms controls. This article shows how to add watermark to Textbox and Combobox controls.
</p>
<p class="Figure" style="text-align: center;">Figure 1: The demo application in action
<br/>
<img alt="" src="/Entries/Articles/2017/11/EricMoreau1.png"></img>
</p>
http://www.emoreau.com/Entries/Articles/2017/11/Watermark-in-Windows-Forms.aspxSun, 26 Nov 2017 00:00:00 GMTNew Article: Watermark in Windows Forms<p>
I really hate when HTML forms shows the label into the edit controls without any labels. It is frustrating when you have tools that automatically fill controls but once filled you don’t know if the right information has been set to the correct control. Without a label, you don’t know if the first name field is filled correctly!
</p>
<p>
But after this rant, this feature of showing a watermark is very useful to display additional information like the format or a mandatory indicator or … Lately, I found out that it was easy to add that kind of watermark to some Windows Forms controls. This article shows how to add watermark to Textbox and Combobox controls.
</p>
<p class="Figure" style="text-align: center;">Figure 1: The demo application in action
<br>
</br>
<img alt="" src="/Entries/Articles/2017/11/EricMoreau1.png"></img>
</p>
<p>
This article can be read from <a href="http://emoreau.com/Entries/Articles/2017/11/Watermark-in-Windows-Forms.aspx">http://emoreau.com/Entries/Articles/2017/11/Watermark-in-Windows-Forms.aspx</a>
</p>
http://www.emoreau.com/Entries/Blogs/2017/11/New-Article-Watermark-in-Windows-Forms.aspxSun, 26 Nov 2017 00:00:00 GMTReading Security events from the Event logs<p>
One of my clients now has to comply to many rules because he registered to the <a href="https://www.sec.gov/">U.S. Securities and Exchange Commission (aka, the SEC)</a>.
</p>
<p>
The SEC is “proposing” many rules regarding the cybersecurity. One of the rule is to monitor Active Directory changes (user created, user deleted, group created, …). All those changes are logged into the Events Logs but my main problem is that those events are flooded between all other events I don’t really care about (like logon successfully). Another problem I have is that the log has a limited size (about 3 days in my case) so I would have to sit tight in front of the server! I know there are tools around but the one I found are quite expensive.
</p>
<p>
While working on that project, I found out that every one of you should probably have some interest for those events. With all the hacking happening today, it should be a good habit for many people to have a look at them.
</p>
http://www.emoreau.com/Entries/Articles/2017/10/Reading-Security-events-from-the-Event-logs.aspxMon, 30 Oct 2017 00:00:00 GMT