DaveWentzel.com            All Things Data

Dave Wentzel's blog

GitLab on Microsoft Azure

I wrote a guest blog post for gitlab.com regarding how to Setup a GitLab Instance in Microsoft Azure.  I'm a big user of git and gitlab puts a nice webUI on top of git, as well as a bunch of additional features.  With gitlab's new images on the Azure Marketplace developers have another avenue to host their git repositories without managing a git server or using external hosting like github.  

U-SQL In Azure Data Lake Presentation

Presentation Download  

(check back for an updated link to the presentation materials)

Hadoop for the RDBMS Expert


Presentation Download

I'll be presenting Hadoop for the RDBMS Expert at the PSSUG March Meeting at Microsoft's Malvern office.  

The Accidental MySQL DBA

If you are an "accidental MySQL DBA" this post is for you.  I assume you know almost nothing about MySQL, or its derivatives...such as MariaDB and Percona.  This post will give you just enough to get up-to-speed quickly and will give you enough knowledge to perform information google searches to find more detailed information.  I assume you have a working knowledge of MS SQLServer and I'll compare and contrast the two.  


Linux Performance Management for the DBA

Sometimes a DBA doesn't have the luxury of a Linux administrator when help is needed diagnosing performance problems.  It doesn't matter if you are an accidental DBA for PostgreSQL, MySQL, Vertica, or any other database manager (NoSQL included)...you really should know how to detect if your OS is performing its best.  This post is a quick guide for a DBA (or anyone really) who needs to get up-to-speed quickly on Linux from a performance management perspective.  

Migrating gitlab to omnibus from source, debian to rpm, apache to nginx, and mysql to postgresql

I've had my own gitlab installation for a few years.  I built it long before it was easy to build and maintain.  Originally I installed gitlab from source, on ubuntu, using mysql and apache.  It's a real PITA to maintain given that omnibus installations are so much easier to maintain.  (omnibus is geek-speek for "all-in-one").  In this post I'll cover the steps I did to pull off upgrading this to omnibus, switching to postgresql from mysql, apache to nginx, and ubuntu to centos (which is my new Linux standard).  


Other MySQL Performance Management Tooling

In my last post, nodetitle, I covered the performance_schema which is a relatively new feature of MySQL 5.5.  If you are using an earlier version of MySQL you won't have access to performance_schema.  This post covers your alternatives when you find yourself facing a performance problem as an "accidental MySQL DBA".  

Introduction to the MySQL Performance Schema

If you are new to performance troubleshooting with MySQL, specifically using the performance_schema, then this post is for you.  If you are an "accidental DBA" for MySQL, and you need to quickly fix some performance problems, then read on.  This post will give you example queries and background to get your MySQL performance problems solved quickly.  

Storm Notes

Need to get up-to-speed quickly on the basics of Apache Storm?  This quick post will give you everything you need to know to speak somewhat competently about Storm.  You'll learn the general architecture, terms, proper use cases, and basic administration and performance management.  

Couchbase Notes

If you have 10 minutes this blog post will give you a quick overview of what Couchbase is, how it works, and some gotchas.  Couchbase is a document-oriented, key-value store that is very simplistic.  But it's also rock solid.  If you are evaluating document stores and you need to come up to speed quickly on Couchbase then this post is for you.  



Subscribe to RSS - Dave Wentzel's blog