Editorials

Announcement: Accidental DBA vWorkshop by Stephen Wynkoop

Webcast Tomorrow
Upgrading to SQL Server 2008, It is easier than ever!
Are you ready for SQL 2008? Many organization are still trying to upgrade from SQL 2000 to SQL 2005 and are now faced with the decision should they upgrade to directly SQL 2008 or do they upgrade to SQL 2005 then SQL 2008. In this session, we cover if you should upgrade to SQL 2008 and discuss potential incompatibility issues. We will then discuss the different methods to upgrade and how to plan for a rollback if needed. This session will cover upgrading SQL 2000 and SQL 2005. Presented by: Sarah Barela Sponsored by: Melissa Data (www.melissadata.com)

> Register Now
> 8/26/2009 at 12:00pm Noon Pacific

Featured Article(s)
Adding webparts to SharePoint list New, Edit, View forms
Everyone have seen New, Edit, View item forms in lists and libraries. More often than not customers ask to add some extra functionality to them. Some ask to include parts of item information in bold for visibility on a top of the View page; some ask for logic requiring .NET development. The good news is that there is an easy way to include any of those without re-creating edit page or compromising its existing functionality.

Announcement: Accidental DBA vWorkshop by Stephen Wynkoop
We’ve officially announced the Accidental DBA Virtual Workshop – and registration is now open for the September 10 virtual workshop. I’ve pulled together all sorts of information you need to know, from monitoring to setup to security to tips for running your server. You can get the full outline at the site and get the full details, as well as register. You can even get a certificate after you successfully complete the quiz. The vWorkshop is available on-demand for review after the course completes, and you can get the slides, complete with timestamps and more to help in your review.

[Get More Information Here] or [Register Here to Save Your Spot]

SQL Azure Released to CTP
It seems that official invitations have gone out for the SQL Azure CTP – looks very interesting and potentially very transparent to your application development. The site has quite the terms of use, covering everything from data ownership (you have to own your data) to use of the service and service levels to be promised (none during the beta/test of course).

It’s interesting in that you can start to get an idea of how this type of implementation will take shape. Create a database, get the connection string and other tools that you’re used to working with should be nearly set to go.

The interface will give you the connection strings, let you create the database and start working with the SQL Server in the cloud to see how your applications will be impacted. It’s a good idea to start working with this; I can see where there may be new support needed for new connection string management in applications, security and so-on. Now’s the time to work with it and provide your input to the final product.

Ongoing SQL Attacks
(Note: Not necessarily SQL *Server*-specific) – There are numerous articles of late about continuing compromises of systems using tools like injection and the like. There are also some additional things happening, things that border on a bit of unionization of the hacker community.

We’ve started seeing reports of a hacker successfully getting into a system, then posting the entrance method, getting other hackers involved and actually swarming a system that is compromised before it is updated/locked down/corrected. You can count on more of this, whether it’s automated or more manual. In most attacks, the injection or other attack is "blind" – forget watching for tell-tale error messages, just try to access a foreign system. If you get in using automated processes, make a note of it, tell the "big guy" and get all hands on deck to go after the compromised system. Not a great time.

Featured White Paper(s)
Managing Complex Database Changes
Development can be a volatile endeavor – especially when sites or applications are database dependent and subject to a high d… (read more)