SQL Server Restore Database Options and Examples
In this article we look at different SQL Server backup types and schedules and the steps to take to properly restore a database.
2021-07-12
database
The key to great database CI is disposable databases
Redgate engineer Matthew Flatt talks about the challenges of database Continuous Integration and what you need to do to become great.
2021-07-09
But we've always done it this way?
This statement can be the biggest hurdle in changing software development and deployment processes. So, the question comes up pretty frequently: How do you overcome it? Grant Fritchey explores techniques to understand and coach others towards change.
2021-07-07
Testing Flyway Migrations Using Transactions
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it?
2021-07-05
Who is responsible for building tests?
When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, you'll pretty quickly come to the question: who is responsible for building tests?
2021-06-23
Notify Users of Power BI Dataset Changes
In this article we cover the steps on how to send notifications to business users when a change in a dataset used for Power BI has occurred.
2021-06-23
Move SQL Server Files for Master Database
In this second part of this article we look at how to move the SQL Server master database files to a different location.
2021-06-21
The changing landscape of continuous database integration
Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.
2021-06-09
Redgate Streamed: Embracing technology trends for database success
Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.
2021-06-07
The changing landscape of continuous database integration
Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.
2021-06-04
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers