Log Buffer #262, A Carnival of the Vanities for DBAs
Mar 9, 2012 / By Fahd Mirza
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.
Tanel Poder guides us about creating a database link with the new host:port/service syntax.
If you are using Oracle Database Appliance (ODA) then this patch is very important to apply, Alex Gorbachev informs.
If you are wondering about as how to Connect to Oracle Database on a Guest VM from the Host, then Awad has a blog about it.
David Kurtz talks about editing hints in stored outlines.
Kevin Closson talks about a little Oracle benchmark.
If you are a Windows user concerned about the new licensing and pricing of SQL Server 2012, then try out TCO Calculator, Bertrand Matthelié tells.
Kevin Roebuck is worried about real time streams.
Vamvas has a nifty post about netstat monitoring and tuning performance with respect to the SQL Server.
Microsoft has launched the SQL 2012 and its a house party as observed by Thomas LaRock.
Are your SQL Servers healthy? If the things went south today today, would you be able to say you can recover confidently? Jason Strate answers.
Grant Fritchey is talking.
Every single time when Performance is discussed, Indexes are mentioned along with it. Pinal Dave has more.
What about a MySQL community Dinner at Pedro’s?
Shlomi Noach is seeking input regarding Auto caching INFORMATION_SCHEMA tables.
Giuseppe Maxia says that it’s all about bringing fresh blood to the MySQL Council.
Baron Schwartz blogs about scalability, performance, capacity planning and USL at Hotsos Symposium.
Henrik Ingo discusses MySQL locking with INSERT/DELETE workload.
Andrew Morgan points towards a white paper regarding getting the best performance out of MySQL Cluster.