Articles

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

Using Recommendations for MAXDOP and Max Memory During Installation

by iLearnSQL

SQLServerCentral

Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2020-09-01

10,338 reads

Discuss

Getting Started with Delta Lake Using Azure Data Factory

by Additional Articles

MSSQLTips.com

Azure Data Factory

This article will demonstrate how to get started with Delta Lake using Azure Data Factory's new Delta Lake connector through examples of how to create, insert, update, and delete in a Delta Lake.

2020-09-01

Database Modeling - Relationships

by Ash

SQLServerCentral

A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2020-08-31

7,529 reads

Discuss

So, You Want to Be a DBA…

by Additional Articles

SimpleTalk

Career Growth

Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives some advice for those who would like to be a DBA.

2020-08-31

Database Snapshot Use Case: Service Migration

by Kenneth Igiri

SQLServerCentral.com

Database

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2020-08-28 (first published: 2018-12-11)

2,556 reads

Discuss

Reverse-Engineering the Production Database into Source Control

by Additional Articles

Redgate

Vendors/3rd-party Products

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