Editorials

Is SQL Server A Commodity Service Now?

Featured Article(s)
Understanding Software Testing (Part III)
This is the last and concluding part in this series of three part articles on Software Testing. In this part we will discuss few other types of testing methodologies.

Webcast Today
Performance Monitoring, Scaling and Watching Over Your SQL Server.
We’ll look into pulling baseline information, things you can do to chart and forecast growth on your system and the basic options you have to grow you system “out” and “up.” Find out how to use Performance Monitor tools and learn about what different scaling techniques can bring to the table.

> Register/View Webcast Now

Automating Roll-outs and Controlling Changes to Multiple Databases, Multiple Servers…
Difficult to imagine, sure. Difficult to do? Nope. Moving code, changes and updates across your SQL Server farm is a simple thing when you have SQL Farms on your side. If you’ve ever been presented with that latest update, asked to apply it, reliably, across servers, then faced the process not only doing the work, but also making sure it all completed successfully, you know the need for SQL Farms. Get SQL Farms, deploy the code, make changes, and be confident in the tools to get the job done. Check out SQL Farms here. Get back to getting things done, not worry about how to get them deployed or managed.

Is It Possible…
That databases, or at least the DAILY administration, care and feeding of databases, would become less demanding, perhaps even (dare I say it) automatic? Sure, the really big systems, odd and unique systems – that type of thing – they all need careful management and daily attention. But, for the vast majority of databases, is it possible that we’d not have to pay daily attention to databases?

I think we’re headed to databases (in general) being almost a commodity service (my term). By that I mean that you’ll be worrying a lot less about the database itself and paying more attention to the specifics that support your application. This comes from the whole "self-tuning" type of approach and the fact that SQL Server just runs, and does a good job of it. I’m not looking to do an ad for SQL Server, but it’s just an observation.

I talked to a number of different people at the conference and specifically talked about things they have to do with the database to support their applications. A vast majority of them don’t do daily things – don’t have to tweak and tune with the occasional exception.

Do you see this happening? Is it possible that the database becomes a lot more like the operating system in the sense that it’s there as a support and facilitation tool, and less like a distinct and separate entity to manage and work with?

Drop me a note – let me know what you think.

Featured White Paper(s)
Minimizing Downtime and Maximizing Performance in Microsoft® SQL Server 64-bit environments
… (read more)

The Top Five Reasons To Consider an Embedded Database for Your Next Project
There are numerous business benefits of using embedded databases during the lifecycle of business application development. Th… (read more)

Technical Overview of Automating the Upsizing of Microsoft Access Databases to SQL Server
2SQL is designed to remove the software programming and database administration component of Microsoft Access to SQL Server u… (read more)

Enterprise Data Management.. Strategies to Increase Business Effectiveness
As the amount of information you collect expands and the number of recorded data transactions grow, your ability to manage ap… (read more)