In this Log Buffer Edition, March madness with method continues with plethora of blog posts from across different database technologies. Enjoy this Log Buffer #263.
Quick post congratulating Gwen Shapira on becoming Oracle ACE Director. Gwen has be an Oracle ACE for a while by now and been very active in the community. Congratulations Gwen!
Thanks to everyone who attended my presentation “Queues, Pools and Caches” at Hotsos 2012. I had a blast and I hope you did too. I posted the slides and paper on SlideShare for your enjoyment. The paper is by far more complete and contains a lot of material I had to leave out of the slides. There were many questions asked after the presentation, so I thought I’ll post a short FAQ to address those:
Pythian organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week. Here are the details..
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.