Code, Query, Ship, and Learn | A Malaysian Data Engineer's Blog

Code, Query, Ship, and Learn

Sign in Subscribe

More issues

AI Empowers Developers to Create Stunning Websites

1. AI-Powered Extensions in Visual Studio Code VS Code’s extensibility makes it a prime platform for AI-driven coding tools. Here are key extensions and workflows to enhance productivity: GitHub Copilot * What it does: This AI pair programmer, powered by OpenAI’s Codex, suggests code completions in real time. It

Running Kafka in a Docker Container for SQL SERVER source and sink

Running Kafka in a Docker Container Apache Kafka is a powerful distributed streaming platform widely used for building real-time data pipelines and event-driven applications. Running Kafka in a Docker container simplifies setup, ensures consistency across environments, and makes it easier to scale and manage. In this article, we'll

Scrapy python to scrap a website to a word document script example

import scrapy from scrapy.linkextractors import LinkExtractor from scrapy.spiders import CrawlSpider, Rule from bs4 import BeautifulSoup from docx import Document import logging from scrapy.spidermiddlewares.httperror import HttpError from twisted.internet.error import DNSLookupError, TCPTimedOutError from docx.shared import Pt, RGBColor from docx.enum.text import WD_PARAGRAPH_ALIGNMENT

Optimizing Performance: Understanding How SQL Server Uses Indexes Based on Row Count and Server Resources

Introduction: In the dynamic world of database management, the efficiency of SQL Server relies heavily on the judicious use of indexes. Indexing is a powerful mechanism that facilitates faster data retrieval by organizing and structuring the data in a way that accelerates query performance. However, the way SQL Server utilizes

Exploring the Hallucinations of Generative AI: Unveiling the Creative Frontier

Introduction Generative AI has rapidly advanced in recent years, pushing the boundaries of what machines can create. As these systems delve into the realm of creativity, a fascinating phenomenon has emerged – hallucinations of generative AI. These hallucinations are not in the traditional sense, as experienced by humans under the influence

Path of a beginner to Kafka on docker for windows from A-Z for SQL Server

Follow the learning process of a beginner from you tube. Install wsl2 in windows add feature and linux from app store https://www.youtube.com/watch?v=n-J9438Mv-s Install docker desktop https://www.youtube.com/watch?v=AgZwJnBe2OE Install terminal app from windows app store and linux integration in docker

Generate insert statement for data in table SQL Server

DECLARE @TABLE_NAME AS NVARCHAR(1000) SET @TABLE_NAME = 'Dim_Date' DECLARE @SCHEMA_NAME AS NVARCHAR(1000) SET @SCHEMA_NAME = 'dbo' DECLARE @OBJECT_ID AS BIGINT SET @OBJECT_ID = (SELECT TOP 1 object_id FROM sys.objects WHERE NAME = @TABLE_NAME AND schema_id = ( SELECT TOP

Best free hosting for WordPress training. Start with zero cost and get 1000Mb for free with PHP & MySQL

AwardSpace is a leading free web hosting provider with millions of users worldwide. AwardSpace operates with high-end server technology and offers a vast number of web hosting services. The free hosting services of AwardSpace give everyone the opportunity to create their website, to promote their art, business, and to learn

Bubble sort in C# .Net Core example

Example of bubble sort in C# .Net core using System; namespace BubbleSort { class Program { static void Main(string[] args) { int[] numbers = { 5, 2, 7,4,7,9,0}; var sorter = new BubbleSort(); sorter.Numbers = numbers; sorter.sort(); Console.WriteLine("[{0}]", string.Join(", ", sorter.Numbers)); } } } using System;