Author Archives: chanmingman

About chanmingman

Since March 2011 Microsoft Live Spaces migrated to Wordpress (http://www.pcworld.com/article/206455/Microsoft_Live_Spaces_Moves_to_WordPress_An_FAQ.html) till now, I have is over 1 million viewers. This blog is about more than 50% telling you how to resolve error messages, especial for Microsoft products. The blog also has a lot of guidance teaching you how to get stated certain Microsoft technologies. The blog also uses as a help to keep my memory. The blog is never meant to give people consulting services or silver bullet solutions. It is a contribution to the community. Thanks for your support over the years. Ming Man is Microsoft MVP since year 2006. He is a software development manager for a multinational company. With 25 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He has been using Visual Studio (.NET) since the Beta back in year 2000. He and the team have developed many projects using .NET platform such as SCM, and HR based applications. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.

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

SharePoint get full file path

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

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

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

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

SSIS Remove Time from Datatime

This blog shows you how to remove time from SQL Server source with Datetime column. The pre-requisite is you need to have basic knowledge on SSIS. You can see from the picture below. I have a column from SQL Server … Continue reading

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

SSIS Getting Started Resources

SSIS is still once of the best integration tool in the market, https://www.gartner.com/reviews/market/data-integration-tools. Below has some resources you can utilize on. Getting started https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-2017/?WT.mc_id=DP-MVP-36769 Install SSDT https://docs.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-2017/?WT.mc_id=DP-MVP-36769 Integration Services (SSIS) Tutorials https://docs.microsoft.com/en-us/sql/integration-services/lesson-1-create-a-project-and-basic-package-with-ssis?view=sql-server-2017/?WT.mc_id=DP-MVP-36769

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