Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Wild Fringes of SQL Server Development

By Tony Davis,

One of the things that I noticed while at the PASS summit is that we can now clearly see two opposing trends in the way SQL Server is being used in applications. On the one hand we have the dumb database brigade. They regard SQL Server as simply a 'data dump'. The real data model is held in, and all the work is done in, the middle tier, using Entity Framework, nHibernate, or their ilk. SQL Server's job is simply to respond in a timely fashion to any dynamic SQL requests that are fired at it.

On the other hand, we have the group who view SQL Server as a powerful enough platform in it own right, for all but the most extreme applications. They would rather dispense with a .NET-based object layer completely, placing all the business logic in SQL Server and serving up the data via wafer-thin front-end applications, using Web Services.

Both groups are viewed by the community as being at the "wild fringes" of SQL Server development and neither receives whole-hearted approval. Can one reconcile these two opposing trends? I hope so. I admire what .NET developers can achieve with their platform, but also know that SQL Server is far too powerful to be used as just a "data dump".

Either type of use may be appropriate for given circumstance; neither is a universal panacea. Far more damaging than the occasional excesses of the "wild men" on the fringes, is the tedious orthodoxy that states that 'you should never do that in SQL Server', or 'that should always be done in the database'.

I am wary of this sort of "best practice" advice. It is usually a device to surreptitiously hide irrational dogma, or else just a vapid reflection of "what Microsoft says". It's the sort of received wisdom that can stifle creativity and innovation.

Anyone who wishes to create an application on an "unorthodox" platform needs to first prove that it will be as secure, scalable, deployable and maintainable as the "orthodox" alternative, and that it will perform as well and take less time to develop. Once that battle is won then it becomes a reasonable platform to develop on.

SQL Server is now versatile enough to accommodate all sorts of methodologies and architectures. Although the over-stretched DBA will occasionally curse the introduction of 'foreign' concepts, such as XQuery, the result is that SQL Server has positioned itself to be uniquely adaptable to new thinking about the way that applications are developed.

And that is something from which all of us will benefit.

Cheers,

Tony (Guest editor, while Steve takes a well-earned Thanksgiving break)

Total article views: 184 | Views in the last 30 days: 1
 
Related Articles
BLOG

Migrating to SQL Server from another Database platform

Migrating to SQL Server from another Database platform has a number of considerations 1)   Create a...

ARTICLE

Developer Deployment Frustrations

SQL Server should work to make it easy for developers to work with it, and include versions like Exp...

BLOG

Stored procedures vs. Do-It-At-Application-Layer-At-All-Costs

Many years back when ASP 2.0 (not ASP.NET) was used as primary server language for web application o...

ARTICLE

DBAs Need to Learn to Develop

SQL Server is growing as a platform and Steve Jones says that DBAs need to learn development skills....

ARTICLE

The Platform Problem

Steve Jones sees a problem with the Azure platform. It's one that he thinks is limiting adoption, an...

Tags
editorial    
sqlservercentral    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones