Posts Categorized: Pythian
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
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.
Whenever I tell an experienced Oracle DBA about Hadoop and what companies are doing with it, the immediate response is “But I can do this in Oracle”. Let’s compare.
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.
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.
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.
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.
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.
As we all look forward eagerly to 2012, bloggers around the gblobe are writing about their insightful reflections on 2011. You’re also welcome to write your’s regarding to database arena in the comments, if you like. This Log Buffer Edition welcomes you to the new year with festive posts from Oracle, SQL Server and MySQL bloggers in Log Buffer #252.
ew Year is the time to bid farewell to the old year and welcome the coming year. It is the time to remember the golden olden blog posts. It is the time for new beginnings and new starts in life, and of course for new blog posts. Bloggers in the database arena are also enjoying the festivities with full zeal and zest and this Log Buffer Edition, which is Log Buffer #251 covers just that. Happy Holidays.