Josep

Install Pyrseas in Windows 64bits

Pyrseas is a Database Version Control for PostgreSQL with a very interesting approach and with an easy way to script a database (database to a YAML file) and to apply changes to a database (YAML file to a database). It’s develped in Python by Joe Abbate (thank you Joe for it!)

Currently I’m using dbtoyaml to script the database in . . .

Read More

April 19, 2016

Explicit date format conversions

Don't let it to the system configuration

Implicit date format conversions, when no format is specified, are always a source of troubles when:

  • Passing dates as parameters in scripts to databases, other scripts, applications, web services or other targets, because each system is waiting the dates in specific format.
  • Running a SQL script in databases with different . . .

Read More

April 19, 2016

Clean coding with Write-Verbose

It’s a good practise to use the Write-Verbose,Write-Debug and other about_CommonParameters when writing functions because it helps you to write clean code in a very integrated way with Powershell. One of its main benefits is for debugging and verbosing without needing to modify your code.

I’ll focus on the usage of Write-Verbose. The . . .

Read More

April 19, 2016

Powershell Get-ChildItem examples

I really like Powershell because you can do a lot of tasks very easily and it’s very integrated with Windows and .NET framework. So, it’s powerfull.

Get-ChildItem it’s a versatile and useful cmdlet that gets the items and child items in one or more specified locations. In this post I write some code examples that I hope you find it . . .

Read More

April 19, 2016

pg_terminate_backend for non-superusers

The problem

Last week I had to give the permission to one user to kill PostgreSQL connections in a development environment, but I found that pg_terminate_backend and pg_cancel_backend functions can only be executed by a superuser and I didn’t want to give such privileges so I started looking for a solution and at the end I . . .

Read More

April 19, 2016

Starting the blog!

This is the very first post of a blog where I will write the DBA stuff I have to work with every day, the DBA daily stuff!

My main background is in Microsoft SQL Server, but I’m also working with PostgreSQL and Oracle.

I’m also using Powershell for scripting.

I hope you enjoy it and find it useful!

Read More

April 19, 2016

Archive

This update link alerts you to new Silvrback admin blog posts. A green bubble beside the link indicates a new post. Click the link to the admin blog and the bubble disappears.

Got It!