SQL Server

Featured
Conditional Formatting In Power BI with Rules

How to Do Conditional Formatting In Power BI with Rules – Font Color Scales

In PowerBI, conditional formatting was a capability that was included in the November 2017 update. In PowerBI, there is a feature summary update, where there are new features...

Featured
Internet Facing Deployments

SQL Server Licensing Internet Facing Deployments & External Connector

If you are looking for SQL Server Licensing details for Internet Facing Deployments, let us try to help you out! If you have an Internet-facing application which has an unknown...

Featured
SQL Server MSDTC Support

SQL Server MSDTC Support for Always On Availability Groups Cross DB

Since there is very little information available on SQL Server MSDTC Support for high availability scenarios, I thought I would write a quick post on the subject. You can check...

Featured
SQL Server 2017 Windows System Requirements

SQL Server 2017 Windows System Requirements & Software Prerequisite

If you are ready to install SQL Server 2017, you will need to know the minimum requirements first. The SQL Server 2017 Windows system requirements are mostly unchanged when...

Featured
SQL Server 2017 Editions

SQL Server 2017 Editions & Supported Features on Windows & Linux

Microsoft has released SQL Server 2017 Editions to the public for general availability. Its predecessor, SQL Server 2016 has been widely successful. SQL Server 2016 was a...

Featured
Power BI Service Desktop & Embedded Interview Questions and Answers

Power BI Service Desktop & Embedded Interview Questions and Answers

In this post, we are going to post about Power BI Service Desktop & Embedded Interview Questions and Answers. As per Gartner’s magic quadrant report, Microsoft is one of...

Featured
How to Create Troubleshoot and Resolve PowerBI Gateway Issues

How to Create Troubleshoot and Resolve PowerBI Gateway Issues

PowerBI gateway enables Enterprises to connect to their on-premises data sources without having to setup any VPN or open firewall ports. Since the Power BI gateway uses...

Featured
What are the Differences between MDX and DAX

What are the Differences between MDX and DAX

Question: What are the Differences between MDX and DAX?

Featured
What are the differences between OLTP and OLAP Systems

What are the differences between OLTP and OLAP Systems

Question: What are the differences between OLTP and OLAP Systems Answer: In a production environment, OLTP system deals with high number of transactions, i.e....

Featured
What is the Business Intelligence Project Lifecycle

What is the Business Intelligence Project Lifecycle

What is the Business Intelligence Project Lifecycle Question: Define what is the business intelligence project lifecycle. Explain all the phases in detail with examples....