I have been looking at a lot of Red-Gate's tools for SQL Server and I have to say I am very excited about them. (Maybe I'm just easy to please and enjoy shiny objects... it's possible)<BR><BR>Anyway, ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

The better your SQL database performs, the more effectively it will fulfill its purpose of providing information to the apps and services that rely upon it to function. Optimizing database performance ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual Studio projects and other tools that SSDT ...

Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say. For almost 13 years, Microsoft has tried to make Visual Studio a place where developers can do ...

I have a need to compare multiple different versions of essentially the same SQL Server 2005+ databases and bring the table structures up to that which is in the newest version. It should compare the ...

How Do I Add Business Intelligence To Visual Studio? The Visual Studio 2019 extension can be installed from the Extensions menu… Manage Extensions… Select Online ...