Month: January 2019

First published on MSDN on Sep 15, 2017

There are multiple ways to integrate or embed SQL Reporting Services Report in an application. This can be achieved via:-

URL Access Method

Usin… Continue reading SQL Server Reporting Services 2016 Integration with an Application→

First published on MSDN on Sep 01, 2017

Analysis Services has been progressing day-by-day with new exciting features and there is an ask from the users to automate the Azure Analysis Services Processing. There are few ways which … Continue reading Automating Azure Analysis Service Processing using Azure Automation Account→

First published on MSDN on Apr 28, 2015

SQL Server allows a user to control max degree of parallelism of a query in three different ways.   Just for references, here is a list of documentation:

SQL Server wid… Continue reading Server’s “Max Degree of Parallelism” setting, Resource Governor’s MAX_DOP and query hint MAXDOP–which one should SQL Server use?→

First published on MSDN on Aug 29, 2017

Cluster Quorum File Share Witness Should Not be Part of a DFS Namespace

When deploying AlwaysOn availability groups you may decide to add a vote to Windows Cluster quorum by configuri… Continue reading Avoid Availability Group Database Data Loss: Do not Deploy File Share Witness From DFS Namespace→

First published on MSDN on Aug 04, 2017

Reporting Services Reports that contain Bing Maps seem to broken due to a change in the Bing Map APIs. From the initial analysis, Bing Maps SOAP web service seems to be shut down after July 31, 2… Continue reading SSRS – Bing Maps seem to be broken with latest changes in Bing Map Service→

First published on MSDN on Aug 01, 2017

Over this blog, I would like to discuss about one of the interesting issues that we had worked upon recently. Here we are having a SSIS package that uses the OData Source Connection manager to co… Continue reading OData source connection manager to PWA (Project Web App) – Project Online URL fails with “(401) Unauthorized”→

First published on MSDN on Jul 26, 2017

With codeplex shutting down, we have moved SQL Nexus to github with a new release (6.0).   Now both

Pssdiag/SQLDiag manager

and

SQL Nexus

are on github… Continue reading SQL Nexus 6.0 is released to github→

First published on MSDN on Jul 07, 2017

Hello Everyone, in this blog I am going to discuss about an interesting scenario while working on a customer issue recently related to Client Printing of SSRS Reports.

Scenario:

… Continue reading Dynamically enable or disable the report printing option on the client side→