{
  "trx_id": "59b1a925e12da942aa9c0204ae61034fe1a69f4f",
  "block": 95645696,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2025-05-17T11:46:48",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "sqlinsix"
      ],
      "id": "notify",
      "json": "[\"setLastRead\",{\"date\":\"2025-05-17T11:46:49\"}]"
    }
  ]
}

{
  "trx_id": "082edcf2c9e8d0d8c4e17799fb20647774b80338",
  "block": 95509639,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2025-05-12T18:06:54",
  "op": [
    "account_update2",
    {
      "account": "sqlinsix",
      "json_metadata": "",
      "posting_json_metadata": "{\"profile\":{\"profile_image\":\"https://pbs.twimg.com/profile_images/990518972452823040/joHpcU3o_400x400.jpg\",\"about\":\"Data and Research Solutions\",\"website\":\"https://sqlinsix.com/\",\"version\":2,\"name\":\"SqlinSix\"}}",
      "extensions": []
    }
  ]
}

{
  "trx_id": "2bf40161339e218360d570854ed84c121bf40ac8",
  "block": 95509636,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2025-05-12T18:06:45",
  "op": [
    "account_update2",
    {
      "account": "sqlinsix",
      "json_metadata": "",
      "posting_json_metadata": "{\"profile\":{\"profile_image\":\"https://pbs.twimg.com/profile_images/990518972452823040/joHpcU3o_400x400.jpg\",\"about\":\"Data and Research Solutions\",\"website\":\"https://sqlinsix.com/\",\"version\":2}}",
      "extensions": []
    }
  ]
}

{
  "trx_id": "3bedf01f34245aac5c20aa3a9fa5bab190ebaf0f",
  "block": 83767198,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2024-03-29T11:52:18",
  "op": [
    "comment",
    {
      "parent_author": "sqlinsix",
      "parent_permlink": "common-wait-types-in-sql-server-pageiolaatchex",
      "author": "jordansanders",
      "permlink": "sb3yb6",
      "title": "",
      "body": "If you need to connect to SQL Server database, try to use <a href=\"https://www.devart.com/odbc/sqlserver/\">odbc for SQL server</a>.",
      "json_metadata": "{\"links\":[\"https://www.devart.com/odbc/sqlserver/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "69e926a965c4f3aa58eb4772e3144e6efadb1f4b",
  "block": 79268832,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2023-10-24T09:26:24",
  "op": [
    "comment",
    {
      "parent_author": "sqlinsix",
      "parent_permlink": "our-sql-server-transaction-log-is-growing-too-big",
      "author": "jordansanders",
      "permlink": "s310w1",
      "title": "",
      "body": "As for the connection to SQL Server, I use <a href=\"https://www.devart.com/odbc/sqlserver/\">ODBC driver for SQL Server</a>.",
      "json_metadata": "{\"links\":[\"https://www.devart.com/odbc/sqlserver/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "0e09a49280d8e94f9fff2bb4e54fc12676740443",
  "block": 72768099,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2023-03-11T02:19:03",
  "op": [
    "transfer",
    {
      "from": "steemegg",
      "to": "sqlinsix",
      "amount": "0.001 STEEM",
      "memo": "Vote se-witness as one of your 30 witnesses for free votes https://steemlogin.com/sign/account-witness-vote?witness=se-witness&approve=1 |  Send 15 or more TRON to TUep3qrvP4QwqHtoXJjdQ6Q7JRQdyuaJQH with your steem username as the memo for the market value back in steem.  Or visit steemegg.com and visit the exchange tab."
    }
  ]
}

{
  "trx_id": "05e5a890af85805db698759b68cacf2bc781c7a1",
  "block": 72583074,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2023-03-04T15:25:15",
  "op": [
    "comment",
    {
      "parent_author": "sqlinsix",
      "parent_permlink": "can-we-find-unused-tables-in-sql-server",
      "author": "hankdry",
      "permlink": "rr05i2",
      "title": "",
      "body": "Hello. It was interesting to read this article, since I work with this database myself. Therefore, I do not miss the opportunity to study useful information on this issue. For example, I recently found one useful article where I learned about <a href=\"https://codingsight.com/sql-convert-datetime-to-date-format/\">sql server date format convert</a>  . Everything is well and clearly described here, I think it will be clear even to beginners in this topic.",
      "json_metadata": "{\"links\":[\"https://codingsight.com/sql-convert-datetime-to-date-format/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "fa7fe4ec758ea09c2a61fcc5190493fe19bfa57a",
  "block": 70579439,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-12-24T17:36:48",
  "op": [
    "transfer",
    {
      "from": "steemegg",
      "to": "sqlinsix",
      "amount": "0.001 STEEM",
      "memo": "Free Upvotes Await!!!, Vote @se-witness for one of your 30 witness votes. Once you do so, you will start accumulating free upvotes every 6 hours automatically.  Please check my latests posts for more info.  Thanks!"
    }
  ]
}

{
  "trx_id": "2c475876a79f190995eb69f5869c4af0a3eccea0",
  "block": 68346467,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-10-07T17:36:18",
  "op": [
    "transfer",
    {
      "from": "roadofrich",
      "to": "sqlinsix",
      "amount": "0.005 STEEM",
      "memo": "❗Hello sqlinsix, You can contribute to the @roadofrich by voting as a witness. You will receive daily STEEM revenue through Witness vote. Enjoy your day 🙃"
    }
  ]
}

{
  "trx_id": "c02568e27214afae43b2d680edc9d1cf37eb1b68",
  "block": 68030409,
  "trx_in_block": 19,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-09-26T16:57:12",
  "op": [
    "transfer",
    {
      "from": "roadofrich",
      "to": "sqlinsix",
      "amount": "0.005 STEEM",
      "memo": "❗Hello sqlinsix, You can contribute to the @roadofrich by voting as a witness. You will receive daily STEEM revenue through Witness vote. Enjoy your day 🙃"
    }
  ]
}

{
  "trx_id": "de1fe3c7c73f13a1b6f19ee24dc76bed981763e9",
  "block": 67801485,
  "trx_in_block": 5,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-09-18T16:56:30",
  "op": [
    "transfer",
    {
      "from": "roadofrich",
      "to": "sqlinsix",
      "amount": "0.005 STEEM",
      "memo": "❗Hello sqlinsix, You can contribute to the @roadofrich by voting as a witness. You will receive daily STEEM revenue through Witness vote. Enjoy your day 🙃"
    }
  ]
}

{
  "trx_id": "74174d8b3335d5bbbdf9a852160c20cd19feafcf",
  "block": 67772810,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-09-17T16:55:51",
  "op": [
    "transfer",
    {
      "from": "roadofrich",
      "to": "sqlinsix",
      "amount": "0.005 STEEM",
      "memo": "❗Hello sqlinsix, You can contribute to the @roadofrich by voting as a witness. You will receive daily STEEM revenue through Witness vote. Enjoy your day 🙃"
    }
  ]
}

{
  "trx_id": "d5f6da2397136be15f2e7cb307eacf6c9d7bfbea",
  "block": 67369217,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-09-03T14:44:54",
  "op": [
    "transfer",
    {
      "from": "roadofrich",
      "to": "sqlinsix",
      "amount": "0.050 STEEM",
      "memo": "❗Hello sqlinsix, You can contribute to the @roadofrich by voting as a witness. 🪙 Vote to share for Daily Witness vote and more 🪙 . ❗ Enjoy your day 🙃"
    }
  ]
}

{
  "trx_id": "f68916e5758ff3e509982b5903af215dbc7bb788",
  "block": 66845237,
  "trx_in_block": 5,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-08-16T05:52:33",
  "op": [
    "transfer",
    {
      "from": "ph-support",
      "to": "sqlinsix",
      "amount": "0.011 STEEM",
      "memo": "Good morning @sqlinsix. We hope that you don't mind this little memo as we would love to bring your attention to small PASSIVE INCOME opportunity here on Steemit. Allow us to share with you link to our new delegation program. Perhaps you will find it worth your time and hopefully you will decide that our efforts bring value to Steemit and are worth your support. Link: // https://steemit.com/hive-175254/@ph-support/check-out-our-passive-income-delegation-program-run-by-project-hope"
    }
  ]
}

{
  "trx_id": "7f6ad25078428c10acd4457925e3dab04e67c7ef",
  "block": 66844853,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-08-16T05:33:15",
  "op": [
    "transfer",
    {
      "from": "ph-support",
      "to": "sqlinsix",
      "amount": "0.003 STEEM",
      "memo": "It's me again. We also would hope that you can Resteem this publication and help us bring more traffic and attention. It would be greatly appreciated. Cheers :)"
    }
  ]
}

{
  "trx_id": "3cead47ccf58560ec484bef0127cd3a99795d8b2",
  "block": 66842410,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-08-16T03:30:06",
  "op": [
    "transfer",
    {
      "from": "ph-support",
      "to": "sqlinsix",
      "amount": "0.011 STEEM",
      "memo": "Also we would hope that you can help us bring more traffic to our post by Resteeming it. It would be greatly appreciated. Cheers :)"
    }
  ]
}

{
  "trx_id": "c518646c19a5c2292b65a643929a3041dcd922a4",
  "block": 66611125,
  "trx_in_block": 13,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-08-08T01:22:36",
  "op": [
    "transfer",
    {
      "from": "crypto.piotr",
      "to": "sqlinsix",
      "amount": "0.001 STEEM",
      "memo": "hi. just small test (sorry for that memo, just testing some tool) . And have a great day."
    }
  ]
}

{
  "trx_id": "e0a15a8a44739ca5af310212c164611b16fbc127",
  "block": 66373429,
  "trx_in_block": 11,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-07-30T18:07:18",
  "op": [
    "transfer",
    {
      "from": "trx-steem",
      "to": "sqlinsix",
      "amount": "0.001 STEEM",
      "memo": "sqlinsix Send 15 or more Tron & get back STEEM Market Value back in under 1 minute ( Tron Address = TUep3qrvP4QwqHtoXJjdQ6Q7JRQdyuaJQH |   Memo = Username No @)"
    }
  ]
}

{
  "trx_id": "488602539786e9ad7c9ff49f32207ef94176254c",
  "block": 65417904,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-06-27T08:26:39",
  "op": [
    "comment",
    {
      "parent_author": "sqlinsix",
      "parent_permlink": "database-challenge-simultaneous-update-of-the-same-value",
      "author": "jordansanders",
      "permlink": "re4ngy",
      "title": "",
      "body": "Here are a few tips on how to effectively handle concurrent updates:\n- Transactions are not supported by all database types. Although MyISAM is still supported, it is not MySQL's default database engine. \n- Due to circumstances beyond your control, transactions may not proceed. If this happens, you'll need to be ready to re-enter your application's BEGIN WORK code.\n- Otherwise, the first select can read data that other transactions have not yet committed (transactions aren't like mutexes in programming languages). \n- If there are concurrent ongoing SERIALIZABLE transactions, some databases will throw an error, and you will have to restart the transaction.\n- SELECT.. FOR UPDATE locks the rows retrieved by select until the end of the transaction in some databases.\nTo deal with concurrent updates easier, you can use these helpful <a href=\"https://www.devart.com/dbforge/sql/sql-tools/\">SQL Tools</a>.",
      "json_metadata": "{\"links\":[\"https://www.devart.com/dbforge/sql/sql-tools/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "744803c82daf72be5d473030142610b5bbaa2f0a",
  "block": 65417816,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-06-27T08:22:15",
  "op": [
    "comment",
    {
      "parent_author": "sqlinsix",
      "parent_permlink": "7kfg5p-use-triggers-or-not-in-sql-server",
      "author": "jordansanders",
      "permlink": "re4n9o",
      "title": "",
      "body": "There are several uses for triggers in SQL Server, including the following:\n- Performing additional checks on the affected table while performing insert, update, or delete actions.\n- They allow users to encode sophisticated default values that default constraints can't handle.\n- All databases must have referential integrity.\n- If you have a view that uses many tables, you may use these controls to fine-tune what happens when you conduct an insert, update, or delete operation.\n- The use of triggers allows you to create a table with aggregated columns that you may manipulate.\n- Using triggers in auditing and enforcing business rules is the best option. It is possible to keep track of table modifications by creating an audit log record that contains information about the user who made the change and what was modified using a trigger.\nYou can also use a stored procedure, but if you do so, you won't be able to log changes that were made directly to the database. It is worth mentioning that a helpful <a href=\"https://www.devart.com/dbforge/sql/studio/\">SQL Manager</a> will automate a lot of processes.",
      "json_metadata": "{\"links\":[\"https://www.devart.com/dbforge/sql/studio/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "9d4dcdb3b786aeaedc5381347dda9c360ebe45ee",
  "block": 65335605,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-06-24T11:24:51",
  "op": [
    "comment",
    {
      "parent_author": "sqlinsix",
      "parent_permlink": "can-we-find-unused-tables-in-sql-server",
      "author": "jordansanders",
      "permlink": "rdzbpz",
      "title": "",
      "body": "Some tables may be unnecessary if their names include the suffixes \"_TEMP,\" \"__TEMP,\" and \"__TEMP\" (as long as this is what is being done for objects that are temporary in nature). All database tables can be retrieved using the sys.all_objects system table, and the type of the object can be restricted to 'U', and then the unwanted tables can be deleted.\nIf the owner of the system failed to rename the tables, we must devise a method for identifying the tables that are no longer in use.\nIf you'd like to know how many scans, searches, and updates have been performed on your database tables since the SQL Service was last restarted, use the sys.dm_db_index_usage_stats DMV in your system. SQL Server restarted, and any table that has not been used since then can be assumed to be an unused table in our query.\nYou can also use helpful <a href=\"https://www.devart.com/dbforge/sql/sql-tools/\">SQL Tools</a> to make the process easier.",
      "json_metadata": "{\"links\":[\"https://www.devart.com/dbforge/sql/sql-tools/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "f9bb8e7a2bbdc0df59450a8ca73cece22754414a",
  "block": 65335428,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2022-06-24T11:16:00",
  "op": [
    "comment",
    {
      "parent_author": "sqlinsix",
      "parent_permlink": "which-tool-sql-vs-nosql",
      "author": "jordansanders",
      "permlink": "rdzbb8",
      "title": "",
      "body": "NoSQL databases differ from SQL databases in that they are not based on relationships.\nA structured query language and a predetermined schema are both features of SQL databases. Unstructured data can be stored in NoSQL databases with dynamic schemas.\nBoth SQL and NoSQL databases are scalable vertically, however only NoSQL databases are scalable horizontally.\nNoSQL databases are document, key-value, graph, or wide-column stores, whereas SQL databases are table-based.\nNoSQL databases are better for unstructured data, such as documents or JSON, than SQL databases.\nSSMS is very popular among users but it can be enhanced with dbForge <a href=\"https://www.devart.com/dbforge/sql/sql-tools/\">SQL Tools</a>.",
      "json_metadata": "{\"links\":[\"https://www.devart.com/dbforge/sql/sql-tools/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58993375,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 5,
  "timestamp": "2021-11-14T15:17:57",
  "op": [
    "author_reward",
    {
      "author": "sqlinsix",
      "permlink": "6ur7lc-solution-when-isjson-may-not-be-a-recognized-function-name",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "175.528139 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58993375,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 4,
  "timestamp": "2021-11-14T15:17:57",
  "op": [
    "curation_reward",
    {
      "curator": "sqlinsix",
      "reward": "173.680474 VESTS",
      "comment_author": "sqlinsix",
      "comment_permlink": "6ur7lc-solution-when-isjson-may-not-be-a-recognized-function-name"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58908874,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 4,
  "timestamp": "2021-11-11T16:28:09",
  "op": [
    "author_reward",
    {
      "author": "sqlinsix",
      "permlink": "57x1ra-creating-a-guid-for-each-guid",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "171.876745 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58908874,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 3,
  "timestamp": "2021-11-11T16:28:09",
  "op": [
    "curation_reward",
    {
      "curator": "sqlinsix",
      "reward": "170.028608 VESTS",
      "comment_author": "sqlinsix",
      "comment_permlink": "57x1ra-creating-a-guid-for-each-guid"
    }
  ]
}

{
  "trx_id": "d6b428b995bd32a2f351f2fb448157a13c7ab951",
  "block": 58851003,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-09T15:55:51",
  "op": [
    "vote",
    {
      "voter": "sqlinsix",
      "author": "sqlinsix",
      "permlink": "6ur7lc-solution-when-isjson-may-not-be-a-recognized-function-name",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "6f2042eaf7cff4c31a91fad5e71e68e23bbedb67",
  "block": 58800341,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-07T21:28:18",
  "op": [
    "vote",
    {
      "voter": "oreany",
      "author": "sqlinsix",
      "permlink": "6ur7lc-solution-when-isjson-may-not-be-a-recognized-function-name",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "bcea1ce18b0d91995a4418fded480cb2cd6ecb02",
  "block": 58792978,
  "trx_in_block": 21,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-07T15:17:57",
  "op": [
    "comment_options",
    {
      "author": "sqlinsix",
      "permlink": "6ur7lc-solution-when-isjson-may-not-be-a-recognized-function-name",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 0,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": []
    }
  ]
}

{
  "trx_id": "bcea1ce18b0d91995a4418fded480cb2cd6ecb02",
  "block": 58792978,
  "trx_in_block": 21,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-07T15:17:57",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "data",
      "author": "sqlinsix",
      "permlink": "6ur7lc-solution-when-isjson-may-not-be-a-recognized-function-name",
      "title": "Solution When ISJSON May Not Be A Recognized Function Name",
      "body": "https://www.youtube.com/watch?v=hyoTI16qUns\n\n<p>Check out the solution in the video <a href=\"https://www.youtube.com/watch?v=hyoTI16qUns\">Schema validation failed: 'ISJSON' is not a recognized built-in function name</a>.  First, note the version of Microsoft SQL Server that we're using.  This is key because we'll see this error if we're using an older version of Microsoft SQL Server.  Second, before upgrading our SQL Server environment, we want to evaluate what we have and be sure that this is the best choice (see below for more information for considerations).  Finally, we have some options outside of SQL Server to convert JSON if we need to get data from a JSON format before extracting the data and importing it into SQL Server.</p>\n\n<center><a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\"><img src=\"https://www.fintekdev.com/wp-content/uploads/2018/08/ad1.jpg\" alt=\"Automating ETL\"></a>\n<em>Check out the highest-rated <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> course on Udemy, if you're interested in data.</em></center>\n\n<p>We will find that some environments are using legacy systems (this may have advantages in both cost and security).  While we can upgrade these environments, we will want to ensure that our database environment will be compatible with an upgrade.  Changes may affect existing code, especially if code or features are deprecated.  Also, we want to ensure that our environment can handle this security and cost change - these two cannot be overlooked.  Upgrading an environment for one function is definitely not worth it, but if there are other reasons to upgrade, this may be worth the effort.  This requires a comprehensive review of the environment.  In the meantime if we cannot immediately upgrade our environment, we can look at alternatives converting JSON, such as scripting languages or the language we're using in our software application (if applicable).  In general, depending on the JSON file or source, this may be faster.  For instance, extracting and designing a schema from a JSON API source would be much faster with a scripting or OOP language in general.</p>\n\n<p><center><a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">YouTube</a> | <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> | <a href=\"https://skl.sh/2mSNeTK\" target=\"_blank\">T-SQL In 2 Hours</a> | <a href=\"https://skl.sh/2XcKpSU\" target=\"_blank\">Consumer Guide To Digital Security</a></p></center>",
      "json_metadata": "{\"tags\":[\"data\",\"development\",\"sql\",\"sqlserver\"],\"image\":[\"https://img.youtube.com/vi/hyoTI16qUns/0.jpg\",\"https://www.fintekdev.com/wp-content/uploads/2018/08/ad1.jpg\"],\"links\":[\"https://www.youtube.com/watch?v=hyoTI16qUns\",\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\",\"https://www.youtube.com/user/sqlinsix\",\"https://skl.sh/2mSNeTK\",\"https://skl.sh/2XcKpSU\"],\"app\":\"steemit/0.2\",\"format\":\"markdown\"}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58763641,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 3,
  "timestamp": "2021-11-06T14:43:15",
  "op": [
    "author_reward",
    {
      "author": "sqlinsix",
      "permlink": "35zgpr-get-a-past-bash-command-quickly",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "179.348020 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58763641,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 2,
  "timestamp": "2021-11-06T14:43:15",
  "op": [
    "curation_reward",
    {
      "curator": "sqlinsix",
      "reward": "177.499072 VESTS",
      "comment_author": "sqlinsix",
      "comment_permlink": "35zgpr-get-a-past-bash-command-quickly"
    }
  ]
}

{
  "trx_id": "f00e98118328c79a367806d016735d1b7822f818",
  "block": 58741358,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-05T20:02:39",
  "op": [
    "vote",
    {
      "voter": "driklo",
      "author": "sqlinsix",
      "permlink": "57x1ra-creating-a-guid-for-each-guid",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "7ff395031846695b892fea738a918f4eddc0447e",
  "block": 58732189,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-05T12:21:54",
  "op": [
    "vote",
    {
      "voter": "sqlinsix",
      "author": "sqlinsix",
      "permlink": "57x1ra-creating-a-guid-for-each-guid",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "5d0a22c5eba2fab537894b7a35d9e430e79ca15f",
  "block": 58730456,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-05T10:54:39",
  "op": [
    "vote",
    {
      "voter": "werviev",
      "author": "sqlinsix",
      "permlink": "57x1ra-creating-a-guid-for-each-guid",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "3ddb667626e99a9da043e3493bf093ea41653674",
  "block": 58708441,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-04T16:28:09",
  "op": [
    "comment_options",
    {
      "author": "sqlinsix",
      "permlink": "57x1ra-creating-a-guid-for-each-guid",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 0,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": []
    }
  ]
}

{
  "trx_id": "3ddb667626e99a9da043e3493bf093ea41653674",
  "block": 58708441,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-11-04T16:28:09",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "data",
      "author": "sqlinsix",
      "permlink": "57x1ra-creating-a-guid-for-each-guid",
      "title": "Creating a GUID For Each GUID",
      "body": "https://www.youtube.com/watch?v=KGv2nZDTfQ4\n\n<p>What happens when we run into a situation where we need to create a GUID for reach GUID?  Check out the solution in the video <a href=\"https://www.youtube.com/watch?v=KGv2nZDTfQ4\">TSQL: Create A GUID For Each GUID (Unique Identifier For Each Unique Identifier)</a>.  As you can see, we learn how to solve this rare event.</p>\n\n<p>Some questions that are answered in the video:<ul>\n<li>What is the possible combination of GUIDs?</li>\n<li>How many GUIDs of each GUID combinations would we have?</li>\n<li>What is a more likely combinatino of GUID plus another identifier?</li>\n</ul></p>\n\n<center><a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\"><img src=\"https://images.hive.blog/DQmPh1cTFVKjUUzATnbCcEYwBw16Cz5RFiy6UAL2vkkF9hd/Ad%20-%20Udemy.PNG\" alt=\"Automating ETL\"></a>\n<em>For mastering data transformation from one form to another form, check out the highest-rated <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> course on Udemy.  For a coupon to the course, check out the trailer video on the channel <a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">SQL In Six Minutes</a>.</em></center>\n\n<p>Even though we don't develop GUIDs with GUIDs often, this doesn't mean that we'll never use this development. There are some cases where we will - when we have a significant number of data points for another significant set of data points.  It's useful to know how to accomplish this in T-SQL in the less-than-common event that we'll use it.</p>\n\n<p>Are you looking for tech consultants that can assist with design and development?  From building custom applications to working with existing infrastructure that's causing you trouble, we can get you connected to consultants who can assist.  You can <a href=\"https://forms.gle/pLgNJaz8XUVET5zB6\" target=\"_blank\">contact for assistance</a>.</p>\n\n<p><center><a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">SQL In Six Minutes</a> | <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> | <a href=\"https://skl.sh/2mSNeTK\" target=\"_blank\">T-SQL In 2 Hours</a> | <a href=\"https://skl.sh/2XcKpSU\" target=\"_blank\">Consumer Guide To Digital Security</a></center></p>",
      "json_metadata": "{\"tags\":[\"data\",\"development\",\"sql\"],\"image\":[\"https://img.youtube.com/vi/KGv2nZDTfQ4/0.jpg\",\"https://images.hive.blog/DQmPh1cTFVKjUUzATnbCcEYwBw16Cz5RFiy6UAL2vkkF9hd/Ad%20-%20Udemy.PNG\"],\"links\":[\"https://www.youtube.com/watch?v=KGv2nZDTfQ4\",\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\",\"https://www.youtube.com/user/sqlinsix\",\"https://forms.gle/pLgNJaz8XUVET5zB6\",\"https://skl.sh/2mSNeTK\",\"https://skl.sh/2XcKpSU\"],\"app\":\"steemit/0.2\",\"format\":\"markdown\"}"
    }
  ]
}

{
  "trx_id": "1e65079cf578fbf137a9edf35c682165f68aa648",
  "block": 58593714,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-31T16:16:21",
  "op": [
    "vote",
    {
      "voter": "sqlinsix",
      "author": "sqlinsix",
      "permlink": "35zgpr-get-a-past-bash-command-quickly",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "46d23f4ff3080081d6117b1d0ca2931e552d22cc",
  "block": 58579257,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-31T04:07:51",
  "op": [
    "vote",
    {
      "voter": "rooseveit",
      "author": "sqlinsix",
      "permlink": "35zgpr-get-a-past-bash-command-quickly",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "2c50d53b1b74157e15dd94d3f282fc39634ca260",
  "block": 58573092,
  "trx_in_block": 23,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-30T22:57:12",
  "op": [
    "vote",
    {
      "voter": "harcles",
      "author": "sqlinsix",
      "permlink": "35zgpr-get-a-past-bash-command-quickly",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "839d39cefd581404a31d3f1854e64a50f5be1dce",
  "block": 58563284,
  "trx_in_block": 22,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-30T14:43:15",
  "op": [
    "comment_options",
    {
      "author": "sqlinsix",
      "permlink": "35zgpr-get-a-past-bash-command-quickly",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 0,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": []
    }
  ]
}

{
  "trx_id": "839d39cefd581404a31d3f1854e64a50f5be1dce",
  "block": 58563284,
  "trx_in_block": 22,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-30T14:43:15",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "development",
      "author": "sqlinsix",
      "permlink": "35zgpr-get-a-past-bash-command-quickly",
      "title": "Get A Past Bash Command Quickly",
      "body": "https://www.youtube.com/watch?v=ifiWrO7FFpo\n\n<p>It's one thing to to surf for past Bash commands if we've only run a few of them in one day, but what if we've been running hundreds (or thousands) of Bash commands and we want to look through our history to get one and re-use it quickly?  Given that a short command could easily be typed, we'll assume that we're surfing for a past command that would take some time to type out, or a past command that we may have forgotten and need to consider.  What happens when we want to get that specific Bash command without re-typing the whole thing in this scenario?  In the video, <a href=\"https://www.youtube.com/watch?v=ifiWrO7FFpo\">Bash Hack: Get History and Select Past Command In Bash</a>, we learn how we can look through past Bash commands and select one for re-use.</p>\n\n<p>Some examples we see in the video:<ul>\n<li>What's a quick way to get the past commands in Bash that we see in the video?</li>\n<li>For quick re-use (and to save us time), how to set the current command to a past one?</li>\n<li>Think of an example when this may be useful - consider that sometimes our commands will be similar to each other and we can get a past command, make a quick edit, then execute it.</li>\n<li>In the context of security, what might be something we want to consider when we write a command that might involve information we may not want \"surfable\"?  What is a way that we can protect this data?</li>\n</ul></p>\n\n<center><a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\"><img src=\"https://images.hive.blog/DQmPh1cTFVKjUUzATnbCcEYwBw16Cz5RFiy6UAL2vkkF9hd/Ad%20-%20Udemy.PNG\" alt=\"Automating ETL\"></a>\n<em>For mastering data transformation from one form to another form, check out the highest-rated <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> course on Udemy.  For a coupon to the course, check out the trailer video on the channel <a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">SQL In Six Minutes</a>.</em></center>\n\n<p>When we want to get a past line, but edit it we can get the past command, then quickly edit the line before running it.  Keep in mind that we'll want to confirm that we obtained the correct past command or else we may end up running something that we didn't want (depends on the actual command).  I also note how we can search the history of past commands, then extract what we want and edit as appropriate (if required).  Given that this feature exists, it should raise concerns about the commands that we use - a history of these exist and we want to reflect over this in the context of security.  While this goes unmentioned, we should be extremely careful about running commands with key data, such as passwords, certificates, etc.</p>\n\n<p>Are you looking for tech consultants that can assist with design and development?  From building custom applications to working with existing infrastructure that's causing you trouble, we can get you connected to consultants who can assist.  You can <a href=\"https://forms.gle/pLgNJaz8XUVET5zB6\" target=\"_blank\">contact for assistance</a>.</p>\n\n<p><center><a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">SQL In Six Minutes</a> | <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> | <a href=\"https://skl.sh/2mSNeTK\" target=\"_blank\">T-SQL In 2 Hours</a> | <a href=\"https://skl.sh/2XcKpSU\" target=\"_blank\">Consumer Guide To Digital Security</a></center></p>",
      "json_metadata": "{\"tags\":[\"development\",\"bash\",\"linux\",\"security\"],\"image\":[\"https://img.youtube.com/vi/ifiWrO7FFpo/0.jpg\",\"https://images.hive.blog/DQmPh1cTFVKjUUzATnbCcEYwBw16Cz5RFiy6UAL2vkkF9hd/Ad%20-%20Udemy.PNG\"],\"links\":[\"https://www.youtube.com/watch?v=ifiWrO7FFpo\",\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\",\"https://www.youtube.com/user/sqlinsix\",\"https://forms.gle/pLgNJaz8XUVET5zB6\",\"https://skl.sh/2mSNeTK\",\"https://skl.sh/2XcKpSU\"],\"app\":\"steemit/0.2\",\"format\":\"markdown\"}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58557582,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 4,
  "timestamp": "2021-10-30T09:55:57",
  "op": [
    "author_reward",
    {
      "author": "sqlinsix",
      "permlink": "3clslm-connecting-a-data-factory-to-an-existing-runtime-in-azure",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "177.609896 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58557582,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 3,
  "timestamp": "2021-10-30T09:55:57",
  "op": [
    "curation_reward",
    {
      "curator": "sqlinsix",
      "reward": "177.609896 VESTS",
      "comment_author": "sqlinsix",
      "comment_permlink": "3clslm-connecting-a-data-factory-to-an-existing-runtime-in-azure"
    }
  ]
}

{
  "trx_id": "a9d88d60632fc26d95cbb7b44ba7d03c75b644df",
  "block": 58388376,
  "trx_in_block": 8,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-24T12:02:21",
  "op": [
    "vote",
    {
      "voter": "sqlinsix",
      "author": "sqlinsix",
      "permlink": "3clslm-connecting-a-data-factory-to-an-existing-runtime-in-azure",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "290b70d6762644a53914e6d5dcbbbd1b20d8263d",
  "block": 58357217,
  "trx_in_block": 21,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-23T09:55:57",
  "op": [
    "comment_options",
    {
      "author": "sqlinsix",
      "permlink": "3clslm-connecting-a-data-factory-to-an-existing-runtime-in-azure",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 0,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": []
    }
  ]
}

{
  "trx_id": "290b70d6762644a53914e6d5dcbbbd1b20d8263d",
  "block": 58357217,
  "trx_in_block": 21,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-23T09:55:57",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "azure",
      "author": "sqlinsix",
      "permlink": "3clslm-connecting-a-data-factory-to-an-existing-runtime-in-azure",
      "title": "Connecting A Data Factory To An Existing Runtime In Azure",
      "body": "https://www.youtube.com/watch?v=IpvmNyTLDxE\n\n<p>With Azure Data Factory, we can connect on premise assets to Azure resources, such as an on premise database to an Azure database.  At this time, this will require an on premise runtime that communicates with both the on premise resource and the Azure resource.  In the video <a href=\"https://www.youtube.com/watch?v=IpvmNyTLDxE\">Connect Azure Data Factory To Existing Runtime</a>, we see how to connect an Azure Data Factory to an existing run time (to set up a runtime on premise, review the video <a href=\"https://www.youtube.com/watch?v=CA7ML8NRM4U\">How To Setup A Runtime for Azure Data Factory</a>, as this video assumes that we have a runtime setup on one of our servers that has been linked to a data factory).  While not discussed in the video, we should review the security of our design - we want to be extremely careful connection on premise assets to the cloud.  If we will be sending data from an on premise asset, make sure that both the server with the data and the server running the runtime (if different) are isolated.</p>\n\n<center><a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\"><img src=\"https://images.hive.blog/DQmPh1cTFVKjUUzATnbCcEYwBw16Cz5RFiy6UAL2vkkF9hd/Ad%20-%20Udemy.PNG\" alt=\"Automating ETL\"></a>\n<em>For mastering data transformation from one form to another form, check out the highest-rated <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> course on Udemy.  For a coupon to the course, check out the trailer video on the channel <a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">SQL In Six Minutes</a>.</em></center>\n\n<p>Once we have our runtime setup, we can grant permissions from this runtime to Azure Data Factories.  We will want to consider how many data factories we want to share this with, as well as whether sharing this will comply with some of our other standards.  For an example, we should not connect one runtime to our Sandbox-QA-Preproduction-Production environments for multiple reasons - scaling, testing and security, to name a few reasons.  The only exception to this would be if we were demonstrating what <strong>NOT</strong> to do.  The same logic applies if we're connecting a runtime to multiple assets within an environment: we want to consider scale early, as it will be more costly if we make adjustments later.</p>\n\n<p>Are you looking for tech consultants that can assist with design and development?  From building custom applications to working with existing infrastructure that's causing you trouble, we can get you connected to consultants who can assist.  You can <a href=\"https://forms.gle/pLgNJaz8XUVET5zB6\" target=\"_blank\">contact for assistance</a>.</p>\n\n<p><center><a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">SQL In Six Minutes</a> | <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> | <a href=\"https://skl.sh/2mSNeTK\" target=\"_blank\">T-SQL In 2 Hours</a> | <a href=\"https://skl.sh/2XcKpSU\" target=\"_blank\">Consumer Guide To Digital Security</a></center></p>",
      "json_metadata": "{\"tags\":[\"azure\",\"datafactory\",\"data\",\"dataengineering\",\"development\"],\"image\":[\"https://img.youtube.com/vi/IpvmNyTLDxE/0.jpg\",\"https://images.hive.blog/DQmPh1cTFVKjUUzATnbCcEYwBw16Cz5RFiy6UAL2vkkF9hd/Ad%20-%20Udemy.PNG\"],\"links\":[\"https://www.youtube.com/watch?v=IpvmNyTLDxE\",\"https://www.youtube.com/watch?v=CA7ML8NRM4U\",\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\",\"https://www.youtube.com/user/sqlinsix\",\"https://forms.gle/pLgNJaz8XUVET5zB6\",\"https://skl.sh/2mSNeTK\",\"https://skl.sh/2XcKpSU\"],\"app\":\"steemit/0.2\",\"format\":\"markdown\"}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58328716,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 8,
  "timestamp": "2021-10-22T10:02:03",
  "op": [
    "author_reward",
    {
      "author": "sqlinsix",
      "permlink": "46ecfc-backing-up-a-database-with-mongodump",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "177.733552 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58328716,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 7,
  "timestamp": "2021-10-22T10:02:03",
  "op": [
    "curation_reward",
    {
      "curator": "sqlinsix",
      "reward": "177.733552 VESTS",
      "comment_author": "sqlinsix",
      "comment_permlink": "46ecfc-backing-up-a-database-with-mongodump"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58241550,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 15,
  "timestamp": "2021-10-19T08:58:57",
  "op": [
    "author_reward",
    {
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "2062.998136 VESTS"
    }
  ]
}

{
  "trx_id": "e4d7b6d1fb067f50e68412113806f9dfcef13950",
  "block": 58164086,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-16T16:03:48",
  "op": [
    "vote",
    {
      "voter": "sqlinsix",
      "author": "sqlinsix",
      "permlink": "46ecfc-backing-up-a-database-with-mongodump",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "35463726664d687a106786fbec9b10ecf11bdd28",
  "block": 58163304,
  "trx_in_block": 17,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-16T15:24:36",
  "op": [
    "vote",
    {
      "voter": "xazt",
      "author": "sqlinsix",
      "permlink": "46ecfc-backing-up-a-database-with-mongodump",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "4dbb898a3dfd5fcf811c9debf71e0be103e7da49",
  "block": 58155613,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-16T08:57:48",
  "op": [
    "vote",
    {
      "voter": "tropit",
      "author": "sqlinsix",
      "permlink": "46ecfc-backing-up-a-database-with-mongodump",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "08167e7e84ab2e246f8150c908e873492976d4fc",
  "block": 58136137,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-15T16:38:27",
  "op": [
    "vote",
    {
      "voter": "krutyn",
      "author": "sqlinsix",
      "permlink": "46ecfc-backing-up-a-database-with-mongodump",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "2f43a54a968ca1b73dc94b6eba3a65c519a454b1",
  "block": 58128251,
  "trx_in_block": 5,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-15T10:02:03",
  "op": [
    "comment_options",
    {
      "author": "sqlinsix",
      "permlink": "46ecfc-backing-up-a-database-with-mongodump",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 0,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": []
    }
  ]
}

{
  "trx_id": "2f43a54a968ca1b73dc94b6eba3a65c519a454b1",
  "block": 58128251,
  "trx_in_block": 5,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-15T10:02:03",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "development",
      "author": "sqlinsix",
      "permlink": "46ecfc-backing-up-a-database-with-mongodump",
      "title": "Backing Up A Database With MongoDump",
      "body": "https://www.youtube.com/watch?v=KrikV7xtQOw\n\n<p>Review how to backup a database with a built-in tool in <a href=\"https://www.youtube.com/watch?v=KrikV7xtQOw\">MongoDB: How To Backup With MongoDump</a>.  As you can see, we learn how backup a database.  As a note, you'll want to specify a location that you are willing to store files.  You'll also want to ensure that your drive can handle the space required for the backup files that are generated.</p>\n\n<p>Some examples we see in the video:<ul>\n<li>What tool comes with MongoDB that we can use for backing up?</li>\n<li>How to specify the database?</li>\n<li>What you should know about the structure?</li>\n</ul></p>\n\n<center><a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\"><img src=\"https://www.fintekdev.com/wp-content/uploads/2018/08/ad1.jpg\" alt=\"Automating ETL\"></a>\n<em>Check out the highest-rated <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> course on Udemy, if you're interested in data.</em></center>\n\n<p>As a note, just because we backup a database does not mean that it will restore at a later time.  For those of you who are familiar with SQL Server, you know that corruption can occur which makes backups invalid.  This occurs with MongoDB too.</p>\n\n<p><center><a href=\"https://www.youtube.com/user/sqlinsix\" target=\"_blank\">YouTube</a> | <a href=\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\">Automating ETL</a> | <a href=\"https://skl.sh/2mSNeTK\" target=\"_blank\">T-SQL In 2 Hours</a> | <a href=\"https://skl.sh/2XcKpSU\" target=\"_blank\">Consumer Guide To Digital Security</a></p></center>",
      "json_metadata": "{\"tags\":[\"development\",\"mongodb\",\"nosql\",\"data\"],\"image\":[\"https://img.youtube.com/vi/KrikV7xtQOw/0.jpg\",\"https://www.fintekdev.com/wp-content/uploads/2018/08/ad1.jpg\"],\"links\":[\"https://www.youtube.com/watch?v=KrikV7xtQOw\",\"https://www.udemy.com/course/automatingetl/?referralCode=4F1507936B09B12EBB2C\",\"https://www.youtube.com/user/sqlinsix\",\"https://skl.sh/2mSNeTK\",\"https://skl.sh/2XcKpSU\"],\"app\":\"steemit/0.2\",\"format\":\"markdown\"}"
    }
  ]
}

{
  "trx_id": "d0feb9c698ea4e0c0f809bf6699746e8be7792fa",
  "block": 58107849,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-14T16:56:00",
  "op": [
    "vote",
    {
      "voter": "ruzmaira",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "f264da666fac33ed8ca27541485b3515daf7acd3",
  "block": 58085000,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:47:27",
  "op": [
    "vote",
    {
      "voter": "remlaps1",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "14e5340e7da99bdc20429698ff5e1852f0ef96f5",
  "block": 58084997,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:47:18",
  "op": [
    "vote",
    {
      "voter": "cub1",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "0881923eb9ef5e598cb18440801a17c44dce9712",
  "block": 58084995,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:47:12",
  "op": [
    "vote",
    {
      "voter": "cmp2020",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "10a07a879617ea2e9ca78e1c9e1e05fa62cd7e05",
  "block": 58084992,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:47:03",
  "op": [
    "vote",
    {
      "voter": "remlaps",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "5342bda1976246ef1d5c5489c4f488ad8b0a3e6f",
  "block": 58084990,
  "trx_in_block": 15,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:57",
  "op": [
    "vote",
    {
      "voter": "remlaps-lite",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "017063773753f9f711ff68862e8104e47aeb4278",
  "block": 58084989,
  "trx_in_block": 15,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:54",
  "op": [
    "vote",
    {
      "voter": "rpalmer13",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "e6e01101b88f1b203abd6f4bcccc32edca8b6624",
  "block": 58084988,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:51",
  "op": [
    "vote",
    {
      "voter": "jmor",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "d2d322ababf1ce55ff3bb4dd89856f9e12bea091",
  "block": 58084987,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:48",
  "op": [
    "vote",
    {
      "voter": "lisa.palmer",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "829a3a063678bf005e3d6d8b6cbeaf6b43634fec",
  "block": 58084985,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:42",
  "op": [
    "vote",
    {
      "voter": "astronomyizfun",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "e1fb9d1823063208aaa65d02cfe6da1a0ac5fd3b",
  "block": 58084984,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:39",
  "op": [
    "vote",
    {
      "voter": "remlaps2",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "429daa1bc4ef56e53094be89c72c5df2727a26f4",
  "block": 58084982,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:33",
  "op": [
    "vote",
    {
      "voter": "cub2",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "44207f707255fb82fdf516be8fbafde5d6f89565",
  "block": 58084981,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-13T21:46:30",
  "op": [
    "vote",
    {
      "voter": "cmp2020-lite",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58076483,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 12,
  "timestamp": "2021-10-13T14:39:21",
  "op": [
    "author_reward",
    {
      "author": "sqlinsix",
      "permlink": "t-sql-how-to-union-all-tables-and-why",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "248.277090 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 58076483,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 10,
  "timestamp": "2021-10-13T14:39:21",
  "op": [
    "curation_reward",
    {
      "curator": "sqlinsix",
      "reward": "176.017340 VESTS",
      "comment_author": "sqlinsix",
      "comment_permlink": "t-sql-how-to-union-all-tables-and-why"
    }
  ]
}

{
  "trx_id": "ff09e53788910373d1ad93b8de46025360df5ce3",
  "block": 58046739,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-12T13:43:39",
  "op": [
    "vote",
    {
      "voter": "jorgebgt",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "15da136144ebeecea2451ec4dc50ed3f96a5d358",
  "block": 58042875,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-12T10:29:12",
  "op": [
    "vote",
    {
      "voter": "krissef",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "weight": -1000
    }
  ]
}

{
  "trx_id": "c54449f6cf6aeadc4caa51ee5785d3a639832261",
  "block": 58041075,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-12T08:58:57",
  "op": [
    "comment_options",
    {
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 0,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": []
    }
  ]
}

{
  "trx_id": "c54449f6cf6aeadc4caa51ee5785d3a639832261",
  "block": 58041075,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2021-10-12T08:58:57",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "hive-109160",
      "author": "sqlinsix",
      "permlink": "sql-basics-using-union-all-or-union-and-why",
      "title": "SQL Basics: Using UNION ALL or UNION and Why",
      "body": "https://www.youtube.com/watch?v=c9kz_DhyWT8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=11\n\n<p>In some cases, we need to combine the result of two tables where data types may be similar or identical.  We could combine the data in one table using INSERT syntaxes, but with UNION ALL or UNION, we can achieve the same result instead of creating a new table.  In the video, <a href=\"https://www.youtube.com/watch?v=c9kz_DhyWT8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=11\">SQL Basics: How To Use UNION ALL and Why</a> we see several examples of this in action.  One example we union tables with the same data type and in another example, we union two columns that have different data types.</p>\n\n<p>Note the tables that we're using and what values are identical based on the column names and what values differ based on the column names.  We'll be using these tables throughout these videos.  We'll notice that if we union two data types that are not similar (varchar and int), we get a clash.  This is because these are not like data types; we can union an int and a smallint because they are like data types, but data types that do not fall into these categories will clash and cause us to get errors.  What if we need to union two different data types?  We can cast or convert the data types to match each other, such as casting an int to a varchar so that we can union two varchars.  Keep in mind that we don't need to do this if two data types fall into the same category (ie: different lengths of ints, varchars, etc).  In some cases, we may do the casting or converting of data types in the application layer; however, this means that we won't be able to use UNION or UNION ALL as we'll still have a clash.</p>\n\n<p>One applied example of using unions is error logs.  Often we have error logs for the database, application and other possible layers.  It's useful to identify when an error happened and how that error translated across layers.  Unioning tables with the errors by combining the error and date can be useful when we order by the time of the error.  We can often find out where the error originated and how it impacted all the layers of our application or service.</p>",
      "json_metadata": "{\"tags\":[\"development\",\"data\",\"sql\",\"sqlserver\"],\"image\":[\"https://img.youtube.com/vi/c9kz_DhyWT8/0.jpg\"],\"links\":[\"https://www.youtube.com/watch?v=c9kz_DhyWT8&list=PLHHm85xMQAYNScEs-nu9gzi2uoQ9JCCYA&index=11\"],\"app\":\"steemit/0.2\",\"format\":\"markdown\"}"
    }
  ]
}