MS SQL Server Archives - Microsoft Business Intelligence

Leveraging SQL Schema Compare in Visual Studio for Efficient Database Management

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… Continue reading Leveraging SQL Schema Compare in Visual Studio for Efficient Database Management

Travel Insurance Industry’s Email Problem

The one thing that anyone working in the travel insurance industry will say is difficult to deal with is the number of emails that they receive. They may hit that sweet spot, the magic number of people that is just right for this task, but they may not be aware of a hidden problem that… Continue reading Travel Insurance Industry’s Email Problem

Copying environment variables from one environment to another using SQL query

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… Continue reading Copying environment variables from one environment to another using SQL query

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

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… Continue reading Microsoft SQL Server > Find a specific value in all the tables of a database using T-SQL

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

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… Continue reading How to quickly match data of two recordsets in SQL Server?