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, […]


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