OFFICIAL PYTHIAN BLOG

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

ALL POSTS

Prepare for the Leap Second

Catch up on how to handle the Leap Second and whether you’re ready for it with our previous updates on the impacts it will have on Cassandra and Linux.   Background Information A leap second will be inserted at the end of June 30, 2015 at 23:59:60 UTC.  There is a small time difference between the…

Pillars of PowerShell: Windows OS

Introduction This is the fifth blog post continuing the series on the Pillars of PowerShell. The previous post in the series are: Interacting Commanding Debugging Profiling The Windows Operating System (OS) is something a DBA should know and be familiar with since SQL Server has to run on top of it. I would say that on…

Permissions in Redshift Administration

As with any database administration strategy, management of Redshift requires setting and revoking permissions.  When first setting up permissions, it is ideal to establish groups as the basic unit of user access.  This keeps us from having to manage hundreds of permissions as users enter and leave organizations.  If you haven’t done this early on…

Tracking ASM Metrics

Collecting ASM IO Metrics If you are an Oracle DBA, then it is quite likely that Oracle ASM is used as the storage management for at least some of the databases you manage. Eventually you will want to see ASM metrics that can be used to track the performance of the storage over time.  There…

Handling the Leap Second – Linux

Leap Second

Last week I published a blog post titled “Are You Ready For the Leap Second?“, and by looking at the blog statistics I could tell that many of you read it, and that’s good, because you became aware of the risks that the leap second on June 30th, 2015 introduces. On the other hand, I…

Cassandra Update – Leap Second & JMX Security

2000px-Cassandra_logo.svg

This is a short post about two things that should be on the to-do list for all Cassandra Administrators. The leap second issue and the new JMX default. The Leap Second Before we move on you should learn more about how the leap second affects Cassandra in more detail. In short, you must update your JVM to version…

Page 1 of 28212345...10...Last Page »