Expandmenu Shrunk

  • Journey in Business Intelligence

    And so I have started the journey from my old job in safety and is stepping into business intelligence.

    The first step seemed simple.
    Just attach the adventure works database.

    The method described by Microsoft to attach the database to the server seems to require the log file to be available. the problem is that the log file is not a part of the downoad. Not a big problem, the instructions tell you that you need to remove the log file from the attach process in order to make it work.

    Turns out that it does not work. SSMS needs the log file and refuses to attach adventure works without it if you follow the instructions.

    Fortunately this can be easily done thorugh SQL.

    I found a description on how here: https://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/

    Using the first method described it worked the first time without problems.

  • Automating Mekanism

    I have taken a liking to the logistics pipes as they are quite versatile and able to connect to just about anything.

    I did face a problem with the metallurgic infuser from Mekanism though. It uses two inputs and one output for a total of three sides. With logistics pipes you only have the option of a single satelite pipe for an additional input. The craftong pipe then serves as the other input as well ad the output. While this does not pose a problem in most machines, the metallurgic infuser was being stubborn.

    Stubborn until I figured out what a sneaky upgrade was.

    With the sneaky upgrade you can tell the crafting pipe which side it should insert to. Combined with a satelite pipe it is now possible to insert from two sides and extract the finished product from a third side.

    The best thing is that the sneaky upgrade goes into the crafting pipe and does not need a pipe on the side it is inserting into.

  • Nether quartz

    Playing around with with Minechem I finally found a use for those granite and diorite blocks in my storage system.

    With Minechem, they can be turned into nether quartz!

    The process is quite easy as each granite or diorite block will give you the components you need for nether quartz. Simply decompose the block into Silicon Dioxide and Gallium ArsenideDecomposing graniteand reassemble it in the synthesizer. One granite gives you one nether quartz.making nether quartzAll you need is a little power.

    Sometimes you will get a few extra elements such as magnesium.

  • All the power

    Exploring the different power options reveals the classics such as big reactors and extra utilities.

    Mekanism had a generator that looked promising, the gas-burning generator.

    Gas-burning generatorWith this, you can burn hydrogen or ethylene. Hydrogen is not really worth it as it takes more power to create than it does when burned.

    Ethylene is a bit more complicated to make however it generates a lot more power.

    The process starts with biomass such as potatoes or saplings. You send them through a crusher to get biofuel. After that, the biofuel goes into a pressurized reaction chamber with water and hydrogen. The result is 100 mb of ethylene and 2 plastic bits.

    When the ethylene is burned in the gas-burning generator the entire process is easily able to power itself and have plenty of power left over.

    Where it really shines is in combination with Minechem.

    Remember how a treefarm would give you saplings and logs? Most will just convert the logs into charcoal and burn that.

    With Minechem you can use the chemical decomposer to get cellulose from logs. You can expect half of the logs to give you 8 cellulose.

    If you are using jungle trees, the vines will also give you some cellulose.

    Decomposing jungle logsThis can be converted into saplings in the synthesizer at a rate of 1 cellulose to 1 sapling.

    Creating Jungle saplingsThe saplings are sent into the crusher to get 2 bio-fuel per sapling.

    Crushing saplings

    The bio-fuel goes into a pressurized reaction chamber with water and hydrogen. 2 bio-fuel returns 100 mb of ethylene and 1 substrate. For now, I have no use for the substrate so it is being dumped into a cache for later use.

    making ethyleneThe ethylene is pumped straight into the gas-burning generator for lots of power.

    The end result is that the logs you get can be sent through the process and give you 400 mb of ethylene per log.

    While I have not maxed out the gas-burning generator, it has easily delivered 12.000 RF/tick with a very little fuel consumption.

    While most information you see on the gas-burning generator says it can only deliver a few hundred RF/tick, that is for an earlier version of Mekanism. In Mekanism V9, this limit has been removed allowing it to produce much more power.