One common requirement is to create an XML structure that is based on the schema of an existing table. Let’s assume that we’ve received a request to create XML data from relevant fields in the Person.Person table, for the person having BusinessEntityID 10001. We need to gather the values from this row:
We need to … Read More →
Table des matières
Qu'est ce que VNC
Installation de tigervnc
Activation des services
Qu'est ce que VNC
Pour toutes les informations sur le protocole VNC se référer à l'article Le service VNC
Il faut bien entendu avoir une interface graphique opérationnelle (Ici GNOME)
On met le système à jour :
Code BASH :
Installation de tigervnc
On installe les paquets … Read More →
Launch Visual Studio, Select menu Tools | Extension Manager,
Search online gallery for Git Source Control Provider
Download and install.
Go to Tools | Options.
Select Source Control in the tree view
Select Git Source Control Provider from the drop down list, and click OK.
Also, please verify the paths to your favorited git tools are setup correctly.
Open Git … Read More →
To develop and test in distributed environment you might use virtualizing tool like VirtualBox to imitate the environment of where number of servers and complex networks resides. But still, you have to move around through VM windows. In order to access all virtual servers using SSH just like we do in the real world, several … Read More →
wpad is short for Web Proxy Autodiscovery Protocol. It's used to tell your browser what proxy it can use without having to go to each and every pc on your network to do so.
The Perfect Linux Firewall Part I -- IPCop
This document describes how to install the GNU/Linux GPL IPCop firewall and create a small home office network. In the second installment we cover creating a DMZ for hosting your own web server or mail server and the Copfilter proxy for filtering web and email traffic.
This is intended … Read More →
Finally I was able to putting each component together. As I implement CI and Deployment system for the DB, I could understand why it is hard to find a novice friendly guide which explains all the basics and also provides step by step instructions. There are way too many options that you need to pick … Read More →
Markdown is a lightweight and easy-to-use syntax for styling all forms of writing on the GitHub platform.
What you will learn:
How the Markdown format makes styled collaborative editing easy
How Markdown differs from traditional formatting approaches
How to use Markdown to format text
How to leverage GitHub’s automatic Markdown rendering
How to apply GitHub’s unique Markdown extensions
What is Markdown?
Markdown is … Read More →
If you're reading this article, chances are you haven't been blinded by Windows 8 or Windows 8.1 and, like millions of others, are using Windows 7, Microsoft's most durable operating system since Windows XP. Windows 10 is coming and promises to be the true successor to Windows 7. Most importantly the Start menu is back!
But … Read More →
I’ve been playing with Jenkins to educate myself. Finally got something that solves a problem, hopefully it can help others. I was getting tired of manually running a query at the end of the month for one of my own reports, so I took on the project to use Jenkins to schedule the execution of … Read More →
One of the most common jokes you’ll hear when talking about the most important tasks for a Database Administrator goes like this – a DBA needs one of two things, a good backup or a good resume. It’s true. If you’re not doing backups, and ensuring that you can recover databases from those backups, you’re … Read More →
While Continuous Integration (CI) started with application code you should apply the same principles to databases. The point is that CI reduces your feedback loop such that changes that break the build are caught as soon as they are committed to source control. We do this by building, testing and deploying every commit and reporting any … Read More →
Table of Contents
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?
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 →
Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system. Code changes are checked into source control, triggering an automated build with unit tests and providing early feedback in the form of errors returned. Potential problems with … Read More →
By default the port 80 for http connection is filtered on Redhat 7 as you can only access this port from the actual localhost and not from any other public host. To open a port 80 on RHEL 7 Linux we need to add an iptables rule. For this RHEL7 uses firewall-cmd. First add your … Read More →
Microsoft étant Microsoft, ce n’est absolument pas simple d’accéder à Bash sous Windows 10. Voici les étapes à suivre pour accéder à la précieuse fonctionnalité.
Commencez bien entendu par mettre à jour Windows 10 avec la mise à jour Anniversary Update, disponible depuis le 2 août 2016
Allez dans Paramètres (remerciez au passage Microsoft d’avoir divisé en … Read More →
There are n stairs, a person standing at the bottom wants to reach the top. The person can climb either 1 stair or 2 stairs at a time. Count the number of ways, the person can reach the top.
Consider the example shown in diagram. The value of n is 3. There are 3 ways to … Read More →
Python is strongly typed (i.e. types are enforced), dynamically, implicitly typed (i.e. you don't have to declare variables), case sensitive (i.e. var and VAR are two different variables) and object-oriented (i.e. everything is an object).
Help in Python is always available right in the interpreter. If you want to know how an object works, all … Read More →