Alok Notes

There are couple of cases might be possible for this issue.One of the approach to overcome from this issue is ,Too generate script using SQL SERVER >Task>Generate Script... Wizard and selection of correct target database. If you are generating script from SQL SERVER 2017 which to be compatible with SQL SERVER 2014 then make sure that in Advanced Scripting Options for Script for Server Version SQL SERVER 2014 by default it sets SQL SERVER 2017. Images of Script for Server Version in SQL SERVER 2014 and 2017 Script file generated for Script for Server Version 2014 and Script for Server Version 2017

Benefits:- # Easy stored procedure debugging. # Each database object (table,view,function,type,stored procedure) treat as an individual file. # On Single click get change history of any database object. # This approach is considered best practice for database development and distribution using CI/CD as it generates *.dll,*.dacpac,*.sql). # Direct deployment of updated objects on any SQL SERVER target platform including Azure. # Single IDE(Integrated development environment) database application development using .NET and SQL Server. # Version control of each database object(table,view,function,type,stored procedure).

Transform your hand-drawn wireframes into digital design files and front-end code(HTML,CSS,XAML) – automatically by using UIZARD Youtube :- https://youtu.be/05uu4fppjmU Source :- https://uizard.io/

SQL Server database objects migration was not so easy earlier as of now with the help of DMA(Data Migration Assistant). The Data Migration Assistant (DMA) which is a free tool from Microsoft. DMA helps us to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. The DMA assessment workflow detects Migration blocking issues,Partially supported or unsupported features,compatibility issues (Breaking changes,Behavior changes,Deprecated features) and suggests feature recommendations(Performance,Security,Storage). References :- https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017 https://channel9.msdn.com/Shows/Data-Exposed/First-Look-at-the-new-SQ

What is Silent Installation? A silent install is the installation of a software program that requires no user interaction. It is a convenient way to streamline the installation process of a desktop application. In a non-silent or "attended installation," the user is prompted to select or confirm these options during the installation process. In a silent install, these items are selected automatically and the installer runs from start to finish without requiring any user input. How to create a custom installer that silently installs a ClickOnce application In your ClickOnce application, add references to System.Deployment and System.Windows.Forms.  Add a new class to your application and specify any name. This walkthrough uses the name MyInstaller.  Add the following Imports or using statements to the top of your new class.  Add the following(see the attached images of MyInstaller.cs) methods to your class. MyInstaller -1 MyInstaller -2 EventVi

ClickOnce Technology is Windows application publishing technology which can be used for any Windows Presentation Foundation (.xbap), Windows Forms (.exe), console application (.exe), or Office solution (.dll). Applications which is published using ClickOnce technology is called ClickOnce application. ClickOnce applications can be self-updating; they can check for newer versions as they become available and automatically replace any updated files. The developer can specify the update behavior; a network administrator can also control update strategies for example, marking an update as mandatory. Updates can also be rolled back to an earlier version by the end user or by an administrator. ClickOnce applications are self-contained; each ClickOnce application is installed to and run from a secure per-user, per-application cache. ClickOnce applications run in the Internet or Intranet security zones. If necessary, the application can request elevated security permission

Technologies cluster together into related ecosystems that tend to be used by the same developers. In this chart we see a large central cluster for web development (with JavaScript, HTML, and CSS) connected via SQL to one for Microsoft technologies (with C#, Visual Studio, and .NET Core). Along the left we see a constellation connecting Java, Android, and iOS across to Linux, bash/shell, and Python. Other smaller correlated clusters include Scala/Spark, C/C++, and other smaller technologies that include language-specific IDEs. Source:- stackoverflow.com