Category Archives: Cloud

SQL Server Analysis Services SSAS Getting Started Resources

This post guides you how to get started with SQL Server Analysis Services, SSAS. This is the path to Multidimensional Modeling. Install SQL Server Analysis Services https://docs.microsoft.com/en-us/analysis-services/instances/install-windows/install-analysis-services?WT.mc_id=DP-MVP-36769 Analysis Services tutorials https://docs.microsoft.com/en-us/analysis-services/analysis-services-tutorials-ssas?WT.mc_id=DP-MVP-36769 Install sample data and multidimensional projects https://docs.microsoft.com/en-us/analysis-services/multidimensional-tutorial/install-sample-data-and-projects?WT.mc_id=DP-MVP-36769 Multidimensional Modeling … Continue reading

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

Multiple databases vs single database for single application

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

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

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

SharePoint client object model (CSOM) getting started

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

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