Tech4Him – Technology with Integrity

Presenter: Matt Masson
http://blogs.msdn.com/mattm/

This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. Well cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you’re interested in learning best practices for this new SQL Server 2008 functionality, you won’t want to miss this session! Read the rest of this entry »

Popularity: 14% [?]

Presenter: Thomas LaRock
Database Administration Manager
ING Investment Management

In SQL 2008, Maintenance Plans create a workflow of tasks to ensure your database is optimized and backed up on a regular schedule. The Maintenance Plan will create an SSIS package that will be scheduled and run with SQL Agent. Attend this session and learn how Maintenance Plans will ease your administrative overhead. Read the rest of this entry »

Popularity: 5% [?]

Brian Chappell has a great little post about quickly optimizing a Drupal installation for SEO. His quick hits include the following points.

Read the rest of this entry »

Popularity: 9% [?]

Today was a great day. First off, the good Lord gave me another day on Earth to do His work. That’s a good start. I also came across a KB article from MediaTemple that provide great hope of some performance improvement on our grid service (gs) account. Now I came across this as a result of researching performance optmizations for Drupal on their dedicated virtuals (dv) that some of my clients sites run on.

I was so excited, I couldn’t wait to try it out. So, nothing too empirical other than firebug net download times with my browser cache cleaned out.

Test Instance with 8 blocks making up a single node page with 100 generated users.
* Before the optimizer was enabled: avg. 4.4 secs total
* After the optimizer was enabled: avg. 2.9 secs total

The change boils down to this:

Open your php.ini file for editing (KB: (gs) HOWTO: edit php.ini). Add these lines:

For PHP4 (Replace the x.x-x with the version number you want to use.)

> zend_optimizer.optimization_level=15
> zend_extension=”/usr/local/php-4.x.x-x/zend/ZendOptimizer.so”

For PHP5 (Replace the x.x-x with the version number you want to use.)

> zend_optimizer.optimization_level=15
> zend_extension=”/usr/local/php-5.x.x-x/zend/ZendOptimizer.so”

Save the changes and quit.

That’s a decent improvement with all things considered. There are plenty of other optimization items that can be done, but since this site provide zero income, I’m not ready to pay any more for some of those non-free options.

I guess that leaves me with Drupal caching support, ZendOptimizer and MySQL Table optimization and indexing. No MySQL containers for me. If I ever move, it will probably be straight to a (dv).

Blessings!

Popularity: 13% [?]