Blogs

Install Machine Learning Services for Python-Get Started with SQL Server Machine Learning Services – Part 2

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 →

Difference Between Drop Table, Truncate Table & Delete Table in MS SQL Server – Zero to Hero Query Master – Part 6

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 →

Tables in Database- MS SQL Server – Zero to Hero Query Master – Part 5

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 →

How is Data Stored in SQL Database

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 →

Get Started with SQL Server Machine Learning Services – Part 1

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 →

SQL Server Date Functions

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 →

SQL Server String Functions

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 →

Aggregate Functions in SQL Server

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 →

Retrieve Unsaved SQL Query Scripts

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 →

Select Statement Execution Order In SQL Server

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 →

System Databases in SQL Server

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 in SQL Server – MS SQL Server – Zero to Hero Query Master – Part 4

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 →

Schema Comparisons using Visual Studio SQL Data Tools

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 →

Link a SQL Server Database Project to a Git Repository

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 →

Create and Publish SQL Server Database Project With Visual Studio

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 →

Build Progressive Web Applications with Blazor WebAssembly

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 →

Customize Azure Data Studio with Dashboard Widgets

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 →

How to get started with the Radzen Blazor components

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 →

Cycle Clipboard Ring In SSMS – Reuse Copied Items

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 →

Breadcrumbs For Blazor using MudBlazor

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 →

Set custom colors to differentiate between environments in SSMS

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 →

Recover unsaved SQL queries in SSMS

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 →

Multiple Backup Files of the SQL Server database with SSMS and T-SQL

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 →

Modal Popup Window in Blazor WebAssembly

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 →

Difference between CURRENT_TIMESTAMP vs GETDATE() vs SYSDATETIME() vs GETUTCDATE() in SQL Server

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 →

Change Schema Name Of Table In MS SQL Server

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 →

What is Blazor and How does it works

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 →

5 Tips to Improve SQL Query Performance

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 →

Identifying object dependencies in SQL Server using SP_DEPENDS

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 →

Select Names Starting With Vowels in MS SQL Server

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 →

Display Line Numbers in a SQL Server Management Studio Query Window (SSMS)

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 →

Blazor Components in Razor Page: Zero To Hero in Blazor with Real Time Implementation Part VI

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 →

Blazor Components in Razor Page: Zero To Hero in Blazor with Real Time Implementation Part V

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 →

Get list of Tables & Views in MS SQL Server- sp_tables

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 →

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 →

Website Built with WordPress.com.

Up ↑

<span>%d</span> bloggers like this: