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

image

COUNTROWS vs COUNT vs COUNTA

As a data modeler, sometimes you might need to write a DAX expression that counts table rows. The table could be a model table or an expression that returns a table. Your requirement can be achieved in two ways. You can use the COUNT function to count column values, or you can use the COUNTROWS function to count table Read More

image

What is the Difference Between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches Read More