Vendors/3rd-party Products

External Article

Using Filters to Fine-tune Redgate Database Deployments

  • Article

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

External Article

Introducing SQL Change Automation 4.3

  • Article

The latest version of SQL Change Automation now integrates with SQL Clone to let you use a snapshot of your database’s schema as a baseline. This simplifies migration development in complex databases, avoiding problems like invalid objects or circular dependencies, and you can verify migration scripts on a copy of the currently released database.

2020-08-20

Technical Article

Insert Statement Without Column List (BP004)

  • DatabaseWeekly

Many production databases have failed embarrassingly as a result of INSERT code that omits a column list, usually in mysterious ways and often without generating errors. Phil Factor demonstrates the problem, and advocates a 'defense-in-depth' approach to writing SQL, in order to avoid it.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-05-22

Technical Article

The Sins of SELECT * (BP005)

  • DatabaseWeekly

If Prompt warns you of use of the asterisk, or 'star' (*), in SELECT statements, consider replacing it with an explicit column list. It will prevent unnecessary network load and query performance problems, and avoid problems if the column order changes, when inserting into a table.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-05-14

149 reads

Technical Article

SQL Clone for Unit Testing Databases

  • DatabaseWeekly

Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-05-14

Technical Article

Monitoring your servers and databases with SCOM and SQL Monitor

  • DatabaseWeekly

SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-05-14

Blogs

My 2024 in Data: Health and Workouts

By

This is my last week of the year working (I guess I come back...

My 2024 in Data: Reading

By

This is my last week of the year working (I guess I come back...

Book Review – Agile Data Warehouse Design

By

I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...

Read the latest Blogs

Forums

Connecting Streamlit to Upload Data to Snowflake

By Shruti Dhumak

Comments posted to this topic are about the item Connecting Streamlit to Upload Data...

Comforting Habits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Comforting Habits

DCL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DCL

Visit the forum

Question of the Day

DCL

We have DDL, DML, and DCL. What is DCL used for?

See possible answers