RedGate

SQLServerCentral Article

Redgate Takes over the SQLCop Project

  • Article

I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop. This should be considered the official repository for the code from this point […]

5 (1)

You rated this post out of 5. Change rating

2019-08-13

3,859 reads

External Article

How to create and refresh development and test databases automatically, using SQL Clone and SQL Toolbelt

  • Article

Phil Factor shows how a set of Redgate tools can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers. Before tearing down and rebuilding a database to a new version, we take care to save any DDL changes made to the existing copy.

2019-04-10

SQLServerCentral Article

Database Cloning Tools in Lower Environments

  • Article

With exciting products like SQL Clone making their debut, the DBA will need to think through the approach to implementing such powerful tools. Done properly, these tools will provide a massive benefit to both the DBA and developer.

3.67 (3)

You rated this post out of 5. Change rating

2019-05-10 (first published: )

4,352 reads

Technical Article

Redgate Data Tools in Visual Studio 2017 Enterprise

  • Article

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.

You rated this post out of 5. Change rating

2017-03-09

5,294 reads

Blogs

T-SQL Tuesday #181: A Technology Present

By

It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...

Trace Flag 3625 Follow Up

By

Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

ESP Scheduling Tool

By Brandie Tarvin

Has anyone ever used Broadcom's ESP Scheduling tool? I have questions regarding it and...

Group records during capture

By Bruin

I have a table which is being written to by another application. A few...

Peer review SQL Central articles

By Srinivasarao Daruna

Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...

Visit the forum

Question of the Day

Getting ANY of the data

I have this data in two tables:

-- Beer table
BeerIDBeerNamebrewer
5Becks    Interbrew
6Fat Tire   New Belgium
7Mac n Jacks  Mac & Jack's Brewery
8Alaskan AmberAlaskan Brewing 
9Kirin        Kirin Brewing

-- Beercount table
BeerName      BottleCount
Becks         5
Fat Tire      1
Mac n Jacks   2
Alaskan Amber 4
NULL          7
Corona        2
Tsing Tao     4
Kirin         12
What is returned from this query?
SELECT *
FROM dbo.BeerCount AS bc
WHERE bc.BeerName=ANY
  (SELECT b2.BeerName FROM dbo.Beer AS b2);
 

See possible answers