OFFICIAL PYTHIAN BLOG

Industry insight and analysis covering Big Data, Hadoop, MongoDB, Oracle, SQL Server, MySQL, and more.

ALL POSTS

amcmd> a better “du”

I discovered ASM with a 10.1.0.3 RAC running on Linux Itanium and that was a big adventure. At this time there was no asmcmd. In 2005, Oracle released Oracle 10gR2 and asmcmd came into the place and we figured out how to make it work with a 10gR1 ASM. We were very excited to have a…

Simplify Oracle Tracing with Creative Scripting

Running a SQL trace is something that all DBAs do to varying degrees. Let’s say you are working on optimizing a SQL statement, and experimenting with some different hints for indexes and optimizer directives. This kind of effort typically goes something like this: modify the SQL statement enable tracing run the statement disable tracing disconnect…

Pillars of PowerShell: SQL Server – Part 2

Introduction This is the seventh and final post in the series on the Pillars of PowerShell. The previous posts in the series are: Interacting Commanding Debugging Profiling Windows OS SQL Server – Part 1 In this final post I am going to touch on SQL Server Management Objects (SMO) with PowerShell. SMO is one of the most widely…

Migration of Oracle Database to Amazon RDS using Golden Gate

Amazon RDS is a web service used to manage databases, like Oracle, in the cloud. Small- and medium-sized enterprises with databases of normal load, volume, and SLA, can certainly leverage the ease and cost efficiency Amazon RDS offers. There are two other methods that are widely used to migrate databases with minimal downtime: Oracle Data…

Three Hidden Azure SQL Database Gotchas

Azure SQL Database is Microsoft’s Database as a Service (DBaaS) platform offering. It allows end users to leverage the power of SQL Server in the cloud without the expense and complexity of building a private infrastructure. Additionally, this offering simplifies database maintenance tasks while providing seamless high availability and disaster recovery capabilities. Although DBaaS offerings…

Trust and confidence from Pythian

Recently I “inherited” some new responsibilities at work. It’s not the first time during my 11 or so of the last 16 years at Pythian. Throughout my employ at Pythian, I have been continually given new titles based on new roles I have taken on. For me, besides the enjoyment I have been lucky to…

Creating an Oracle Database Cloud Service

Back in late June of 2015, Larry Ellison launched several public cloud services and one of those services was the public DBaaS. Today, I had the opportunity to try out this new service. This blog post will examine how to create it and how to connect it with sqlcli. As with any cloud service, it…

Are you ready to be a private cloud service provider?

When defining what a cloud service is, we need to know that it is not a technology per se, but its an architectural and operational paradigm. It is a self-service computing environment offering the ability to create, consume, and pay for services. In this architecture, computing resources are elastically supplied from a shared pool and charged based…

Page 1 of 28512345...10...Last Page »