Explore the Unknown
Introduction Python is a 'high-level, interpreted, general-purpose programming language' that is utilized for various purposes such as 'web development, scientific computing, data analysis, artificial intelligence, and more.' It is recognized for its 'simple and easy-to-read syntax,' making it a desirable language for novice programmers. Furthermore, Python has a thriving and dynamic community, offering an abundance... Continue Reading →
Introduction Entity Framework (EF) is an object-relational mapping (ORM) framework for the Microsoft .NET Framework. It allows developers to work with a database using objects, eliminating the need to write SQL commands. EF provides a set of APIs for creating, querying, and updating data in a database, and it can work with a variety of... Continue Reading →
Introduction ChatGPT, developed by OpenAI, is a large language model trained on a dataset of conversational text. It generates human-like responses to text-based prompts and is useful for various natural language processing tasks including language translation, question answering, and text completion Who can use ChatGPT ChatGPT, a publicly accessible model, is widely used by researchers... Continue Reading →
Introduction Whenever we work with data, sometimes there are some possibilities of getting duplicate data, not only because of the duplicate entries but also because of the T-SQL statement. We may need to remove it as well. In this instance, most of us follow to implement the DISTINCT keyword in our T-SQL Statement. Applying DISTINCT... Continue Reading →
Introduction In this article, let's understand how to play audio files in the Blazor Application, We will cover both Blazor Server and Blazor WASM applications. Before getting into the core concepts, let's discuss what Blazor is. Blazor is an excellent framework in which we can use C# code to write both the Client and Server... Continue Reading →
These days many projects are using NoSQL and MongoDB is one of the NoSQL Databases. In this article, we will learn what is MongoDB and it's purpose. The below is the ToC. Introduction PrerequisiteWhy need for MongoDB Architecture of MongoDB Feature of Mongo DBConclusion Introduction In this simple article, let's discuss what is Mongo DB.... Continue Reading →
Introduction Yes, now it's officially released !!! We can create Native Mobile and Desktop with C# & XAML and this is a cross-platform framework called .NET MAUI. MAUI stands for Multiple-Platform Application UI. We can develop applications for Android, iOS, Windows, and macOS from a single code base. This also means, that from a single... Continue Reading →
Introduction In this simple article, let's explore different ways to find a Database owner. When a database is created, generally who creates it owns it and they have all permissions on that database. The Owner can perform maintenance of the database, grant permissions to other users, and even drop the database. Different Ways to Find... Continue Reading →
Introduction In modern web applications, the business may require to send SMS to end-users in various scopes like Alerting the users, acknowledging the users, or even sending OTP. Sending as SMS is the easiest way and also can be implemented easily in .NET applications using Twilio. Setting Up Twilio Account Twilio two-way SMS and MMS... Continue Reading →
Introduction When working on large-scale projects, we might have created many tables, or later some point we might have changed the structure as part of the requirements. There is a huge possibility of tables that are not required or unused for a long time. A good practice is to remove/delete those by identifying them. In... Continue Reading →
Introduction In this article, we will discuss how to get the list of table names that contain specific columns. Sometimes we may need to find the table names which contain similar column names or we may know the column name but, we may not remember the table name. By using a simple query we can... Continue Reading →
Introduction In this article, We will discuss where the SQL Jobs are stored in SQL Server. Most of us know the purpose of SQL Job, A job is a specified series of actions that SQL Server Agent performs. Use jobs to define an administrative task that can be run one or more times and monitored... Continue Reading →
Introduction Golang is a General Purpose programming language developed by Google engineers Robert Griesemer, Ken Thompson, and Rob Pike in the year 2007. Golang is also known as Go. Golang is open-source. Table of Contents Overview of Go Features of GolangGo Getting Started Conclusion Overview of Go Applications developed using Go works faster since the... Continue Reading →
Introduction In this simple article, I would like to share how to check DB size. Sometimes when working in a Database, we may need to know the current space occupied by that particular DB. Based on the size, we need to take action. There are three easiest ways to check it, Using T-SQL StatementUsing SP... Continue Reading →
Introduction In this simple tips and tricks article, I would like to share how to when was a view last modified. Let's have a look at the below T-SQL Statement SELECT name as ViewName, create_date as CreatedDt, modify_date as LastModifiedDt FROM sys.views In the above T-SQL Statement list, from the column LastModifiedDt column we can... Continue Reading →
Introduction In this article, we will discuss how to get the created date of a table. Sometimes, we may need to know when the table was created in the particular database. Rather than relying on the row inserted date, we can see when the table was created. Finding the Created date using T-SQL SELECT name... Continue Reading →
Introduction In this simple tips and tricks article, I would like to share how many time zones does our SQL Server supports. Well, it's pretty much easy to find by using the system table sys.time_zone_info sys.time_zone_info Here is the sample T-SQL to get the list of time zones our SQL Server supports. SELECT name AS... Continue Reading →
Introduction In Power BI, we can do a limited amount of calculations using Power Query Editor, but that is not enough to perform. For that we have DAX. DAX means Data Analysis Expression is an inbuild function which is the formula language that is used by Power BI. DAX is developed by Microsoft to interact... Continue Reading →
Introduction In this simple article, lets explore to get total number of columns in a table in SQL Server Example SELECT COUNT(COLUMN_NAME) AS [Number of Columns] FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = 'PracticalWorks' AND TABLE_SCHEMA = 'Demo' AND TABLE_NAME = 'OrderDetails' Fig. 1 Number of Columns in a Table From the INFORMATION_SCHEMA.COLUMNS table we can find... Continue Reading →
Introduction In this article, I would like to share how to rename a column name or table name in SQL Server using T-SQL. For that, we have to use sp_rename. sp_rename renames the objects in the current database. Renaming column name to new column name The syntax for renaming a column in SQL Server using... Continue Reading →
Introduction When working in SQL Server tables, sometimes we may need to change a column that allows NULL to NOT NULL. This change is required as part of business requirement, that is definitely this column contains value or else as part of performance improvements, we may be in need to change the column from NULL... Continue Reading →
Introduction When working in SQL Server Stored Procedures, we are keen about the execution time of it. Its very simple to find execution time of stored procedures in SQL Server. Execution Time Its simple to figure out the execution time of stored procedures using SET STATISTICS TIME ON. SET STATISTICS TIME ON EXEC [Sales].[pGetSalesDetails] After... Continue Reading →
Introduction In this article, we will discuss how to integrate Dapper with the Blazor Web Server application. As many of us may know, Dapper is a micro ORM framework that helps us map object-oriented domain models to a relational database. Using Dapper, it is very easy to execute an SQL query against database and get... Continue Reading →
Introduction In this simple article, we will discuss different ways to find the particular table's column names in SQL Server. Method One The first approach is using the system table sys.columns. This table results many columns, but we are interested only in the column name, so I am selecting name column from the sys.columns table,... Continue Reading →
Introduction For any project, the folder structure is very important. We can organize the files and also if required, we can amend our changes easily. In this article, we will see the default Folder Structure of MAUI Preview 6. If you are new to this article, I would like to strongly recommend you to have... Continue Reading →
Introduction What if we are able to create native Mobile apps, Desktop apps using .NET C# and XAML from a single code base?. !!! How cool it will be right ?. Yes, now we can create native Android, iOS, macOS, and Windows applications from a single code base. This is possible using .NET's new feature... Continue Reading →
Introduction When working in a large set of Data, definitely we cannot use the data as it is. We need to perform some refinements so that we can exactly look into the data in which we are interested. In Power BI, this process is called Data Transformation, which can be done in different ways. In... Continue Reading →
Introduction When installing Machine Learning Services in SQL Server by default few Python Packages are installed. In this article, we will have a look on how to get those installed python package information. Python Packages When we choose Python as Machine Learning Service during installation, the following packages are installed in SQL Server, revoscalepy -... Continue Reading →
Introduction The columns in a table, that allows NULL in a database sometimes can lead to performance issues. The Nullable columns may be one of the reason to lead query to performance bad. By making columns NOT NULL can help the query to perform well. In this article we will discuss a simple way to... Continue Reading →
Introduction As like an Aggregate functions, the Ranking functions will rank the values of specified field and categorize them according to their rank . Ranking functions are most commonly used to find the top records based on conditions, example, to find the top ranking students, top highest paid employees and etc. Ranking Functions There are... Continue Reading →
Introduction In SQL Server, we can find the Longest String Value and Shortest String Value from the same table. To find the longest and shortest values, there are many ways, but in this article, we will discuss some simplest ways. Disclaimer: From this article, I am not sharing these are the only efficient ways to... Continue Reading →
Introduction In a single transaction (MERGE Statement) we can perform Insert, Update and Delete records on a existing table based on the result comparison between important columns with another table. Which also means we no longer needs to write multiple T-SQL statements to handle Insert, Update, Delete. MERGE Statements To perform MERGE, we need two... Continue Reading →
Introduction Whenever working in Financial Applications like Banking applications or financial modules in any ERP application we might have seen as Simple Interest. Usually we do those calculations in the programming application or else in the Frontend side and pass that calculated value to the database tables. But we can also do the same simple... Continue Reading →
Introduction Using keyboard shortcuts, it saves time, isn't it?. SQL Server Management Studio is also not an exception !!!. We can add our own custom keyboard shortcuts, that too for T-SQL query. Really cool !!!! How many of you know about this feature???. Do not worry if you did not know this before. Now you... Continue Reading →
Introduction Sometimes when working in Database, we may need to create another working copy of the current database or production database to check our new logic which should not affect the existing objects such as tables, stored procedures or etc. Example, suppose we may need to check few things using the Production database, but applying... Continue Reading →
Introduction When as a developer working in a database, which is in Development state, we may create some physical tables or temp tables to check the logic. Or based on the initial requirement we may have created more tables as part of Normalizing the data and our reviewer may suggest some better ideas to accommodate... Continue Reading →
Introduction From our previous articles, we know how to load data into our Power BI from various data sources. But that exact data is not enough to create our Power BI reports. We need to shape those data, that is refine the data, adding new columns, renaming the columns and many other improvements to create... Continue Reading →
Introduction Mostly the Power BI Desktop tool automatically detects the datatype of a column based on its value. Sometime it detects wrong datatype because Power BI automatically detects all these column data types as text (mostly) or as some other datatype formats. Say for an example, the Number's may be converted to Text datatype or... Continue Reading →
Introduction In this article, we will discuss about the Azure Search also known as Azure Cognitive Search. What is Azure Search?. Azure Search is a Search-as-a-Service cloud solution. These days modern applications has Search options, which make users to use the application in simple. But developers know that implementing the search engine is not that... Continue Reading →
Introduction When working in the SQL Server, we may have to check some other databases other than the current one which we are working. In that scenario we may not be sure that does we have access to those Databases?. In this article we discuss the list of databases that are available for the current... Continue Reading →
Introduction SQL Server maintains a table to keep information about each tables that are created in appropriate databases. Its a System Table called as sys.tables. For every table created to the database, a new one record is created in the sys.tables table which contains information such as table name, object id of table, created date,... Continue Reading →
Introduction In this article we will discuss about the Relational Databases that our Azure Cloud provides. Azure provides four Relational Database Services as, SQL Server in a Virtual Machine SQL Managed Instance Azure SQL DatabaseAzure Database for MySQL, PostgreSQL, MariaDB Now lets explore each services individually. SQL Server in a Virtual Machine The same software... Continue Reading →
Introduction In this article, we will discuss about the steps that we need to flow to prepare an Interactive Reports and Dashboards using the Data in Power BI. Import Data from Data Source First thing is we have to load the data from the data sources. In our previous articles we have discussed about this,... Continue Reading →
Introduction These days Data place an important roles in our day to day life and there are plenty of data available, which in terms becomes difficult to manage by Data Professionals. But we have smart tool to manage our large amount of data, which is called Azure Databricks. In this simple article, we will have... Continue Reading →
Introduction In our previous article, we discuss about how to run Python in SQL Server that hard coded. In this article we will discuss about the data which is already stored in our SQL Server Databases. Steps to Process Python with SQL Server Data In order to work with Data using Python, we have to... Continue Reading →
Introduction When we want to execute any external language script in SQL Server, then we have to sp_execute_external_script stored procedure. sp_execute_external_script is a new system stored procedure which was introduced in the SQL Server 2016. It is mainly used to execute the Machine Learning Services such as Python and R in SQL Server. Executing Python... Continue Reading →
Introduction Who will say to NO to know some tips and tricks which will improve our productivity and also makes task simpler. In this article, we will discuss some important simple tips and tricks in Power BI to create Dashboards and reports. 5 Simple Tips and Tricks If we want to keep same visualization for... Continue Reading →
Introduction In the previous article, we discussed about the different data sources that can provide data for Power BI. In this article we will learn how to connect those data sources with Power BI. I recommend you to refer the previous article to get better understanding. As mentioned before, in this article we will learn,... Continue Reading →
Introduction In this article, we will learn "How to connect Power BI with difference Data Sources". With Power BI, we can connect different types of data such like from Excel to Online data. Connecting Power BI with Different Data Sources Select Get Data option from the Home Menu in the Ribbon tool. This will list... Continue Reading →
Introduction Sometimes we may need to increase the current column value by Percentage. The very good example is Salary in an organization. We need to update the salary of each employee based on the Hike Percentage. Increasing Salary By Percentage In this example, lets assume the Hike percentage is equal for all employees, and I... Continue Reading →
Introduction If we want to access Power BI for FREE, then Power BI Desktop is option, a free application that we can install on our local computer that lets us connect to, transform, and visualize your data. We can create Data Model by connection to multiple different data sources. With this data model we can build... Continue Reading →
Introduction In this article, we will discuss how to Order By the Column Result By Last Three Characters of that Column. Order By The Last Three Characters First lets select all the rows from the table, SELECT StudentId, FirstName, LastName, RegistrationNumber FROM [Details].[StudentDetails] Fig 1. All Results from the table StudentDetails Now lets apply logic... Continue Reading →
Introduction Who will say NO to when they want to improve the speed and efficiency of writing SQL Queries?. Azure Data Studio has more features to improve efficient way of writing SQL Queries. In this article, we will have a look some Tips and Tricks in Azure Data Studio Command Palette If we want to... Continue Reading →
Introduction Sometime we may need to select the column results that the string not starting with Vowels. In this article, We will have a look, How to select the columns results not starting with Vowels. In our previous articles we discussed how to select columns results Select Names Starting With Vowels in MS SQL ServerSelect Names... Continue Reading →
Introduction Sometime we may need to select the column results that the string not starting and not ending with Vowels. In this article, We will have a look, How to select the columns results not starting and not ending with Vowels. In our previous articles we discussed how to select columns results Select Names Starting With... Continue Reading →
Introduction In this article, We will have a look, How to select the columns results NOT ending with Vowels. In our previous articles we discussed how to select columns results starting with vowels and column results ending with vowels. Select Names Starting With Vowels in MS SQL ServerSelect Names Ending With Vowels in MS SQL... Continue Reading →
Introduction Sometime we may need to select the column results that the string ends with Vowels. In this article, We will have a look, How to select the columns results ending with Vowels. In one of the articles, we discussed how to select names Starting with Vowels, please refer that article here. Example As an... Continue Reading →
Introduction This is Part 2 of "Get Started with SQL Server Machine Learning Services ". In the part 1 article, we discussed about the capabilities of Machine Learning in SQL Server. In this article, we will discuss "How to Install Machine Learning Services in SQL Server". Note: If you are new to this article, recommending... Continue Reading →
Introduction In this article, we will discuss the difference between Drop Table, Truncate Table, Delete Table. To perform dropping, deleting and truncating a table, I am creating three tables. With these three tables let's look into more: Students.StudentDetailsStudents.StudentMarks Students.StudentClass Drop TableThe syntax for dropping a table in MS SQL is, Syntax DROP TABLE TableName Example DROP... Continue Reading →
Introduction All the data in a database is stored in a Table, which is a data object. Data is organized in Rows and Columns in a table and each row represents a unique record while each column represents a field in the record Types of Tables SQL Server provides the following types of tables that... Continue Reading →
Introduction Being Software Developer / DBA / Database Developer, its important to know or understand the concept How the Data is Stored in SQL Database. This knowledge is very important when we want to troubleshoot and fix SQL queries that are not performing well from the Tuning point. In this article, we will discuss how... Continue Reading →
Introduction We know Humans learn from their past experiences. Mean while Machines follow Instructions given by Humans. But what if Human can train Machines to learn from the past data?. In simple, this is what Machine learning is !!!!. SQL Server has capabilities of Machine Learning. In this article, we will discuss about the capabilities... Continue Reading →
Introduction Date and Time plays major role in many projects. SQL Server has several date and time functions. In this article, we will discuss all the Date and Time functions in SQL Server with an Example. CURRENT_TIMESTAMP() Returns the date and time of the machine the SQL Server is running on. Example SELECT CURRENT_TIMESTAMP AS... Continue Reading →
Introduction In this article, we will discuss about the SQL Server String Functions (built in functions) in SQL Server. String Functions in SQL Server ASCII() Return the ASCII code value of a character CHAR() Convert an ASCII value to a character CHARINDEX() Search for a substring inside a string starting from a specified location and... Continue Reading →
Introduction Aggregate Functions are used to return a single value, which is calculated from multiple values in a column. Aggregate functions are build in SQL Server functions which are applied to set of records and we get summarized data. Aggregate Functions The following are the set of built in Aggregate functions in SQL Server, AVG()CHECKSUM()... Continue Reading →
Introduction In this article, we will have a look how to retrieve the Unsaved SQL Query using T-SQL. Sometimes, we may close the Query Window or SSMS accidentally without saving. This may cause to loss the Queries which we where working. Retrieve Unsaved SQL Query using T-SQL Statement Apply the below T-SQL Statement in which... Continue Reading →
Introduction We all can write the SELECT Statement in SQL Server. But how many of us know the execution order of SELECT statement query?. In this article, lets discuss how the SELECT statement is Executed or the in which order the Query is executed. Query Order Of Execution SELECT column,column1,.... column n FROM TableName JOIN... Continue Reading →
Introduction In SSMS, we many of may noticed System Databases under the Database Folder. But how many of us knows its purpose?. In this article lets discuss about the System Databases in SQL Server. System Database Fig. 1 System Databases There are five system databases, these databases are created while installing SQL Server. MasterModelMSDBTempdbResource Master... Continue Reading →
What is Database Normalization Database normalization is the step by step process of organizing data to minimize data redundancy i.e. Data duplication which in turn ensures data consistency Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies.Normalization rules divide larger tables into smaller tables... Continue Reading →
Introduction There are many occasions where we may need to compare the schema between two databases. For example, comparing Development and Production databases against each other, or comparing a database against a SQL Server Database project. Microsoft Visual Studio SQL Data Tools provides functionality that allows us to compare the structure of the database tables,... Continue Reading →
Introduction Continuous Integration has become practice to many development project. Did you know, we can achieve that in SQL Server Project in Visual Studio as well!!. Much needed one !!! There is a relatively easy path to get our databases into Database Projects (which we discussed in previous article), and ultimately source control. Implementing proper database... Continue Reading →
Introduction Databases plays an important role in any project these days. It becomes too difficult to manage the objects such as Tables, Views, Procedures and Functions increases over the time and also difficult to manage when number of team members works in Database at the same time. And even after that when we manage the... Continue Reading →
Introduction How many of us know, Blazor WebAssembly applications has offline support?. They can convert our Web Application into a Desktop or Mobile Applications, and that is called Progressive Web Application (PWA). In this article, we will discuss how to convert our WebAssembly Application into a Progressive Web Application (PWA), How do a PWA application... Continue Reading →
Introduction Azure Data Studio is a free multi-platform database tool with built-in support for both SQL Server on-premises and Azure SQL Databases. These databases can be accessed in Azure Data Studio for numerous tasks like query editing, data development, built-in charting of T-SQL queries, etc. Database developers or Database Administrators often have a need to... Continue Reading →
Introduction When creating a Blazor Application (both Server and WebAssembly), by default it consist of the UI framework. But some projects might be need to deliver sooner or the time frame for a project is lesser. In those scenarios we can use Blazor UI Components and in this article we discuss an awesome Blazor UI... Continue Reading →
Introduction As a developer, the most used shortcut keys are CTRL+C and CTRL+V i.e., copy and paste. But CTRL+C and CTRL+V allows us to copy paste the last item. But what happens if we want to paste more than one item that we copy or cut without going back? Cycle Clipboard Ring Cycle Clipboard Ring... Continue Reading →
Introduction A breadcrumb is a type of secondary navigation scheme that reveals the user’s location in a website or Web application. Breadcrumbs in real-world applications offer users a way to trace the path back to their original landing point. In this article, let's discuss how to implement breadcrumbs for WebAssembly Project Getting Started - Initial... Continue Reading →
Introduction Generally we have to shift between different environments within SQL Server Management Studio, as Dev Environment, Staging, Production, resulting in the creation of multiple query tabs. With each query tab connected to different environments. This leads to unmanageable sometimes and difficult to keep track of each environment. To resolve this confusion, SSMS provides us... Continue Reading →
Introduction During our productive hours, sometimes due to SSMS crashes or sudden machine reboots due to a windows update, during this time there is a possibility to lose the unsaved works / Script files. There is an option to recover our unsaved SQL queries in SSMS. How to recover unsaved SQL Queries By enabling the... Continue Reading →
Introduction In this article, we will learn a simple tip to take multiple backup files of one Database. Sometime we may need more than one copy of a backup file in different file location and we can achieve that in two ways, either using T-SQL Query or using SSMS. T-SQL Statement BACKUP DATABASE [PracticalWorks] TO... Continue Reading →
Introduction Sometime in our web application we may need to display contents in Popup Window. A popup window is a web browser window that is smaller than standard windows and without some of the standard features such as toolbars or status bars. Popups are one of the trickiest effects in web development, but in Blazor WebAssembly we can create it in... Continue Reading →
Introduction In this article, we will discuss the difference between CURRENT_TIMESTAMP , GETDATE() , SYSDATETIME() GETUTCDATE() in SQL Server. Even though all four SQL Server function returns the current date-time in SQL Server, there are some subtle differences between them. The main difference between GETDATE() and SYSDATETIME() is that GETDATE returns current date and time... Continue Reading →
Introduction In this article we will learn the trick to Move a Table from One Schema to Another Schema. Sometimes accidentally we might have given the incorrect name of a schema for the table while creating. But we can move the newly created table from one schema to another schema. Syntax ALTER SCHEMA NewSchemaName TRANSFER... Continue Reading →
Introduction In this article, we will discuss about the amazing technology called Blazor. Personally after working on this amazing technology, it increased my development works so much productive and interesting. In this article, we will cover the overall features of Blazor like as, What is BlazorWhy should we use Blazor Getting started with BlazorBlazor WebAssemby... Continue Reading →
Introduction In this article, I will share few SQL Tips for Boosting our SQL Query Performance. We nobody likes delay in response, right !!. Here are some simple changes that we have to make our query perform faster. The following is the flow of this write-up, Use Schema NameAlways Select ONLY required ColumnsUse NOT EXISTS... Continue Reading →
Introduction When developing components for SQL Server one change may affect another database object. Finding these dependent objects should be straightforward, but in most cases it is not as easy as we would think. There are several methods of getting this information, in this article we will have a look using SP_DEPENDS a System Stored Procedure.... Continue Reading →
Introduction Sometime we may need to select the column results that the string starts with Vowels. In this article, We will have a look, How to select the columns results starting with Vowels. Example As an example, we have a StudentDetails table, first lets select all the results from the table. SELECT [StudentId] ,[FirstName] ,[LastName]... Continue Reading →
Introduction Sometimes when we encounter an error message for a T-SQL query while debugging. The SQL Server shows the error message along with the line number where the error has occurred. In this article, I will give a simple tip to enable the Line Number feature in SSMS. This feature is applicable to all versions... Continue Reading →
Introduction This is part six of the “Blazor: Zero to Hero” article series. Before getting into the Part VI article series, let’s have a Glimpse at previous articles in this series, Part V Blazor is a component driven framework, i.e. Components are the fundamental build blocks of a Blazor applicationComponents can be reused and shared across multiple... Continue Reading →
Introduction This is part five of the “Blazor: Zero to Hero” article series. Before getting into the Part V article series, let’s have a Glimpse at previous articles in this series, 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... Continue Reading →
Introduction Sometimes we may need to get all the tables and views from a database in MS SQL Server. By using T-SQL Statement sp_tables, we can retrieve a list of tables and views. Syntax sp_tables [ @table_name = 'Table name.' ] , [ @table_owner = 'The database user who created the table.' ] , [... Continue Reading →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
In this blog, I wish to share some of my ways which I used to follow for a better goal achievements. Hope, this may also help you. Have a VisionWithout a vision, nothing can happen.There is no limit for one's vision. Have a big picture of your goal so that you can evaluate your progress.... Continue Reading →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
Learn With Sundar 