• The Excel and SQL Server experts blog

  • Temporal Tables and how to use them in SQL Server

    Andy McDonald - Feb 01, 2024

    If you want to keep track of when changes were made to your data, or see how data changes over time, you need to start using temporal tables in SQL Server. Microsoft introduced this great feature in the 2016 version of SQL Server, but is still relatively unknown. In this article, we’re going to take …

  • SQL Spreads release 7.3.0

    Johannes Åkesson - Jan 31, 2024

    SQL Spreads 7.3.0 is now available for download. Enhanced SharePoint integration for SQL Spreads documents by implementing document locking for Editors. In the SQL Spreads Designer, the database and table filters are now displayed by default in the Database tab. Optimized connectivity with Azure Data Warehouse/Azure Synapse. Refined the introductory dialogues for a more intuitive …

  • Get started with Azure SQL

    Andy McDonald - Jan 26, 2024

    In this article, we’re going to show you how to get started with Azure SQL. Azure SQL is one of the many services offered on Azure, Microsoft’s comprehensive cloud computing platform. And it enables organizations to run workloads and develop applications in regional data centers around the globe. Table of contents 1. Introduction to Azure …

  • Artificial Intelligence Add-Ins for Excel

    Andy McDonald - Dec 06, 2023

    In this third article, in our series about using AI in Excel, we’re going to look at the best third party Artificial Intelligence Add-Ins for Excel that bring the power of AI technology to your spreadsheets. In the past year or so, there has been a great deal of interest in using AI more generally …

  • Excel AI Tools: built-in AI technology in Excel

    Andy McDonald - Dec 02, 2023

    In our second article looking at Excel AI tools, we’re going to look at existing features and functionality in Excel that use AI technology to some extent. Make sure you also check out our earlier article on the new experimental LABS.GENERATIVEAI function. This allows you to send prompts from within Excel to a generative AI …

  • SQL Spreads release 7.2.5

    Johannes Åkesson - Nov 10, 2023

    SQL Spreads 7.2.5 is now available for download. Fixed issue with the new Show intro button being shown in Data Editor mode. Download the latest version of SQL Spreads »

  • SQL Spreads release 7.2.4

    Johannes Åkesson - Nov 08, 2023

    SQL Spreads 7.2.4 is now available for download. Improved the Intro dialogs shown during the first start of the trial. Added a button in the SQL Spreads tab to show the Intro again. Minor bug fixes. Download the latest version of SQL Spreads »

  • Alternative to Microsoft Access: SQL Server + Excel

    Andy McDonald - Oct 12, 2023

    In this article we’re going to look at why you might consider an alternative to a Microsoft Access database for your organization, or specific project. As we’ll see, Access has some limitations that can become a problem eventually. A simple solution is to use a combination of SQL Server and Excel, with the SQL Spreads …

  • Update View in SQL Server using Excel – Step by Step Guide

    Johannes Åkesson - Sep 08, 2023

    In many businesses, it’s common to use Views to present database tables in a user-friendly way. With SQL Spreads, you can update a View in SQL Server from within Excel. SQL Spreads allows you to work with SQL Server Views, making it easy to display data side by side in Excel, similar to any other …

  • AI in Excel: the LABS.GENERATIVEAI function

    Andy McDonald - Aug 30, 2023

    Excel is a powerful tool for data analysis, but did you know that there is a new function that provides the power of generative AI in Excel. The experimental LABS.GENERATIVEAI function allows you to send prompts from within Excel to a generative AI model and then return the results from the model back to your …

  • Page 1 of 1012345»...Last »