• Blog
  • Get Help Now!
  • Customer Portal

BlueGecko Denmark

  • Why you need us
    • Why act now
    • Why are we unique
  • What we do
    • Products Supported 24/7
      • MySQL
      • Postgres
      • SQL Server
      • Open Source
      • OS & Storage
  • How we do it
    • Consulting
    • System Monitoring
    • Security
  • Support
    • Blog
      • Oracle
      • MySQL
      • News & Events
      • Oracle Applications
      • Amazon Web Services
      • Jeremiah Wilton’s Oradeblog
      • OurSQL Community Podcast
      • Remote DBA
    • Team viewer
    • Whitepapers
  • About Us
    • Philosophy
    • The Blue Gecko Teams
    • Employment Opportunities
    • Partners
    • News
    • Press
  • Contact Us

August 25, 2011 by jwilton

Finding non-default configuration settings in SQL Server

In our Remote DBA practice, we frequently perform comprehensive system reviews for our customers on their database services. Among the things we always check for are non-default settings for the database software. We want to validate that any non-default setting is set that way for a good reason, and that any setting that is default really should … [Read more...]

Filed Under: Jeremiah Wilton's Oradeblog, Remote DBA, SQL Server

May 26, 2011 by jwilton

Amazon RDS for Oracle: First Impressions

On Tuesday, Amazon announced availability of an Oracle version of their Relational Database Service (RDS). RDS is one of Amazon’s cloud services. You can think of it as ”database as a service.” Amazon provides a running database, storage, horsepower and a variety management tasks. And all you have to do is store you data in it. … [Read more...]

Filed Under: Amazon Web Services, Jeremiah Wilton's Oradeblog, Oracle

April 23, 2011 by jwilton

Determining optimal Amazon S3 transfer parallelism

Amazon’s Simple Storage Service (S3) is a robust, inexpensive and highly-available internet data storage service.  At Blue Gecko, we occasionally help our customers design and implement S3-based backup strategies. Compared to conventional off site tape vaulting services, the advantages of vaulting database and other backups to S3 are many.  … [Read more...]

Filed Under: Amazon Web Services, Jeremiah Wilton's Oradeblog, parallel, performance, S3, SQL Server Tagged With: aws

April 22, 2011 by jwilton

EC2 outage reactions showcase widespread ignorance regarding the cloud

Amazon EC2′s high-profile outage in the US East region has taught us a number of lessons.  For many, the take-away has been a realization that cloud-based systems (like conventionally-hosted systems) can fail.  Of course, we knew that, Amazon knew that, and serious companies who performed serious availability engineering before deploying to … [Read more...]

Filed Under: Amazon Web Services, downtime, ebs, elastic block store, elastic compute cloud, ignorance, Jeremiah Wilton's Oradeblog, misconceptions, outage Tagged With: aws, EC2, high availability

December 9, 2010 by jwilton

Oracle tablespace hot backup mode revisited

Here’s a revised version of an old popular article I wrote over ten years ago.  I wrote this when I was at Amazon.com, long before I came to work at remote DBA provider Blue Gecko. Enjoy! Oracle’s pre-RMAN hot backup mode is the subject of one of the most pervasive and persistent misconceptions about Oracle. During an Oracle tablespace … [Read more...]

Filed Under: hot backup, Jeremiah Wilton's Oradeblog, misconception, Oracle, proof

November 22, 2010 by jwilton

YPDNGG: You Probably Don’t Need Golden Gate

Before launching into this, I must give due deference to Mogens Nørgaard’s landmark article, You Probably Don’t Need RAC (YPDNR), available here, but originally published Q3 2003 in IOUG Select Journal.  Mogens showed that you can be a friend of Oracle without always agreeing with everything they do. At Blue Gecko, many of our remote … [Read more...]

Filed Under: Jeremiah Wilton's Oradeblog, MySQL, Oracle, replication, SQL Server Tagged With: goldengate, streams

October 21, 2010 by jwilton

How I got access to My Oracle Support (MOS) for US$2.67

Oracle professionals know that the two main sites for information and support on running Oracle products are the Oracle Technology Network (OTN), and My Oracle Support (MOS). OTN is free for anyone, and provides discussion forums, white papers and free base-release software downloads under the Developer License. MOS requires a paid software … [Read more...]

Filed Under: Education, Jeremiah Wilton's Oradeblog, Oracle, Oracle Applications Tagged With: access, MOS, My Oracle Support

September 23, 2010 by jwilton

Report from Oracle Openworld

Openworld 2010, despite the supposedly lagging economy, had record attendance again this year.  No doubt this was the result of Oracle acquiring something like fourteen companies since last year, including Sun in 2009.  The crowds were thick, divided about evenly between geeks in badly-fitting vendor t-shirts and slick sales-side hustlers with … [Read more...]

Filed Under: Amazon Web Services, Education, Jeremiah Wilton's Oradeblog, MySQL, Oracle, Oracle Applications Tagged With: amazon, ClosedWorld, cloud, openworld

September 21, 2010 by jwilton

A Cloud over San Francisco for OpenWorld 2010

Oracle OpenWorld 2010 is just bursting with big cloud-related announcements this week.  As I prepare to present on the Amazon cloud at OOW2010 on Thursday (http://bit.ly/aSKdIQ), I thought I would highlight two of the biggest cloud-related announcements of the week. Exalogic We all know about Exadata, Oracle’s hardware-based storage-optimized … [Read more...]

Filed Under: Amazon Web Services, Jeremiah Wilton's Oradeblog, Oracle, Oracle Applications Tagged With: amazon, cloud, EC2, exalogic, openworld

August 18, 2010 by jwilton

Finding thread IDs and names of SQL Server background threads

In Microsoft SQL Server, session IDs of 50 or less are dedicated background threads. These are analogous to Oracle’s background processes.  Suppose you needed to obtain the Windows thread ID of a SQL server background thread.  Just try finding out how to do that in the Microsoft documentation or by Googling.  I tried, and came up … [Read more...]

Filed Under: Jeremiah Wilton's Oradeblog, SQL Server

August 4, 2010 by jwilton

Good OCP / bad OCP

For those contemplating launching a career in Oracle database administration, there are essentially three routes: Oracle education and certification (OCP) Third-party educational programs (University and private training) Self-directed study and experimentation Most entering into the field assume that to be employable, they must become an Oracle … [Read more...]

Filed Under: Education, Jeremiah Wilton's Oradeblog

April 8, 2010 by jwilton

How Incompetence Stimulates the Information Technology Economy

As information technology professionals, we constantly complain about mismanaged projects in which we have the misfortune to be involved.  Frequently, someone with more power than knowledge – usually in management and under the sway of a persuasive vendor sales team – has come up with a systems design most politely described as novel. Because of … [Read more...]

Filed Under: Jeremiah Wilton's Oradeblog

March 23, 2010 by cedwards

High Performance Oracle 11g in the Amazon Cloud

Jeremiah Wilton will be presenting High Performance Oracle 11g in the Amazon Cloud at Collaborate 2010 - an updated version of his February RMOUG presentation.  For a preview, you can find both the white paper and presentation slides from RMOUG on our white paper page.  Currently scheduled for Monday, April 19, the session abstract reads: … [Read more...]

Filed Under: Jeremiah Wilton's Oradeblog, Oracle Tagged With: 11g, amazon cloud, aws, cloud computing, EC2, jere, Jeremiah Wilton

August 23, 2009 by cedwards

New presentation: Deriving Optimal Configurations Using 11g Database Replay

Jeremiah Wilton’s presentation shows how to use Oracle 11g Real Application Testing to quantify effect of system and database configuration changes.  As an example, he uses Real Application Testing to validate the Automatic Advisor recommendations, and uncovers some interesting results. Check out the presentation on our whitepaper page. … [Read more...]

Filed Under: Jeremiah Wilton's Oradeblog, News & Events, Oracle Tagged With: database replay, oracle configuration, performance tuning, Real Application Testing

March 23, 2009 by cedwards

New presentation: Simulating failures for testing and diagnostic practice

In this entertaining presentation, Jeremiah Wilton demonstrates creative ways to induce Oracle failures with the objective of learning how to detect, assess and diagnose problems.  Some of the self-induced failures are quite amusing, and will allow the reader to have some fun with their DBA friends. Check out the presentation on our whitepaper … [Read more...]

Filed Under: Jeremiah Wilton's Oradeblog, News & Events, Oracle Tagged With: database crash, emergency support, jeremiag wilton, ORA-00600, ORA-600, whitepaper

  • 1
  • 2
  • Next Page »

Categories

  • Amazon Web Services
  • Configuration Management
  • downtime
  • Drizzle
  • ebs
  • Education
  • elastic block store
  • elastic compute cloud
  • hosting
  • hot backup
  • ignorance
  • Infrastructure
  • IOUG
  • Jeremiah Wilton's Oradeblog
  • misconception
  • misconceptions
  • Monocle
  • MySQL
  • MySQL Council
  • News & Events
  • Oracle
  • Oracle Applications
  • Oracle Data Guard
  • Oracle Database
  • Oracle Database Appliance
  • Our People
  • OurSQL Community Podcast
  • outage
  • parallel
  • performance
  • podcast
  • proof
  • Remote DBA
  • replication
  • S3
  • Security
  • SQL Server
  • System monitoring
  • Uncategorized

Contact Blue Gecko

  • This field is for validation purposes and should be left unchanged.

Get Our Newsletter

  • This field is for validation purposes and should be left unchanged.

The Fine Print

  • Privacy Policy
  • Terms of Use
  • When is remote DBA the right solution
  • What are remote DBA services
  • Get Help

Blog Categories

  • 24/7 support
  • Blue Gecko 360° Services
  • Products Supported 24/7

Virtual runs

Contact Blue Gecko

Blue Gecko A/S
Slotsgade 21
DK – 4200 Slagelse
Denmark
Phone: (DK) +45 70 60 51 20

Networks

  • Email
  • Twitter

© Blue Gecko Group