How To Linux

How to – Remove Files and Directories Using Linux Command Line

In this tutorial, we will see how to use the rm, unlink, and rmdir commands to remove files and directories in Linus using Terminal (command line). Remove Files: To remove (or delete) a file on Linux using the command line, use either rm (remove) or unlink command. unlink command allows you to remove only a single file. rm command allows you to remove multiple files […]

Apache Kafka

Apache Kafka- Fundamentals

In the previous post, we learned what a messaging system is and the Role of Apache Kafka. In this post we will dive deep into Apache Kafka – We will learn Kafka cluster, brokers, topics, partitions, replicas, producers, consumers, consumer groups, Zookeeper, and how together make Kafka work. Most of Kafka revolves around Kafka Cluster, […]

SQL

Find a specific column Name in all tables of a database – SQL Server

Below is the query for searching only tables. SELECT c.name AS ‘ColumnName’ ,t.name AS ‘TableName’ FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE ‘%columnName%’ ORDER BY TableName ,ColumnName; If you want to search both tables and views – replace Sys.Columns toINFORMATION_SCHEMA.COLUMNS in the above query -Hussain Patel