Updating data in SQL Server is a common task for business users who need to ensure their data remains accurate and up-to-date. This guide will walk you through the process of using the ‘UPDATE’ statement in SQL Server, providing easy-to-follow steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding …
The Excel and SQL Server experts blog
-
How to perform an UPDATE in SQL Server
Johannes Åkesson - Jun 28, 2024 -
How to insert data from Excel to SQL Server
Johannes Åkesson - Jun 04, 2024Most 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, 2024In 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, 2024We’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, 2024In 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, 2024If 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, 2024SQL 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, 2024In 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, 2023In 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, 2023In 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 …
