SQL Server

Featured
Unable to create databases in SQL Server Management Studio 2016

Unable to create databases in SQL Server Management Studio 2016 For Dynamic 365

While working on the “Bring Your Own Database to Azure” functionality in Microsoft Dynamics 365 for Finance and Operations, Enterprise Editions/Microsoft Dynamics 365...

Featured
Exporting SSRS Key to Azure Key Vault

Exporting SSRS Key to Azure Key Vault for Scale-Out Deployments

You will have to agree that managing so many encryption keys for SQL Server could be a tedious job. With Azure Storage Value, storing and distributing keys is even more...

Featured
BYOL SQL License to Existing Azure VM

How to Apply BYOL SQL License to Existing Azure VM on Cloud IAAS

In case if you are looking to apply BYOL SQL License to Existing Azure VM, then this post is for you. If you or your customer have an Enterprise Agreement or Software Assurance...

Featured
PowerBI Trace File FlightRecorderCurrent.trc

PowerBI Trace File FlightRecorderCurrent.trc: Where and How to Find it

Learn how and where you can find out the PowerBI Trace File FlightRecorderCurrent.trc for debugging and troubleshooting. PowerBI Trace File FlightRecorderCurrent.trc PowerBI...

Featured
SQL Server Analysis Services Performance Tuning on Azure Virtual Machines

SQL Server Analysis Services Performance Tuning on Azure Virtual Machines

In this post, we will be covering SQL Server Analysis Services (SSAS) Performance tuning best practices on Azure with a bit of detail. Do note that we are referring to running...

Featured
Row Level Security in PowerBI Desktop

How to do Row Level Security in PowerBI Desktop and PowerBI Service

This post explains the implementation of Row Level Security in PowerBI Desktop and PowerBI Service, in detail. What is Row Level Security in PowerBI Desktop? Row Level...

Featured
Quick Insights is a very useful feature available in the PowerBI Service that can be used to get various insights to sub-sets of a dataset

What are Quick Insights in PowerBI Service: Know More

Quick Insight is an advantageous feature available in the PowerBI Service that can be used to get various insights to sub-sets of a dataset. It runs a set of machine learning...

Featured
Q&A in PowerBI: Using Ask a Question feature in PowerBI

Q&A in PowerBI: Using Ask a Question feature in PowerBI

Ask a Question was a feature added in the December 2017 Update (Q&A in PowerBI) of Microsoft PowerBI. This is a feature available as a part of the Q&A capabilities in...

Featured
Bookmarks in PowerB

Bookmarks in PowerBI: How to Set For Desktop and PowerBI Service

Bookmarks in PowerBI was a capability that was introduced in the October 2017 PowerBI Feature update, but with the December 2017 update, the bookmark capabilities have been...

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...