Alok Notes

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

Introduction :- Passwordless authentication is a type of authentication where users do not need to login with passwords. This form of authentication totally makes passwords obsolete. With this form of authentication, users are presented with the options of either logging in simply via a magic link, fingerprint, or using a token that is delivered via email or text message. Case Study :- Over the years, cases of stolen and hacked passwords have been on the rise. So many cases, such as the Yahoo data breach, Dropbox user accounts leak, and LinkedIn Data Breach, had to do with having several passwords leaked. With these challenges staring down at us like a monster, what if there are no more passwords to be hacked? What if there are no more passwords for users to remember? What if we discard the use of passwords totally? Passwordless authentication to the rescue! Benefits:- Improve User Experience:- The faster users can sign up and use your service, the more users your app ten