I have updated SSMS to v18.5 and then uninstall SQL Search, downloaded the latest one and installed. SSMS started, I click button "SQL Search" - no any errors/exceptions but SQL Search does not st...

I have been using Redgate SQL Prompt so far. But I came to know about ApexSQL Complete which has the same features and is FREE!. Has anyone used both the tools and has any idea if ApexSQL Co...

We have been looking into possible solutions for our SQL Source control. I just came across Red Gates SQL Source control and wondered if anyone has implemented it? I am going to download the trial ...

I'm developing a database using the Red Gate SQL Developer tools. SQL Test, the SSMS add-in that runs tSQLt tests, lacks a way to rename test classes. I have a test called [BackendLayerCustomerAdm...

When I compare the 2 databases with the Red Gate's SQL compare then getting below error. "ExecuteReader: CommandText property has not been initialized" I am using the SQL server 2012 express and R...

I have a big SQL file that does not fit into memory and needs to be executed against Microsoft SQL Server 2008. It seems that the sqlcmd.exe tool always loads it into memory first which is impossib...

I'm looking for a way to validate the SQL schema on a production DB after updating an application version. If the application does not match the DB schema version, there should be a way to warn the...

I am running a large ASP.net 4.0 website. It uses a popular .Net content management system, has thousands of content items, hundreds of concurrent users - is basically a heavy website. Over the co...

I used to love .NET Reflector back in the day, but ever since Red Gate Software took over it has gone downhill dramatically. Now it forces me to update (which is absolutely ridiculous), half ...

Our team is using Red-Gate SQL Source Control as our database CM tool. After performing a quick test to determine how linking static data affects the speed of SQL Source Control, I got the followi...

The Redgate tool SQLTest for SQL unit testing now offers the ability to add tests from SQLCop however the Redgate tool only comes with few of those tests prebuild. Since tests are just stored pro...

I've just inherited an SQL Server database. One of the things I will need to sort out is versioning and automated builds. It has been suggested that I should think seriously about recommendi...

I've got a database change management workflow in place. It's based on SQL scripts (so, it's not a managed code-based solution). The basic setup looks like this: Initial/ Generate Initial Schem...

I have a WindowsForms app that appears to leak memory, so I used Redgate's ANTS Memory Profiler to look at the objects I suspect and find that they are only held by objects already on the Finalizer...