This article illustrates how to call a web service using SQL Server Integration Services (SSIS), store the XML results in a SQL Server database table then query the XML using XQuery.
Often enough, there is a huge benefit in knowing how to leverage SQL Server Integration Services to accomplish a data task that depends on a … Read More →
So now I have to resort to doing web service calls the old way, making post requests using MSXML. This is what my stored procedure looks like.
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 →
code source : http://sqlfiddle.com/#!3/210df/2
The other day I truly had a dumbstruck, absolutely floored, speechless moment. I tried to run SQL Server Management Studio and was presented with an error telling me that an exception has been thrown by the target of an invocation. Well that error message was about as helpful as the first time I ever saw the … Read More →
Lorsqu’on travaille sur plusieurs projets, avec différentes technologies, on est amené à faire l’installation de nombreux logiciels pour avoir l’environnement adéquat pour chaque projet. Et même si l’on travaille avec une certaine version d’un logiciel, il faut parfois avoir deux ou trois autres versions d’installées simultanément. Même si de nos jours la performance et la … Read More →
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 →