Understanding the OUTPUT Clause in SQL Server

SQL Server provides a powerful feature called the OUTPUT clause, which allows developers to return information from the rows affected by an INSERT, UPDATE, DELETE, or MERGE statement. This clause can be used to return the values of the columns affected by the statement, which can be inserted into a table, used in a SELECT […]


Introduction The GROUP BY clause in SQL is used to group rows in a result set based on the values in one or more columns. When a GROUP BY clause is added to a SELECT statement, the result set is sorted by the values in the specified columns, and all rows with the same values […]

Brave: The Privacy-Focused Web Browser

In today’s digital age, online privacy and security are becoming increasingly important concerns. That’s where Brave comes in. Brave is a free and open-source web browser that is designed to protect your online privacy and security while also improving your browsing experience. Developed by Brave Software, Inc., Brave was first released in 2016. It is […]

Headless CMS: The Future of Content Management

In today’s digital world, organizations need to be able to publish and manage their content across a wide range of channels and devices. This includes websites, mobile apps, and connected devices such as smart TVs and home assistants. A traditional CMS (content management system) can be inflexible and may not provide the necessary tools for […]

What is SaaS?

Software as a Service (SaaS) is a software delivery model in which a software application is hosted by a third-party provider and made available to customers over the internet. Customers can access the software through a web browser or API (Application Programming Interface) without the need to install it on their own computers or servers. […]

5 Tips for Resetting an Identity Column in SQL

To reset the identity column in a SQL table, you can use the following steps: Here is an example of how you can reset the identity column in a table called MyTable: Note that this will reset the identity column to start at 1 and increment by 1 for each new row that is inserted […]

Iphone Apps that can read PDF and other documents aloud

There are several iPhone apps that can read PDF files aloud. Some of these include: There are also many other apps that can read PDF documents out loud, so you may want to explore different options to find the one that works best for you.

What is MariaDB?

MariaDB is a free and open-source database management system that is a fork of the MySQL database management system. It was created by the original developers of MySQL, who decided to make MariaDB an open-source project after concerns arose about the acquisition of MySQL by Oracle Corporation. MariaDB is designed to be a drop-in replacement […]

How to create an AI chatbot for Facebook Messenger

pink background with speech bubble

To create an AI chatbot for Facebook Messenger, you will need to use a chatbot building platform or a chatbot API. Here is a general outline of the steps you will need to follow: Note: Building a chatbot for Facebook Messenger requires some programming knowledge, as well as an understanding of chatbot design and machine […]

How create an SQL INSERT statement from data in an Excel spreadsheet

To create an SQL INSERT statement from data in an Excel spreadsheet, you can follow these steps: Note: If you have a large number of rows to insert, you may want to use the INSERT INTO SELECT statement, which allows you to insert data from a SELECT statement into a table. This can be more […]

What is React?

React is a JavaScript library for building user interfaces. It was developed by Facebook and is often used for building single-page applications and mobile applications. A React app is a web application that is built using the React library. It is typically implemented as a single-page application, meaning that the entire app is loaded in […]

What is npx?

npx is a tool that is included with npm, the package manager for JavaScript. It is a command-line utility that allows you to execute npm package binaries directly, without having to install the package globally on your system. Here are some examples of how npx can be used: npx is useful for situations where you […]

How to refresh or resize a modal window in Bootstrap once the content has been rendered

To refresh or resize a modal window in Bootstrap once the content has been rendered, you can use the $(‘#myModal’).modal(‘handleUpdate’) method. This method triggers the shown.bs.modal event, which updates the modal’s position and dimensions. Here is an example of how you can use the handleUpdate method to refresh or resize a modal window: You can […]

How to increase the width of a modal window in Bootstrap

To increase the width of a modal window in Bootstrap, you can use the .modal-dialog class and set the width property to a desired value in pixels or as a percentage of the viewport. Here is an example of how you can increase the width of a modal window in Bootstrap: This will set the […]

Things to know about your computer

Computer and Information Systems Manager

What is a recovery partition in windows? A recovery partition is a special section of a computer’s hard drive that contains files and instructions for restoring the system to its factory default state. In Windows, the recovery partition typically contains a copy of the operating system and other important system files, as well as tools […]

What is a tag cloud? All you need to know

a picture of tag cloud

A tag cloud, also known as a word cloud, is a visual representation of text data. It is typically used to represent the frequency or importance of various words in a body of text. In a tag cloud, the most frequently used or important words are usually displayed in larger fonts, while less frequently used […]

New Iphone to support wireless charging

Iphone Wireless Charging

The new tech age is finally here! Imagine those charging cords that lasts for weeks if not just a few months. According to CNBC news, JP Morgan has stated on Tuesday this week that the next Iphone will implement this feature and they are expected to make millions of dollars on it. It’s not clear […]

Enabling and setup of Team Foundation Server (TFS) plugin for Microsoft SQL Server Management Studio

MMS TFS Plugin

In this article, the version in use are TFS 2017 and Microsoft SQL server version 2014 and Microsoft Visual Studio (VS) 2013 and Microsoft Visual Studio 2015. First we have to download the MMS plugin for TFS (Microsoft Visual Studio Team Foundation Server 2013 & 2015 MSSCCI Provider 32-bit). https://marketplace.visualstudio.com/items?itemName=TFSPowerToolsTeam.MicrosoftVisualStudioTeamFoundationServer20132015M After installing go to MMS […]

How to protect your Facebook account from hackers

Facebook Security

If you value the information (data) stored in your Facebook account, you should take steps to protect it from unauthorized users. Not only would you make it difficult for hackers to take over your account, you will be protecting your Facebook “friends” which some of whom are your families. When your Facebook account is compromised, the hacker […]

Flying taxi to be launched this summer

Flying taxi model

The sci-fi technology that we often see on television is finally here. No longer do we have to be congested in traffic moments away from executing a road rage action. The flying taxi is finally here! At least not until this summer. That is what is planned in Dubai this summer. According to Forbes news, […]

Data Warehouse Quick Guide and usage in tableau

Tableau Connection Microsoft SQL screen shot

Introduction This article is intended to bring a user up to speed on steps and usage of tools from importing data from a data source to the data warehouse and then to tableau environment. It assumes that data warehouse server and tableau server has already been setup and users in each environment has been setup appropriately. […]

How to extend Apple TV movie rentals beyond 24 hours

Apple TV movie rental image

Rented a movie on Apple TV and Running out of time? As you know Apple TV movie rental are for 24 hours only. Or some other family member want to watch the movie and only 30 minutes or less left? Don’t worry! There is a way to extend the Apple TV movie rental beyond 24 […]

Water, stain proof clothing powered by Filium technology

Imaging re-wearing your t-shirt for a few weeks without a need to wash it? Probably shouldn’t wear the same color t-shirt everyday but you can own a few colors.  Existing now is a technology that can make clothing resistant to water and stains which leaves clothes smelling fresh after weeks of usage. The technology is […]

Finding opponent in Fifa 16

Getting tired of trying to find an opponent in Fifa 16 and the likes? If you are connected to a router it is very likely it is your router! It needs to be configured. Although the FIFA game loads, logs in successfully to the EA Sports server, it does not mean a successful opponent will be […]

Steps to move data from database to data warehouse database

Databases connected together

These are very high level overview of how to move data from a traditional database or transactional database to a data warehouse database. It provides vital clues to get you started on a productive road to success! Steps to move data from a transactional database to a data warehouse type of database. The general steps […]

Troubleshooting internet connection using trace route

Having high speed internet does not mean a website will load quickly on the browser. But you can gain a clue or two by doing a bit of digging. 😛 Sometimes websites that usually load faster appear to be loading very slowly – even on a broadband connection. The internet has many path connected together […]