Skip to main content

Posts

Showing posts from January, 2023

The Ultimate Guide to SQL Server Version Upgradation for Cloud Applications (2025)

  The Ultimate Guide to SQL Server Version Upgradation for Cloud Applications (2025) Upgrading your SQL Server version is no longer just a routine maintenance task—it's a strategic move that impacts performance , security , and cloud compatibility . Whether you're modernizing legacy systems or preparing your application for cloud migration , using the right SQL Server version is critical. In this blog, we’ll explore: Why upgrading SQL Server matters in 2025 Benefits of new SQL versions for cloud use Best SQL Server versions for cloud-based applications Real-world examples Tools & steps for smooth upgradation Image explanation External references for further reading Why SQL Server Version Upgrade Is Important in 2025 Security Compliance Older versions like SQL Server 2012 or 2014 are out of support , leaving you vulnerable to threats. Performance Gains New versions include intelligent query processing , in-memory database support , and fa...

Model binding in angular template driven forms

  Model binding in angular template driven forms This article will help you understand how model binding works in Angular Template Driven Forms. Forms are a common way to get data into your Angular app and the easiest way to do this is with template driven forms. Model binding occurs when we create a class that has a component, or template associated with it. The component is responsible for displaying the form and handling user input while the model is responsible for processing that input into an object. • • • • • #angular #javascript #programming #coding #developer #html #css #code #programmer #webdeveloper #webdevelopment #coder #frontend #nodejs #reactjs #webdesign #java #react #python #php #development #dev #codinglife #web #softwaredeveloper #software #vuejs #developers #webdeveloper

Blazor Hybrid development requirements

Blazor Hybrid development requirements Blazor is a framework that allows developers to create desktop applications running in the cloud with HTML and C#. Blazor development requirements include a browser that supports WebRTC’s JavaScript APIs, as well as Microsoft Visual Studio to write the client application. The Blazor Hybrid development requirements are very straight forward and easy to understand, with a clear example below. A Blazor hybrid application is a single page web application that runs in the browser or as a desktop application. It uses the Web Assembly framework to execute code as JavaScript and machine code, so it can be deployed on both platforms. Blazor, which provides a Cross-Device WebAssembly runtime for .Net using the Microsoft Edge rendering engine, enables developers to bring their existing .NET code to .Net on WebAssembly and run it on devices equipped with the Microsoft Edge browser.

Windows Presentation Foundation introduction and uses??

 Windows Presentation Foundation (WPF) is a set of technologies that provide an object-oriented, designer-driven foundation for delivering rich, dynamic user interfaces. Windows Presentation Foundation (WPF) is an interface designed to build applications that run on top of the Windows operating system. It provides common controls such as buttons, lists, text boxes, and graphics, as well as integrated support for vector drawing and animation Windows Presentation Foundation is a component framework that provides a common programming model for building user interfaces (UI) and presenting data. WCF provides a uniform programming model for authoring the UI, data binding, and motion graphics in both Windows Forms and Windows Presentation Foundation application segments. Windows Presentation Foundation (WPF) is a complete, object-oriented API that makes it easy to build attractive, interactive user interfaces in XAML. Applications written using WPF are declarative, so they are defined onc...

What's Coming for Blazor Hybrid in .NET 7

 What's Coming for Blazor Hybrid in .NET 7 Blazor Hybrid apps are native apps that can leverage web technologies like HTML and CSS for additional functionality. A hybrid app might use an embedded WebView control to render web UI while also leveraging native device capabilities, as explained in last month's Visual Studio Magazine article "Edit Local Images/Text from a .NET MAUI Blazor Hybrid App." Blazor (web) has been around since 2018 in both client-side and server-side components, the new support for building cross-platform hybrid desktop apps using .NET MAUI and Blazor arrived with .NET 6 last November. Microsoft's announcement at Build 2019 that their ASP.NET Core technologies will soon support building Blazor apps on Windows tablets and phones is a big step forward for developers who want to deliver content across the device space. This month's edition of Visual Studio Magazine dives into the future of .NET app development with a series of articles coveri...

Use merge function in ms sql databases !!

 If you are searching for how to use merge function in ms sql databases, then this page will give you the solutions. Merge is a function available in the MS SQL database by which you can merge two tables. The result of merge function is same as the original data it uses. In addition, Merge can be used to combine multiple tables into single table whatever you want. The merge function is often used to combine two sets of data. It is a common data-modification function in the database world and can be used for many different purposes, including: combining records, concatenating strings or creating combinations of values. If you have a 1 to many relationship in ms sql, that means that there is one input data (Company) and one output data (Loan). For example: Company has addresses and Loans has balances. An example of this 1-to-many relationship is a person who has 2 names, addresses and phone numbers. You may want to merge two different sets of data into one single set, so we will use ...

What is recursive stored procedure in ms sql?

What is recursive stored procedure in ms sql? A recursive SQL stored procedure is one that calls itself. Recursive SQL procedures are very useful when you want to perform the same calculations on many rows of data and then return their results together as one set of data. You can write a recursive procedure using any language that supports procedural programming. You can use T-SQL, PL/SQL, or any other procedural language for your recursive SQL stored procedure definition.  A recursive stored procedure is a stored procedure that calls itself. It is a very powerful way of organizing code, as well as being a great way to execute code in parallel. A recursive stored procedure can be considered a subroutine within another subroutine. The name recursive refers to the fact that it does not return until it has called itself and then it returns back to where it was called from. The main advantage of using recursion over iteration is that we don't have to worry about going off and creating ...

Explain how Angular is different from AngularJS ??

AngularJS is a web application framework written in TypeScript that powers many popular enterprise applications. It's a client-side JavaScript framework for building mobile and desktop web apps. Angular has its own language, which is called TypeScript. TypeScript is a superset of JavaScript that compiles to plain JavaScript, so it provides some features around type checking and other features that help you write more maintainable code. You can use TypeScript with any library or framework that supports it, including Angular 2+. AngularJS is a very lightweight toolkit for building HTML5-based single-page applications (SPAs) with HTML templates, CSS3 animations, and powerful data binding. It was originally developed by Google as the app engine standard for developing dynamic websites on Google App Engine.

Recover SQL Database from Emergency Mode to Normal Mode

 The steps in the recovery plan are defined by the database administrator to recover SQL Server databases in an emergency situation or if they believe the databases have been compromised. These steps first begin with bringing the server into EMERGENCY mode, reading data from it using statements like SELECT statements and executing DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS command on it. ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE  DBCC CHECKDB ( DBNAME , REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE  DBNAME  SET MULTI_USER Now refresh the database and it will be back online. The simplest way to revert a SQL database back to normal mode is to restore it from the latest available backup. In case, if no valid backup exists then the next option is to repair it online by re-copying the data pages and removing dangling objects. If there are no options left and you are still in a dire need of data from that corrupt database, then Stellar Repair for MS SQL software is h...

History of SQL Databases

 As you can see, SQL is a very powerful, widely used language. Although it has seen many updates since it first came about, the fundamentals remain the same. The earliest SQL databases were conceived as separate systems from their host operating system and often ran on minicomputers or mainframes. Since SQL databases have grown in popularity over the years and are now used on a daily basis by individuals and businesses across the globe it is no wonder the demand for skilled database administrators has continued to grow as well. Today, SQL continues to be the dominant language for creating relational databases. There are many different dialects of SQL but standard SQL (SQL-2003) is supported by almost every major commercial data management system in use today. Because SQL is different than a query language in the hard-coded sense and allows for dynamic changes to the database design in part by using the JOIN function. SQL’s open source roots and extension capability have allowed dev...

What are ActiveX controls?

 ActiveX controls enable web applications on the Internet to work smoothly. ActiveX controls are created with a programming language that the developer can use to create the control. The ActiveX consortium has developed a set of standards for creating and using COM components in browsers. ActiveX relies on COM, which is an object model for developing software components that makes it easier to write programs that can interact with one another. ActiveX is a method of bringing features of many different applications together in one program that runs on your computer. ActiveX allows you to run active components, such as audio and video, and script-driven programs such as games. ActiveX can be used not only on Windows systems but also on other operating systems such as Unix or Mac OS. Developing with the Microsoft .NET Framework is a great way to take advantage of the power of the Internet and its many rich applications. The .NET platform provides developers with everything they need t...

When choosing the right .NET implementation for your needs

 When choosing the right .NET implementation for your needs, consider what you need to run and where you intend to run it. For example, if you only need to target mobile platforms, Xamarin/Mono may be a good choice since it lets you do so on multiple operating systems. On the other hand, if you only need to target Windows and Linux, .NET Core may work best. With all these different options, which should you choose? We'll let you know brief advantages and disadvantages of each platform, but we can't tell you precisely what to do. The best advice is to try them all. Microsoft has been evolving .NET Framework since its initial launch back in 2002. The company released .NET Core and .NET Standard in 2014, and they've slowly been increasing the amount of innovation they're bringing to their products since the inception of both. In the following table, we've outlined some of the latest news and announcements concerning their products, along with their current statuses.