index

Cet article décrit les éléments suivants concernant cette version du correctif :

Les problèmes qui sont résolus par le package de correctifs
Les conditions préalables à l’installation du package de correctifs
Si vous devez redémarrer l’ordinateur après avoir installé le package de correctifs
Si le package de correctifs est remplacé par un autre package de correctif logiciel
Si vous devez modifier Read More →

index

 

Table of Contents

Introduction

Background
Prerequisites
Recommendations
Disclaimer

FAQs

Help! I’m lost!
But I don’t want to use the Brian Keller VM!
I already have MS RM set-up. What’s the minimal work I need to do to add a DB to my system?

System Overview
Exercise 1 – Source Controlling your Database

Linking a Database to source-control

Exercise 2 – Getting your Database into the Continuous Integration Process

Part Read More →

index

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 →

tools

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 →

mysql-data-at-rest-encryption

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 →

mysql_workbench

Getting started:

http://www.sqlteaching.com/
https://www.codecademy.com/courses/learn-sql

Related tutorials:

MySQL-CLI: https://www.youtube.com/playlist?list=PLfdtiltiRHWEw4-kRrh1ZZy_3OcQxTn7P
Analyzing Business Metrics: https://www.codecademy.com/learn/sql-analyzing-business-metrics
SQL joins infografic: http://cd64.de/sql-joins

Tools:

DataGrip: https://www.jetbrains.com/datagrip/
Sequel Pro: http://www.sequelpro.com/

Commands
Aggregate functions
Multiple tables
Users functions
Find out the IP Address of the Mysql Host

mysql_workbench

Database
Sample database cart table contains four columns cart_id, user_id, product_id and created_at.

Enable MySQL Event Scheduler
Start MySQL event scheduler by executing following query in PhpMyAdmin or MySQL command prompt.

 

Create a Event
Here the following event will run everyday and clear/delete 10 days old data from cart table based on time stamp

 

Alter Event
If you want to modify the Read More →

index

SQL Server’s query optimizer uses distribution statistics to determine how it’s going to satisfy your SQL query. These statistics represent the distribution of the data within a column, or columns. The Query Optimizer uses them to estimate how many rows will be returned from a query plan.
Distribution statistics are created automatically when you create an Read More →

mysql_workbench

Schema changes can often lock your database, stall your application, and cause an outage, so you'll want to be careful in how you design the infrastructure to permit database changes.
Achieving a zero-downtime schema deployment can be done with load balancer and a technique called Blue-Green deployment.
"Blue-Green deployment" is a fancy term that basically means you Read More →