Data Platform

External Article

SQL Database: How to Configure Active Geo-Replication

  • Article

Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.

2016-10-27

3,361 reads

Technical Article

RE: CASE in computed column

  • Reply

Whoops, never mind, I got it to work. There wasn't any code, I just set up a varchar field in Enterprise Manager and pasted CASE WHEN TYPE='O' THEN ORGNAME ELSE LAST_NAME + ', ' + FIRST_NAME END in the Formula. You can answer a question about computed fields, though. My understanding is that it should […]

2005-05-05

Technical Article

Replication Transformation

  • Topic

I am currently trying to setup Transformation on a Transactional Publication.  When I finish setting up all the transformation info for the package and click finish to save the DTS package I get the Message "SQL Server Enterprise manager could not complete this operation."  this message comes up when it is in the "Adding task […]

2005-05-04

2 reads

Technical Article

RE: Generate Next Numbers with SQL Server

  • Reply

Why don't you let the database structure handle this with additional fields for date, type of entity (order, invoice, etc.), unique id(generated from SQL Server)?  The unique entity number can then be derived from the elements after the unique id is returned.  Your one-off-approach-for -this-client may prove difficult to maintain and likely to cause issues later on.  What if the […]

2005-03-08

Technical Article

RE: Memo field

  • Reply

Hi RemiThanks for the reply.  The problem is that the number of characters can vary from 1 per line to none to a paragraph of continuous text.Paul

2005-03-01

Technical Article

List database recovery modes

  • Topic

Hi list,Does anybody have an idea where SQL server keeps the information about database recovery modes (full, simple, etc) rather then looking up in EM.Maybe someone has a script to get all modes for all databases on the server.Thank you,JP

2004-11-15

2 reads

Blogs

Advent of Code 2022

By

Foreword Advent of Code is an annual event in which participants solve a series of...

Daily Coping 8 Dec 2022

By

Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.

By

One of my favorite parts of having a new job is that I learn...

Read the latest Blogs

Forums

The Enterprise Roadmap to Reducing Costs (While Increasing Value)

By Additional Articles

Comments posted to this topic are about the item The Enterprise Roadmap to Reducing...

The Temp Alias

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Temp Alias

Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String

By Additional Articles

Comments posted to this topic are about the item Connect to SQL Server with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers