Featured Article(s)
Installing MySQL and MySQL-Front tool
It is very important before you learn how to install MySQL and MySQL-Front tool to understand what are the MySQL system is a relational database, ie tables relate to each other. The programming language used is SQL (Structured Query Language) used for operations with the database. The tool MySQL-Front is used in the administration of the database in MySQL and has a friendly interface and easy to understand. With this tool you can export tables, run SQL commands, manage database and a host of other useful functions for the administration of a database.
Upcoming Events
SQL Server Performance Virtual Workshop
We have our next virtual workshop ready to go – it’ll be November 19, you can register now and be eligible for a drawing for a free annual membership for SSWUG.ORG. Just be one of the first 50 to register and you’ll be automatically entered into the drawing. We’ll announce the drawing winner here in the newsletter. We offer a certificate on completion (and passing the quiz), the slides, live Q&A and much more. This workshop is all about performance management for your SQL Server – from the basics to the more advanced items. We’ll be covering TSQL, Indexing, Monitoring, Tuning and a whole lot more. Check out the site for the course outline! I’ll be teaching this virtual workshop and we’ll bring it directly to you on your computer – no travel, just great information.
> Get the course outline here
> Register here
Webcast: Database Recovery 101
Every DBA is required to maintain good backups of their systems. But what are your options for recovering the system once you do experience a failure? In this presentation youll learn how to restore various types of database backups, the impact the recovery process has on your system, and how to estimate downtime and time to recover. Presented by: Buck Woody Sponsored by: BakBone (www.BakBone.com)
> Register Now
> Live date: 11/4/2009 at 12:00 Pacific
SQL Server Upgrade Challenges
It amazes me that still, after all this time (many years!) one of the top things that has been said over and over again in the responses thus far to the editorial on Friday is "we’re waiting for the vendor to certify on 2005/8. I can’t do anything about it, but man-o-man – I thought that, for once, we wouldn’t see that in the results. Or perhaps more to the point, for 2005/8. Sure, I get 2008 R2 certification, but the others?
The balance of the responses on what your upgrade plans are for 2008, 2008 R2 and such seem to revolve around very mixed environments. I don’t believe I have seen a single response so far that indicates standardization and implementation of that standard, on a given version. Most have selected 2005 as the platform targeted, but 2000 and 2008 are almost always in the mix too. The R2 move is understandably based on the need for BI. 2008 in general seems to be the direction going forward for new projects (especially internal projects).
I’ll keep you posted with more information – and if you have feedback on how you’re approaching the SQL Server versions, I’d love to hear it. Email: swynk@sswug.org
This does seem to push for standardized tools that support multiple versions of SQL Server. I’m assuming that the mixed version support is a key component of considering tools for use in your shop. I know internally, it’s an early-on question, usually answered with "yes we support multiple versions" – but not always ,or at least not always with high-functionality on some versions.
Did You Know?
Did you know SQL Server can let you know when specific issues arise? You don’t have to wait to review the logs or wait for problem reports from users. You can set up alerts and have the system monitor for those and let you know when specific things happen. Check out alerts and operators – it’s a great tool.
Featured White Paper(s)
Java Database Connectivity
Database connections are the lifeblood of enterprise applications, administrating the secure and steady flow of information b… (read more)