External Article

Introducing DLM Techniques for a Multi-Database Multi-Server System

Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems, what if the database 'layer' consists of several large interdependent databases and data flows with replication and audit? Does DLM scale to this level of complexity? Margaret Cruise O'Brien starts a series of articles that describes the practicalities of improving DLM within an existing framework and team supporting a multi-database multi-server system, by describing some of the database management problems and solutions in an enterprise-scale database.

Blogs

QUOTENAME Basics: #SQLNewBlogger

By

Recently I ran across some code that used a lot of QUOTENAME() calls. A...

When growing companies outgrow Excel

By

There are some telltale signs that your growing business has outgrown Excel for your...

T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?

By

Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...

Read the latest Blogs

Forums

Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployment...

QUOTENAME Quote Parameters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item QUOTENAME Quote Parameters

Limit the Blast Radius

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limit the Blast Radius

Visit the forum

Question of the Day

QUOTENAME Quote Parameters

When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?

See possible answers