• SQL Spreads Blog

  • Master Data Services Excel Add-in: What to Know and Alternatives

    Andy McDonald - Dec 06, 2021

    In 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 …

  • Master Data Management: What is it and Why is it Important?

    Andy McDonald - Dec 02, 2021

    Master Data Management (MDM) is an information management discipline focusing on data quality and data governance. Its goal is to mitigate problems caused when Master Data is inconsistent, fragmented, or out of date. In this article, we’re going to explain what MDM is and provide some tips on how to start an MDM journey. Table …

  • Simple Data Validation in SQL

    Andy McDonald - Oct 24, 2021

    What is data validation in SQL and why is it important?  Data validation is a method for checking the accuracy and quality of data.  Information in databases is constantly being updated, deleted, queried, or moved by multiple people or processes, so ensuring that data is valid at all times is essential. In this article, we’re …

  • How to create Pivot Tables in SQL Server

    Andy McDonald - Oct 10, 2021

    In this article, we’re going to show you how to create pivot tables in SQL Server.  This is the third article aimed at teaching Excel users some basic SQL server queries, and how to mimic some of the main functions used in Excel. In a previous article we looked at the equivalent of Excel’s VLOOKUP …

  • How to Export Data from SQL Server to Excel

    Andy McDonald - Aug 26, 2021

    In a previous article, SQL and Excel: Why you need both, we showed that for many businesses the use of both SQL Server and Excel is an optimum approach to data management.  For organizations that use SQL Server and Excel extensively, there is often a need to export data from SQL Server to Excel.  The …

  • What’s new in SQL Spreads 5.0?

    Johannes Åkesson - May 07, 2020

    SQL Spreads 5.0 is the largest update in over two years, with several new and exciting improvements. We have implemented a couple of long-anticipated features, such as: We have also implemented several changes to improve how you can develop and deploy SQL Spreads documents: To try SQL Spreads 5.0, you can download the 14-day free …

  • What’s new in SQL Spreads 4.4?

    Johannes Åkesson - Feb 01, 2019

    We are proud to announce the release 4.4 of SQL Spreads – the solution for easily letting your non-technical people manage and update data in SQL Server using Excel. In this article, we will shortly describe what’s new in this release. A complete list of the changes in SQL Spreads release 4.4 can be found …

  • Happy Holidays from the SQL Spreads team

    Johannes Åkesson - Dec 18, 2018

    This year has been a successful year for SQL Spreads thanks to our fantastic customer and partners. There are now more than 200 customers in over 30 countries that use SQL Spreads to simplify for their non-technical users to update and manage their important data stored in Microsoft SQL Server. We would like to thank …

  • SQL Spreads exhibiting at PASS SQL Saturday

    Johannes Åkesson - Sep 01, 2015

    I am excited to announce that SQL Spreads is sponsoring the PASS SQL Saturday event in Gothenburg at September 5th. PASS is the global community for sharing knowledge and insights in the data analytics and business intelligence technologies on the Microsoft platform. Read more about the event >>

  • Introducing the new Table Wizard

    Johannes - Sep 08, 2014

    We are proud to announce the release of SQL Spreads 2014 with the completely new Table Wizard. The Table Wizard makes it extremely simple to create an Excel document which can be used to Update, Insert or Delete data in a SQL Server table. The Wizard contains five screen: When clicking Finish, SQL Spreads will load the …