I just published my latest article. And oh surprised, I will show you some PowerShell this month!
A client of mine finally switched to Office 365 last month. They started to have recurring issues with their old on premise Exchange server and going to Office 365 was a no-brainer decision.
On the previous server, because space was tight, I had a script running weekly showing the usage of all users’ mailboxes to discover who was using all the precious space. That script was built for Exchange Server 2010 and was not compatible with Office 365.
Now with the standard 50 gb of total space for each user, they have plenty of space but managers are still interested in getting statistics about the space used in Office 365 and the licensing.
When I started to look around for samples, I found snippets here and there but none were giving me all the client wanted. I found that I needed to mix many of them in order to get various pieces of information.
For example, Get-Mailbox returns a list of the mailboxes in your tenant but we need to call Get-MailboxStatistics to get the total size of an account. but I later discovered that this size does include much more than just emails (so it was a bit different from I expected). If we want a break that value down, we need to call Get-MailboxFolderStatistics to get more granular information like the number and size of emails, calendar items, and contacts. Lastly, if we are interested in licensing information, we need to call Get-MsolUser.
This current article is clearly not a full tutorial on how to use PowerShell as I am not an expert in that domain. It is the result of my experiments trying to produce some statistics putting together snippets that were working separately but not when combined all together.
You can read this article from http://emoreau.com/Entries/Articles/2016/11/PowerShell-Get-O365-mailboxes-statistics.aspx
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.