Category: SQL

MicrosoftTeams-image

How to Fix Cannot Install OLE DB Driver – Keep Asking for Visual c++ Redistributable

Posted on by Summa Lai

I am trying to use Visual Studio 2022 to successfully load and build an SSIS package that targets SQL Server 2016. Documentation suggests that this is indeed supported. Per the online docs (https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16), I have used the visual studio installer to add in the SQL Server Data Tools. Then I have installed the SSIS extension. Read More

MicrosoftTeams-image

What is Azure SQL Edge?

Posted on by Summa Lai

Azure SQL Edge is an optimized relational database engine geared for IoT and IoT Edge deployments. It provides capabilities to create a high-performance data storage and processing layer for IoT applications and solutions. Azure SQL Edge provides capabilities to stream, process, and analyze relational and non-relational such as JSON, graph and time-series data, which makes Read More

MicrosoftTeams-image

Automate Backup Microsoft SQL Server Express Databases

Posted on by Summa Lai

by John Litchfield Have you ever attempted to setup an automated backup of your SQL Server Express database server, only to discover that the handy job scheduler maintenance options that you are accustomed to using with the full version of SQL Server are not available with the express edition? After a brief search of Google, Read More

MicrosoftTeams-image

How to Fix “Data type errors” in Power BI

Posted on by Summa Lai

Sometimes, when you import data into Power BI, the columns appear blank. This situation happens because of an error in interpreting the data type in Power BI. The resolution to this error is unique to the data source. For instance, if you are importing data from SQL Server and see blank columns, you could try Read More

MicrosoftTeams-image

How to Create a User with Access to a Specific Database Only in Azure SQL

Posted on by Summa Lai

In this exercise, you’ll create logins, users, and admins, and you’ll grant Azure Active Directory (Azure AD) users access to the database, as you would for normal users in SQL Server. Open SQL Server Management Studio (SSMS), and connect to your Azure SQL Database server, if you aren’t already connected. After you’ve configured and connected Read More