SQL | Summa Lai

How to Download OData Source to SQL or a TXT File in SSIS

Posted on November 26, 2021November 26, 2021 by Summa Lai

Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory This tutorial walks you through the process to extract the Employees collection from the sample Northwind OData service (https://services.odata.org/V3/Northwind/Northwind.svc/), and then load it into a flat-file. 1. Create an Integration Services project Launch SQL Server Data Tools or Visual Studio. Click File, point to New, and click Project. In the New Project dialog box, Read More

Difference between Oracle, SQL Server, MySQL, and PostgreSQL

Posted on August 19, 2021August 19, 2021 by Summa Lai

Oracle, SQL Server, MySQL 5 and PostgreSQL are the most commonly used databases and people normally get caught in the comparison between them. The inability to work around all aspects of comparison becomes a limitation and leads to indecisiveness about which database to use. Here is a comparison of the all the four in a Read More

How to Alter column size in SQL Server

Posted on July 30, 2021July 30, 2021 by Summa Lai

If you’re using SQL Server, and you want to use T-SQL to change the size of an existing column, this article can help. By “changing the size of an existing column”, I mean changing the data size. For example, say you have a varchar(255) but you want to increase its size to varchar(500). Here’s what you need to do in that Read More

How to Find New Tables in SQL Server with SSMS

Posted on July 23, 2021July 25, 2021 by Summa Lai

Solution 1 – First thing to try Try: “Edit > Intellisense > Refresh local cache” Keyboard shortcut: Ctrl + Shift + R After adding lots of tables, SSMS gets out of sync at times… Solution 2 In this article I’d like to show you how you can find newly created tables in SQL Server Management Studio. Read More

How to Change Power BI Data Source From MS SQL Server to Excel

Posted on May 20, 2021May 20, 2021 by Summa Lai

Changing Power BI data source from MS SQL Server to Excel for Power BI file

How to Fix The “Microsoft.ACE.OLEDB.16.0 Provider is not registered on the local machine.”

Posted on May 9, 2021May 9, 2021 by Summa Lai

A popular issue in importing the data which is in Microsoft Excel 2016 to MSSQL via SSMS (Management Studio). It throw an error : “=================================== The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data) To fix this, First thing first, install “Microsoft Access Database Engine 2016 Redistributable.” https://www.microsoft.com/en-us/download/details.aspx?id=54920 And then also check the Read More