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.
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.
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.
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.
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.
The unofficial link below, as long as Microsoft does not remove my one drive account then you will still have it.
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.
Hope Microsoft Visual Studio team will not remove the last surviving link for Web Forms.