(Join us for a different kind of presentation; check out the banner above!)
Featured Article(s)
Easy procedures
Creating procedures can be time consuming, here is a fast little script to create the simple CRUD procedures for a given table.
Kalen Delaney Virtual Workshops
In just a couple of weeks, Kalen’s next workshop will be happening. Kalen has an extraordinary reputation for deep, specific tips in her classes, presentations and workshops and this workshop will certainly continue that tradition. Several hours of help and very specific instruction, a course quiz and certificate, slides, demonstrations, live Q&A with Kalen throughout so you can make sure you get the information you need and get questions
answered, all right from your computer. Here’s a quick look at the workshops – just click the title for all the details:
Query Plans Workshop (June 30, 2010)
Indexing Workshop (July 23, 2010)
Plan Caching Workshop (Aug 27, 2010)
Wrap-Up on Multi-Database Work
The discussions about multiple databases have been interesting, but I have to say, very consistent in what people are facing and working with. First, to the point of the original post, it seems that there are more applications out there than I ever imagined using more than one database back-end. In one single application – more than one back-end . Egad. Like I originally said when I asked about this, I can’t imagine a good scenario for this type of thing. It just simply sounds like a nightmare.
Second though, the realities of multiple databases in a given shop, are really clear.
So many wrote in with their frustrations working with cross-database issues, moving information around, trying to keep things synchronized and also trying to find the right sets of tools to help out. It’s clear that there is a good deal of aggravation in the requirement to work with different platforms, but there are some clear advantages too. Many people talked about applications that were tweaked well for their database back-end of choice, be it Oracle, SQL Server or others.
So, the short answer is that we need to work to avoid multiple platforms within an application, if only for sanity-sake. Multiple platforms for a shop however, are a reality that many (perhaps even most) of us work with on a daily basis.
Interestingly, many considered Access, SQL Server Express, SQL Server Standard and Enterprise to be "cross-platform" – if only because tools had to be smart enough to handle them all. Of course adding Oracle, MySQL and others to mix just keeps things interesting.
What do you think? Drop me a note, or post here on the Facebook page for SSWUG.ORG. (You can even post video responses!)