Simple Way To Use Pivot In SQL Query
This post intends to help T-SQL developers get started with PIVOT queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past.
Let us have a table name Invoice which has … Read More →
When it comes to project management tools, you certainly have a lot of options to choose from, and that’s mostly a good thing. However, sometimes the abundance of choice can backfire, and even entirely halt your efforts.
I mean, speaking about the tools that can be used for project management, we have: JIRA, Anydo, TeamClerk, Remember … Read More →
We willl use PostgreSQL
Download latest stable PostgreSQL RPM for CentOS 7 :
Install this release :
Create a new PostgreSQL database cluster :
We will install Java 8 SDK
Install “java-1.8.0-openjdk-devel” package :
Download SonarQube, and copy it to your server :
User & database
Logon as “postgres” :
Set password (here : ‘sonar’) to this PosgreSQL user :
Start & … Read More →
PL/SQL Cop for SonarQube is a plugin for SonarQube. The plugin analyses SQL and PL/SQL code and calculates various metrics and checks the code for compliance of the Trivadis PL/SQL & SQL Coding Guidelines Version 2.0. Behind the scenes the plugin calls the PL/SQL Cop command line utility for the static code analysis.
A static code analysis is typically initiated as part of an … Read More →
Installing SonarQube on windows machine with Sql Server express as back end is quite simple, but here is some information you should know to avoid some common problem with database layer (or at least avoid problem I had )
Setting up Sonar Qube in Windows is easy, but sometimes you can encounter some problem to have … Read More →
Merging code. Coordinating releases. Determining build status. Maintaining updates. If you know the frustration of these processes well enough that the words themselves threaten a headache, you might want to look into Jenkins CI.
Maintaining any project, especially one developed by several team members concurrently and one that might incorporate many functions, components, languages, and environments, … Read More →
I have talked about Database Change Management using Liquibase. Now, I will talk about the integration with Jenkins CI.
As you can see in the example of my previous post. In the pom.xml there are 3 profiles: update,tag and rollback which will be used by Jenkins. The profile approach will be useful in our integration.
I am … Read More →
Liquibase is a dabasebase chane management tool. Rather than writing SQL directly against the database to create, update or drop database objects, developers define their desired database changes in XML files.
Any change to database are grouped into "ChangeSet", the best practice is one changeset per modification to make roll back easily. Changes to database can … Read More →
1. Install Java
Liquibase 3.x requires Java 1.6+ so lets get that installed first
2. Get the Liquibase Code
I'm just going to install put Liquibase in the home directory for now
3. Install MySQL
4. Install the MySQL connector for Java
5. Create the MySQL database
6. Create a Changelog file
Add the following...
7. Run Liquibase
8. Create a liquibase.properties file
Add the following...
9. … Read More →
If you have had a project with several developers working at a high velocity on different branches you are probably aware of the amount of trouble that a theoretically simple task such as managing the db schema changes can provoke. The main issues occur on a daily-basis at development, less DRY, less agile; also the … Read More →
This week at Redgate HQ we’ve been lucky enough to have a visit from Dave Farley, Continuous Delivery evangelist and co-author of the book Continuous Delivery.
In one of our discussions we started talking about database unit testing. Pretty soon we realized we both meant something fundamentally different when we called something a database unit test. … Read More →
With OSX 10.11 El Capitan, here is how to get the AMP stack up and running. This tutorial will go through the process on getting Apache, MySQL, PHP (or otherwise known as the ‘AMP’ stack) and phpMyAdmin running on the El Capitan OS.
This tutorial sets up the AMP stack in more of a traditional way using the loaded Apache and PHP and downloading MySQL and phpMyAdmin. For … Read More →
To completely uninstall MySql OS X it is neccessary to remove numerous files.
You unable to install an older version of MySql even though you thought you have removed everything.
To uninstall MySQL and completely remove it (including all databases) from your Mac do the following:
Open a terminal window
Use mysqldump to backup your databases to text files!
Stop the … Read More →
LaTeX Symbols - http://pages.cs.wisc.edu/~dakoop/latex_symbols.html
Formules en ligne et formules centrées
On Linux start/stop/restart from the command line:
On macOS Sierra & OS to start/stop/restart MySQL post 5.7 from the command line:
On OS X to start/stop/restart MySQL pre 5.7 from the command line:
SQL function for hour changes between UTC(Universal Time Coordinate) and the France zone
This post will look how to use encryption to secure your database credentials.
Before we can go on to use GPG to encrypt our credentials, we need to get it working. GnuPG comes with almost every *nix operating system, but for this post we’ll be using Ubuntu 16.04 LTS and we’ll presume that it isn’t yet … Read More →
L’utilité des dérivées
Laisser un commentaireGo to comments
La dérivée peut sembler être une chose bien abstraite lorsqu’on la regarde sous un angle mathématique, puisqu’il est bien difficile de lui trouver une utilité. Cependant, la dérivée occupe une place bien importante dans d’autres domaines. En physique, elle peut servir à étudier le mouvement d’un objet, c’est-à-dire sa … Read More →
OK, you got “.img” virtual machine image. Now what?
Diving in VMWare, Oracle Virutal Machine, etc, etc, there is not a shadow of the option to choose “new virutal machine” from .img image.
What should I do?
1. Download Qemu (ported version for OSX) http://www.kju-app.org/
2. After installing it on Mac (works fine for me on Maverick),
./qemu-img convert -f raw -O vmdk /Volumes/xxx/rawdisk200gb.img /Volumes/xxx/vdisk200gb.vmdk
3. Next, … Read More →