Posts Categorized: Pythian

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

Searching for the blogging inspiration? On the look-out for that Eureka moment for your next blockbuster blog post? Finding the exact ingredients for your dream rambling? Well in the Log Buffer Edition, there are some awe-inspiring posts in this Log Buffer #256. Get Inspired, keep blogging.

T-SQL: Retrieve all users and associated roles for ALL databases

A frequent inquiry concerning databases’ security is to retrieve the database role(s) associated with each user for auditing or troubleshooting purposes. Each database user (principal) can be retrieved from sys.database_principals and the associated database roles can be retrieved from sys.database_role_members The following code runs against ALL the databases using SP_MSForeachdb and all roles for one principal is concatenated in one row

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

With winter and its cold weather starting to set in across most of the world, now is the time when travelers start to think about warming things up. For most, that means flying to hot and sunny destinations. Another way of looking at it, however, is to head out for a different kind of sizzle. There’s perhaps no better way to heat up the chilling months with blogging. Let’s snuggle up in this Log Buffer Edition with hot blog posts in Log Buffer #255.

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

After having party and festive time during holidays, bloggers are returning with reinvigorated zest and with uplifted zeal and the blogs are sprouting energy and promise. The new year is already here and the blogs across the database rainbow are oozing colors of all kinds. This Log Buffer Edition depicts some of them in Log Buffer #254.

Oracle Connects Big Data to Medium and Small Data

With the announcement of the Oracle Big Data Appliance, Oracle also comes up with some really cool technology stack which is being termed as Oracle Big Data Connectors (OBDC). This piece of software can be used with both Oracle Big Data Appliance and other Apache Hadoop-based systems.

Comparing Hadoop Appliances

At this time there are three Hadoop appliances in the market:Oracle’s Big Data appliance, Netapp’s Hadooplers and EMC’s Greenplum DCA. It looks like a lot of companies that did not already adopt Hadoop in 2011, are looking to do so in 2012, and some of them may be considering going with an appliance. I want to take a look at some of the reasons a company will be interested in a Hadoop appliance, and what are the differences between the different appliances.

Starting MySQL from cold backup: Replication stopped

A few days ago, we faced a Duplicate entry problem in the mysqld server on one of our customer’s slave after cold backup. We made some recommendations to the Customer (read them here) in which the option 3 was chosen as the slave was dedicated for backup’s and a quick solution applicable for their data set and timeline for resolution of the issue.

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

A very very Happy New Year 2012 to all of you. These are the festive and jubilant times when people look back on previous years and make plans for their new year and beyond. Well, this Log Buffer Edition is no different. This week covers the new year posts of the bloggers across the database arena in Log Buffer #253.

Page 60 of 203« First...102030...5859606162...708090...Last »