Tag: SQL Server
Add custom fonts in SSRS Report
Inkey, February 13, 20242830 Views
Adding custom fonts in SSRS or SQL Server Reporting Services is a powerful way to personalize and enhance the visual appeal of your reports. This process involves selecting a distinct typeface that aligns with your brand identity and integrating it seamlessly into your SSRS environment. Let’s explore how the addition of a custom font can […]
Read moreLeveraging SQL Schema Compare in Visual Studio for Efficient Database Management
Admin, January 2, 20241864 Views
In the dynamic landscape of database management, maintaining and evolving database schemas is a critical aspect. Visual Studio provides a powerful platform for managing these tasks efficiently. In this blog post, we’ll explore the ins and outs of using SQL Schema Compare for altering, creating, and deleting objects, and discuss why Visual Studio is a […]
Read moreCopying environment variables from one environment to another using SQL query
Inkey, October 7, 20223100 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, 20223470 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, 20217028 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 moreMicrosoft Business Intelligence: SSRS > Shared Dataset > Not detecting NEW fields > a simple fix
Inkey, April 20, 20209762 Views
For many reasons, we may feel the need of bringing additional fields to the SSRS dataset. A common issue faced when using SSRS i.e. Microsoft Business Intelligence 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 […]
Read more
