Tony Davis

  • Interests: football, modern literature, real ale

SQLServerCentral Editorial

The Wild Fringes of SQL Server Development

We can now clearly see two opposing trends in the way SQL Server is being used in applications. The dumb database brigade regards SQL Server as simply a 'data dump'. The 'database fanatics' think SQL Server on its own can meet the needs of all but the most demanding applications. Can these opposing trends be reconciled? Tony Davis would like to think so.

You rated this post out of 5. Change rating

2008-12-01

226 reads

SQLServerCentral Editorial

Barriers to Entry, Database Weekly (Oct 27 2008)

Many people who spend time contributing to technical forums bemoan the increasing amount of time and energy they expend trying to help people who seem unwilling or unable to help themselves. At the same time, they say, the courtesy is deteriorating and the number of people willing to "stir things up" for the sake of it increases. Is there a solution to this?

You rated this post out of 5. Change rating

2008-10-27

109 reads

SQLServerCentral Editorial

Dataphor

Over the years, there have been several attempts to turn conventional RDBMSs into object relational databases, by inserting an intermediate layer. The driving force behind this was the generally-held assumption that the relational model could not handle complex data types.

(1)

You rated this post out of 5. Change rating

2008-06-24

289 reads

SQLServerCentral Editorial

Rules, Defaults and the SQL Standard

I see, with some relief that the threatened removal of Rules and Defaults in SQL Server 2008 hasn’t happened. There has been a stay of execution. Even though they are documented, they still come with a dire warning that they are deprecated and will be removed in future versions. They have fallen foul of the SQL Standards committee, and we are now supposed to use check constraints instead.

You rated this post out of 5. Change rating

2008-06-23

179 reads

SQLServerCentral Editorial

Open Source and SQL Server communities

The other day, I was chatting to a keen PostgreSQL user. We're used to having free databases, such as IBM DB2 Express-C, Microsoft SQL Server 2005 Express Edition, SQLite and Oracle XE, but PostgreSQL is different in that it is open source. It is a proper, dedicated community too, I was told...

You rated this post out of 5. Change rating

2008-06-09

117 reads

Blogs

Using CAT for Testing of Data Agents

By

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By

Do you spend so long manipulating your data into something vaguely useful that you...

The Book of Redgate: SQL Server Central

By

It was neat to stumble on this in the book, a piece by me,...

Read the latest Blogs

Forums

Backup to Immutable Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backup to Immutable Storage

Microsoft Security Changes and SQL Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Microsoft Security Changes and SQL...

Expanding into Print

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expanding into Print

Visit the forum

Question of the Day

Backup to Immutable Storage

In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?

See possible answers