Dinesh's Blog :::: Being Compiled ::::

Microsoft SQL Server team has done few releases related SQL Server 2014 and 2012 in last few months. You can download and upgrade your inst...

The latest Preview of Microsoft SQL Server Management Studio is release and it can be downloaded from; https://msdn.microsoft.com/en-...

Many have been working with Microsoft SQL Server for years and most have worked with either Enterprise or Standard edition. Here is a ques...

Apache Hadoop is an open source solution for distributed data processing and storage that consists a cluster of servers for holding data, ...

This concern can be seen everywhere, why my Power Query data sometime appears in Power Pivot but sometime does not appear in Power Pivot? ...

SQL Server support multi-server administration that allows us to distribute jobs across our enterprise, basically across our SQL Servers. ...

Here is the question of the week, it is based on SELECT statements and join mechanism can be used. Assume that you have two tables like b...

Have you heard about a term called Spreadmart ? If you have not, then it is something you should know because your business users might be...

DAX, Data Analysis Expression is a language that can be used with Microsoft Analysis Services tabular data models. It was initially intro...

Report builder is a report authoring tool that is specifically given for business users who are familiar with ribbon-based interface of Mi...

Many use or plan Microsoft Power BI for reporting and dashboard solutions with an assumption that is, Power BI always loads selected data ...

Analysis Services can be installed in one of three modes; Multi-dimensional, Power Pivot for SharePoint, and Tabular. One instance can be ...

Microsoft Power BI, bringing your data to life, yes it is available and can be used FREE :). Power BI is a cloud-based business an...

Are you experiencing this error when trying to deploy reports from SQL Server Data Tools to Reporting Services site? As it says, it c...

I have written few posts on SQL Server Auditing  and they are written based on either Windows Event Log or File  as the target of the Audi...

SQL Server Audit is the main tool for capturing events related to server and databases, and it can record event information to files, Wind...

Creating multi-valued parameters with reports is a common requirement and it can be easily done with Reporting Services, making  Allow mul...

The key reason for implementing OLAP databases is performance related to data retrieval and what if the wrote query does not offer e...

Microsoft SQL Server supports two type of authentication modes; Windows authentication and Mixed authentication. Windows authentication is...

Color expression section of Calculations  tab of Cube Designer  allows us to set Fore Color  and Back Color  for the Calculated Measures/M...

When there is a requirement for granting permission on tables for database users, common or known way of doing it is, granting explicit pe...

We create SQL Server login principal for allowing users to connect with the instance of SQL Server. A standard logins are the most common ...

Well known three functionalities provided by a business intelligence solution are; Drilling down , Drilling through and Slicing and dicin...