Logo
banner

Blogs

Copying environment variables from one environment to another using SQL query

, October 7, 2022249 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 more

SQL Server > Find a specific value in all the tables of a database using T-SQL

, September 2, 20223028 Views

Often times we find ourselves in a situation where we want to find a particular value but we are unaware of its whereabouts, i.e., we don’t know in which table or column this value is present. Or we want to know in which other tables a particular value is present. Or just if this value […]

Read more

How to quickly match data of two recordsets in SQL Server?

, August 10, 2022387 Views

While working with T-SQL, many times we create complex queries, and then we might need to optimize them at some later point of time to reduce the execution time. This activity always demands an approach to compare data for the older and newer version of the T-SQL. And here comes the question – how do […]

Read more

Would you like to digitize your business and put it on the cloud?
Do you need clear, concise reports for your organization?