The most requested feature I receive from reader is to show C# code directly in the article. I thought of switching all the code to C# but I still have a great number of VB readers.
I finally took some time to create tabs to show both VB and C# code on article.
Hope you will like it.
10 years ago, I wrote 2 articles about Crystal Reports for .Net (Feeding Crystal Reports from your application and Crystal Reports – Part II). At that time, it was for the Universal Thread magazine which has stopped publishing since then but I never stopped.
Without any doubt, these 2 articles have been in the top 5 of my most visited and they are still today attracting readers even after 10 long years. Since I continue to receive questions about the use of CR in .Net, I decided to revisit that topic.
You can read the new revamped article from http://www.emoreau.com/Entries/Articles/2016/10/Crystal-Reports-for-Net-revisited-10-years-later.aspx
Have you ever used LightSwitch? It is a tool proposed by Microsoft targeting power users/business analyst but not developers.
Well, if you never used it, be aware that the product is not officially dead (but still supported until October 2020) as announced at https://blogs.msdn.microsoft.com/lightswitch/2016/10/14/lightswitch-update/.
The same post is pushing on a newer tool named PowerApps (https://powerapps.microsoft.com/en-us/). Will you take the chance?
I just published an article that is revisiting one I wrote back in February 2008 showing how to create a wiki-like help system.
Since 2008, I have implemented that feature in most applications because the user can really customize the documentation to fit their needs. The system has proven to be useful in many occasion.
Not only users are more than happy to be able create and improve the help by themselves, they have also asked for some improvements. These required are the same as those listed in the “Extending this system” section of the 2008 article. I have seen them coming! One of the improvements is the ability to be able to jump from one topic to another (this is why I have a listbox control on the left of the screen). Lately, a customer also asked me to generate a Word document containing all the topics from the wiki system.
That last request will be subject of this article.
You can read it from http://emoreau.com/Entries/Articles/2016/09/Wiki-revisited--Generating-a-Word-document.aspx
I just published a new article about a very recurrent question in forums: how can I persist my forms settings (location and size and state) to restore them at the same place when the application restart?
I have seen this question so many. I decided to write something that will answer some of the issues and fill some caveats of answers I found.
You can read this article from http://emoreau.com/Entries/Articles/2016/08/Persisting-screen-settings-in-a-Net-application.aspx
For those of you waiting for the first set of fixes before installing a new version of SQL Server, a Cumulative Update has been released today.
It is available from https://support.microsoft.com/en-us/kb/3164674 and fixes many glitches.
I just published my July article.
Following my last month article on the new Native JSON support feature of SQL Server, I decided to continue the exploration of another new feature of SQL 2016.
This month, it will be about Temporal tables. This feature is also sometime referred to as a system-versioned table.
I am not a big fan of this first iteration of that feature, I would have like to get the application-period temporal tables but apparently it was left for another version.
You can read it from http://emoreau.com/Entries/Articles/2016/07/Microsoft-SQL-Server-2016-Temporal-tables-features.aspx
I still write VB code on (almost) a daily basis for one of my client. One thing that irritates me is that the "Pretty Listing" feature always turns off every so often probably because of some conflicts with other tools.
I just found a tool that will hopefully fix my issue: https://visualstudiogallery.msdn.microsoft.com/47db893a-b50a-4267-8866-9f3fd4ff2dac
Last Friday, I have received an email from Microsoft announcing that they are renewing my MVP title for the 13th year:
Congratulations!We are pleased to present you with the 2016 Microsoft® MVP Award! This award isgiven to exceptional technical community leaders who actively share their highquality, real world expertise with others. We appreciate your outstandingcontributions in Visual Studio and Development Technologies technicalcommunities during the past year.
They have once again changed my area of expertise because they are revamping the MVP program.
The title says it (almost) all.
I have seen thins behavior many times where a stored procedure had a correct performance when executed from SSMS but ran poorly when executed from an application.
There can be many reasons. The ArithAbort setting can be one reason as shown in https://www.mssqltips.com/sqlservertip/4318/sql-server-stored-procedure-runs-fast-in-ssms-and-slow-in-application/. But there are many more reasons as explained in http://www.sommarskog.se/query-plan-mysteries.html