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-02
Vendors/3rd-party Products
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-06-30
Creating and Maintaining a SQL Code Snippet Library
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
Running SQL Clone on an Azure VM with Azure File Storage
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
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
How DevOps can enable the evolving insurance landscape
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
Branching and Merging in Database Development using Flyway
How to exploit the branching and merging capabilities of Git for scaling up team-based development, when doing Flyway migrations.
2021-06-18
Managing SQL Snippet Collections using JSON and PowerShell
Maintain your favorite SQL snippets and queries centrally, using PowerShell to save and update each snippet collection, in JSON, and then converting them into SQL code snippets for SQL Prompt.
2021-06-16
How Can Redgate Tools Help with a Cloud Migration?
The cloud migration tools and processes that will help you move a database to the cloud, from planning, implementation and validation through to extending existing development and deployment processes to the new cloud platform.
2021-06-14
The four best features to look out for in SQL Monitor
In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.
2021-06-11
Blogs
Code signing for mere mortals
Well, turns out code signing is pretty complex, so I’m writing this blog post...
Blogging for the Tech Professional at Denver Dev Days
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
Getting AI Written Unit Tests
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
Forums
Software Flexibility (Avoiding the next hack)
Comments posted to this topic are about the item Software Flexibility (Avoiding the next...
Delayed tcp acknowledgement registry setting
Our IT department contacted me recently and asked if they should change the default...
Ask SSC