Download all files from FTP in Python
Recursively download an FTP directory tree in Python using ftplib with NLST, RETR, and local directory mirroring.
Continue ReadingStore historical records in a history table in SQL Server
Audit data changes in SQL Server with history tables triggered on UPDATE and DELETE from base tables.
Continue ReadingJQuery snippets
Common jQuery patterns for DOM selection, events, traversal, and AJAX in legacy web apps.
Continue ReadingAccessing MySQL databases from remote computer
Allow remote MySQL connections by binding address, creating users with host %, and opening firewall port 3306.
Continue ReadingOracle EM Configuration
Configure Oracle Enterprise Manager Database Express or Cloud Control for monitoring and administration.
Continue ReadingEnable Pretty Permalinks on WordPress
Switch WordPress to SEO-friendly URLs by enabling pretty permalinks and configuring Apache or nginx rewrite rules.
Continue ReadingHow to Extract Pages from a PDF Document to Create a New PDF Document using Google Chrome
Split and merge PDF pages using Chrome's built-in PDF viewer and print-to-PDF without installing extra software.
Continue ReadingDatatable to CSV file
Export DataTable contents to CSV in C# with proper quoting, escaping, and culture-aware formatting.
Continue ReadingRabbitMQ.NET library to easily integrate RabbitMQ in .NET Core applications
Integrate RabbitMQ.Client in .NET Core with DI, hosted consumers, and resilient connection management.
Continue ReadingC# DataTable select method
Filter DataTable rows with the Select method using expression syntax similar to SQL WHERE clauses.
Continue Reading