Blogs

What is Flutter ?.

Introduction  This is part one of the "Deep Dive into Flutter" series. In this article, we will learn the basics of Flutter. The following is the ToC of this article. Background Introduction to FlutterNeed of Flutter Highlights of FlutterLanguageEditors  Points to remember Conclusion  Background  Flutter is an emerging technology. I started learning this new amazing technology on my own.... Continue Reading →

Microsoft’s Artificial Intelligence – An Overview

Introduction  In this article, we will have a detailed listing at AI Services supported and provided by Microsoft.   What of Artificial Intelligence  Artificial Intelligence is a branch of computer science that aims to create intelligent machines, in simple terms, Human Intelligence processed by Machines, specifically computers.   AI Categories   AI can be categorized as either weak... Continue Reading →

Selecting Only EVEN or ODD Records from Tables – MS SQL SERVER

Introduction In this article, we will learn to Select only EVEN or ODD records from the MS SQL Server database table🤔. The efficient way to find the record belongs to even or odd is determining by the table's ID column. Select EVEN Records By applying the modulo operator by 2 for the ID column, we... Continue Reading →

Stored Procedure Performance Tuning

Introduction In the Database, we may be using Stored Procedures. Most of the time we are concerned about the performance of the Stored Procedures. In this article, I would like to share a few techniques to improve the stored procedure's performance to get better results in less time. Optimization Techniques SET NOCOUNT ON/OFF - When... Continue Reading →

Optimize your SQL Query – Replace Star (*) in Select Statement – MS SQL Server

Introduction Sometime we may need almost all the columns from a table result. In this scenario we use Star(*) in our select statement i.e. as SELECT * FROM TableName. Using Star(*) in the select statement is BAD. The best approach is selecting the table with column names. In this article we will learn how quickly... Continue Reading →

How to Store non-English Characters in SQL Server

Introduction Sometime, we may need to store non-English characters or multiple languages in our database. In this article, we will have a look at how to store non-English characters in SQL Server. VARCHAR vs NVARCHAR We can store non-English Characters in our database table using the data type NVARCHAR(). The N stands for Unicode. It... Continue Reading →

Monolithic vs Microservice Architecture

Introduction Most of web application developer might discussed about Monolithic vs Microservice. Now a days we can develop better web application with either these options. Its all important that which one is right our needs. In this article, we will discusses both of these architecture and you can decide which architecture is needed for application... Continue Reading →

Backup Database using T-SQL Statements

Introduction In this article, We will discuss how to backup our database in MS-SQL Server using T-SQL Statements. We need to use BACKUP DATABASE statement to create full database backup, along with the name of Database and device to store the backup file. Syntax BACKUP DATABASE database_name TO device_name Example BACKUP DATABASE PracticalWorks TO DISK... Continue Reading →

What is Power BI

Introduction With Microsoft Power BI we can quickly connect to our data and visualize as much or as little as we like and creates stunning reports and dashboards to help get insights into the business, which helps to make decisions. To make decisions we need data, that only the business data. In this article, we... Continue Reading →

Pinned tabs in SQL Server Management Studio (SSMS)

Introduction While working in SQL Server Management Studio (SSMS), we may need to open many query windows. But each time we may feel difficult to recognize the important query window which we need to refer frequently. There is an option, we can Pin the tabs which are mostly frequently referred. Pinning Tabs We can pin... Continue Reading →

SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master – Part 3

Introduction This is part 3 of "MS SQL Server- Zero to Hero" and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below, MS SQL Server – Zero to Hero Query Master – Part 1 MS... Continue Reading →

Split Query Window in SQL Server Management Studio(SSMS)

Introduction Sometime we may write a long query in our query window and we may need to refer the objects or other part of the T-SQL frequently. For that we may be scrolling up and down in the query window. But we have an awesome option for that in the SQL Query Window, which many... Continue Reading →

Last Execution of Stored Procedure in SQL Server

Introduction In an ERP project or any other big applications, there may be many Stored Procedures used. But we are not sure that all the stored procedures are required or not or valid ones. While the requirement(s) has changed, we may ended with another new stored procedure or based on the performance we may have... Continue Reading →

List Databases Available for Current User -SQL Server

Introduction Sometimes, we may be curious to know to which databases do we have access or we need to access a particular database but not sure that we have access or not. In this article, we will discuss a T-SQL that will list the Databases available for current user. For Particular Database HAS_DBACCESS  - This... Continue Reading →

Format JSON Output in SQL Server

Introduction From SQL Server 2016 JSON functions are introduced, since many modern Web and Mobile applications are using JSON data format for exchanging data. Many REST web service results are in format of JSON text or accept the data that is formatted as JSON. In this article, we will have a look How to Create... Continue Reading →

Find user who ran DROP statements – SQL Server

Introduction Sometimes we need to track or find which user has DROPPED the table(s) from the Database. In this article, we will discuss the possible ways to track this situation. I have a table already in my Database, SELECT [StudentId], [FirstName], [LastName] FROM [StudentManagementSystem].[Students].[StudentDetails] Fig 1. Results Drop table Now I am going to apply... Continue Reading →

Effective Meetings

Introduction We are almost spending 25% to 50% of our time in meetings in an organisation, because meetings are inevitable and necessary part of organisational life. Meetings must be made more effective. The most common types of meetings that you will have are, Information Sharing Problem Solving To announce new Products / Services / People... Continue Reading →

Blazor: Zero To Hero Real Time Implementation Part IV

Introduction  This is part four of the “Blazor: Zero to Hero” article series. Before getting into the Part III article series, let’s have a Glimpse at Part I, Part II and Part III articles,  Part I Blazor is a framework to build Interactive Web UIs using C# and HTML. The initial release was in 2018 by Microsoft.   We can... Continue Reading →

Hangfire – .NET Background Tasks

Introduction In this article, We will discuss about the Hangfire, an open source framework, which is used to run background tasks in .NET. In general, we may need an application which run's in the background based on the code nature, that is, it may take long time to execute and users does not want to... Continue Reading →

Blazor: Zero To Hero Real Time Implementation Part III

Introduction  This is part three of the “Blazor: Zero to Hero” article series. Before getting into the Part III article series, let’s have a Glimpse at Part I and  Part II articles,  Part I Blazor is a framework to build Interactive Web UIs using C# and HTML. The initial release was in 2018 by Microsoft.   We can... Continue Reading →

Machine Learning Models With C# – Part Two

Introduction This is part two article series of "Machine Learning Models With C#", before getting into the part two series, if you have not yet read the. part one, please have a look at Machine Learning Models with C# Part I. In this article, we will have a detailed view on Setting Up the C#... Continue Reading →

Blazor: Zero To Hero Real Time Implementation Part II

Introduction This is part two of the “Blazor: Zero to Hero” article series. Before getting into the Part II article series, let’s have a Glimpse at Part I,  Blazor is a framework to build Interactive Web UIs using C# and HTML. The initial release was in 2018 by Microsoft.   We can use C# code in the Client-Side... Continue Reading →

Software Testing and Types – An Overview

Introduction    In this article, we will have a detailed look at Software Testing and its type.  Software testing is a process of executing an application with the intention of finding bugs. Testing is also done for making sure whether the application is developed as per the customer requirement or not. Checking satisfies customer requirement in... Continue Reading →

SQL Server Management Studio Shortcut Keys Cheat sheet

Introduction In this article, I would like to share few shortcut keys which is really useful fIn this article, I would like to share a few shortcut keys which are really useful for day to day usage in SQL Server Management Studio, which will improve your productivity. Main Menu Bar Main Menus in SSMS To... Continue Reading →

Blazor: Zero To Hero Real Time Implementation Part I

This is Part one of “Blazor: Zero to Hero” article series and in this article series, rather than learning Blazor, we will also develop a real-time application with best practices. At the end of the article series, we will be familiarised with Blazor with real-time implementations. We will take Financial Application as our example for... Continue Reading →

The Internet of Things – Deep Overview

Introduction The first question that we should attempt to answer is, of course, what is the Internet of Things? Although the concepts we call on throughout this article are relatively straightforward, people have many different visions of what the phrase means, and many of the implications are hard to grasp. So we will take this... Continue Reading →

How to Become Full Stack .NET Web Developer

IntroductionIn this article, I would like to share some of the important key skills required to become a Full Stack Web Developer of .NET. In other terms, Full Stack Web Developer is also noted as a Web Stack Developer (Mainly works in Web-based application developments). In this article, we will see the following. BackgroundSkills Required... Continue Reading →

Personality Traits Required to be a Successful Business Analyst

Introduction  In this article, I have explained in detail about the personal traits required for a business analyst. A business analyst may require additional skills, depending on the project.  The following is a list of the most commonly needed personal traits for a business analyst.  CommunicationAnalytical SkillsCritical ThinkingProblem SolvingAttention to DetailTeam Player/ManagementRelationship BuildingInfluencingLeadership QualitiesUnderstanding of Organizational DynamicsPoise ... Continue Reading →

Business Analyst and Scope of Their Role

Introduction  In this article, we will take a detailed look at who is a business analyst and the scope of a business analyst in organizations.  Business Analyst   A business analyst is a professional who is involved in any of the activities under the purview of business analysis. As mentioned in the previous question, the role... Continue Reading →

Time Management

Introduction  In this article, I would like to share the four Ds of Effectiveness that will boot up your time management skills.    Background   Recently I have purchased a book on "Time Management" and it was very useful for me. I thought of those concepts through this article. Hopefully, this will be very useful for all of us,... Continue Reading →

The Knowledge Areas A Business Analyst Needs To Know

Introduction  In this article, we will get a detailed view of the knowledge areas that a business analyst needs to know.  A business analyst needs to have knowledge of business analysis, product management, and technical know-how, including an understanding of testing.  Behavioral and personality-related skills Analytical and critical thinking skillsCommunicationRelationship buildingInfluencing and leadership skillsTeam player and... Continue Reading →

Software Development Life Cycle – An Overview

Introduction  In this article, we will learn more about the basic software development life cycle phases.  Initiation Phase  The initiation phase of the project begins when a business need is identified regarding a problem or opportunity. Once the business analyst analyzes and defines the problem or opportunity, a project manager may be appointed to evaluate... Continue Reading →

MS SQL Server – Zero to Hero Query Master – Part 2

Introduction In this article, you will learn how to create a database, access the created database, and delete the database in SQL Server. This is the continuation of part one of the series of "Zero To Hero in MS SQL Server."  As I stated in my previous article, this article series is mainly for beginners who... Continue Reading →

MS SQL Server – Zero to Hero Query Master – Part 1

Introduction This is part one of the Zero To Hero Series in MS SQL Server. This is mainly focused on beginners who are into MS SQL Server and also for experienced developers who want to freshen up their knowledge for interviews and daily technical work. The examples in this article series will be connecting us... Continue Reading →

SQL Developer – Roles & Responsibilities

Introduction In this article, I would like to share some of the key roles and responsibilities of a SQL Developer. This will be useful for those who wish to be a master of the database (MS SQL Server). The following is the flow of this write-up. BackgroundWhat is SQLWho is SQL DeveloperRole and Responsibility of an... Continue Reading →

Machine Learning Models With C# – Part One

Introduction   This is Part 1 of "Machine Learning Models with C#". In this article, we will have a look into the Basics Models of Machine Learning. Background I recently started to learn Machine Learning in C# from a book. I found it is very useful and thought of sharing that knowledge with you all. Article Credits  The concepts in... Continue Reading →

Methodologies To Learn A New Computer Programming Language

The following methodologies are my own practices. If you find these useful, you can practice these too. Step 1 (Analyze the languages) There are many languages avalibale nowadays to develop applications, so you should  have an in-depthlook at all  thelanguages.Choose one new language for learning at a time. Step 2 (Allocate Time) Make spare time... Continue Reading →

Effective Application Development

In this blog I would like to share some of my Application Development methodologies which give some more productivity in development. Analysis When your Team Leader or Project Manager assigns a task, initially it takes more time to analyze, before you start to code. You should have a clear idea about the result before you... Continue Reading →

Get Ready For Interviews

In this blog, I would like to share some of my interview experiences, and what to do and what not to do during interviews. This will help freshers mainly but experienced candidates can also improve themselves. Applying for JobYou can apply for a job position in many ways - via their company site, via job... Continue Reading →

WordPress.com.

Up ↑

%d bloggers like this: