Tag: SQL Server
Copying environment variables from one environment to another using SQL query
Inkey, October 7, 2022577 Views
As any developer, one always follows the cycle of deployment using different environments, i.e., DEV (for development phase or the underground lab) -> UAT (for testing phase or Racoon city) -> PROD (for real-time application or the world). In SSIS also, we are able to deploy the same SSIS package in 3 different environments, but […]
Read moreMigrate Audit records from Dynamics 365 CRM to Azure SQL Server
Inkey, May 12, 20221832 Views
Storage space comes at a premium in Dynamics 365 world. So, we need to manage it carefully and aggressively. When audit is enabled, the space it occupies creeps up steadily and silently and we only notice it when we get a message from Microsoft telling us we have run out of storage space. So, a […]
Read moreUpdating the SQL DataSource from Power BI using Power Automate Visual
Inkey, August 6, 20214355 Views
Ever thought of manipulating the data in your SQL data source directly from the Power BI Report? If yes, our prayers have been heard (as the use of Power Automate within Power BI is still in Preview as of writing this blog) and will be answered soon (when made GA)! An exciting new feature was […]
Read moreSSRS > Shared Dataset > Not detecting NEW fields > a simple fix
Inkey, April 20, 20206383 Views
For many reasons, we may feel the need of bringing additional fields to the SSRS dataset. A common issue faced when using SSRS shared datasets is when we change the backend query to bring additional fields for reporting, the dataset fails to recognize this change. Let us try to regenerate this issue to understand this […]
Read more
