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
Redgate engineer Matthew Flatt talks about the challenges of database Continuous Integration and what you need to do to become great.
2021-07-09
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
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
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-02
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-06-30
How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard.
2021-06-28
How to use SQL Clone in the Azure Cloud, installing it on an Azure Virtual Machine, storing a copy of your SQL Server database as an 'image' on an Azure File Share, and then deploying multiple clones to another Azure VM or to a remote machine.
2021-06-25
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
The insurance landscape is evolving, and customer demands are far from where they used to be, with some of the biggest changes happening in the last year. James Boother from COEO covers how database DevOps can enable the evolving insurance landscape.
2021-06-21
How to exploit the branching and merging capabilities of Git for scaling up team-based development, when doing Flyway migrations.
2021-06-18
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Comments posted to this topic are about the item Create an HTML Report on...
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Hi everyone I am getting an error when I create the index but I...
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers