Comparing the differences between two folders in Windows

This post shows you one of the way to compare between two folders. I have 2 folders,

I didn’t want to update the file that already existed but finding the files that did not exist as one side or another. I have downloaded the FreeFileSunc, https://freefilesync.org/, then compare the 2 folders. What I was look at is either

or

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

Azure Data Studio vs SQL Server Management Studio part 2

This post continue to look at the differences between Azure Data Studio and SQL Server Management Studio. When you want to change the connection in query pane of SSMS you need to right click then choose Connection.


This is more convenient in ADS. The connection is on top of the query pane.


Azure Data Studio new feature Snippet is not in SSMS.


I do not find a New Query button in Azure Data Studio. In SSMS to start a new query I click on the button.


In Azure Data Studio, I only found that under the File menu.

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | 1 Comment

Azure Data Studio vs SQL Server Management Studio part 1

This post shows you some differences between Azure Data Studio and SQL Server Management Studio. From the market you will hear ADS is going to replace SSMS, maybe not now because many features in SSMS is not available in ADS yet.

There are so good points in ADS.

1. ADS can see the database on the first page.


2. ADS will open the last file that you were using when the program starts.


3. ADS will highlight the whole row when it is selected but not SSMS.


4. In SQL Server Management Studio you can have Intellisense. ADS will have intellisense but you need to select the database on top and not at the right side.


When you right click on the database in ADS there is nothing much you can do.


As compare to SSMS.


From here you can bet SSMS will still be around longer. I will continue to compare them later.

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 1 Comment

SharePoint Approval every time user edit the document in Document Library

This short post shows you where to set the versioning so that the user must check out the document if they want to edit. Once they check in then they document needs to be approved.

Go to Library Settings on your Document Library.


Choose Versioning Settings.


Choose Yes under Require content approval for submitted items?

Choose Require document to be checked out before they can be edited? To Yes.


User need to Check Out and Check In when editing the document.


The Document Library owner can approve the document checked in,


By choosing Approved to approve the version
every time someone edits a document.

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

ORA-01847 day of month must be between 1 and last day of month

This post is just showing you the workaround and not really a full solution If you still having what we are running Oracle 9i. You may have this below issue when you are connecting through Oracle 11g client using ODBC. I am running 64 bit Windows Server 2012 R2 and actually have VBA running in 32 bit Excel.

ORA-01847 day of month must be between 1 and last day of month“.

When I reconfigure the ODBC using Microsoft ODBC for Oracle I got another error below.

“ORA-12154 TNS could not resolve the content identifier specified”


I installed a 32 bit Windows 7 and 32 bit Office 2013 with ODBC Microsoft ODBC for Oracle somehow without changing anything the VBA works.

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

AdventureWorks database sample 2012 to 2017

This post just give you links to the most desirable database samples, AdventureWorks. The official Microsoft link is this one. The link will be out of my control because it have been keep changing over the years.

https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

The unofficial link below, as long as Microsoft does not remove my one drive account then you will still have it.

https://1drv.ms/f/s!AlUZkNIm6J4hhBqwRgDuTu_v6J9h

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

ASP.NET Web Forms resources

This post shows you where can you still get the ASP.NET Web Forms resources such as tutorials and samples. Especially the samples that can access to MS SQL Server database for production.

Despite Microsoft keep wanting people to develop the application to cross platform such as Linux and pushing people to use .NET Core with MVC. But how many people don’t want Windows Server anymore and using linux server? Or Microsoft don’t have confidence in their on Windows Server against Linux? Even some people are using linux servers, should Microsoft enhancing the great the only WYSIWYG (What You See Is What you Get) development environment in the world or asking people to code in blind.

Now a day, ASP.NET has removed ASP.NET Web Forms resources, so many reliable resources that MVC still don’t have, from ASP.NET main page. If you are a dinosaur like me who are dwelling in the rapid enterprise development environment then do go to the link below.

https://docs.microsoft.com/en-us/aspnet/web-forms/

Hope Microsoft Visual Studio team will not remove the last surviving link for Web Forms.

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