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 […]

(1)

You rated this post out of 5. Change rating

2019-08-13

3,909 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)

You rated this post out of 5. Change rating

2019-05-10 (first published: )

4,403 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

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

AI: Blog a Day – Day 7: Vector and Vector Databases

By

Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...

AI: Blog a Day – Day 6: Embeddings – How AI Understands

By

Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...

Read the latest Blogs

Forums

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Restoring On Top I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Restoring On Top I

Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers

By mehul.bhuva@gmail.com

Comments posted to this topic are about the item Designing Delta Tables with Liquid...

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers