A Quick Diff Checker for SQL Server Databases
Compare the schemas of two SQL Server databases using SQL Compare command line then quickly produce a diff report showing you immediately which tables, views and functions have changed.
2021-07-16
database
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
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
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers