Monthly Archives: October 2019

Multiple databases vs single database for single application

Posted on October 28, 2019 by chanmingman

I have been discussing this many times with a friend. They are people that working in a company for 17 years never ever created a system and like to teach people how to design databases for system. For the topic … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

10 Things I learnt deploying Office 365

Posted on October 28, 2019 by chanmingman

Many Office 365 projects delayed because they have been facing the same challenges as below. 1. Active Directory Domain Controller not synchronizing 2. The version of your exchange server 3. Test your environment (application) 4. Test your environment (infra) 5. … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Office 365, sharepoint | Tagged , , | Leave a comment

What’s new in C# 8.0

Posted on October 28, 2019 by chanmingman

This post just gives you another way to know what’s new in C# 8.0. https://docs.microsoft.com/en-us/dotnet/csharp/whats-new/csharp-8#disposable-ref-structs?WT.mc_id=DP-MVP-36769 In the page you have code snippet like public readonly override string ToString() => $”({X}, {Y}) is {Distance} from the origin”; The document should show … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

NetBeans 11 create Java project without Maven

Posted on October 28, 2019 by chanmingman

When you want to create a Java SE project in NetBeans 8, you see Java -> Java Application. A straightforward way. Many people are lost when come to NetBeans 11. In NetBeans 11 you choose Java with ant -> Java … Continue reading →

Posted in Computers and Internet, Java | Tagged | Leave a comment

SharePoint client object model (CSOM) getting started

Posted on October 27, 2019 by chanmingman

Below are the resources for C# developer to connect to SharePoint. Complete basic operations using SharePoint client library code https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-client-library-code?WT.mc_id=DP-MVP-36769 SharePoint .NET Server, CSOM, JSOM, and REST API index https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/sharepoint-net-server-csom-jsom-and-rest-api-index?WT.mc_id=DP-MVP-36769 SharePoint site theming: CSOM development https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-theming/sharepoint-site-theming-csom?WT.mc_id=DP-MVP-36769 Using the Client Object … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Office 365, sharepoint | Tagged , , | Leave a comment

SQL Server System Dynamic Management Views

Posted on October 19, 2019 by chanmingman

System Dynamic Management Views https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 Returns size and fragmentation information for the data and indexes of the specified table or view in SQL Server, sys.dm_db_index_physical_stats. https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 Returns information about all the waits encountered by threads that executed, sys.dm_os_wait_stats. https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 Returns … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SharePoint get full file path

Posted on October 16, 2019 by chanmingman

This post shows you how to get the full file path. In order to do that you need to add Document Location in Quick Access area on top of your Office App. Follow the video below to add the Document … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged | Leave a comment

Azure SQL Database

Posted on October 10, 2019 by chanmingman

You can get started with SQL Azure here. Azure SQL Database documentation https://docs.microsoft.com/en-us/azure/sql-database/?WT.mc_id=DP-MVP-36769 What is Azure SQL Data Warehouse? https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is/?WT.mc_id=DP-MVP-36769 Cheat sheet for Azure SQL Data Warehouse https://docs.microsoft.com/en-us/azure/sql-data-warehouse/cheat-sheet/?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

C# getting started

Posted on October 6, 2019 by chanmingman

To ask wherever ask me “how do I start with C#” .NET Documentation https://docs.microsoft.com/en-us/dotnet/?WT.mc_id=DP-MVP-36769 C# Guide https://docs.microsoft.com/en-us/dotnet/csharp/?WT.mc_id=DP-MVP-36769 Get started with C# https://docs.microsoft.com/en-us/dotnet/csharp/getting-started/?WT.mc_id=DP-MVP-36769 A Tour of the C# Language https://docs.microsoft.com/en-us/dotnet/csharp/tour-of-csharp/?WT.mc_id=DP-MVP-36769 C# Reference https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet | Tagged | Leave a comment

using Microsoft.Office.Interop.Excel object cannot be deleted

Posted on October 5, 2019 by chanmingman

This post shows you how to dispose and get rid the object when you exit the application. Previously in https://chanmingman.wordpress.com/2017/11/06/convert-excel-sheet-to-csv-file/. The application exited but the Excel object still exist. You have to implement IDisposable to get rid of the unmanaged … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment