Sitemap
Main Pages
2026 Articles (7)
- DP-750: Azure Databricks Cluster Explained and with Real Exam QuestionsJul 10, 2026
- Best AI Coding Agent for the Money: What Databricks’ Benchmark RevealsJul 9, 2026
- Was My Claude Account Banned Because I Speak Chinese?Jul 9, 2026
- Selling Power BI Templates for Passive IncomeJul 8, 2026
- Where to Write Python in Azure - Building the Python ETL PipelineJul 2, 2026
- Why I Left China as a Data AnalystJul 1, 2026
- Data Analyst: Does Your Work Actually Matter?Mar 13, 2026
2025 Articles (30)
- Fixing Azure SQL Connection Errors in Azure Scheduled Python JobDec 8, 2025
- Stuck in a Version Trap - How I Used Azure ML to Deploy an Azure FunctionNov 19, 2025
- Stop Using Spark for Your Small Data - Why Azure Functions is the Right Tool for the JobNov 18, 2025
- 10 Essential Data Science Algorithms & TechniquesNov 15, 2025
- Data Security in SQL: Encryption, Roles, and PermissionsNov 13, 2025
- How to Install Python Package in Azure Synapse for Apache Spark poolsNov 12, 2025
- How to Calculate a Dynamic Truncated Mean in Power BI Using DAXNov 10, 2025
- How to Store JSON and XML in SQL DatabasesNov 9, 2025
- The Opportunity Card Germany - My First-Hand Experience and Complete GuideSep 24, 2025
- Python + AI - The Essential Skill Combination for Modern Workers Without Coding BackgroundsSep 10, 2025
- Markdown Code Blocks Breaking HTML Rendering: How to Fix Line Break IssuesAug 21, 2025
- Draw a Fish and Watch it Swim - Crazy Idea Create Viral WebsiteAug 14, 2025
- English Speaking Companies in GermanyAug 12, 2025
- NotionNext - The Ultimate Solution for Notion-Based Website BuildingAug 8, 2025
- Essential Services for Newcomers in Germany - Personal RecommendationsAug 6, 2025
- Do You Really Need a “Second Brain”?May 2, 2025
- SQL Advanced Functions - CASE, COALESCE, and NULLIF ExplainedFeb 21, 2025
- Database Design Principles - Normalization and DenormalizationFeb 14, 2025
- Implementing Triggers in SQL - Automating Database ActionsJan 27, 2025
- Handling Dates and Times in Oracle DatabaseJan 21, 2025
- SQL Transactions - COMMIT, ROLLBACK, and Savepoints with PythonJan 20, 2025
- SQL Recursive Queries - Understanding Common Table Expressions (CTEs)Jan 16, 2025
- SQL Performance Tuning: Best Practices for Faster QueriesJan 15, 2025
- Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with ExamplesJan 13, 2025
- A Guide to Manage Access in SQL - GRANT, REVOKE, and Access ControlJan 6, 2025
- A Quick Guide to SQL Data Modification Commands with ExamplesJan 5, 2025
- How to chat with Local LLM in ObsidianJan 4, 2025
- Getting Responses from Local LLM Models with PythonJan 3, 2025
- Local LLM Models and Game Changing Use Cases for Life HackersJan 2, 2025
- Why You Should Try a Local LLM Model—and How to Get StartedJan 1, 2025
2024 Articles (39)
- A Quick Review of SQL Window Functions with ExamplesDec 29, 2024
- How to Publish an Article to DEV Using PythonSep 5, 2024
- How to Schedule Python Scripts on a Mac Using CrontabSep 2, 2024
- How to Publish an Article to Medium Using Python and the Medium APIAug 31, 2024
- Obsidian - How to create Daily note every day, even if I don't open itAug 30, 2024
- Tableau Desktop Public: Free Data Visualization ToolMay 23, 2024
- Effective Strategies for Searching Stored Procedures in OracleMay 20, 2024
- How to Use ChatGPT on macOS: Installation and Access SolutionsMay 20, 2024
- How to connect to Oracle, MySql and PostgreSQL databases using Python?Apr 29, 2024
- Active Directory (AD) vs Azure Active Directory (AAD)Apr 22, 2024
- How to Download All Your Published Articles from DEV.to in Markdown FormatApr 4, 2024
- Setting Up Jupyter Notebook on a Windows Server: A Step-by-Step GuideMar 28, 2024
- Power BI: Two ways to Union Tables - DAX and Power QueryMar 20, 2024
- How to read and write JSON files in PythonMar 19, 2024
- Python: Effective Techniques for Managing Dates in DataFrameMar 18, 2024
- Four Types of Bar Charts in Python - Based on Tabular DataMar 15, 2024
- Four Types of Bar Charts in Python - Based on Array DataMar 14, 2024
- How to Use the Concat Function in Pandas for Horizontal or Vertical Table ConcatenationMar 13, 2024
- How to Convert Rows to Columns and Columns to Rows in Pandas DataFrame using Python?Mar 12, 2024
- Oracle Database: How to Create/Delete New User and Grant Privilege?Mar 11, 2024
- Power BI: How to Create Dynamic Show Hide Slicer PanelMar 7, 2024
- Automating Time-Based Tasks: Scheduling Functions at Flexible IntervalsMar 6, 2024
- Understanding Nested IF vs. SWITCH in Power BI: A Comparative AnalysisMar 5, 2024
- Python: Updating and Appending pandas DataFrame using DictionaryMar 4, 2024
- Use Python to Fetch Followers and Monitor Post Status on DEV.toFeb 25, 2024
- Will Python replace Stored Procedures?Feb 6, 2024
- Use Python to Refresh Tableau DashboardFeb 2, 2024
- Comparing Two Lists in Python: Differences, Intersections, and UnionsJan 30, 2024
- How to Use DAX Studio to Retrieve All Measures in Power BIJan 29, 2024
- Using the Logger Class in Python for Effective LoggingJan 25, 2024
- Creating Divider Lines in PythonJan 23, 2024
- How to use Python automatically get the Sap BO Temporary License keys?Jan 21, 2024
- Python: Setting data types when using to_sqlJan 17, 2024
- Solving Pandas .to_sql Double Quotes Issue When Writing to DatabaseJan 16, 2024
- Saving Dataframes into Oracle Database with PythonJan 15, 2024
- How to Use Pyinstaller to Generate an EXE FileJan 10, 2024
- Using Python to Retrieve Data Through Tableau REST APIJan 6, 2024
- How to specify the data format when saving Excel via Python?Jan 4, 2024
- Accessing Power BI Data with Python Using the Power BI REST APIJan 2, 2024
2023 Articles (10)
- How to Change Number of rows fetched by SAP BusinessObjects Report?Dec 29, 2023
- How to Create Calendar Table in Power BI?Dec 27, 2023
- Automate SAP Report Extraction with PyAutoGUIDec 25, 2023
- Sending Emails with Python: A Step-by-Step GuideDec 20, 2023
- Using the os module for high-level file operations such as iterating, moving, copying, and deleting files and directoriesDec 20, 2023
- Getting the List of Universes SAP Business Objects using PythonDec 15, 2023
- Unlocking SAP BusinessObjects Data: A Comprehensive Guide to Retrieving Documents with PythonDec 14, 2023
- How to Get the List of SAP BusinessObjects Schedules using Query BuilderDec 13, 2023
- Python Web Scraping in SAP Business Objects CMC: Get the List of SchedulesDec 12, 2023
- How to merge multiple Excel files using PythonDec 11, 2023