I've uploaded a Jupyter Notebook in Github explaining two ways to print Markdown in a Jypyter Notebook:
The first option is straightforward, but the second one is much more powerful because can be used with other widgets, . . .
Missing an official YAML powershell module
I made another post about Powershell and YAML some months ago with more code where I explain the different ways to write YAML and how it behaves in powershell, comparing PSYaml and powershell-yaml modules.
After the experience of being working in a module that's compatible with both modules to read YAML files, I decided to write this . . .
PostgreSQL 10 implements SQL standard's IDENTITY
In SQL Server is quite common to use IDENTITYs for non-natural primary keys. In PostgreSQL, until version 10, only SERIALs could be used for the same purpose. But that has changed.
Why INDENTITY and not SERIAL and SEQUENCES?
Posted in: postgresql
I had to export some data from an Oracle database to a MongoDB. For this reason I created a python function called
export_data_from_oracle_to_mongodb that can be found in my Github.
To make the function more generic, I've there's an optional parameter called
transform,where a function can be specified to . . .
powershell doesn't have native support for yaml. Solution: PSYAML and powershell-yaml
UPDATE on 2018-07-06
I recommend reading my second post A Brief introduction to YAML in Powershell: it's shorter and has less code. It's done after working in a module that's compatible with powershell-yaml and PSYaml modules to read YAML files in Powershell.
I only recommend to read this blog if you're new to . . .
Posted in: powershell
How to check consistency at the end of a transaction
DEFERRED CONSTRAINTS are useful when you know that in a transaction you'll have inconsistent data for a while, like foreign keys that don't match, but you know that at the end of a transaction it will be consistent.
It was a nice PostgreSQL surprise to discover
DEFERRED CONSTRAINTS, because it's not . . .
Posted in: postgresql
Changing normal SQL Server's behavior
Microsoft defines the trace flags as:
Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior.
The purpose of trace flags is to change a SQL Server default behavior. The context they apply to can be global, session or query and it depends . . .
Posted in: sqlserver