Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask
Phil Factor offers straightforward answers to tricky SQL Compare questions.
2020-09-30
Phil Factor offers straightforward answers to tricky SQL Compare questions.
2020-09-30
How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration testing, and using Redgate tools to automate tasks such as provisioning, database scripting, and testing.
2020-09-25
Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.
2020-09-02
Starting out a new database development with source control is relatively easy. To introduce source control into an existing database application can be more challenging. Phil Factor explains some of the fundamental steps.
2020-08-28
There is no single, correct approach to developing and testing your SQL batches and routines. It depends on the requirement. For simple tasks, like modifying and testing a view or stored procedure, SQL Compare and SQL Data Generator, combined, provide a useful, lightweight development harness.
2020-07-29
Phil Factor dissects and disentangles the various SQL Compare options.
2020-07-28
Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them.
2020-06-12
Phil Factor describes how custom pre- and post-deployment scripts work, when doing state-based database deployments with SQL Compare or SQL Change Automation, and how you might use them to, for example, add a version number to the target database, specify its database settings, or stuff data into some tables.
2019-11-18
By Steve Jones
There is a nice article at Harness.io on their use of feature flags and...
By James Serra
There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...
I have this query, which is gives result I want (may be not, i...
Hello, I have long-term task, which came one year ago, and just now I...
Comments posted to this topic are about the item LOGON Trigger Count
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers