• The Excel and SQL Server experts blog

  • SQL Spreads release 7.4.1

    Johannes Åkesson - Mar 29, 2024

    We’re excited to announce the latest enhancements and fixes in SQL Spreads to make your data management experience smoother and more secure. Here’s what’s new in SQL Spreads 7.4.1: Enhanced Tree Filters: Tree Filters have been improved and are now shown only for individual Excel sheets, and changes in a Tree Filter only refresh the …

  • Use Case: How to build a KPI Excel template with SQL Server

    Andy McDonald - Mar 06, 2024

    In this article, we’re going to show you how to build a KPI Excel template using SQL Server and an Excel Add-In. Many organizations collect performance metrics related to aspects of their business and then use KPIs to measure and track performance against targets. However, the process of collecting the data is often a manual …

  • 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. Introduction to Azure SQL Azure SQL is …

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

  • Page 1 of 1012345»...Last »