image

How to Backup Microsoft SQL Database by Using Transact-SQL

Create a full database backup by executing the BACKUP DATABASE statement to create the full database backup, specifying: The name of the database to back up.The backup device where the full database backup is written.The backup options like COPY_ONLY, COMPRESSION, etc. COMPRESSION will be very helpful to reduce the backup size.COPY_ONLY is very useful for Read More

image

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

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

image

What is Azure SQL Edge?

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

image

Automate Backup Microsoft SQL Server Express Databases

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

image

How to Fix “Data type errors” in Power BI

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

image

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

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