• About Dangerous DBA
  • Table of Contents
Dangerous DBA A blog for those DBA's who live on the edge

Category Archives: General Blog

Whats been going on in the world of the Dangerous DBA:

May 11, 2020 3:19 pm / Leave a Comment / dangerousDBA

It’s been a while ….. again:

So since I last posted way back in 2016 and QCon there has been a lot of water under the bridge in terms of technologies used and abused, and either taken into the stack or discarded to the ummm it nearly worked pile.

Things that have changed in that time:

Where a I work has seen a massive increase in the number of people in the data team in response to the business becoming far more data driven. The team has gone from two or three of us to three distinct sections all with a minimum of four people in them.

We now embrace what was just emerging as a widespread phenomenon in 2016 – streaming data; and make good use of this for micro services and data products.

I now have processed to a “senior” role in the business; with juniors and none prefixed or suffixed data engineers in the data products team.

Things that have NOT changed in that time:

We are still moving off DB2 but due to several large scale events over the years and the increasing size of the team then this is rapidly gathering pace but as a business we still need the old beast, but it has been on somewhat of a diet!

Where are things going:

Well for us from the Data Centre and Amazon Web Services (AWS) and to Google Cloud. Making extensive use of everything that it has to offer because of it nature we face far less of the size issues that we did on the data centre or even on AWS with some of its offerings

What are my interests (white whales) now:

Well I am going to be looking at a few things now:

  1. Google Cloud Management – is it possible to create a tool that will aid this from a green field prospective and also brownfield. It seems (not that I can google so they need to do a better effort at SEO) that there is not a product out there that does this in an obvious way
  2. IOT – This is going to be something that is “easily implemented” but then has individual elements that can taken WAY further, currently working on something and look put for upcoming posts

Posted in: 2020, Big Data, Blogging, General Blog / Tagged: AWS, GCP

Mentioned in dispatches from IBM

December 22, 2011 8:30 pm / Leave a Comment / dangerousDBA

A while back me and one of the directors at Holiday Extras where I work did a telephone interview with IBM arranged through Triton about the migration we did a while back from DB2 on HP-UX to DB2 on VM’s. It was an interesting experience and we did not have too many revisions and it is now published you can read it here.

Thats about the long and the short of this post, all that is left is to wish you a Merry Christmas and a Happy New Year and hope you dont get too many OOH calls.

Posted in: Confessions of a DB2 Geek, DB2, General Blog, IBM, Triton / Tagged: db2, hp ux, merry christmas and a happy new year

IDUG – EMEA – 13th – 1 DAYS

November 13, 2011 7:26 am / Leave a Comment / dangerousDBA

So I did not write this last night as I was a little tired but here we go now. Not actually a lot to write about the conference so far as nothing is due to happen till today (14th). All I can write about is the travel here and what I have learnt about the hotel so far.

Getting here was a “breeze”. Southern railways train / bus service from Hastings to Gatwick, considering there was a bus involved it was quite good. The bus was packed and there was quite a wait at Haywards Heath. I think this is because the trains carry far more people than the busses can and so several busses have to “catch up”. We arrived at Gatwick by my watch 30 seconds early, well done Southern Rail.

Easyjet first time travelling with them, not everything is explained but if you follow the crowds then you cant go wrong, just make sure you are near the front because the seats are first come first served. That said I still managed to get an isle seat and no one sat next to me. Seats were comfortable and overall I was very impressed with the flight and surrounding experience.

Taxi service from Prague airport to the Clarion Congress hotel was supplied by a company found on the internet – Prague Airport transfer, so far would highly recommend. They were there waiting for me with a name board when I arrived and the taxi was clean and the driver good and chatty. They gave me some money off vouchers various things in prague and a mini map. The other note here is that the confirmation that they send you and the price you see on the website is not each way it is the total price, because to my suprise when we arrived at the hotel he only asked my for half the fare I thought it was going to be.

Calrion Congress has been interesting, the room is brilliant and clean, only one BBC channel “World news” that is the only complaint about the room. I am lucky and it was arranged that everything would be charged to the room, this so far has not worked! I will have to see if it works today or not, think I will take the confirmation emails with me and flash them if it gets rejected again. Also do not put your room card in the same pocket as your mobile IT WILL WIPE IT!!!

So looking forward to the DB2 UDB V9.7 for LUW Advanced Database Administration certification Preparation Seminar with Guy Przytula and try not to be too much of a drag on the rest of the class as I have not quite finished the study guide. So I will try and do a post tonight and keep you all updated.

And thank you all to made this possible at Holiday Extras and Triton Consulting

Posted in: DB2, EMEA, General Blog, IBM, IDUG, Triton

DB2 LUW Research

September 19, 2011 8:22 pm / Leave a Comment / dangerousDBA

I was set a task by one of the company directors to find out about the DB2 ecosystem but there seems to be very little information out there that is freely accessible, or anybody that hints that they have it to buy so I have decided to collect my own. So this is a tester to see how willing you guys are to impart some information, equally once you have filled it in then you should be able to see the answers and have the info too.

So the first question was:

We use DB2 LUW on Linux SUSE. The next of the starter questions for the “DB2 ecosystem” was:

Here at Holiday Extras we use DB2 LUW for OLAP and data warehousing. The final question for this

Thank you for taking the time to fill in this questionnaire. There maybe more questions later and I would really appreciate it if you could keep an eye out and fill them in too.

Posted in: DB2, DB2 Ecosystem, DB2 Maintenance, General Blog, IBM

So what to put in my Blog

December 13, 2010 9:05 pm / Leave a Comment / dangerousDBA

Who knows what is going to be going on in the blog, well if you look at the top of the page you will see that I am going to be covering, but who knows there may be more, may be less. As you can see I am a natural writer, and this comes really easily to me, so bear with me and I am sure you might find out something useful.

Posted in: General Blog

Post Navigation

← Older Posts
 

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 757 other subscribers

Recent Posts

  • Self generating Simple SQL procedures – MySQL
  • Google Cloud Management – My Idea – My White Whale?
  • Position Tracker – The Stub – Pandas:
  • Position Tracker – The Stub
  • Position Tracker – In the beginning
  • Whats been going on in the world of the Dangerous DBA:
  • QCon London Day 1
  • Testing Amazon Redshift: Distribution keys and styles
  • Back to dangerous blogging
  • DB2 10.1 LUW Certification 611 notes 1 : Physical Design

Dangerous Topics

added functionality ADMIN_EST_INLINE_LENGTH Amazon Bootcamp colum convert data types db2 DB2 DB2 Administration DB2 Development db2advis db2licm Decompose XML Exam EXPORT Google IBM IBM DB2 LUW idug information centre infosphere LOAD merry christmas and a happy new year Recursive Query Recursive SQL Redshift Reorganisation Reorganise Reorganise Indexes Reorganise Tables Runstats sqlcode sql statement Stored Procedures SYSPROC.ADMIN_CMD Time UDF User Defined Functions V9.7 V10.1 Varchar XML XML PATH XMLTABLE

DangerousDBA Links

  • DB2 for WebSphere Commerce
  • My Personal Blog

Disclaimer:

The posts here represent my personal views and not those of my employer. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. DB2 is a trademark of IBM. I am not an employee or representative of IBM.

Advertising

© Copyright 2021 - Dangerous DBA
Infinity Theme by DesignCoral / WordPress