Those of you who have seen me present about GoldenGate will know that I recommend using a heartbeat table to monitor GoldenGate lag. The heartbeat table is a great way to monitor GoldenGate replication because it can follow a single SQL insert through each major GoldenGate replication process, and report the replication lag attributable to each.
This week is packed with conference news, birthdays, tutorials, awards, and much more. From Pythian proud recipient of HIO Employer Excellence Award to the health checks of SQL Server, and from hints in stored outlines to the birthday of Paul Vallee, this Log Buffer Edition has it all in Log Buffer #262.
As we all are aware SQL Server 2012 virtual launch has arrived. Earlier I discussed what’s new in SQL Server 2012 setup, MS has released the SQL Server 2012 training kit and made it available for us to download.
Pythian is thrilled to receive the 2012 Employer Excellence Award for Retention and Engagement by Hire Immigrants Ottawa, for our achievement in workplace diversity.
I’ve been playing with SQL Server 2012, codenamed “Denali,” since the CTP days and am very happy with some of the features that they have introduced to address high availability and disaster recovery requirements. For me, these are more than enough reasons to consider upgrading to SQL Server 2012.
In recent past we had a situation where in, we were required to move MSDB, Model and Master databases to a new location, the reason being a faulty drive. While moving the system databases to the new location we needed to be extra cautious. Let’s see the process step-by-step.
With this milestone birthday that has now arrived for Paul, it’s time to look back on the years and SOME (there are way too many stories to put them all here) of the Pythian history highlights.
If you are using Oracle Database Appliance (ODA) then this patch is very important to apply. The patch bundle 220.127.116.11.0 has been published just this week and the most important fix from my perspective is the new BIOS version 12010304.
I’m in the throes of a major redesign of the site of my comic book, Académie des Chasseurs de Primes. Like any of those redesign, it involves a lot of CSS whack-a-mole. Fine-tuning one page throws a second one slightly off another, and fixing that second one causes unforseen effects on a third one. And so on, and so bloody forth. Generally, to discover those oopsies, I have to navigate the whole site. Bah, humbug. Wouldn’t it be much efficient to have a single document showing all of the site’s page? Something like a contact sheet for the website, if you will. Well, let’s see how hard that would be.
The process of upgrading SQL Server is usually time consuming, costs money and requires availability of human resources. If you don’t see the immediate need…Why bother?! Before deciding on upgrading, you should be aware of the new features and make sure you will really benefit by the upgrade. From our experience at Pythian with dozens of clients and hundreds of environments, what could be worth upgrading to SQL Server 2012?
Here are some of the top features related to the database engine (Part I):