• SQL Spreads Blog

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

  • How to Update an SQL Table from Excel

    Johannes Åkesson - Nov 26, 2021

    If you want to easily let your non-technical users update and manage SQL Server data from Excel,click here to download the SQL Spreads Excel Add-In. SQL Spreads solves some common data management problems for Microsoft SQL Server. It makes it fast and simple to update an SQL table from an Excel spreadsheet. And it gives …

  • SQL Spreads release 6.0.44

    Johannes Åkesson - Oct 29, 2021

    SQL Spreads 6.0.44 is now available for download. This new release focus on stability improvements – we have made a number of stability improvements and fixes in the areas around Excel table formatting, detection of changes in SQL Server etc. Added the possibility to set a Default value for a column to use when a …

  • 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 insert data from Excel to SQL Server

    Johannes Åkesson - Oct 10, 2021

    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.

  • How to create Pivot Tables in SQL Server

    Andy McDonald -

    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 …

  • What is the equivalent to VLOOKUP in SQL?

    Andy McDonald - Sep 11, 2021

    In this article, we’re going to show you how to perform the equivalent of Excel’s VLOOKUP in SQL.  This is the second of our articles aimed at teaching Excel users the basics of SQL. In our previous article “Introduction to SQL for Excel Users”, we introduced the JOIN statement, and here we’re going to expand …

  • Introduction to SQL for Excel Users

    Andy McDonald - Aug 27, 2021

    This is the first of several articles on SQL for Excel users.  The aim is to show you why it’s so useful for Excel users to be familiar with SQL and to introduce some basic concepts and queries. Why is it important to learn SQL? In a previous article, SQL and Excel: Why you need …

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

  • SQL Server Import and Export Wizard Guide

    Andy McDonald - Jul 20, 2021

    What is the SQL Server Import and Export Wizard? SQL Server Import and Export Wizard is a simple way to copy data from a source to a destination.  It is most commonly used to get data into or out of a SQL Server database, but it caters to several scenarios. Although like most Microsoft wizards …

  • Page 1 of 612345»...Last »
Envelope Iconsmall picture of an envelope signifying email Need help?