Foto%20quadrada%20per%20silvrback_large

Josep

A Brief introduction to YAML in Powershell

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 . . .

Read More

July 06, 2018

Change SERIAL to IDENTITY in PostgreSQL

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?

SERIAL is a friendly way to set a SEQUENCE, but at the end, it's a SEQUENCE: an object that . . .

Read More

Posted in: postgresql

February 27, 2018

Export data from Oracle to MongoDB in Python

This post can be found in a Jupyter Notebook in my Github.

This could be a good script as a starting point to export data from Oracle to MongoDB. It can be modified easily to add some row transformations (like combining columns) or other things.

Tested with:

  • pymongo version: 3.4.0
  • cx_Oracle version: 6.0.2
  • . . .

Read More

February 09, 2018

YAML in powershell

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 . . .

Read More

Posted in: powershell

December 27, 2017

DEFERRED CONSTRAINTS in PostgreSQL

How to check consistency at the end of a transaction

Introduction

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 . . .

Read More

Posted in: postgresql

December 19, 2017

SQL Server trace flags

Changing normal SQL Server's behavior

Introduction

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 . . .

Read More

Posted in: sqlserver

March 03, 2017

List all Ole DB Providers in Powershell

In Microsoft documentation for OleDbEnumerator.GetRootEnumerator() method
there's a C# example how to list all Ole DB Providers. I've just rewritten it in Powershell, creating a function that returns a list of providers, so it's easier to work with and can be filtered.
It's useful to check which providers are installed . . .

Read More

Posted in: oledbpowershell

June 21, 2016

Archive