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

Few days back, I wrote an article on SQL Server default behavior when it expands files with AutoGrowth enabled. Where there are multiple f...

As per the announcement made by Microsoft on Power BI early this month,  Following things will be changed on Power BI Free account; ...

When the relational model was introduced, in order to work with the model or in order to retrieve or update data in the model, languages w...

Here is another issue I experienced today with bcp utility (see my previous post related to this:  SQL Server bcp Error - Invalid ordinal ...

We still use bcp  utility for importing or exporting data, specifically when we have to work with large amount of data (I have written pos...

We add multiple data files to file groups to get data distributed (it is always better to get them distributed among multiple physical vol...

We have been writing DAX queries using MDX Query Editor whenever we need to do something with Analysis Services Tabular Model databases (R...

A new option has been added to Management Studio - Quick Launch  for enabling Presentation Mode  on and off. This is really useful during ...

Have you noticed an input box called Quick Launch  at top-right corner of the Management Studio ? Have you used it? Do you know that why i...

Power BI supports three types of connectivity: Import, DirectQuery and Live Connection . We generally use DirectQuery  if the dataset is l...

Yesterday, I posted on an error related to Reporting Services. Here is another error related to Reporting Services encountered at one of m...

What if you suddenly experience this when you open the Reporting Services Portal? HTTP Error 404. The requested resource is not found....

Showing Cumulative or Running Totals is not an uncommon requirement in reporting, hence it is required with almost all reporting solutions...

When we face an issue with SQL Server or any other software, we simply think that either restart of the server or service would solve the ...