SQL Spreads 7.1.2 is now available for download. In this new release we are introducing the new SQL Server tools which allows you to do more SQL Server operations from within Excel. The SQL Server tools contains these three features: The Table Creator – to create SQL Server tables based on data in Excel. The …
The Excel and SQL Server experts blog
-
SQL Spreads release 7.1.2
Johannes Åkesson - Jul 14, 2023 -
SQL Spreads: a front end for SQL Server
Andy McDonald - Jul 05, 2023There are several options available if you are looking for a front end for SQL Server. Like most things, what is best for you will depend on a number of factors. In this article, we’re going to look at the things to consider when choosing a front end for SQL Server and how the SQL …
-
Master Data Services Excel Add-in: What to Know and Alternatives
Andy McDonald - Jun 20, 2023In a previous article, we provided an overview of Master Data Management (MDM). In this article, we’re going to look at Microsoft’s platform for supporting the discipline of MDM: “Master Data Services”. Specifically, we’re going to look at how the Master Data Services Excel Add-in can be used to organize your MDM data models and …
-
SQL Spreads release 7.0.8
Johannes Åkesson - May 29, 2023SQL Spreads 7.0.8 is now available for download. This release fixed a couple of minor issues. Fixed issue with columns with data type Time not updating correctly. Fixed issue with Change tracking not working when only one of the ModifiedBy or ModifiedOn was used. Fixed issue with labels for number of loaded rows not shown …
-
Tree Filters in Excel: an easy way to view and filter SQL data
Andy McDonald - May 11, 2023With the rise of data democratization in the workplace, more people across the organization are working with datasets on a day-to-day basis. SQL Spreads makes this easier for people by letting them use Excel to update and manage data in SQL Server. One of the reasons people enjoy working in Excel is the familiarity of the UI …
-
SQL Spreads release 7.0.5
Johannes Åkesson - Mar 30, 2023SQL Spreads 7.0.5 is now available for download. The new SQL Spreads 7.0 has two major improvements: The first improvement is the batch processing of updates, inserts and deletes from Excel to the SQL Server. We have measured speed improvements of up to 18 times with this new release, compared to the older 6.2 release. …
-
Cleansing data in SQL Server
Andy McDonald - Jan 30, 2023We come across ‘dirty’ data all the time. It’s one of the realities of working with data on a regular basis. With the rise of data democratization in the workplace, more people across the organization are exposed to the problem of dirty data and are also more likely to be involved in the cleansing process. …
-
SQL Spreads release 6.2.15
Johannes Åkesson - Dec 22, 2022SQL Spreads 6.2.15 is now available for download. Improved Intro screens shown during first time start-up. Fixed issue when moving columns if Excels table header filters are turned off. Fixed issue with items with quotes not working in Fixed List Lookups. Fixed issue when switching server when the document has key Lookups. Fixed issue with …
-
How a Business Analyst can help with data conversion projects
Andy McDonald - Nov 25, 2022Businesses today are required to manage more data than ever before. Change is also occurring at a faster rate. Organizations therefore need to be agile with regard to data management and this means being able to move data around from one system to another or between parties with relative ease. In this article we’ll discuss …
-
Master Data Management Tools for Azure
Andy McDonald - Nov 07, 2022Maintaining a “single source of truth” is critical for all organizations. The discipline of Master Data Management (MDM) is one of the means to achieve this. In this article, we’re going to look at some Master Data Management tools for Azure. Introduction Master Data Management (MDM) is an information management discipline focusing on data quality and …
Product
Key features
Use Cases
Compare SQL Spreads
Resources
Doc
Support
Company
Subscribe for updates
×
×