Log Buffer #275, A Carnival of the Vanities for DBAs
Jun 22, 2012 / By Fahd Mirza
With the rapid advancement in the database technologies, the legacy systems are either being upgraded or they are being replaced or in some cases technologists are finding ways to support them in new ways showing us the flexible nature of databases and the belief of professionals that the sky is the limit. For this Log Buffer Edition, we go even beyond in this Log Buffer #275.
Why is a Full Table Scan Selected – Will the Execution Plan Provide a Clue? Charles Hooper answers.
Martin shares as how to use vi-style editing in SQL*Plus.
The Oracle Security guy Pete Finnigan blogs about Oracle, Proxy, Obfuscation, Cookie Law, Talks, more…
Greg Rahn has a great post about Linux 6 Transparent Huge Pages and Hadoop Workloads.Dominic Delmolino’ve been impressed with the solutions to his little problem of generating a symmetric Pascal matrix using SQL
Pinal Dave is doing an insightful follow up of usage of $rowguid and $IDENTITY.
What does the ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS mean on the CREATE INDEX statement ? What is the cost\benefit of ON|OFF? Is there a performance gain? Jack Vamvas answers.
Andy Lohn has done a nice link round up.
Kevin Kline is suggesting two TechNet Radio Sessions You Don’t Want to Miss.
Simple time series calculations, such as comparing sales in the current year with the previous year, are easy to do in DAX and well-documented. Chris Webb has more.
Michael McLaughlin is discussing the single wildcard operator with respect to MySQL and Oracle.
This post by Mayank Prasad aims to provide detailed steps to get gprof data for MySQL client and server.
Ronald Speelman is sharing as how to generate meaningful test data using a MySQL function.
Shlomi Noach is blogging about a real world experience about MySQL connections.
Ernie Souhrada is on character sets and disappearing tables.
Leave a Reply
You must be logged in to post a comment.