• The Excel and SQL Server experts blog

  • How to insert data from Excel to SQL Server

    Johannes Åkesson - Jun 04, 2024

    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 Build a KPI Dashboard with Power BI

    Andy McDonald - May 21, 2024

    In this article, we’re going to show you how to build a KPI dashboard in Power BI for managers. The example we’ll work through uses our KPI data collection template, used by operational level administrators to collect KPI metrics. This template was built with SQL Server, Excel and the SQL Spreads Excel Add which is …

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

  • Page 1 of 1012345»...Last »