IT Infrastructure

Articles on IT infrastructure for businesses: NAS systems, Synology, QNAP, SQL Server, backup, security, and practical tips from IT consulting.

Softwareentwicklung - WiKon-IT

Software Development in Business

Efficiency, Automation and Competitive Advantage A Business World Without Software – Unthinkable Modern companies cannot function without software. Whether it’s SAP, Excel, or specialized applications – nearly every process relies on digital solutions.A simple example: In Excel, entering a formula into a cell instantly delivers the result. The software, working together with the hardware, performs […]

Software Development in Business Read More »

SQL - WiKon-IT

SQL Server in Business Data

Challenges in Everyday Business Different Data Sources A SQL Server in business helps companies provide important KPIs (Key Performance Indicators), reports, and analyses efficiently.In practice, the required data often comes from different SAP transactions or other sources. Time-Consuming Data Preparation Before meaningful results are available, data must be collected and linked together – a process

SQL Server in Business Data Read More »

VBA - WiKon-IT

Possibilities of VBA: Processes

Microsoft Office is present in almost every company. As long as tasks are standardized, the built-in features of Excel, Access and Outlook are usually sufficient. However, as soon as processes become more complex, involve different data sources or require repetitive steps, the standard functions reach their limits. This is where VBA demonstrates its true value:

Possibilities of VBA: Processes Read More »

VBA und SQL - WiKon-IT

Efficiency with VBA and SQL in Use

Why SQL Is Essential Today In today’s business world, there is no way around SQL. Many companies work with large and complex Excel files that often contain elaborate programming in the background. These structures quickly reach their limits when data volumes increase or when efficient processing is required. This is precisely where SQL provides the

Efficiency with VBA and SQL in Use Read More »

Visual Basic for Applications - WiKon-IT

Visual Basic for Applications (VBA)

Introduction to VBA Visual Basic for Applications (VBA) is a programming language based on Visual Basic and integrated into all Microsoft Office products. I use VBA to expand the standard functions of Excel, Access, Outlook and other applications significantly. This allows me to solve tasks that cannot be managed with built-in tools alone and to

Visual Basic for Applications (VBA) Read More »

Scroll to Top