Johannes Åkesson, Author at SQL Spreads

How to Update an SQL Table from Excel: Easiest Method
May 23rd, 2025

People in Business Intelligence, Data Analytics and other data projects often know how to update data in SQL Server — but find it time consuming or frustrating. We hear from IT and BI teams that they spend time writing scripts, building custom web applications, or even manually updating data in SQL Server to fulfill requests …
SQL Spreads release 7.7.0
May 23rd, 2025

This release includes several improvements to the trial experience, along with a few smaller fixes to enhance usability and stability across the application.
Top 5 Profisee Alternatives: 2025 edition
Feb 15th, 2025

Profisee offers thorough MDM capabilities for larger companies looking for a potentially more affordable alternative to the industry giants. However, compared to its competitors, it can still prove a tough buy-in, leaving users to look for better options. SQL Spreads emerges as a top alternative for teams looking for an effective – and cost-efficient – …
SQL Spreads release 7.6.3
Jan 31st, 2025

In this release, we have made several improvements to Forecasting and KPI data collection scenarios. We have also added the long-awaited feature that allows using Excel formulas to calculate values saved back to SQL Server.

Additionally, we have introduced an automatic check for new SQL Spreads updates and simplified the process of sending details to SQL Spreads support.
Top 5 Vena Solutions Alternatives for FP&A
Jan 27th, 2025

Are you looking for a more streamlined FP&A and financial forecasting solution than Vena Solutions? In this article, we’ll show you five top Vena alternatives that can help your finance team budget and plan more effectively – and reveal how SQL Spreads not only makes the switch straightforward, but also offers the flexibility and value your …
How to insert data from Excel to SQL Server
Jan 20th, 2025

Most people do not know that there is a really simple way to copy and paste data from Excel to SQL Server. In this article, I will show you what you need to know to copy and paste data from Excel to SQL Server.
I will go through and show the technique using simple step-by-step instructions, and I will also cover a few special cases that are great to know.
Top Devart Excel add-in alternatives in 2025
Jan 8th, 2025

Is Devart falling short on essential safeguards in your needs for secure and reliable SQL data management? Many teams have looked for alternatives to Devart’s Excel add-ins because of security limitations and lagging performance. Plenty of these users found SQL Spreads to be an excellent alternative, highlighting its intuitive approach to role-based permissions and faster …
Top CData Excel Add-in Alternatives in 2025
Dec 23rd, 2024

Is CData proving too complex or not user-friendly enough for your SQL data management needs? You’re not alone. Plenty of our users migrated to SQL Spreads from CData’s Excel add-in, attracted by an exceptionally intuitive interface and the promise of a leaner stack. Here’s everything you need to know about the top CData competitors this …
Top Alternatives to Microsoft MDS in 2025
Nov 22nd, 2024

Are you looking for an effective solution for master data management as Microsoft Master Data Services approaches its end of life? We’ll walk you through these top alternatives as MDS replacements that offer robust features tailored to your organization’s unique data management needs – and show you how SQL Spreads not only makes the transition …
Top Alternatives to Microsoft Power Apps for SQL Data Management in 2024
Nov 15th, 2024

Looking for a way to simplify SQL data management? Check out these top Power Apps alternatives that make it easier to build SQL data management solutions without requiring excessive technical skills and suited to your organization’s unique needs. Microsoft Power Apps – a major market player Microsoft Power Apps is a development platform that – …
SQL Spreads release 7.5.6
Sep 17th, 2024

SQL Spreads 7.5.6 is now available for download. Resolved an issue with the new setting for lookups, enabling the creation of dependent drop-down lists. Download the latest version of SQL Spreads »
SQL Spreads release 7.5.5
Sep 13th, 2024

SQL Spreads 7.5.5 is now available for download. Fixed issue with connecting to Azure using Azure AD Authentication Download the latest version of SQL Spreads »
SQL Spreads release 7.5.4
Sep 3rd, 2024

We’re excited to announce the release of SQL Spreads 7.5.4, which focuses on improving the Tree Filters and Intro dialogs, as well as addressing various bug fixes. New Features and Enhancements Redesigned Introductory Dialogues: We have redesigned the introductory dialogues to provide a more intuitive user experience. This includes a new option to restart the …
How to perform an INSERT in SQL Server
Aug 1st, 2024

Inserting data into SQL Server is a fundamental operation for business users who need to add new records to their databases. This guide will walk you through the process of using the INSERT statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding the …
How to perform a DELETE in SQL Server
Aug 1st, 2024

Deleting data in SQL Server is a critical operation for business users who need to remove obsolete or incorrect records from their databases. This guide will walk you through the process of using the DELETE statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). …
Page 1 of 312 3 »