Posts Categorized: Pythian

2013 in Review — SQL Server

It’s that time of year. When I take some time away from work, hide out, and reflect on the past year. 2013 was a big year for Microsoft, particularly SQL Server, Windows Azure, and HDInsight. While I’d love to recap every Microsoft moment that excited me, there are too many to count, so I’ll just…

Log Buffer #355, A Carnival of the Vanities for DBAs

It’s no secret anymore that social networks like Facebook are fast loosing their hyper-active charm. But ask anybody about blogging, and its still there and the future is as solid as rock. Innovation, creation, and quality content with public engagement is what makes it lasting. This Log Buffer acknowledges that fact for the database bloggers.

My first week at Pythian

“You are lucky,” the taxi driver told me when he picked me up at the Ottawa Airport. “It began snowing right after your flight landed.” I personally like snow — just like the Chinese saying, “heavy snow brings heavy harvest”. Yes, I am lucky to be able to work at Pythian where the world’s top…

Disabling Triggers in Oracle 11.2.0.4

Yes you can still disable triggers per-session in Oracle 11.2.0.4, but you have to have a GoldenGate license, set the enable_goldengate_replication parameter, use a program name that starts with replicat, and set your module to OGG.

Log Buffer #352, A Carnival of the Vanities for DBAs

Jingle bells are all the way towards the happy new year. Whether the database bloggers are basking at white, sandy beaches or warming up indoors in white, snowy mornings, they are gearing up with their blog posts to start the new year with a bang. Log Buffer shares that enthusiasm with them.

How to Apply a Standby-First PSU Patch in a 2 node RAC environment

Oracle provides since it’s 11.2.0.1 version a way to apply certain patches, to our standby environment first, without compromising the primary database, to allow to let it burn in the Standby  for the time you deem appropriate and then apply the patch binaries to the primary BD ORACLE_HOME and these will cascade into our Standby DB. The first…

Do you have enough Redo?

The question of whether a database has enough redo logs available is quite common. The documentation suggests to use FAST_START_MTTR_TARGET and V$INSTANCE_RECOVERY.OPTIMAL_LOGFILE_SIZE to identify “the optimal” redo log size based on the target recovery time. I’ve never used it and can’t comment if it is a correct/reasonable way or not. The easiest way to identify…

Page 18 of 207« First...10...1617181920...304050...Last »