7 DB Forge SQL Studio Features Discovered in Less Than 2 Hours

• by Kenneth Igiri

• SQLServerCentral

• DBA Tools
• SQL Toolbelt
• Tools for development

dbForge SQL Studio gives you a few advantages over SSMS. See what Kenneth discovered during his first use of the tool.

Migrating a Large Database

• by Steve Jones

• SQLServerCentral

• upgrading

Large database upgrades are stressful, but a little planning and practice can help things go smooth.

SQL Server Crib Sheet Compendium

• by Tony Davis

• SimpleTalk

• books

As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.

Continuous Data Protection with SQL Data Catalog 2.0 and Data Masking

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

SQL Data Catalog 2.0 provides a simple, policy-driven approach to data protection, through data masking. It can now automatically generate the static masking sets that Data Masker will use to protect your entire database, directly from the data classification metadata held within the catalog.

Why your PL/SQL needs to be testable – and how to do it: Part 1

• by Additional Articles

• SimpleTalk

• Oracle

Part 1: What is testable code, why is it important, and first glimpses on practices that can help

The Best of SQLServerCentral, Vol.7

• by Steve Jones

• SQLServerCentral.com

• books

The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.

The Craziness of Code

• by Steve Jones

• SQLServerCentral

• software development

Building software can seem like a crazy process, especially to a developer who joins a project.

Understanding the Mapping Data Flow Activity in Azure Data Factory

• by Randheer Parmar

• SQLServerCentral

• ETL/SSIS/Azure Data Factory

Learn about using Mapping Data Flows in Azure Data Factory.

The 10 Benefits of Monitoring for Leaders

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.

Understanding SQL Server Linked Servers

• by Additional Articles

• MSSQLTips.com

• Linked Server
• Linked Servers

In this tip we look at how to setup a Linked Server in SQL Server using SQL Server Management Studio.